diff options
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> |