Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e9aKM-00038h-Gk for pgsql-performance@arkaria.postgresql.org; Tue, 31 Oct 2017 17:27:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e9aKM-0004w8-3Y for pgsql-performance@arkaria.postgresql.org; Tue, 31 Oct 2017 17:27:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e9aIb-0001lQ-8c for pgsql-performance@postgresql.org; Tue, 31 Oct 2017 17:26:01 +0000 Received: from mail-yw0-x231.google.com ([2607:f8b0:4002:c05::231]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1e9aIX-0002ZN-QY for pgsql-performance@postgresql.org; Tue, 31 Oct 2017 17:26:00 +0000 Received: by mail-yw0-x231.google.com with SMTP id t11so15385795ywg.12 for ; Tue, 31 Oct 2017 10:25:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=eKQJnXsSGnbpHVG+g/wN3r+dvS9CBD9/yGIxDfvqS/8=; b=SFmk7GX8oMvITxzbxySxXqVkPcLRGH1wQxZoYLNzl4Kj6eYFmbKXyEwlKzpSgYrlwT AkyPGVPgUg5DYFBgTrOmj2bmFifiW0l6F+CT+GW+zlKlChAD0UcTFukL5/X3jH3EBDfV WcBBMKBwCPY5Az7kniGODZ/idICCEsCxf9WD0Wx+njT71K/OXHjoVY8XQhpnqvD6/meD bpqiGwAmSzp6lJq9Jw7oijcAXoxfkmyQOtgQsCfMy1hPy+IGTw7hClfpoUjGZwMf+eDV 6aG94tNq17T+sulqhRjde9wnc8eaqNArxUGGKQV2LbTR/1vMhBMR+6e3YaOOjYZb3gfK 3WmQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=eKQJnXsSGnbpHVG+g/wN3r+dvS9CBD9/yGIxDfvqS/8=; b=hZEvx/LQyRq1dg3ZS/K6gUMtzkfKOlwiotJDO+BGmWsyitnQLWnfGhE47f5oSy0PQR X9adODWvhyt0nyyY/Pe6D5mjmtcXDLbTMGxosQzujUV27V+YITP+6KT2gr3GHZeEIcZs Ld4CzPoJZJliPtgnTHYqH4P/AyHZjgzWvEYh3AAEI2QrnvDNIZR75tkzXqQmcKUFluri oyc3xdAY9vQYzJyLQ+QwuxBIKU/t4NkXOImgfH/wHQZi0mFpxrsXSEKK3uh4A5ZYrZsx OMpzslt4Gpg2661aQpbo7PGC8EHy/2iE2ttZcF5Q0OOTHQGyutDavjTW3d5Sn7xW6avY BTKQ== X-Gm-Message-State: AMCzsaUGQ36aRpwl1yTjDFOP2goHKi/AkyD3IJSdat2xk4X6Psfs9TOv UYEsVRiLruHJTYe2gK0+jP2WF0r6uS220I8NwgX6sQ== X-Google-Smtp-Source: ABhQp+QtD9MarbsDOttOpIKTNiFOCYcD0Yedr5jZTssF9AKhlLPYFc8uNWC49cJiL18KTPlXM8XP7FGswcnwT6fj030= X-Received: by 10.129.201.67 with SMTP id c3mr1808174ywl.202.1509470756145; Tue, 31 Oct 2017 10:25:56 -0700 (PDT) MIME-Version: 1.0 Received: by 10.37.115.18 with HTTP; Tue, 31 Oct 2017 10:25:55 -0700 (PDT) In-Reply-To: References: From: Neto pr Date: Tue, 31 Oct 2017 15:25:55 -0200 Message-ID: Subject: Re: Index-Advisor Tools To: Anthony Sotolongo Cc: postgres performance list Content-Type: multipart/alternative; boundary="089e0822085c381004055cdb0cf6" List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --089e0822085c381004055cdb0cf6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 : > Hi Neto, maybe HypoPG > Can help you: > > https://github.com/dalibo/hypopg > > El 31 oct. 2017 2:13 PM, "Neto pr" escribi=C3=B3: > >> >> 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 >> > --089e0822085c381004055cdb0cf6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks for reply Antony.=C2=A0
But from wha= t 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,= =C2=A0 maybe=C2=A0

HypoPG

Can help you:


El 31 oct. 2017 2:13 PM, "Neto pr" <netopr9@gmail.com&= gt; escribi=C3=B3:
<= div dir=3D"ltr">
Hello All I'm researching on Index-Advisor Tools to be applied in SQL queries. At first I found this: - EnterpriseDB - https://w= ww.enterprisedb.com/docs/en/9.5/asguide/EDB_Postgres_Advanced_Ser= ver_Guide.1.56.html Someone would know of other tools for this purpose. I'd appreciate it i= f you can help me.

Best Regards
= Net= o

--089e0822085c381004055cdb0cf6--