Re: is there a tracking trace tool like the "SQL Analizer

> ------- Original Message -------
> From: "Ian Harding" <harding(dot)ian(at)gmail(dot)com>
> To: "Jeffrey Melloy" <melloyj(at)alliancetechnologies(dot)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