Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.0

# tibdg Table Stats

Run the tibdg table stats <table-name> command to view statistics such as row counts or overall table size for a table and all of its indexes.

The following is an example that shows statistics for a table named `t1`:

    $ tibdg table stats t1
    Table 't1' statistics:
      Rows:  10  (exact)
      Size by Index:
        primary: 103.0B (exact)

In this example, `t1` contains 10 rows. The `(exact)` after the row count indicates that this is an exact count. The table has one index called `primary` that takes up 103 bytes of space, which is also exact. The size reported for the primary index is the size of data in all rows in the table, which includes all the data for the primary index. The size reported for a secondary index is the additional data size of that index. The total data size for a given table is the sum of the sizes of all its indexes.

The sizes reported by this command are the sizes of the uncompressed data, so they might not reflect the disk usage for the table due to other factors such as compression of the data when it is written to the disk.

If a table or index does not have statistics enabled, the values for row count and sizes are 0, and `(off)` is displayed next to the values. See Enabling Statistics to set the row_counts attribute during table or index create to exact.

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 ActiveSpaces® - Enterprise Edition

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