Redshift Observatory

System Table Tracker

System view pg_catalog.pg_stat_database version 1.0.71912 / 2024-08-02

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