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

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To: 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-08 19:06:05
Message-ID: 45A2961D.3080108@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2007-01-08 19:06:31 Re: is there a tracking trace tool like the "SQL Analizer" in MS sqlserver.?
Previous Message Joshua D. Drake 2007-01-08 19:05:10 Re: is there a tracking trace tool like the "SQL