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

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-sql by date

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

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