GS_STATIO_ALL_PARTITIONS

GS_STATIO_ALL_PARTITIONS contains I/O statistics about each partition in a partitioned table of the current database. The information can be queried by using the gs_statio_get_all_partitions_stats() function.

**Table 1** GS_STATIO_ALL_PARTITIONS columns
Name	Type	Description
partition_oid	oid	Specifies a partition OID.
schemaname	name	Specifies the name of a partition mode.
relname	name	Specifies the name of a table to which a partition belongs.
partition_name	name	Specifies the name of a level-1 partition to which a partition belongs.
sub_partition_name	name	Specifies the name of a level-2 partition to which a partition belongs.
heap_blks_read	bigint	Specifies the number of disk blocks read from a partition.
heap_blks_hit	bigint	Specifies the number of cache hits in a partition.
idx_blks_read	bigint	Specifies the number of disk blocks read from all indexes in a partition.
idx_blks_hit	bigint	Specifies the number of cache hits of all indexes in a partition.
toast_blks_read	bigint	Specifies the number of disk blocks read from TOAST table partitions (if any) in a partition.
toast_blks_hit	bigint	Specifies the number of buffer hits in TOAST tables (if any) in a partition.
tidx_blks_read	bigint	Specifies the number of disk blocks read from TOAST table partitioned indexes (if any) in a partition.
tidx_blks_hit	bigint	Specifies the number of buffer hits in TOAST table indexes (if any) in a partition.