| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
| Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Detect missing combined indexes (automatically) |
| Date: | 2019-01-14 07:42:56 |
| Message-ID: | CAOBaU_aF40htBMcX1SCQ3dKCAZvXGJih0g3wvS4KMY_6G6BYQA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, Jan 14, 2019 at 8:20 AM Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:
>
> Thomas Güttler schrieb am 10.01.2019 um 13:56:
> > Is there a way to detect missing combined indexes automatically
> >
> > I am managing a lot of databases and I think a lot of performance
> > could get gained.
> >
> > But I don't want to do this manually.
> >
> > My focus is on missing combined indexes, since for missing
> > single indexes there are already tools available.
>
> The PoWA monitoring tool contains an extension to suggest missing indexes.
>
> I don't know if that includes multi-column indexes though, but it might be worth a try:
>
> https://powa.readthedocs.io/en/latest/stats_extensions/pg_qualstats.html
Yes, it can handle multi-column indexes.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2019-01-15 01:46:34 | Re: Query with high planning time at version 11.1 compared versions 10.5 and 11.0 |
| Previous Message | Thomas Kellerer | 2019-01-14 07:19:50 | Re: Detect missing combined indexes (automatically) |