reading pg_stat_activity view - Mailing list pgsql-admin

From Tena Sakai
Subject reading pg_stat_activity view
Date
Msg-id FE44E0D7EAD2ED4BB2165071DB8E328C03062E18@egcrc-ex01.egcrc.org
Whole thread Raw
Responses Re: reading pg_stat_activity view
List 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@gallo.ucsf.edu

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Schema security
Next
From: "Ferry, Craig"
Date:
Subject: Error Creating Tablespace