GS_TABLE_STAT

Updated on 2023-10-31 GMT+08:00

View PDF

GS_TABLE_STAT displays statistics about all tables (excluding foreign tables) of the database on the current node. The values of live_tuples and dead_tuples are real-time values, and the values of other statistical columns are accumulated values since the instance was started.

**Table 1** GS_TABLE_STAT columns
Name	Type	Description
schemaname	name	Namespace of a table
relname	name	Table name
seq_scan	bigint	Number of sequential scans. It is counted only for row-store tables. 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. It is counted only for row-store tables.
index_scan	bigint	Number of index scans. It is counted only for row-store tables.
index_tuple_read	bigint	Number of rows scanned by the index. It is counted only for row-store tables.
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.