Search Postgresql Archives

Re: Drivers users by connections

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On 06/06/2023 09:18 CEST Hrishikesh (Richie) Rode <hrode@xxxxxxxxxxx> wrote:
>
> 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.

Column pg_stat_activity.application_name is the only one I know of that may
provide such details.  But it relies on the driver setting application_name
when connecting.  Some drivers set a default, e.g. pgjdbc, but also allow
overriding with a custom application name that may include additional info
such as driver version.  But in the end application_name is just text without
any inherent structure.

--
Erik





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux