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	Partition OID.
schemaname	name	Name of the schema that the partition is in.
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. The distributed system does not support level-2 partitions. Set this parameter to NULL.
heap_blks_read	bigint	Number of disk blocks read from the partition.
heap_blks_hit	bigint	Number of cache hits in the partition.
idx_blks_read	bigint	Number of disk blocks read from all indexes on the partition.
idx_blks_hit	bigint	Number of cache hits of all indexes in a partition.
toast_blks_read	bigint	Number of disk blocks read from the partition's TOAST table partition (if any).
toast_blks_hit	bigint	Number of buffer hits in the partition's TOAST table partition (if any).
tidx_blks_read	bigint	Number of disk blocks read from the partition's TOAST table partitioned indexes (if any).
tidx_blks_hit	bigint	Number of buffer hits in the partition's TOAST table partitioned indexes (if any).