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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
