MIME-Version: 1.0
References: 
 <CAN4RuQv-nVDGLEu3J19CLWBUTf-HHB=Vsf=YL=LVvXbc06cCTw@mail.gmail.com>
 <1886050.1649080891@sss.pgh.pa.us>
In-Reply-To: <1886050.1649080891@sss.pgh.pa.us>
From: Kouber Saparev <kouber@gmail.com>
Date: Mon, 4 Apr 2022 17:11:45 +0300
Message-ID: 
 <CAN4RuQvo-ZAm0HBWLLPp80aSM+15fC4N1bE=iATXzaS9D5ShMw@mail.gmail.com>
Subject: Re: Indexes documentation bug
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000004c360405dbd4b6ed"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN4RuQvo-ZAm0HBWLLPp80aSM%2B15fC4N1bE%3DiATXzaS9D5ShMw%40mail.gmail.com>
Precedence: bulk

--0000000000004c360405dbd4b6ed
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

My bad, yes indeed, the view is different.

=D0=9D=D0=B0 =D0=BF=D0=BD, 4.04.2022 =D0=B3. =D0=B2 17:01 =D1=87. Tom Lane =
<tgl@sss.pgh.pa.us> =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0:

> 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 secon=
d
> > 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
>

--0000000000004c360405dbd4b6ed
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">My bad, yes indeed, the view is different.</div><br><div c=
lass=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">=D0=9D=D0=B0 =D0=
=BF=D0=BD, 4.04.2022 =D0=B3. =D0=B2 17:01 =D1=87. Tom Lane &lt;<a href=3D"m=
ailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; =D0=BD=D0=B0=D0=BF=D0=B8=
=D1=81=D0=B0:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Ko=
uber Saparev &lt;<a href=3D"mailto:kouber@gmail.com" target=3D"_blank">koub=
er@gmail.com</a>&gt; writes:<br>
&gt; I believe there is an error within this sentence in section<br>
&gt; <a href=3D"https://www.postgresql.org/docs/current/monitoring-stats.ht=
ml#MONITORING-PG-STAT-USER-FUNCTIONS-VIEW" rel=3D"noreferrer" target=3D"_bl=
ank">https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORI=
NG-PG-STAT-USER-FUNCTIONS-VIEW</a><br>
<br>
&gt; &quot;Therefore, a bitmap scan increments the<br>
&gt; pg_stat_all_indexes.idx_tup_read count(s)<br>
&gt; for the index(es) it uses, and it increments the pg_stat_all_tables.<b=
r>
&gt; idx_tup_fetch count for the table, but it does not affect<br>
&gt; pg_stat_all_indexes.idx_tup_fetch.&quot;<br>
<br>
&gt; There is repeated mentioning of pg_stat_all_indexes.idx_tup_fetch whil=
e I<br>
&gt; suppose one should read=C2=A0 pg_stat_all_indexes.idx_scan instead the=
 second<br>
&gt; time. I.e. bitmap scans do not increment idx_scan.<br>
<br>
Um ... you did notice that the mentions of idx_tup_fetch apply to two<br>
different views, pg_stat_all_tables vs pg_stat_all_indexes?<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>

--0000000000004c360405dbd4b6ed--