How to get DB connection PID from JDBC

Поиск
Список
Период
Сортировка
От Oleg Golovanov
Тема How to get DB connection PID from JDBC
Дата
Msg-id 1662974029.147588580@f112.i.mail.ru
обсуждение исходный текст
Ответы Re: How to get DB connection PID from JDBC
Список pgsql-jdbc
Hello
 
There was a need for logging purposes to receive in a Java / Spring application using JDBC, the PID of the connection on the database side. I did not find such an opportunity in the JDBC sources.
 
Can you explain if there is such a possibility?
 
It seems to me to execute when establishing a connection each time a request
select pg_backend_pid()
not the best idea.
 
Best Regards,

Oleg Golovanov
Tel./WhatsApp +79067778133
Moscow, Russia
 

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Postgresql JDBC process consumes more memory with partition tables update delete
Следующее
От: Jorge Solórzano
Дата:
Сообщение: Re: How to get DB connection PID from JDBC