vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_0953.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

9.2 KiB
Raw Permalink Blame History

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.

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.
Parent topic: System Views