Re: long lasting select, no io nor cpu usage ?

From: Franck Routier <franck(dot)routier(at)axege(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: long lasting select, no io nor cpu usage ?
Date: 2014-03-20 14:07:31
Message-ID: 532AF623.2040502@axege.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 ?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2014-03-20 14:15:03 Re: long lasting select, no io nor cpu usage ?
Previous Message Tom Lane 2014-03-20 13:56:25 Re: long lasting select, no io nor cpu usage ?