diff options
| author | Magnus Hagander <magnus@hagander.net> | 2007-03-30 18:34:56 +0000 |
|---|---|---|
| committer | Magnus Hagander <magnus@hagander.net> | 2007-03-30 18:34:56 +0000 |
| commit | 335feca441b338f796e205f0e227b2f3a43f130e (patch) | |
| tree | 9b11d242f2d60e4e38c87cb74946f04889de49bf /src/backend/utils/adt | |
| parent | f9ce21f94cd90ffa5e6c63c91e8b05aa0b6d2b25 (diff) | |
| download | postgresql-335feca441b338f796e205f0e227b2f3a43f130e.tar.gz postgresql-335feca441b338f796e205f0e227b2f3a43f130e.zip | |
Add some instrumentation to the bgwriter, through the stats collector.
New view pg_stat_bgwriter, and the functions required to build it.
Diffstat (limited to 'src/backend/utils/adt')
| -rw-r--r-- | src/backend/utils/adt/pgstatfuncs.c | 54 |
1 files changed, 53 insertions, 1 deletions
diff --git a/src/backend/utils/adt/pgstatfuncs.c b/src/backend/utils/adt/pgstatfuncs.c index 831fe6b8899..f30e57ec2c2 100644 --- a/src/backend/utils/adt/pgstatfuncs.c +++ b/src/backend/utils/adt/pgstatfuncs.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/adt/pgstatfuncs.c,v 1.40 2007/03/16 17:57:36 mha Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/pgstatfuncs.c,v 1.41 2007/03/30 18:34:55 mha Exp $ * *------------------------------------------------------------------------- */ @@ -61,9 +61,19 @@ extern Datum pg_stat_get_db_tuples_inserted(PG_FUNCTION_ARGS); extern Datum pg_stat_get_db_tuples_updated(PG_FUNCTION_ARGS); extern Datum pg_stat_get_db_tuples_deleted(PG_FUNCTION_ARGS); +extern Datum pg_stat_get_bgwriter_timed_checkpoints(PG_FUNCTION_ARGS); +extern Datum pg_stat_get_bgwriter_requested_checkpoints(PG_FUNCTION_ARGS); +extern Datum pg_stat_get_bgwriter_buf_written_checkpoints(PG_FUNCTION_ARGS); +extern Datum pg_stat_get_bgwriter_buf_written_lru(PG_FUNCTION_ARGS); +extern Datum pg_stat_get_bgwriter_buf_written_all(PG_FUNCTION_ARGS); +extern Datum pg_stat_get_bgwriter_maxwritten_lru(PG_FUNCTION_ARGS); +extern Datum pg_stat_get_bgwriter_maxwritten_all(PG_FUNCTION_ARGS); + extern Datum pg_stat_clear_snapshot(PG_FUNCTION_ARGS); extern Datum pg_stat_reset(PG_FUNCTION_ARGS); +/* Global bgwriter statistics, from bgwriter.c */ +extern PgStat_MsgBgWriter bgwriterStats; Datum pg_stat_get_numscans(PG_FUNCTION_ARGS) @@ -756,6 +766,48 @@ pg_stat_get_db_tuples_deleted(PG_FUNCTION_ARGS) PG_RETURN_INT64(result); } +Datum +pg_stat_get_bgwriter_timed_checkpoints(PG_FUNCTION_ARGS) +{ + PG_RETURN_INT64(pgstat_fetch_global()->timed_checkpoints); +} + +Datum +pg_stat_get_bgwriter_requested_checkpoints(PG_FUNCTION_ARGS) +{ + PG_RETURN_INT64(pgstat_fetch_global()->requested_checkpoints); +} + +Datum +pg_stat_get_bgwriter_buf_written_checkpoints(PG_FUNCTION_ARGS) +{ + PG_RETURN_INT64(pgstat_fetch_global()->buf_written_checkpoints); +} + +Datum +pg_stat_get_bgwriter_buf_written_lru(PG_FUNCTION_ARGS) +{ + PG_RETURN_INT64(pgstat_fetch_global()->buf_written_lru); +} + +Datum +pg_stat_get_bgwriter_buf_written_all(PG_FUNCTION_ARGS) +{ + PG_RETURN_INT64(pgstat_fetch_global()->buf_written_all); +} + +Datum +pg_stat_get_bgwriter_maxwritten_lru(PG_FUNCTION_ARGS) +{ + PG_RETURN_INT64(pgstat_fetch_global()->maxwritten_lru); +} + +Datum +pg_stat_get_bgwriter_maxwritten_all(PG_FUNCTION_ARGS) +{ + PG_RETURN_INT64(pgstat_fetch_global()->maxwritten_all); +} + /* Discard the active statistics snapshot */ Datum |