From: | Alvaro Aguayo <aaguayo(at)opensysperu(dot)com> |
---|---|
To: | Yambu <hyambu(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | RE: Locks |
Date: | 2020-11-16 18:06:12 |
Message-ID: | SC1P15201MB22384E579053E82636DE6D8DAFE30@SC1P15201MB2238.LAMP152.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)gmail(dot)com>
Sent: 16 November 2020 12:51
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Locks
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
From | Date | Subject | |
---|---|---|---|
Next Message | Keith Fiske | 2020-11-16 18:52:19 | Re: Locks |
Previous Message | David G. Johnston | 2020-11-16 17:59:54 | Re: Locks |