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
Name	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.