Redshift Research Project

System Table Tracker

System Table Version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog pg_statio_sys_sequences blks_hit int8
pg_catalog pg_statio_sys_sequences blks_read int8
pg_catalog pg_statio_sys_sequences relid oid
pg_catalog pg_statio_sys_sequences relname name
pg_catalog pg_statio_sys_sequences schemaname name

View Text

SELECT pg_statio_all_sequences.relid,
       pg_statio_all_sequences.schemaname,
       pg_statio_all_sequences.relname,
       pg_statio_all_sequences.blks_read,
       pg_statio_all_sequences.blks_hit
FROM pg_statio_all_sequences
WHERE pg_statio_all_sequences.schemaname = CAST('pg_catalog' AS name)
   OR pg_statio_all_sequences.schemaname = CAST('pg_toast' AS name)
   OR pg_statio_all_sequences.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