| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
| Cc: | Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>, Jeffrey Melloy <melloyj(at)alliancetechnologies(dot)net>, harding(dot)ian(at)gmail(dot)com, guillermoariast(at)linuxwaves(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: is there a tracking trace tool like the "SQL Analizer" |
| Date: | 2007-01-09 19:20:58 |
| Message-ID: | 45A3EB1A.5030405@hagander.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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.
Out of curiosity, how does that work? I mean, how does it pick up when a
new query has been issued? Do you use some server-proc to tail the
logfile or such?
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2007-01-09 19:28:53 | Re: Array constructor requires one argument |
| Previous Message | Tony Caduto | 2007-01-09 19:15:52 | Re: is there a tracking trace tool like the "SQL Analizer" |