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.
Show quoted text
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 "SQLAnalizer" 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
------- Original Message -------
From: "Jeffrey Melloy" <jmelloy@gmail.com>
To: "Dave Page" <dpage@postgresql.org>
Sent: 1/8/07, 8:18:02 PM
Subject: Re: [GENERAL] is there a tracking trace tool like the "SQL AnalizerHow long has that been available for OS X? Last time I looked at it it
wasn't.
2 years or so iirc.
Regards, Dav3
Import Notes
Resolved by subject fallback
------- Original Message -------
From: Tony Caduto <tony_caduto@amsoftwaredesign.com>
To: Harald Armin Massa <haraldarminmassa@gmail.com>
Sent: 1/9/07, 7:15:52 PM
Subject: Re: [GENERAL] is there a tracking trace tool like the "SQL Analizer"Harald Armin Massa wrote:
Jeffrey,
Not exactly. SQL Analyzer also includes live monitoring of whatever
queries
are coming into the database. You can achieve something similar by
enabling
query logging in the settings.that is within Tools / View Server Status of pgAdmin III
Of course, Query Command String has to be enabled on the server; and
the security implications of that setting have to be considered before
:)best wishes,
Harald
Hi,
I may be wrong but:
Enabling query logging (in the options dialog) will only log the SQL
pgAdmin III sends to the server, it will not capture the query for a
selected process
in the server status dialog.
That's not what Harald was referring to. The server status dialog monitors the entire server via pg_stat*.
/D
Import Notes
Resolved by subject fallback
Dave Page wrote:
That's not what Harald was referring to. The server status dialog monitors the entire server via pg_stat*.
/D
Hi Dave,
It was not just a response to Harald's comment, but also the one right
above his :-)
"You can achieve something similar by enabling query logging in the settings."
Which Harald then continued with this:
"that is within Tools / View Server Status of pgAdmin III"
So someone reading that may have thought that you could turn on query logging
in Tools/ Server Status.(which as far as I can tell you can't)
So yes, you can turn on SQL logging in the main options dialog, but that will
not capture the query values in the server status dialog which what Harald was "seeming"
to say.
I guess everyone can read into something differently :-)
Later,
---
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration