Open topic with navigation

TIBCO® Patterns 6.1.2

### Table Statistics Command

## tblstats –table <name>

The `tblstats` command returns various statistical information about the specified table.

    Example of output against a table called ‘names’.

    -- Table Statistics: names
    The status of any checkpoint for this table: Never Checkpointed
    The total size of the overhead for a table (in kbytes): 223
    The total size of the indexing information for the table (in kbytes): 5616
    The total size of the tree structure which holds the record keys for the table (in kbytes): 357
    The number of records currently in the table: 10012
    The total memory used by the process (in kbytes. Only available on Linux.): -1
    The total size of the overhead for storing the field structure of the table (in kbytes): 661
    The table info field for this table. It will be null if no table info was specified at load time:
    The total size of the table, all structures included (in kbytes): 6858
    Whether of not the GIP filter is turned on for the database: true
    -- Field Level Information
    Field Name: last : Field Type: 5 : Searchable: true
    Field Name: first : Field Type: 5 : Searchable: true
    Field Name: ssn : Field Type: 5 : Searchable: true
    Field Name: street : Field Type: 5 : Searchable: true
    Field Name: city : Field Type: 5 : Searchable: true
    Field Name: state : Field Type: 5 : Searchable: true
    Field Name: zip : Field Type: 5 : Searchable: true
    Field Name: id : Field Type: 5 : Searchable: true

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® Patterns

Copyright © 2010-2025. Cloud Software Group, Inc. All Rights Reserved.