Skip site navigation (1) Skip section navigation (2)

waiting column in pg_stat_activity and function pg_stat_get_backend_waiting (8.1)

From: Carol Cheung <cacheung(at)consumercontact(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: waiting column in pg_stat_activity and function pg_stat_get_backend_waiting (8.1)
Date: 2010-03-10 18:38:18
Message-ID: 4B97E71A.7080209@consumercontact.com (view raw or flat)
Thread:
Lists: pgsql-novice
In 8.2, pg_stat_activity has a column called waiting, which is achieved 
through a function called pg_stat_get_backend_waiting.

However, in 8.1, this column does not exist in pg_stat_activity. Is it 
possible to get this column / data in 8.1? I see from 
http://www.postgresql.org/docs/8.1/static/monitoring-stats.html
that such a function is not available.

Responses

pgsql-novice by date

Next:From: Brad NicholsonDate: 2010-03-11 17:33:28
Subject: Re: waiting column in pg_stat_activity and function pg_stat_get_backend_waiting (8.1)
Previous:From: Joshua TolleyDate: 2010-03-10 18:30:11
Subject: Re: Slony vs Pgpool

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group