SHOW TABLECOUNT returns the number of rows and the attributes of all tables.
SHOW TABLECOUNT [<table>]
Specifying a table name will return only the information related to this table.
Number of lines in the table
The type of object:
|analyzer_mode||The analyzer mode of the table, as described in optimizer-analyzer-mode.|
|need_commit||Boolean indicating if this table has lines inserted or deleted and that needs to be committed.|
|lines_after_commit||Number of lines in the table, if we perform a COMMIT on the table (always equal to 'lines' in case need_commit is false).|
|index_need_compaction||Boolean indicating if this table should be compacted, as described in compact-tables. We consider the table's hyperindexes need compaction when the index_tombstone_percent is above 40%.|
|index_tombstone_percent||Percentage of tombstone lines in all the hyperindexes of this table. Tombstone lines are lines that have been deleted but are still occupying space in the hyperindexes.|