public inbox for [email protected]
help / color / mirror / Atom feedFrom: Julien Rouhaud <[email protected]>
To: Alexandre de Arruda Paes <[email protected]>
Cc: Neto pr <[email protected]>
Cc: Anthony Sotolongo <[email protected]>
Cc: postgres performance list <[email protected]>
Subject: Re: Index-Advisor Tools
Date: Tue, 31 Oct 2017 21:04:12 +0100
Message-ID: <CAOBaU_ZmCQ_NnVXXEwjf-sprVXt=oKGepc3e_e4tsWpSRMq=yw@mail.gmail.com> (raw)
In-Reply-To: <CAGewt-uXrx3MKEFs6b77tVQe68hF2aW_BesodSNUG-aqNJuaUw@mail.gmail.com>
References: <CA+wPC0OG5Ww2TT1bVbm8B3jhj0yY3dxhmMeOt-EP1DttoXNJuw@mail.gmail.com>
<CAASDfF3WwiMoYMKQtJSd-QWSK+PjfUs43NXnXq5RMXEo8XfVGA@mail.gmail.com>
<CA+wPC0OXyPoQ0L38r8-9Gndf4QkwZOvmKn33d3ZmG4=FPfqRMQ@mail.gmail.com>
<CAGewt-uXrx3MKEFs6b77tVQe68hF2aW_BesodSNUG-aqNJuaUw@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
On Tue, Oct 31, 2017 at 8:25 PM, Alexandre de Arruda Paes
<[email protected]> wrote:
> I will be very happy with a tool(or a stats table) that shows the most
> searched values from a table(since a statistic reset). i.e.:
>
> table foo (id int, year int)
>
> top 3 searched value for year field: 2017(500x), 2016(300x), 2015(55x)
>
> With this info we can create partial indexes or do a table partitioning.
>
>
>
> 2017-10-31 15:25 GMT-02:00 Neto pr <[email protected]>:
>>
>> Thanks for reply Antony.
>> But from what I've read, HYPOPG only allows you to create hypothetical
>> indexes, so the DBA can analyze if it brings benefits.
>> What I would like is a tool that from a SQL Query indicates which indexes
>> would be recommended to decrease the response time.
powa + pg_qualstats will give you this kind of information, and it can
analyse the actual queries and suggest indexes that could boost them,
or show constant repartition for the different WHERE clauses.
You can get more information on http://powa.readthedocs.io/en/latest/.
--
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Index-Advisor Tools
In-Reply-To: <CAOBaU_ZmCQ_NnVXXEwjf-sprVXt=oKGepc3e_e4tsWpSRMq=yw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox