Re: 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.
If you want something like the trace in MS SQL server Lightning Admin
has something similar:
http://www.amsoftwaredesign.com/onlinehelp/pgla/server_status.htm
You can select the process ID you want, then check the Capture selected
rows query option and all the queries for that process that become
visible will be
logged to a memo control, you can then copy the captured queries to
where ever you like.


Later,

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration