Обсуждение: how to know slowly query in lock postgre

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
>

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