Updated on 2024-05-07 GMT+08:00

GS_STAT_XACT_ALL_PARTITIONS

GS_STAT_XACT_ALL_PARTITIONS displays the transaction status about all partitions of partitioned tables in a namespace. The information can be queried by using the gs_stat_get_xact_all_partitions_stats() function.

Table 1 GS_STAT_XACT_ALL_PARTITIONS columns

Name

Type

Description

partition_oid

oid

Partition OID.

schemaname

name

Schema name of the partition.

relname

name

Name of the table where the partition is located.

partition_name

name

Name of the level-1 partition to which the partition belongs.

sub_partition_name

name

Name of the level-2 partition to which the partition belongs.

seq_scan

bigint

Number of sequential scans initiated by the partition.

seq_tup_read

bigint

Number of live rows fetched by sequential scans.

idx_scan

bigint

Number of index scans initiated by the partition.

idx_tup_fetch

bigint

Number of live rows fetched by index scans.

n_tup_ins

bigint

Number of rows inserted.

n_tup_upd

bigint

Number of rows updated.

n_tup_del

bigint

Number of rows deleted.

n_tup_hot_upd

bigint

Number of rows HOT updated (with no separate index update required)