| Lists: | pgsql-novice |
|---|
| From: | Richard Hayward <richard(at)tortoise(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Equivalent of mssql profiler? |
| Date: | 2004-03-23 20:54:00 |
| Message-ID: | ik8160d8caf4c4m9sppd2eu29jequ918at@4ax.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
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.
regards
Richard
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Richard Hayward <richard(at)tortoise(dot)demon(dot)co(dot)uk> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Equivalent of mssql profiler? |
| Date: | 2004-03-26 18:04:37 |
| Message-ID: | 25467.1080324277@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-novice |
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