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

reading pg_stat_activity view

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: reading pg_stat_activity view
Date: 2007-12-13 19:33:56
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C03062E18@egcrc-ex01.egcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
Hi everybody,

As I look at output from pg_stat_activity view,
I see often <idle> under query column and on the
same row waiting column is always f.  I gather
that this is someone sitting at prompt of psql.

My question: What does it mean when a query column
lists a sql statment and waiting column f?  Would
this mean something is in a hung state?

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

Responses

pgsql-admin by date

Next:From: Ferry, CraigDate: 2007-12-13 19:36:51
Subject: Error Creating Tablespace
Previous:From: Joshua D. DrakeDate: 2007-12-13 18:49:22
Subject: Re: Schema security

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