From: | Matt Kelly <mkellycs(at)gmail(dot)com> |
---|---|
To: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Exposing the stats snapshot timestamp to SQL |
Date: | 2015-01-29 05:18:09 |
Message-ID: | CA+KcUkiibrsMJ-ST0T5k9E0xbLWcRJZtqJESghGzvo3VoidN7A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
In a previous thread Tom Lane said:
(I'm also wondering if it'd make sense to expose the stats timestamp
> as a callable function, so that the case could be dealt with
> programmatically as well. But that's future-feature territory.)
(http://www.postgresql.org/message-id/27251.1421684169@sss.pgh.pa.us)
It seemed the appropriate scope for my first submission, and that feature
has been on my wish list for a while, so I thought I'd grab it.
Main purpose of this patch is to expose the timestamp of the current stats
snapshot so that it can be leveraged by monitoring code. The obvious case
is alerting if the stats collector becomes unresponsive. The common use
case is to smooth out graphs which are built from high frequency monitoring
of the stats collector.
The timestamp is already available as part of PgStat_GlobalStats. This
patch is just the boilerplate (+docs & tests) needed to expose that value
to SQL. It shouldn't impact anything else in the server.
I'm not particularly attached to the function name, but I didn't have a
better idea.
The patch should apply cleanly to master.
- Matt K
Attachment | Content-Type | Size |
---|---|---|
pg_stat_snapshot_timestamp_v1.patch | application/octet-stream | 5.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2015-01-29 05:26:11 | Re: pg_upgrade and rsync |
Previous Message | Stephen Frost | 2015-01-29 05:07:30 | Re: pg_upgrade and rsync |