Redshift Observatory

System Table Tracker

System view pg_catalog.pg_stat_sys_indexes version 1.0.57864 / 2023-10-14

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

View Text

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