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: | Raw Message | Whole Thread | 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
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 |