diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2015-02-19 21:36:50 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2015-02-19 21:36:50 -0500 |
| commit | 2fb7a75f37d0beca80f45e15736ec8d50064228a (patch) | |
| tree | 75b55578c09991a16f3714b928e3e5d8d717a8fd /doc/src | |
| parent | 634618ecd039cf99fb8212b0314ef8a3754ca9c2 (diff) | |
Add pg_stat_get_snapshot_timestamp() to show statistics snapshot timestamp.
Per discussion, this could be useful for purposes such as programmatically
detecting a nonresponding stats collector. We already have the timestamp
anyway, it's just a matter of providing a SQL-accessible function to fetch
it.
Matt Kelly, reviewed by Jim Nasby
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 3ce7e80dfa2..9eaf1446a1f 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -1710,6 +1710,14 @@ postgres 27093 0.0 0.0 30096 2752 ? Ss 11:34 0:00 postgres: ser </row> <row> + <entry><literal><function>pg_stat_get_snapshot_timestamp()</function></literal><indexterm><primary>pg_stat_get_snapshot_timestamp</primary></indexterm></entry> + <entry><type>timestamp with time zone</type></entry> + <entry> + Returns the timestamp of the current statistics snapshot + </entry> + </row> + + <row> <entry><literal><function>pg_stat_clear_snapshot()</function></literal><indexterm><primary>pg_stat_clear_snapshot</primary></indexterm></entry> <entry><type>void</type></entry> <entry> |