PG_STATIO_SYS_INDEXES
PG_STATIO_SYS_INDEXES displays I/O status information for all system catalog indexes in a namespace.
Table 1 PG_STATIO_SYS_INDEXES columns
Name  | Type  | Description  | 
|---|
relid  | oid  | OID of the table for this index  | 
indexrelid  | oid  | OID of the index  | 
schemaname  | name  | Name of the schema that the index is in  | 
relname  | name  | Name of the table that the index is created for  | 
indexrelname  | name  | Index name  | 
idx_blks_read  | bigint  | Number of disk blocks read from the index  | 
idx_blks_hit  | bigint  | Number of cache hits in the index  | 
openGauss 2025-11-03 22:42:56