PGXC_TABLE_STAT

PGXC_TABLE_STAT provides statistics of all tables of the database on all CNs and DNs in the cluster. Except the nodename column of the name type added in front of each row, the names, types, and sequences of other columns are the same as those in the GS_TABLE_STAT view.

**Table 1** PGXC_TABLE_STAT columns
Column	Type	Description
nodename	name	Node name.
schemaname	name	Table namespace.
relname	name	Table name.
seq_scan	bigint	Number of sequential scans. Only row-store tables are counted. For a partitioned table, the sum of the number of scans of each partition is displayed.
seq_tuple_read	bigint	Number of rows scanned in sequence. Only row-store tables are counted.
index_scan	bigint	Number of index scans. Only row-store tables are counted.
index_tuple_read	bigint	Number of rows scanned by the index. Only row-store tables are counted.
tuple_inserted	bigint	Number of rows inserted.
tuple_updated	bigint	Number of rows updated.
tuple_deleted	bigint	Number of rows deleted.
tuple_hot_updated	bigint	Number of rows with HOT updates.
live_tuples	bigint	Number of live tuples. Query the view on the CN. If ANALYZE is executed, the total number of live tuples in the table is displayed. Otherwise, 0 is displayed. This indicator applies only to row-store tables.
dead_tuples	bigint	Number of dead tuples. Query the view on the CN. If ANALYZE is executed, the total number of dead tuples in the table is displayed. Otherwise, 0 is displayed. This indicator applies only to row-store tables.