Re: Detect missing combined indexes (automatically)

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Detect missing combined indexes (automatically)
Дата
Msg-id 1154619c-9abc-c39c-c800-ef19b8f37aa6@gmx.net
обсуждение исходный текст
Ответ на Detect missing combined indexes (automatically)  (Thomas Güttler <guettliml@thomas-guettler.de>)
Ответы Re: Detect missing combined indexes (automatically)  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-performance
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

Thomas





В списке pgsql-performance по дате отправления:

Предыдущее
От: Jim Finnerty
Дата:
Сообщение: Re: Detect missing combined indexes (automatically)
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Detect missing combined indexes (automatically)