Locks

From: Yambu <hyambu(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Locks
Date: 2020-11-16 17:50:40
Message-ID: CALhHtcBm-+Ois+czF+i-garOnEekojViUkvpYnudnvoaDLKVAg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

  • Re: Locks at 2020-11-16 17:59:54 from David G. Johnston
  • RE: Locks at 2020-11-16 18:06:12 from Alvaro Aguayo
  • Re: Locks at 2020-11-16 18:52:19 from Keith Fiske

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2020-11-16 17:59:54 Re: Locks
Previous Message David G. Johnston 2020-11-15 20:30:22 Re: Create multiple users, to have all privileges on each others objects/relations