diff options
| author | Robert Haas <rhaas@postgresql.org> | 2012-04-05 14:03:21 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2012-04-05 14:04:37 -0400 |
| commit | b736aef2ec57b520ebadb70cceac0fed3168a5df (patch) | |
| tree | 33ae0d9d4da2097abde0bbbd6de63b72ef1f7dd7 /src/backend/utils/adt/pgstatfuncs.c | |
| parent | a75b08066ab4b426b1bd056fed81302e5a5d5371 (diff) | |
| download | postgresql-b736aef2ec57b520ebadb70cceac0fed3168a5df.tar.gz postgresql-b736aef2ec57b520ebadb70cceac0fed3168a5df.zip | |
Publish checkpoint timing information to pg_stat_bgwriter.
Greg Smith, Peter Geoghegan, and Robert Haas
Diffstat (limited to 'src/backend/utils/adt/pgstatfuncs.c')
| -rw-r--r-- | src/backend/utils/adt/pgstatfuncs.c | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/src/backend/utils/adt/pgstatfuncs.c b/src/backend/utils/adt/pgstatfuncs.c index 20ee13db6cf..288243a7787 100644 --- a/src/backend/utils/adt/pgstatfuncs.c +++ b/src/backend/utils/adt/pgstatfuncs.c @@ -87,6 +87,8 @@ extern Datum pg_stat_get_db_block_time_write(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_checkpoint_write_time(PG_FUNCTION_ARGS); +extern Datum pg_stat_get_checkpoint_sync_time(PG_FUNCTION_ARGS); extern Datum pg_stat_get_bgwriter_buf_written_checkpoints(PG_FUNCTION_ARGS); extern Datum pg_stat_get_bgwriter_buf_written_clean(PG_FUNCTION_ARGS); extern Datum pg_stat_get_bgwriter_maxwritten_clean(PG_FUNCTION_ARGS); @@ -1420,6 +1422,18 @@ pg_stat_get_bgwriter_maxwritten_clean(PG_FUNCTION_ARGS) } Datum +pg_stat_get_checkpoint_write_time(PG_FUNCTION_ARGS) +{ + PG_RETURN_INT64(pgstat_fetch_global()->checkpoint_write_time); +} + +Datum +pg_stat_get_checkpoint_sync_time(PG_FUNCTION_ARGS) +{ + PG_RETURN_INT64(pgstat_fetch_global()->checkpoint_sync_time); +} + +Datum pg_stat_get_bgwriter_stat_reset_time(PG_FUNCTION_ARGS) { PG_RETURN_TIMESTAMPTZ(pgstat_fetch_global()->stat_reset_timestamp); |