Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id E4C38635DAD;
	Tue, 13 Apr 2010 10:23:00 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024)
	with ESMTP id 86139-01-6; Tue, 13 Apr 2010 13:22:49 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-ew0-f220.google.com (mail-ew0-f220.google.com
	[209.85.219.220])
	by mail.postgresql.org (Postfix) with ESMTP id 08603632CA2;
	Tue, 13 Apr 2010 10:17:40 -0300 (ADT)
Received: by ewy20 with SMTP id 20so2782889ewy.21
	for <multiple recipients>; Tue, 13 Apr 2010 06:17:38 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:from:reply-to:to:subject:date
	:user-agent:cc:references:in-reply-to:mime-version:content-type
	:content-transfer-encoding:content-disposition:message-id;
	bh=oqcp7d2vcw0bJFxcCEnbvolZMY7yaPOJ2PLTcVF5tI0=;
	b=U7AcyqZYfANYLGwceM5cUI4KjwuxK5145tIXPqbmSZIH05pJ/xyEu/k+Y0ZSNzjXdP
	r1BtvEUbvAio3yYpIxZXVPkQPdTbKUNLx9IZ7Vsg54nQLzu8GiutZaz6MU44xBVaTiRV
	pTCMeeo4/dYNG8g6eS7NFrcOfPypqETPVJ+oQ=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=from:reply-to:to:subject:date:user-agent:cc:references:in-reply-to
	:mime-version:content-type:content-transfer-encoding
	:content-disposition:message-id;
	b=Bl4DcR+eQdOvFWcc15e6/u4eVQBT7dwSpH458KNX6P8d11jGSzNV7dsFruFfGr/xbI
	f9mUGao3lPD/KmjifxnuTklA237vDtsF/7HjOIgrd0ty7Q49gyYXPQofjgbbHiP8Jcjl
	kOglHZNDuhiLZFxAk/zxKsWYOX1AzQfBaz3MU=
Received: by 10.213.25.78 with SMTP id y14mr2896789ebb.75.1271164658744;
	Tue, 13 Apr 2010 06:17:38 -0700 (PDT)
Received: from tucker.local (c-24-17-164-54.hsd1.wa.comcast.net
 [24.17.164.54])
	by mx.google.com with ESMTPS id 13sm3618969ewy.9.2010.04.13.06.17.37
	(version=SSLv3 cipher=RC4-MD5); Tue, 13 Apr 2010 06:17:37 -0700 (PDT)
From: Adrian Klaver <adrian.klaver@gmail.com>
Reply-To: adrian.klaver@gmail.com
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Query is stuck
Date: Tue, 13 Apr 2010 06:17:34 -0700
User-Agent: KMail/1.9.10
Cc: "Satish Burnwal (sburnwal)" <sburnwal@cisco.com>,
	"Plugge, Joe R." <JRPlugge@west.com>, pgsql-admin@postgresql.org
References: <3A8C969225424C4D8E6BEE65ED8552DA0119F188@XMB-BGL-41C.cisco.com>
	<BD69807DAE0CE44CA00A8338D0FDD08302CF97EA2F@oma00cexmbx03.corp.westworlds.com>
	<3A8C969225424C4D8E6BEE65ED8552DA0119F18F@XMB-BGL-41C.cisco.com>
In-Reply-To: <3A8C969225424C4D8E6BEE65ED8552DA0119F18F@XMB-BGL-41C.cisco.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <201004130617.35417.adrian.klaver@gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.889 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201004/157
X-Sequence-Number: 34251

On Tuesday 13 April 2010 6:03:43 am Satish Burnwal (sburnwal) wrote:
> controlsmartdb=3D# select * from pg_stat_activity where waiting=3D't';
>
> ERROR:  column "waiting" does not exist
>
>

=46rom here:
http://www.postgresql.org/docs/8.4/interactive/monitoring-stats.html#MONITO=
RING-STATS-VIEWS

My guess is you are being caught by this;

pg_stat_activity

"Furthermore, these columns are only visible if the user examining the view=
 is a=20
superuser or the same as the user owning the process being reported on. '

=2D-=20
Adrian Klaver
adrian.klaver@gmail.com