Exposing the stats snapshot timestamp to SQL

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

Responses

Browse pgsql-hackers by date

  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