Re: [SQL] Monitor what command is executing at the backend

[Karthikeyan Sundaram]

George,

 How will I enable command string to see the commands?
Regards
skarthi


From: "George Pavlov" <[EMAIL PROTECTED]>
To: "Karthikeyan Sundaram" 
<[EMAIL PROTECTED]>,<pgsql-admin@postgresql.org>,<pgsql-sql@postgresql.org>
Subject: Re: [SQL] Monitor what command is executing at the backend
Date: Wed, 21 Mar 2007 14:56:50 -0700

>    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.

for a current snapshot you don't need the logs, try:

  select * from pg_stat_activity;

(command string needs to be enabled for your database.)

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

_________________________________________________________________
It’s tax season, make sure to follow these few simple tips 
http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTips.aspx?icid=HMMartagline


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend