how to know slowly query in lock postgre

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-performance@xxxxxxxxxxxxxx
Subject: how to know slowly query in lock postgre
From: Didik Prasetyo <prasetyodidik62@xxxxxxxxx>
Date: Mon, 20 Jun 2011 15:57:12 +0800 (SGT)

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

Follow-Ups:
- Re: how to know slowly query in lock postgre
  - From: Tomas Vondra
- Re: how to know slowly query in lock postgre
  - From: Claudio Freire

Prev by Date: Re: generating a large XML document
Next by Date: Re: generating a large XML document
Previous by thread: Inoptimal query plan for max() and multicolumn index
Next by thread: Re: how to know slowly query in lock postgre
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux