Re: is there a tracking trace tool like the "SQL Analizer"

guillermo arias wrote:
> is there a tracking trace tool in postgre? like the "SQL Analizer" in 
> MS sqlserver.
>
> I have downloaded the PGAdmin III and i have not found any tool like this.
>
> Thanks
>
>  
> ------------------------------------------------------------------------
> Get your FREE, LinuxWaves.com Email Now! --> http://www.LinuxWaves.com
> Join Linux Discussions! --> http://Community.LinuxWaves.com
Hi,
You can do this with Postgresql by turning on log statements in the 
postgresql.conf file.
You can then trace all the statements that the server executed in the 
log and the values that where passed.

You could also check out Lightning Admin instead of pgAdmin III. 
We have a feature that can capture the currently running statement from 
a process and list them all in a memo.
Can be handy.
You can find out more here:
http://www.amsoftwaredesign.com/onlinehelp/pgla/server_status.htm
While not free, Lightning Admin is SUPER inexpensive :-) and you will 
get great support.

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