Hello
We are not able to find table which give session connection details about drivers. In pg_stat_activity details information is not there. Please let us know where we can find these information.
Please help me to get this information.
Thanks
Richie-
In Oracle and Mysql we use below sql to get details
SQL used to get mysql driver connection details
SELECT SUBSTRING_INDEX(s.user,"@",1),sca.attr_value
FROM sys.session as s
join performance_schema.session_connect_attrs as sca
on s.conn_id = sca.processlist_id
group by SUBSTRING_INDEX(s.user,"@",1)
SQL used to get Oracle driver connection details
select a.CLIENT_VERSION, a.CLIENT_DRIVER ,b.USERNAME,b.PROGRAM
from v$session_connect_info a, v$session b
where CLIENT_VERSION!='Unknown' and CLIENT_DRIVER is not null
and a.sid=b.sid
group by a.CLIENT_VERSION, a.CLIENT_DRIVER ,b.USERNAME,b.PROGRAM
order by b.USERNAME
