Subject: Re: Detect missing combined indexes (automatically)
To: pgsql-performance@lists.postgresql.org
References: <fdbf5d62-c06a-761e-276e-ef72e772ed25@thomas-guettler.de>
From: Thomas Kellerer <spam_eater@gmx.net>
Message-ID: <1154619c-9abc-c39c-c800-ef19b8f37aa6@gmx.net>
Date: Mon, 14 Jan 2019 08:19:50 +0100
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23)
 Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
MIME-Version: 1.0
In-Reply-To: <fdbf5d62-c06a-761e-276e-ef72e772ed25@thomas-guettler.de>
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: 8bit
Precedence: bulk

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