Re: how to know slowly query in lock postgre - Mailing list pgsql-performance

From Claudio Freire
Subject Re: how to know slowly query in lock postgre
Date
Msg-id BANLkTi=rq2GGGb8eg4-eySmh_Munux=gUw@mail.gmail.com
Whole thread Raw
In response to how to know slowly query in lock postgre  (Didik Prasetyo <prasetyodidik62@yahoo.com>)
List 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@yahoo.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
>

pgsql-performance by date:

Previous
From: Julius Tuskenis
Date:
Subject: Re: generating a large XML document
Next
From: "Kevin Grittner"
Date:
Subject: Re: Inoptimal query plan for max() and multicolumn index