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.
| 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. |
