Analyze tool?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Analyze tool?
Date: 2010-10-01 09:53:14
Message-ID: 20101001115314.55d010c2@btj-tux.asp-as.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are using both DB2 and PostgreSQL at work and DB2 has a nice tool, i5 Navigator, where one can enable logging of SQL statements and then it will
recommed indexes that should/could be created to increase speed...
Does there exist a similar tool for PostgreSQL?

Regards,

BTJ

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj(at)havleik(dot)no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2010-10-01 09:58:20 Re: PostgreSQL 9.0 (x86-64) and Windows 7 (x86-64) - Unable to install
Previous Message Michele Petrazzo - Unipex 2010-10-01 09:47:28 Re: [9.0] hot standby plus streaming replication