Thread: Re: is there a tracking trace tool like the "SQL Analizer
> ------- 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
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