Re: is there a tracking trace tool like the "SQL Analizer - Mailing list pgsql-general

From Dave Page
Subject Re: is there a tracking trace tool like the "SQL Analizer
Date
Msg-id 200701082010060000@1928231100
Whole thread Raw
Responses Re: is there a tracking trace tool like the "SQL Analizer
List pgsql-general

> ------- Original Message -------
> From: "Ian Harding" <harding.ian@gmail.com>
> To: "Jeffrey Melloy" <melloyj@alliancetechnologies.net>
> Sent: 1/8/07, 7:06:31 PM
> Subject: Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?
>
> I thought that was called SQL Profiler.
>
> http://msdn2.microsoft.com/en-us/library/ms181091.aspx
>
> Query Analyzer is EXPLAIN with a GUI.
>
> http://msdn2.microsoft.com/en-gb/library/aa178423(SQL.80).aspx
>
> Anyway, I have not heard of such a thing for PostgreSQL, although I am
> sure the basic information you want could be obtained from logging
> queries and timing.

pgAdmin has graphical explain, and basic activity monitoring. It is free, and has great support!

Regards, Dave

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Slony in Windows installer?
Next
From: Shelby Cain
Date:
Subject: Re: Database Failure on Windows XP Pro psql (PostgreSQL) 8.1.4