Hi,
Hannu Krosing wrote:
>> 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
Or read about dtrace to analyze lower level locking contention:
http://www.postgresql.org/docs/8.3/static/dynamic-trace.html
Regards
Markus Wanner