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

Re: PostgreSQL blocked locks query

2021-05-13 Thread Justin Pryzby
On Thu, May 13, 2021 at 01:54:32PM +, Manoj Kumar wrote: > 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. >

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