public inbox for [email protected]
help / color / mirror / Atom feedFrom: Masahiro Ikeda <[email protected]>
To: [email protected]
Subject: more detailed description of tup_returned and tup_fetched
Date: Fri, 14 May 2021 17:00:45 +0900
Message-ID: <[email protected]> (raw)
Hi,
I worried the difference between "tup_returned" and "tup_fetched" in
pg_stat_database. I assumed that "tup_returned" means the number of tuples
that returned to clients. Of course, this is wrong.
So, why don't you describe in more detail? If my understanding is right, they
correspond to "seq_tup_read" and "idx_tup_fetch" in pg_stat_all_tables.
Regards,
--
Masahiro Ikeda
NTT DATA CORPORATION
Attachments:
[text/x-patch] add-more-detailed-description-of-tup_returned-and-tup_fetched.patch (936B, 2-add-more-detailed-description-of-tup_returned-and-tup_fetched.patch)
download | inline diff:
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
index dcbb10fb6f..09a22a43ac 100644
--- a/doc/src/sgml/monitoring.sgml
+++ b/doc/src/sgml/monitoring.sgml
@@ -3712,7 +3712,7 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
<structfield>tup_returned</structfield> <type>bigint</type>
</para>
<para>
- Number of rows returned by queries in this database
+ Number of live rows returned by sequential scans of queries in this database
</para></entry>
</row>
@@ -3721,7 +3721,7 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i
<structfield>tup_fetched</structfield> <type>bigint</type>
</para>
<para>
- Number of rows fetched by queries in this database
+ Number of live rows fetched by index scan of queries in this database
</para></entry>
</row>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: more detailed description of tup_returned and tup_fetched
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox