diff options
| author | Magnus Hagander <magnus@hagander.net> | 2012-01-26 15:58:19 +0100 |
|---|---|---|
| committer | Magnus Hagander <magnus@hagander.net> | 2012-01-26 15:58:19 +0100 |
| commit | 61cb8c5abb9235c3106af6c6a6e60d94cb1eee80 (patch) | |
| tree | a15bff3458b883beee010a9cc111e2c3b63bbf51 /doc/src | |
| parent | 0e549697d1c6b8eeb623c497dc38a5aed4deea1e (diff) | |
| download | postgresql-61cb8c5abb9235c3106af6c6a6e60d94cb1eee80.tar.gz postgresql-61cb8c5abb9235c3106af6c6a6e60d94cb1eee80.zip | |
Add deadlock counter to pg_stat_database
Adds a counter that tracks number of deadlocks that occurred in
each database to pg_stat_database.
Magnus Hagander, reviewed by Jaime Casanova
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index 1e4cb24455f..cb13c8e8353 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -283,8 +283,8 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re read requests avoided by finding the block already in buffer cache), number of rows returned, fetched, inserted, updated and deleted, the total number of queries canceled due to conflict with recovery (on - standby servers), number and size of temporary files used, and time - of last statistics reset. + standby servers), number and size of temporary files used, total + number of deadlocks detected, and time of last statistics reset. </entry> </row> @@ -910,6 +910,14 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re </row> <row> + <entry><literal><function>pg_stat_get_db_deadlocks</function>(<type>oid</type>)</literal></entry> + <entry><type>bigint</type></entry> + <entry> + Number of deadlocks detected in the database + </entry> + </row> + + <row> <entry><literal><function>pg_stat_get_numscans</function>(<type>oid</type>)</literal></entry> <entry><type>bigint</type></entry> <entry> |