| schema | name | column | data type |
|---|---|---|---|
| pg_catalog | pg_stat_sys_indexes | idx_scan | int8 |
| pg_catalog | pg_stat_sys_indexes | idx_tup_fetch | int8 |
| pg_catalog | pg_stat_sys_indexes | idx_tup_read | int8 |
| pg_catalog | pg_stat_sys_indexes | indexrelid | oid |
| pg_catalog | pg_stat_sys_indexes | indexrelname | name |
| pg_catalog | pg_stat_sys_indexes | relid | oid |
| pg_catalog | pg_stat_sys_indexes | relname | name |
| pg_catalog | pg_stat_sys_indexes | schemaname | name |
SELECT pg_stat_all_indexes.relid,
pg_stat_all_indexes.indexrelid,
pg_stat_all_indexes.schemaname,
pg_stat_all_indexes.relname,
pg_stat_all_indexes.indexrelname,
pg_stat_all_indexes.idx_scan,
pg_stat_all_indexes.idx_tup_read,
pg_stat_all_indexes.idx_tup_fetch
FROM pg_stat_all_indexes
WHERE pg_stat_all_indexes.schemaname = CAST('pg_catalog' AS name)
OR pg_stat_all_indexes.schemaname = CAST('pg_toast' AS name)
OR pg_stat_all_indexes.schemaname = CAST('information_schema' AS name) Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers