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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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