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.
