Thread: see all queries incoming

How can I see, such as MSSQL screen, all queries that are processing in
real time?

I want to monitor all the queries that are being processed by a user in
real time.

Thanks

Flavio

On Sun, Aug 28, 2005 at 08:49:13AM -0300, Flávio Brito wrote:
> How can I see, such as MSSQL screen, all queries that are processing in
> real time?

You can configure the backend to log the queries it receives; for
more information see "Error Reporting and Logging" in the "Server
Run-time Environment" chapter of the documentation.  Here's a link
to the documentation for the latest version of PostgreSQL:

http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-LOGGING

--
Michael Fuhr