Redshift Observatory

System Table Tracker

System view pg_catalog.pg_statio_user_sequences version 1.0.46806 / 2023-02-21

schema	name	column	data type
pg_catalog	pg_statio_user_sequences	blks_hit	int8
pg_catalog	pg_statio_user_sequences	blks_read	int8
pg_catalog	pg_statio_user_sequences	relid	oid
pg_catalog	pg_statio_user_sequences	relname	name
pg_catalog	pg_statio_user_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)
  AND pg_statio_all_sequences.schemaname <> CAST('pg_toast' AS name)
  AND 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