GS_TABLE_STAT
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.
| Column | Type | Description |
|---|---|---|
| schemaname | Name | Namespace of a table |
| relname | Name | Table name |
| seq_scan | Bigint | Number of sequential scans. 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. |
| index_scan | Bigint | Number of index scans. |
| index_tuple_read | Bigint | Number of rows scanned by the index. |
| 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
