Monitor what command is executing at the backend

From: "Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Monitor what command is executing at the backend
Date: 2007-03-21 21:49:43
Message-ID: BAY131-F16DCAE8C81294422B3C522B0740@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

Hi everybody,

Is there a way to see from the log files on what sql statement is
currently by which user? In other words, I want to monitor the DB activity.

How can I find it?

Regards
skarthi

_________________________________________________________________
Get a FREE Web site, company branded e-mail and more from Microsoft Office
Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message George Pavlov 2007-03-21 21:56:50 Re: [SQL] Monitor what command is executing at the backend
Previous Message Karthikeyan Sundaram 2007-03-21 18:33:13 Re: Read-only access to a database

Browse pgsql-sql by date

  From Date Subject
Next Message George Pavlov 2007-03-21 21:56:50 Re: [SQL] Monitor what command is executing at the backend
Previous Message Guy Fraser 2007-03-21 20:32:26 Re: Regular Expressions