Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group