Re: how to know slowly query in lock postgre

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Didik Prasetyo <prasetyodidik62(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: how to know slowly query in lock postgre
Date: 2011-06-20 09:45:00
Message-ID: BANLkTi=rq2GGGb8eg4-eySmh_Munux=gUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Something like this[0] ?

[0] http://archives.postgresql.org/pgsql-hackers/2007-04/msg01037.php

On Mon, Jun 20, 2011 at 9:57 AM, Didik Prasetyo
<prasetyodidik62(at)yahoo(dot)com> wrote:
> hai friend i have problem with performance database in postgre, how to know
> slowly query in postgre,
> i want kill or stop query to make postgre slowly, on the server status on
> the admin pg, sometimes the query and how long the query runs do not appear
>
> Thanks for solution
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Sushant Sinha 2011-06-20 15:38:59 sequential scan unduly favored over text search gin index
Previous Message Julius Tuskenis 2011-06-20 09:03:21 Re: generating a large XML document