| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | "Satish Burnwal (sburnwal)" <sburnwal(at)cisco(dot)com>, "Plugge, Joe R(dot)" <JRPlugge(at)west(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Query is stuck |
| Date: | 2010-04-13 13:17:34 |
| Message-ID: | 201004130617.35417.adrian.klaver@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2010-04-13 13:33:37 | Re: Unknown winsock error 10061 |
| Previous Message | Satish Burnwal (sburnwal) | 2010-04-13 13:14:49 | Re: Query is stuck |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Satish Burnwal (sburnwal) | 2010-04-13 13:51:19 | Re: [ADMIN] Query is stuck |
| Previous Message | Jaiswal Dhaval Sudhirkumar | 2010-04-13 13:15:17 | Re: Unknown winsock error 10061 |