Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Index-Advisor Tools - Mailing list pgsql-performance

From Alexandre de Arruda Paes
Subject Re: [PERFORM] Index-Advisor Tools
Date
Msg-id CAGewt-uXrx3MKEFs6b77tVQe68hF2aW_BesodSNUG-aqNJuaUw@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Index-Advisor Tools  (Neto pr <netopr9@gmail.com>)
Responses Re: [PERFORM] Index-Advisor Tools
List pgsql-performance
Tree view
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 <netopr9@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 <asotolongo@gmail.com>:
Hi Neto,  maybe 

HypoPG

Can help you:


El 31 oct. 2017 2:13 PM, "Neto pr" <netopr9@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_Postgres_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


pgsql-performance by date:

Previous
From: Neto pr
Date:
Subject: Re: [PERFORM] Index-Advisor Tools
Next
From: Yves Dorfsman
Date:
Subject: Re: [PERFORM] Index-Advisor Tools