Postgres Pro
Downloads
Home   >   mailing lists

Re: long lasting select, no io nor cpu usage ? - Mailing list pgsql-performance

From Franck Routier
Subject Re: long lasting select, no io nor cpu usage ?
Date
Msg-id 532AF623.2040502@axege.com
Whole thread Raw
In response to Re: long lasting select, no io nor cpu usage ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: long lasting select, no io nor cpu usage ?
List pgsql-performance
Tree view 
Le 20/03/2014 14:56, Tom Lane a écrit :
> pg_locks, probably. regards, tom lane

select * from pg_stat_activity shows 'F'alse in the waiting column for
the query.

Can I rely on that or should I be investigating further for subtile
types of locks ?
Attachment

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: long lasting select, no io nor cpu usage ?
Next
From: Tom Lane
Date:
Subject: Re: long lasting select, no io nor cpu usage ?