From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kouber Saparev <kouber@gmail.com>
cc: pgsql-docs@lists.postgresql.org
Subject: Re: Indexes documentation bug
In-reply-to: 
 <CAN4RuQv-nVDGLEu3J19CLWBUTf-HHB=Vsf=YL=LVvXbc06cCTw@mail.gmail.com>
References: 
 <CAN4RuQv-nVDGLEu3J19CLWBUTf-HHB=Vsf=YL=LVvXbc06cCTw@mail.gmail.com>
Comments: In-reply-to Kouber Saparev <kouber@gmail.com>
	message dated "Mon, 04 Apr 2022 15:21:24 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1886049.1649080891.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 04 Apr 2022 10:01:31 -0400
Message-ID: <1886050.1649080891@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1886050.1649080891%40sss.pgh.pa.us>
Precedence: bulk

Kouber Saparev <kouber@gmail.com> writes:
> I believe there is an error within this sentence in section
> https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING=
-PG-STAT-USER-FUNCTIONS-VIEW

> "Therefore, a bitmap scan increments the
> pg_stat_all_indexes.idx_tup_read count(s)
> for the index(es) it uses, and it increments the pg_stat_all_tables.
> idx_tup_fetch count for the table, but it does not affect
> pg_stat_all_indexes.idx_tup_fetch."

> There is repeated mentioning of pg_stat_all_indexes.idx_tup_fetch while =
I
> suppose one should read  pg_stat_all_indexes.idx_scan instead the second
> time. I.e. bitmap scans do not increment idx_scan.

Um ... you did notice that the mentions of idx_tup_fetch apply to two
different views, pg_stat_all_tables vs pg_stat_all_indexes?

			regards, tom lane