Does anybody know if it is possible to use the statistics collected by
PostgreSQL to do the following, and how?
- view all locks held by a particular PostgreSQL session (including how to
determine
the session ID#)
- determine effect of lock contention on overall database performance, as
well as the
extent to which contention varies with overall database traffic
I am using version 8.0.2 on Windows 2003.