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

From Tomas Vondra
Subject Re: how to know slowly query in lock postgre
Date
Msg-id 4DFF9AEE.8080009@fuzzy.cz
Whole thread Raw
In response to how to know slowly query in lock postgre  (Didik Prasetyo <prasetyodidik62@yahoo.com>)
List pgsql-performance
Dne 20.6.2011 09:57, Didik Prasetyo napsal(a):
> 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

Killing long running queries probably is not a good idea (at least the
users usually think that).

You should try to identify the slow queries and optimize them first. The
"log_min_duration_statement" can do that - the queries that take longer
will be written to the postgresql log.

http://www.postgresql.org/docs/8.3/static/runtime-config-logging.html

regards
Tomas

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: sequential scan unduly favored over text search gin index
Next
From: Jon Nelson
Date:
Subject: Re: bad plan: 8.4.8, hashagg, work_mem=1MB.