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)