> How will I enable command string to see the commands?
in your postgresql.conf set stats_command_string = true
read
http://www.postgresql.org/docs/8.2/interactive/monitoring-stats.html for
details
---(end of broadcast)---
TIP 3: Have you checked
George,
How will I enable command string to see the commands?
Regards
skarthi
From: "George Pavlov" <[EMAIL PROTECTED]>
To: "Karthikeyan Sundaram"
<[EMAIL PROTECTED]>,,
Subject: Re: [SQL] Monitor what command is executing at the backend
Date: Wed, 21 Mar 20
>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.)
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
