Richard Hayward <richard@tortoise.demon.co.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