Re: [PERFORM] how to know slowly query in lock postgre

2011-06-20 Thread Tomas Vondra
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

Re: [PERFORM] how to know slowly query in lock postgre

2011-06-20 Thread Claudio Freire
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 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 postg

[PERFORM] how to know slowly query in lock postgre

2011-06-20 Thread Didik Prasetyo
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