From 5147ab1dd34ad81c169c85fa3c7d11a782a1555b Mon Sep 17 00:00:00 2001
From: Michael Paquier
Date: Thu, 19 Oct 2023 14:03:31 +0900
Subject: pg_stat_statements: Add local_blk_{read|write}_time
This commit adds to pg_stat_statements the two new fields for local
buffers introduced by 295c36c0c1fa, adding the time spent to read and
write these blocks. These are similar to what is done for temp and
shared blocks. This information available only if track_io_timing is
enabled.
Like for 5a3423ad8ee17, no version bump is required in the module.
Author: Nazir Bilal Yavuz
Reviewed-by: Robert Haas, Melanie Plageman
Discussion: https://postgr.es/m/CAN55FZ19Ss279mZuqGbuUNxka0iPbLgYuOQXqAKewrjNrp27VA@mail.gmail.com
---
doc/src/sgml/pgstatstatements.sgml | 20 ++++++++++++++++++++
1 file changed, 20 insertions(+)
(limited to 'doc')
diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml
index 2c4e3655ffe..6c7ca962f81 100644
--- a/doc/src/sgml/pgstatstatements.sgml
+++ b/doc/src/sgml/pgstatstatements.sgml
@@ -353,6 +353,26 @@
+
+
+ local_blk_read_time double precision
+
+
+ Total time the statement spent reading local blocks, in milliseconds
+ (if is enabled, otherwise zero)
+
+
+
+
+
+ local_blk_write_time double precision
+
+
+ Total time the statement spent writing local blocks, in milliseconds
+ (if is enabled, otherwise zero)
+
+
+
temp_blk_read_time double precision
--
cgit v1.2.3