diff options
Diffstat (limited to 'src/backend/catalog/system_views.sql')
| -rw-r--r-- | src/backend/catalog/system_views.sql | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql index 5948db162b..79a9d7bf40 100644 --- a/src/backend/catalog/system_views.sql +++ b/src/backend/catalog/system_views.sql @@ -3,7 +3,7 @@ * * Copyright (c) 1996-2007, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/backend/catalog/system_views.sql,v 1.36 2007/03/16 17:57:36 mha Exp $ + * $PostgreSQL: pgsql/src/backend/catalog/system_views.sql,v 1.37 2007/03/30 18:34:55 mha Exp $ */ CREATE VIEW pg_roles AS @@ -364,3 +364,13 @@ CREATE VIEW pg_stat_database AS pg_stat_get_db_tuples_updated(D.oid) AS tup_updated, pg_stat_get_db_tuples_deleted(D.oid) AS tup_deleted FROM pg_database D; + +CREATE VIEW pg_stat_bgwriter AS + SELECT + pg_stat_get_bgwriter_timed_checkpoints() AS checkpoints_timed, + pg_stat_get_bgwriter_requested_checkpoints() AS checkpoints_req, + pg_stat_get_bgwriter_buf_written_checkpoints() AS buffers_checkpoint, + pg_stat_get_bgwriter_buf_written_lru() AS buffers_lru, + pg_stat_get_bgwriter_buf_written_all() AS buffers_all, + pg_stat_get_bgwriter_maxwritten_lru() AS maxwritten_lru, + pg_stat_get_bgwriter_maxwritten_all() AS maxwritten_all; |