waiting column in pg_stat_activity and function pg_stat_get_backend_waiting (8.1) - Mailing list pgsql-novice

From Carol Cheung
Subject waiting column in pg_stat_activity and function pg_stat_get_backend_waiting (8.1)
Date
Msg-id 4B97E71A.7080209@consumercontact.com
Whole thread Raw
Responses Re: waiting column in pg_stat_activity and function pg_stat_get_backend_waiting (8.1)  (Brad Nicholson <bnichols@ca.afilias.info>)
List 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.

pgsql-novice by date:

Previous
From: Joshua Tolley
Date:
Subject: Re: Slony vs Pgpool
Next
From: Brad Nicholson
Date:
Subject: Re: waiting column in pg_stat_activity and function pg_stat_get_backend_waiting (8.1)