Dear Team,
Recently we have noticed that in one of our DB instances there is a potential
delay in querying a table from java code. could you please check the attached
log and help understand what is the problem and which direction should be look
into solving this delay of 4 odd mins ?
The tabl
Hi ,
Thank you for the reply. Is there a similar way to extract the same from a SQL
command ?
Thanks
-Original Message-
From: Justin Pryzby
Sent: Thursday, May 13, 2021 10:09 PM
To: Manoj Kumar
Cc: pgsql-performa...@postgresql.org
Subject: [EXT MSG] Re: PostgreSQL blocked locks query
Hi Team,
I have query in terms of lock monitoring in PostgreSQL where I am not able to
find a way to figure out what value has been passed in SQL statement (from JDBC
driver as prepared statement).
I am using PostgreSQL 13 version.
The following is the SQL statement I am running in PGAdmin
S