Commitc78d8cd

committed

Note that index-only scans can affect idx_tup_fetch.

An index-only scan that avoids heap fetches will increment idx_tup_readbut not idx_tup_fetch.

1 parentb324384 commitc78d8cdCopy full SHA for c78d8cd

File tree

-1

lines changed

-1

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -507,7 +507,8 @@ postgres: <replaceable>user</> <replaceable>database</> <replaceable>host</> <re`
`507`	`507`	`considering bitmap scans, because <structfield>idx_tup_read</> counts`
`508`	`508`	`index entries retrieved from the index while <structfield>idx_tup_fetch</>`
`509`	`509`	`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.`
`511`	`512`	`</para>`
`512`	`513`	`</note>`
`513`	`514`

Comments

(0)