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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match