Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q6UkD-0002NV-25 for pgsql-general@arkaria.postgresql.org; Tue, 06 Jun 2023 11:20:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q6UkC-0006vM-1R for pgsql-general@arkaria.postgresql.org; Tue, 06 Jun 2023 11:20:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q6UkB-0006g0-Lq for pgsql-general@lists.postgresql.org; Tue, 06 Jun 2023 11:20:55 +0000 Received: from mout-u-107.mailbox.org ([80.241.59.207]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q6Uk6-000Z9w-9I for pgsql-general@lists.postgresql.org; Tue, 06 Jun 2023 11:20:55 +0000 Received: from smtp202.mailbox.org (smtp202.mailbox.org [10.196.197.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-107.mailbox.org (Postfix) with ESMTPS id 4Qb7M34JJgz9sSV; Tue, 6 Jun 2023 13:20:47 +0200 (CEST) Date: Tue, 6 Jun 2023 13:20:47 +0200 (CEST) From: Erik Wienhold To: "Hrishikesh (Richie) Rode" , "pgsql-general@lists.postgresql.org" Cc: Rag Krishnan Message-ID: <747443146.893352.1686050447046@office.mailbox.org> In-Reply-To: References: Subject: Re: Drivers users by connections MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Normal List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 06/06/2023 09:18 CEST Hrishikesh (Richie) Rode 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