Redshift Research Project

System Table Tracker

System view pg_catalog.pg_stat_user_tables version 1.0.62614 / 2024-02-02

schema	name	column	data type
pg_catalog	pg_stat_user_tables	idx_scan	int8
pg_catalog	pg_stat_user_tables	idx_tup_fetch	int8
pg_catalog	pg_stat_user_tables	n_tup_del	int8
pg_catalog	pg_stat_user_tables	n_tup_ins	int8
pg_catalog	pg_stat_user_tables	n_tup_upd	int8
pg_catalog	pg_stat_user_tables	relid	oid
pg_catalog	pg_stat_user_tables	relname	name
pg_catalog	pg_stat_user_tables	schemaname	name
pg_catalog	pg_stat_user_tables	seq_scan	int8
pg_catalog	pg_stat_user_tables	seq_tup_read	int8

View Text

SELECT pg_stat_all_tables.relid,
       pg_stat_all_tables.schemaname,
       pg_stat_all_tables.relname,
       pg_stat_all_tables.seq_scan,
       pg_stat_all_tables.seq_tup_read,
       pg_stat_all_tables.idx_scan,
       pg_stat_all_tables.idx_tup_fetch,
       pg_stat_all_tables.n_tup_ins,
       pg_stat_all_tables.n_tup_upd,
       pg_stat_all_tables.n_tup_del
FROM pg_stat_all_tables
WHERE pg_stat_all_tables.schemaname <> CAST('pg_catalog' AS name)
  AND pg_stat_all_tables.schemaname <> CAST('pg_toast' AS name)
  AND pg_stat_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