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

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

From
"Dave Page"
Date:

> ------- 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

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

From
"Jeffrey Melloy"
Date:
How long has that been available for OS X?  Last time I looked at it it wasn't.

On 1/8/07, Dave Page <dpage@postgresql.org > wrote:


> ------- 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster