PostgreSQL blocked locks query - Mailing list pgsql-performance

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.

Is there a way to compute what is being passed as value for the above SQL statement ?

Thanks