| 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: | Whole Thread | Raw Message | 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 |