Redshift Observatory

System Table Tracker

System view pg_catalog.pg_stat_database version 1.0.45698 / 2023-01-27

schema	name	column	data type
pg_catalog	pg_stat_database	blks_hit	int8
pg_catalog	pg_stat_database	blks_read	int8
pg_catalog	pg_stat_database	datid	oid
pg_catalog	pg_stat_database	datname	name
pg_catalog	pg_stat_database	numbackends	int4
pg_catalog	pg_stat_database	xact_commit	int8
pg_catalog	pg_stat_database	xact_rollback	int8

View Text

SELECT d.oid AS datid,
       d.datname,
       pg_stat_get_db_numbackends(d.oid) AS numbackends,
       pg_stat_get_db_xact_commit(d.oid) AS xact_commit,
       pg_stat_get_db_xact_rollback(d.oid) AS xact_rollback,
       pg_stat_get_db_blocks_fetched(d.oid) - pg_stat_get_db_blocks_hit(d.oid) AS blks_read,
       pg_stat_get_db_blocks_hit(d.oid) AS blks_hit
FROM pg_database AS d

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