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

From: "George Pavlov" <gpavlov(at)mynewplace(dot)com>
To: "Karthikeyan Sundaram" <skarthi98(at)hotmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] Monitor what command is executing at the backend
Date: 2007-03-21 22:25:05
Message-ID: 8C5B026B51B6854CBE88121DBF097A869869E1@ehost010-33.exch010.intermedia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Davidson, Robert 2007-03-22 02:42:40 Vacuum taking forever
Previous Message Karthikeyan Sundaram 2007-03-21 22:16:42 Re: [SQL] Monitor what command is executing at the backend

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2007-03-22 01:35:28 Re: Regular Expressions
Previous Message Karthikeyan Sundaram 2007-03-21 22:16:42 Re: [SQL] Monitor what command is executing at the backend