diff options
author | Michael Paquier <michael@paquier.xyz> | 2023-10-19 13:39:38 +0900 |
---|---|---|
committer | Michael Paquier <michael@paquier.xyz> | 2023-10-19 13:39:38 +0900 |
commit | 295c36c0c1fa7b6befd0a3525c7f109e838c9448 (patch) | |
tree | d5367a109733fbfbefd2f17ca730b425c53cdcd6 /doc/src | |
parent | 13d00729d422c84b1764c24251abcc785ea4adb1 (diff) | |
download | postgresql-295c36c0c1fa7b6befd0a3525c7f109e838c9448.tar.gz postgresql-295c36c0c1fa7b6befd0a3525c7f109e838c9448.zip |
Add local_blk_{read|write}_time I/O timing statistics for local blocks
There was no I/O timing statistics for counting read and write timings
on local blocks, contrary to the counterparts for temp and shared
blocks. This information is available when track_io_timing is enabled.
The output of EXPLAIN is updated to show this information. An update of
pg_stat_statements is planned next.
Author: Nazir Bilal Yavuz
Reviewed-by: Robert Haas, Melanie Plageman
Discussion: https://postgr.es/m/CAN55FZ19Ss279mZuqGbuUNxka0iPbLgYuOQXqAKewrjNrp27VA@mail.gmail.com
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/ref/explain.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml index ae493c86d6c..5ba6486da19 100644 --- a/doc/src/sgml/ref/explain.sgml +++ b/doc/src/sgml/ref/explain.sgml @@ -183,8 +183,8 @@ ROLLBACK; Include information on buffer usage. Specifically, include the number of shared blocks hit, read, dirtied, and written, the number of local blocks hit, read, dirtied, and written, the number of temp blocks read and - written, and the time spent reading and writing data file blocks and - temporary file blocks (in milliseconds) if + written, and the time spent reading and writing data file blocks, local + blocks and temporary file blocks (in milliseconds) if <xref linkend="guc-track-io-timing"/> is enabled. A <emphasis>hit</emphasis> means that a read was avoided because the block was found already in cache when needed. |