On Thu, 2008-11-13 at 18:55 +0800, 崔岩ccuiyyan(at)sina(dot)com wrote:
> Hi all:
>
> I am a fresh men in PostgreSQL. And i work on benchmark study
> these days using PostgreSQL.
>
> Now i have a question: Is there some way to show the lock contention
> of PostgreSQL?
>
> As I know, you can use show mutex status in MySQL to find which mutex
> is hot. But i don't know in PostgreSQL.
look at pg_locks system view
--
------------------------------------------
Hannu Krosing http://www.2ndQuadrant.com
PostgreSQL Scalability and Availability
Services, Consulting and Training