Performance Issue on a table

2021-07-23 Thread Manoj Kumar
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

RE: Re: PostgreSQL blocked locks query

2021-05-14 Thread Manoj Kumar
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

PostgreSQL blocked locks query

2021-05-13 Thread Manoj Kumar
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