There is also interesting new module pg_stat_wait that enables LWLocks monitoring (as well as other types of locks), it is already used in mail.yandex.ru (the 2

There is also interesting new module pg_stat_wait that enables LWLocks monitoring (as well as other types of locks), it is already used in mail.yandex.ru (the 2nd largest email service in Russia). However the module requires Postgres be patched https://github.com/postgrespro/postgres/tree/waits_monitoring_94 https://github.com/postgrespro/postgres/tree/waits_monitorin... Related discussion in -hackers: http://www.postgresql.org/message-id/flat/3F71DA37-A17B-4961-9908-016E6323E612@postgrespro.ru#3F71DA37-A17B-4961-9908-016E6323E612@postgrespro.ru http://www.postgresql.org/message-id/flat/3F71DA37-A17B-4961...