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
SELECT
activity.pid as BlockedPid,
activity.usename,
activity.query,
blocking.pid AS Blocking_Pid,
to_char(now() - activity.query_start, 'HH24:MI:SS') as elapsed
FROM pg_stat_activity AS activity
JOIN pg_stat_activity AS blocking ON blocking.pid =
ANY(pg_blocking_pids(activity.pid));
The output I am getting is below, where in the SQL query is with $1.
[cid:image001.png@01D74810.4207C100]
Is there a way to compute what is being passed as value for the above SQL
statement ?
Thanks
The information in this e-mail and any attachments is confidential and may be
legally privileged. It is intended solely for the addressee or addressees. Any
use or disclosure of the contents of this e-mail/attachments by a not intended
recipient is unauthorized and may be unlawful. If you have received this e-mail
in error please notify the sender. Please note that any views or opinions
presented in this e-mail are solely those of the author and do not necessarily
represent those of TEMENOS. We recommend that you check this e-mail and any
attachments against viruses. TEMENOS accepts no liability for any damage caused
by any malicious code or virus transmitted by this e-mail.
