Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

GLOBAL_TABLE_STAT

Updated on 2024-12-19 GMT+08:00

GLOBAL_TABLE_STAT displays statistics about all tables (excluding foreign tables) in the current database. 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 GLOBAL_TABLE_STAT columns

Name

Type

Description

schemaname

name

Namespace of a table

relname

name

Table name

distribute_mode

char

Distribution mode of a table. The meaning of this column is the same as that of the pclocatortype column in the pgxc_class system catalog.

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. For a replication table, the maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

tuple_updated

bigint

Number of rows updated. For a replication table, the maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

tuple_deleted

bigint

Number of rows deleted. For a replication table, the maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

tuple_hot_updated

bigint

Number of rows with HOT updates. For a replication table, the maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

live_tuples

bigint

Number of live tuples. The maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

This indicator applies only to row-store tables.

dead_tuples

bigint

Number of dead tuples. The maximum value of each node is displayed. For a distribution table, the sum of all nodes is displayed.

This indicator applies only to row-store tables.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback