Re: Huge shared hit for small table

From: Andres Freund <andres(at)anarazel(dot)de>
To: Scott Rankin <srankin(at)motus(dot)com>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Huge shared hit for small table
Date: 2019-11-04 20:17:28
Message-ID: 20191104201728.qwjfwakseprjoe3m@alap3.anarazel.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

On 2019-11-04 19:56:57 +0000, Scott Rankin wrote:
> The index is exceedingly simple:
>
>
> CREATE UNIQUE INDEX "programPK" ON program(id int8_ops);
>
> From pg_stat_user_indexes:
>
> Staging:
>
> idx_scan: 5826745
> idx_tup_read: 52715470
> idx_tup_fetch: 52644465
>
> Production:
>
> idx_scan : 7277919087
> idx_tup_read: 90612605047
> idx_tup_fetch: 5207807880

I was basically asking for SELECT * FROM pgstatindex('pgstatindex');
with pgstatindex being from the pgstattuple extension
https://www.postgresql.org/docs/current/pgstattuple.html
not the pg_stat_user_indexes entry...

Greetings,

Andres Freund

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Rankin 2019-11-04 20:18:03 Re: Huge shared hit for small table
Previous Message Peter Geoghegan 2019-11-04 20:07:27 Re: Huge shared hit for small table