Postgres Pro
Downloads
Home   >   mailing lists

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

From Neto pr
Subject Re: [PERFORM] Index-Advisor Tools
Date
Msg-id CA+wPC0OXyPoQ0L38r8-9Gndf4QkwZOvmKn33d3ZmG4=FPfqRMQ@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Index-Advisor Tools  (Anthony Sotolongo <asotolongo@gmail.com>)
Responses Re: [PERFORM] Index-Advisor Tools
List pgsql-performance
Tree view
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: Anthony Sotolongo
Date:
Subject: Re: [PERFORM] Index-Advisor Tools
Next
From: Alexandre de Arruda Paes
Date:
Subject: Re: [PERFORM] Index-Advisor Tools