Richard Hayward <richard(at)tortoise(dot)demon(dot)co(dot)uk> writes:
> Using MSSQL, I really like the Profiler tool.
> You can watch the SQL statements from all, or a subset of clients
> arrive at the server. I find it usefull to know who is asking what.
> Also when clent apps dont behave as I expect, I can watch the commands
> they issue to faultfind.
> Is there such a tool in PostgreSQL? I've not found one.
You can turn on log_statement and then watch the postmaster log file
(eg, with "tail -f"). I'm not aware of anyone having made a fancy GUI
tool to monitor the log file ... but try poking around in the projects
at gborg.postgresql.org, maybe you'll find something.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Stephan Szabo||Date: 2004-03-26 18:56:44|
|Subject: Re: Extract Function|
|Previous:||From: David P. Lurie||Date: 2004-03-26 01:59:14|
|Subject: Re: configure script failure with SCO 5.0.7|