|
Hi. If you mean currently held locks, there is some info in pg_locks & pg_stat_activity which may be helpful for you. Check the Wiki:
https://wiki.postgresql.org/wiki/Lock_Monitoring Regards, Alvaro Aguayo From: Yambu <hyambu@xxxxxxxxx>
Hi How can i find out when a lock happened? Im writing a function that will check why some queries ran slowly at particular times, so i want to know if i can store lock information somewhere and retrieve what time the lock happened? regards |
