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

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 (view raw or flat)
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

pgsql-admin by date

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

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