Redshift Observatory

System Table Tracker

System view pg_catalog.pg_statio_sys_tables version 1.0.77706 / 2024-11-05

schema name column data type
pg_catalog pg_statio_sys_tables heap_blks_hit int8
pg_catalog pg_statio_sys_tables heap_blks_read int8
pg_catalog pg_statio_sys_tables idx_blks_hit int8
pg_catalog pg_statio_sys_tables idx_blks_read int8
pg_catalog pg_statio_sys_tables relid oid
pg_catalog pg_statio_sys_tables relname name
pg_catalog pg_statio_sys_tables schemaname name
pg_catalog pg_statio_sys_tables tidx_blks_hit int8
pg_catalog pg_statio_sys_tables tidx_blks_read int8
pg_catalog pg_statio_sys_tables toast_blks_hit int8
pg_catalog pg_statio_sys_tables toast_blks_read int8

View Text

SELECT pg_statio_all_tables.relid,
       pg_statio_all_tables.schemaname,
       pg_statio_all_tables.relname,
       pg_statio_all_tables.heap_blks_read,
       pg_statio_all_tables.heap_blks_hit,
       pg_statio_all_tables.idx_blks_read,
       pg_statio_all_tables.idx_blks_hit,
       pg_statio_all_tables.toast_blks_read,
       pg_statio_all_tables.toast_blks_hit,
       pg_statio_all_tables.tidx_blks_read,
       pg_statio_all_tables.tidx_blks_hit
FROM pg_statio_all_tables
WHERE pg_statio_all_tables.schemaname = CAST('pg_catalog' AS name)
   OR pg_statio_all_tables.schemaname = CAST('pg_toast' AS name)
   OR pg_statio_all_tables.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