Content-Length: 257994 | pFad | http://github.com/postgrespro/postgres/commit/c78d8cd1464bc6b69fdc72f9ce51407c89554ece

9B Note that index-only scans can affect idx_tup_fetch. · postgrespro/postgres@c78d8cd · GitHub
Skip to content

Commit c78d8cd

Browse files
committed
Note that index-only scans can affect idx_tup_fetch.
An index-only scan that avoids heap fetches will increment idx_tup_read but not idx_tup_fetch.
1 parent b324384 commit c78d8cd

File tree

1 file changed

+2
-1
lines changed

1 file changed

+2
-1
lines changed

doc/src/sgml/monitoring.sgml

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -507,7 +507,8 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re
507507
considering bitmap scans, because <structfield>idx_tup_read</> counts
508508
index entries retrieved from the index while <structfield>idx_tup_fetch</>
509509
counts live rows fetched from the table; the latter will be less if any
510-
dead or not-yet-committed rows are fetched using the index.
510+
dead or not-yet-committed rows are fetched using the index, or if any
511+
heap fetches are avoided by means of an index-only scan.
511512
</para>
512513
</note>
513514

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/c78d8cd1464bc6b69fdc72f9ce51407c89554ece

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy