Обсуждение: how to know slowly query in lock postgre
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
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
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