> `pg_statio_all_indexes`視圖將為當前數據庫中的每個索引包含一行，該行顯示指定索引上有關 I/O 的統計信息。`pg_statio_user_indexes`和`pg_statio_sys_indexes`視圖包含相同的信息，但是被過濾得分別只顯示用戶索引和系統索引。 | 列 | 類型 | 描述 | | --- | --- | --- | | `relid` | `oid` | 這個索引的基表的 OID | | `indexrelid` | `oid` | 這個索引的 OID | | `schemaname` | `name` | 這個索引所在的模式的名稱 | | `relname` | `name` | 這個索引的基表的名稱 | | `indexrelname` | `name` | 這個索引的名稱 | | `idx_blks_read` | `bigint` | 從這個索引讀取的磁盤塊數 | | `idx_blks_hit` | `bigint` | 在這個索引中的緩沖區命中數量 | ``` postgres=# select * from pg_statio_user_indexes; relid | indexrelid | schemaname | relname | indexrelname | idx_blks_read | idx_blks_hit -------+------------+------------+---------+-------------------------------------+---------------+-------------- 16384 | 16387 | public | test | test_pkey | 562 | 208622 16391 | 16400 | public | alerts | index_attack_alarm_attack_result | 2595 | 1425693 16391 | 16401 | public | alerts | index_attack_alarm_attack_type | 2028 | 2663172 16391 | 16402 | public | alerts | index_attack_alarm_suffer_branch_id | 2013 | 2690922 16391 | 16404 | public | alerts | index_attack_alarm_last_time | 6173 | 1175136 16391 | 16405 | public | alerts | index_attack_alarm_priority | 1763 | 2711351 16391 | 16406 | public | alerts | index_attack_alarm_reliability | 3345 | 2711559 16391 | 16407 | public | alerts | index_attack_alarm_rule_id | 6940 | 3605577 16391 | 16408 | public | alerts | index_attack_alarm_sub_attack_type | 2129 | 2663389 16391 | 16409 | public | alerts | attack_alarm_pkey | 8402 | 1188701 16384 | 16531 | public | test | t_index_union | 507 | 225670 16532 | 16538 | public | goods | goods_pkey | 10 | 3644 16391 | 16564 | public | alerts | index_attack_alarm_event_desc | 13 | 0 ```