From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-performance@lists.postgresql.org
Subject: Re: Detect missing combined indexes (automatically)
Date: Mon, 14 Jan 2019 08:19:50 +0100
Message-ID: <1154619c-9abc-c39c-c800-ef19b8f37aa6@gmx.net> (raw)
In-Reply-To: <fdbf5d62-c06a-761e-276e-ef72e772ed25@thomas-guettler.de>
References: <fdbf5d62-c06a-761e-276e-ef72e772ed25@thomas-guettler.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: spam_eater@gmx.net, pgsql-performance@lists.postgresql.org
Subject: Re: Detect missing combined indexes (automatically)
In-Reply-To: <1154619c-9abc-c39c-c800-ef19b8f37aa6@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox