Skip site navigation (1) Skip section navigation (2)

Re: Equivalent of mssql profiler?

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: (view raw, whole thread or download thread mbox)
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, maybe you'll find something.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Stephan SzaboDate: 2004-03-26 18:56:44
Subject: Re: Extract Function
Previous:From: David P. LurieDate: 2004-03-26 01:59:14
Subject: Re: configure script failure with SCO 5.0.7

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group