Redshift Observatory

System Table Tracker

System view pg_catalog.pg_statio_all_sequences version 1.0.51304 / 2023-06-04

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

View Text

SELECT c.oid AS relid,
       n.nspname AS schemaname,
       c.relname,
       pg_stat_get_blocks_fetched(c.oid) - pg_stat_get_blocks_hit(c.oid) AS blks_read,
       pg_stat_get_blocks_hit(c.oid) AS blks_hit
FROM pg_class AS c
     LEFT JOIN pg_namespace AS n ON n.oid = c.relnamespace
WHERE c.relkind = CAST('S' 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