Hi,
I have a question regarding session params. We are using them thru SET LOCAL call request when connection is popped from pool to set, for example userId or API call route for current transaction so that any stored procedure can fetch them, if needed.
This reduces number of params for every stored procedure call.
In order to debug system locks, we want to access those values. I have found an idea on https://wiki.postgresql.org/wiki/Lock_Monitoring to use
SET application_name='%application_name_plus_additional_params%'
to be able to acces those data when we have system locks, but that adds anotner call on every transaction.
Is it somehow possible to access session level configuration data for specific PID from another transaction?
Kind regards,
Stanislav