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

Browse pgsql-admin by date

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