Redshift Observatory

System Table Tracker

System view pg_catalog.pg_stat_all_indexes version 1.0.50300 / 2023-05-09

schema	name	column	data type
pg_catalog	pg_stat_all_indexes	idx_scan	int8
pg_catalog	pg_stat_all_indexes	idx_tup_fetch	int8
pg_catalog	pg_stat_all_indexes	idx_tup_read	int8
pg_catalog	pg_stat_all_indexes	indexrelid	oid
pg_catalog	pg_stat_all_indexes	indexrelname	name
pg_catalog	pg_stat_all_indexes	relid	oid
pg_catalog	pg_stat_all_indexes	relname	name
pg_catalog	pg_stat_all_indexes	schemaname	name

View Text

SELECT c.oid AS relid,
       i.oid AS indexrelid,
       n.nspname AS schemaname,
       c.relname,
       i.relname AS indexrelname,
       pg_stat_get_numscans(i.oid) AS idx_scan,
       pg_stat_get_tuples_returned(i.oid) AS idx_tup_read,
       pg_stat_get_tuples_fetched(i.oid) AS idx_tup_fetch
FROM pg_class AS c
     INNER JOIN pg_index AS x ON c.oid = x.indrelid
     INNER JOIN pg_class AS i ON i.oid = x.indexrelid
     LEFT JOIN pg_namespace AS n ON n.oid = c.relnamespace
WHERE c.relkind = CAST('r' AS "char")

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