SHOW TABLECOUNT

Description

SHOW TABLECOUNT returns the number of rows and the attributes of all tables.

Syntax

BASH

SHOW TABLECOUNT [<table>]

<table>

Specifying a table name will return only the information related to this table.

Output

Column Name

Description

schema

Schema name

table

Table/View/Alias name

lines

Number of lines in the table

Object Type	Result
Ingested Table	Number of rows in the table
Alias	Number of rows in the table source of the alias
External Table	Number of rows in the table when there is at least 1 index on this table. N/A otherwise.
View	-1 * Number of Nodes

table_type

The type of object:

EXTERNAL: a reference to a table in an external datasource
FACT: a fact table, with data ingested into Indexima, which indexes are partitioned through nodes for performance
LIMITED: a fact table with no index still created. This table won't allow a large load until at least one index is created
DIMENSION: a dimension table (less volatile, less volume), loaded on every node for performant pre-join with fact tables
VIEW: a view (not materialized) on top of Indexima tables

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.