Re: Patch: Show queries of processes holding a lock

2024-10-03 Thread Alexey Orlov
On Thu, Oct 3, 2024 at 3:58 AM David Rowley wrote: > > On Tue, 1 Oct 2024 at 21:04, Alexey Orlov wrote: > > session 1: > > CREATE TABLE foo (val integer); > > INSERT INTO foo (val) VALUES (1); > > BEGIN; > > UPDATE foo SET val = 3; > > > > sessio

Re: Patch: Show queries of processes holding a lock

2024-10-02 Thread Alexey Orlov
On Tue, Oct 1, 2024 at 11:45 AM wenhui qiu wrote: > > Hi Alexey Orlov > Thank you for your work on this path,The lock information is recorded in > detail,Easy to trace the lock competition at that time there is a detailed > lock competition log,But I have a concern,Frequen

Patch: Show queries of processes holding a lock

2024-10-01 Thread Alexey Orlov
Sep 17 00:00:00 2001 From: Alexey Orlov Date: Mon, 30 Sep 2024 22:11:25 +0300 Subject: [PATCH v=1] Show queries in log_lock_wait_log --- src/backend/storage/lmgr/proc.c | 20 1 file changed, 16 insertions(+), 4 deletions(-) diff --git a/src/backend/storage/lmgr/proc.c b/src/