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 <neto...@gmail.com>:

> 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 <asotolo...@gmail.com>:
>> Hi Neto,  maybe HypoPG
>> Can help you:
>> https://github.com/dalibo/hypopg
>> El 31 oct. 2017 2:13 PM, "Neto pr" <neto...@gmail.com> 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 via email to