pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Adrian Klaver <adrian.klaver@gmail.com>
To: pgsql-general@postgresql.org
Cc: Satish Burnwal (sburnwal) <sburnwal@cisco.com>
Cc: Plugge, Joe R. <JRPlugge@west.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] Query is stuck
Date: Tue, 13 Apr 2010 06:17:34 -0700
Message-ID: <201004130617.35417.adrian.klaver@gmail.com> (raw)
In-Reply-To: <3A8C969225424C4D8E6BEE65ED8552DA0119F18F@XMB-BGL-41C.cisco.com>
References: <3A8C969225424C4D8E6BEE65ED8552DA0119F188@XMB-BGL-41C.cisco.com>
	<BD69807DAE0CE44CA00A8338D0FDD08302CF97EA2F@oma00cexmbx03.corp.westworlds.com>
	<3A8C969225424C4D8E6BEE65ED8552DA0119F18F@XMB-BGL-41C.cisco.com>

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

From here:
http://www.postgresql.org/docs/8.4/interactive/monitoring-stats.html#MONITORING-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 
superuser or the same as the user owning the process being reported on. '

-- 
Adrian Klaver
adrian.klaver@gmail.com

view thread (22+ messages)  latest in thread

Message-ID: <201004130617.35417.adrian.klaver@gmail.com>
Permalink:  ../201004130617.35417.adrian.klaver@gmail.com/
Also on:    postgresql.org/message-id/201004130617.35417.adrian.klaver@gmail.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: adrian.klaver@gmail.com, pgsql-general@postgresql.org, sburnwal@cisco.com, JRPlugge@west.com
  Subject: Re: [GENERAL] Query is stuck
  In-Reply-To: <201004130617.35417.adrian.klaver@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox