public inbox for [email protected]  

help / color / mirror / Atom feed

From: Alexandre de Arruda Paes <[email protected]>
To: 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 17:25:36 -0200
Message-ID: <CAGewt-uXrx3MKEFs6b77tVQe68hF2aW_BesodSNUG-aqNJuaUw@mail.gmail.com> (raw)
In-Reply-To: <CA+wPC0OXyPoQ0L38r8-9Gndf4QkwZOvmKn33d3ZmG4=FPfqRMQ@mail.gmail.com>
References: <CA+wPC0OG5Ww2TT1bVbm8B3jhj0yY3dxhmMeOt-EP1DttoXNJuw@mail.gmail.com>
	<CAASDfF3WwiMoYMKQtJSd-QWSK+PjfUs43NXnXq5RMXEo8XfVGA@mail.gmail.com>
	<CA+wPC0OXyPoQ0L38r8-9Gndf4QkwZOvmKn33d3ZmG4=FPfqRMQ@mail.gmail.com>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

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.
>
> Best Regards
> Neto
>
> 2017-10-31 15:19 GMT-02:00 Anthony Sotolongo <[email protected]>:
>
>> Hi Neto,  maybe HypoPG
>> Can help you:
>>
>> https://github.com/dalibo/hypopg
>>
>> El 31 oct. 2017 2:13 PM, "Neto pr" <[email protected]> escribió:
>>
>>>
>>> Hello All I'm researching on Index-Advisor Tools to be applied in SQL
>>> queries. At first I found this: - EnterpriseDB -
>>> https://www.enterprisedb.com/docs/en/9.5/asguide/EDB_Postgre
>>> s_Advanced_Server_Guide.1.56.html Someone would know of other tools for
>>> this purpose. I'd appreciate it if you can help me.
>>>
>>> Best Regards
>>> Neto
>>>
>>
>

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]
  Subject: Re: Index-Advisor Tools
  In-Reply-To: <CAGewt-uXrx3MKEFs6b77tVQe68hF2aW_BesodSNUG-aqNJuaUw@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