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 | 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 it 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). |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
