Re: see all queries incoming

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Flávio Brito <flavio(at)gral(dot)org(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: see all queries incoming
Date: 2005-08-28 12:17:53
Message-ID: 20050828121753.GA7944@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Aldor 2005-08-28 16:01:25 VACUUM - Wow long should it take?! - Here are some test results
Previous Message Flávio Brito 2005-08-28 11:49:13 see all queries incoming