Re: Index-Advisor Tools
Neto pr <netopr9@gmail.com>
From: Neto pr <netopr9@gmail.com>
To: Anthony Sotolongo <asotolongo@gmail.com>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Date: 2017-10-31T17:25:55Z
Lists: pgsql-performance
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: > > https://github.com/dalibo/hypopg > > 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_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 >> >