diff options
| author | Magnus Hagander <magnus@hagander.net> | 2012-01-26 14:41:19 +0100 |
|---|---|---|
| committer | Magnus Hagander <magnus@hagander.net> | 2012-01-26 14:41:19 +0100 |
| commit | bc3347484a7bf9eddb98e4352d84599cae9a31c6 (patch) | |
| tree | f362d4e7f8e1f1d5f1fe318bd796e4e86d5d2abd /doc/src | |
| parent | 9d35116611e6a1fc10f2298944fbf0e4e1a826be (diff) | |
| download | postgresql-bc3347484a7bf9eddb98e4352d84599cae9a31c6.tar.gz postgresql-bc3347484a7bf9eddb98e4352d84599cae9a31c6.zip | |
Track temporary file count and size in pg_stat_database
Add counters for number and size of temporary files used
for spill-to-disk queries for each database to the
pg_stat_database view.
Tomas Vondra, review by Magnus Hagander
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 25 |
1 files changed, 24 insertions, 1 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index fef2a35ba7d..1e4cb24455f 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -283,7 +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), and time of last statistics reset. + standby servers), number and size of temporary files used, and time + of last statistics reset. </entry> </row> @@ -887,6 +888,28 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re </row> <row> + <entry><literal><function>pg_stat_get_db_temp_bytes</function>(<type>oid</type>)</literal></entry> + <entry><type>bigint</type></entry> + <entry> + Amount of data written to temporary files by queries in the database. + All temporary files are counted, regardless of why the temporary file + was created (sorting or hash), and regardless of the + <xref linkend="guc-log-temp-files"> setting. + </entry> + </row> + + <row> + <entry><literal><function>pg_stat_get_db_temp_files</function>(<type>oid</type>)</literal></entry> + <entry><type>bigint</type></entry> + <entry> + Number of temporary files written by queries in the database. All temporary + files are counted, regardless of why the temporary file was created + (sorting or hash) or file size, and regardless of the + <xref linkend="guc-log-temp-files"> setting. + </entry> + </row> + + <row> <entry><literal><function>pg_stat_get_numscans</function>(<type>oid</type>)</literal></entry> <entry><type>bigint</type></entry> <entry> |