diff options
| author | Andres Freund <andres@anarazel.de> | 2014-08-22 00:28:37 +0200 |
|---|---|---|
| committer | Andres Freund <andres@anarazel.de> | 2014-08-22 00:28:37 +0200 |
| commit | f57791985ac3d776cb67e9d69befde538cfdf13b (patch) | |
| tree | 334e1096d00e11c63c69c676e878a968883e6db7 /doc | |
| parent | ce486056ecd28050f367894a2b5aad3656d37511 (diff) | |
Add pinning_backends column to the pg_buffercache extension.
The new column shows how many backends have a buffer pinned. That can
be useful during development or to diagnose production issues
e.g. caused by vacuum waiting for cleanup locks.
To handle upgrades transparently - the extension might be used in
views - deal with callers expecting the old number of columns.
Reviewed by Fujii Masao and Rajeev rastogi.
Diffstat (limited to 'doc')
| -rw-r--r-- | doc/src/sgml/pgbuffercache.sgml | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/doc/src/sgml/pgbuffercache.sgml b/doc/src/sgml/pgbuffercache.sgml index 4eb02c06239..f379be225f0 100644 --- a/doc/src/sgml/pgbuffercache.sgml +++ b/doc/src/sgml/pgbuffercache.sgml @@ -106,6 +106,13 @@ <entry>Clock-sweep access count</entry> </row> + <row> + <entry><structfield>pinning_backends</structfield></entry> + <entry><type>integer</type></entry> + <entry></entry> + <entry>Number of backends pinning this buffer</entry> + </row> + </tbody> </tgroup> </table> |