Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1t1qxd-000ji9-6t
	for pgsql-admin@arkaria.postgresql.org; Fri, 18 Oct 2024 17:40:25 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1t1qxa-0082JB-C4
	for pgsql-admin@arkaria.postgresql.org; Fri, 18 Oct 2024 17:40:22 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <itdev@gatewaynet.com>)
	id 1t1oY1-005yGM-Tw
	for pgsql-admin@lists.postgresql.org; Fri, 18 Oct 2024 15:05:50 +0000
Received: from mail.gatewaynet.com ([185.90.37.66])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <itdev@gatewaynet.com>)
	id 1t1oXu-001YGv-Pu
	for pgsql-admin@lists.postgresql.org; Fri, 18 Oct 2024 15:05:48 +0000
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mail.gatewaynet.com (Postfix) with ESMTP id B62A12A0F26;
	Fri, 18 Oct 2024 18:05:39 +0300 (EEST)
Authentication-Results: mail.gatewaynet.com (amavis); dkim=pass (2048-bit key)
 header.d=gatewaynet.com
Received: from mail.gatewaynet.com ([127.0.0.1])
 by localhost (mail.gatewaynet.com [127.0.0.1]) (amavis, port 10032)
 with ESMTP id P2o0io_MdELH; Fri, 18 Oct 2024 18:05:39 +0300 (EEST)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mail.gatewaynet.com (Postfix) with ESMTP id 1C4F52A0DD1;
	Fri, 18 Oct 2024 18:05:39 +0300 (EEST)
DKIM-Filter: OpenDKIM Filter v2.10.3 mail.gatewaynet.com 1C4F52A0DD1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gatewaynet.com;
	s=5495D85E-17AE-11EA-94AA-A4C7E0C5309B; t=1729263939;
	bh=OSnNKJHWptI66ACqvzHDxH1bx30ey/P5CB/aShpDiZ8=;
	h=Date:From:To:Message-ID:MIME-Version;
	b=XsNswx0lNDr/NgXaOrmuKau/+X8WrS1T0GVgoqSnhoExieg1rYAo0UgYJc9nkyXSN
	 weZuGTZ1I/2jkDdTGkQ0/CFANSWNSAN+GnaGSM5OlxQ7MsQipFMd0A4Ktln5f9zmM4
	 chWwjgYdBE0X/Htd/qVRaLsi4UPeyHIaLym7p4f8aOFi7xIpjPV7hECV9Xf7fYhCeK
	 EfGnjxLM2Fj02+IIkbdLiy+KIV6+rFSQyfxa64PcaSIg0Qq+6oz0qbeJRqlIM3bljE
	 INJDZXPYQzRylcFNRlP2Oja1DqeqPsLU7AbCl1h9PPW6RfHBN9u1HtlOvtCd0fZwZJ
	 jNJdurdPp/fsA==
X-Virus-Scanned: amavis at mail.gatewaynet.com
Received: from mail.gatewaynet.com ([127.0.0.1])
 by localhost (mail.gatewaynet.com [127.0.0.1]) (amavis, port 10026)
 with ESMTP id zxNnP-WXODtf; Fri, 18 Oct 2024 18:05:39 +0300 (EEST)
Received: from mb4.gatewaynet.com (mb4.gatewaynet.com [185.90.37.41])
	by mail.gatewaynet.com (Postfix) with ESMTP id 0303A2A0EDE;
	Fri, 18 Oct 2024 18:05:39 +0300 (EEST)
Date: Fri, 18 Oct 2024 18:05:38 +0300 (EEST)
From: Achilleas Mantzios <itdev@gatewaynet.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>,
	pgsql-admin@lists.postgresql.org
Message-ID: <1207906126.14112498.1729263938926.JavaMail.zimbra@gatewaynet.com>
In-Reply-To: <871996.1729262194@sss.pgh.pa.us>
References: <b661cc9f-da73-4c41-aba8-0bd680a6085c@cloud.gatewaynet.com>
 <871996.1729262194@sss.pgh.pa.us>
Subject: Re: Migrating from 10 -> 16, PreparedStatements disabled in JDBC
 and pgbouncer, I am getting : bind <unnamed>/C_5
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-Originating-IP: [193.92.121.98]
X-Mailer: Zimbra 8.8.15_GA_4581 (ZimbraWebClient - FF130
 (Linux)/8.8.15_GA_4581)
Thread-Topic: Migrating from 10 -> 16,
 PreparedStatements disabled in JDBC and pgbouncer,
 I am getting : bind <unnamed>/C_5
Thread-Index: 5CzPIPuZSEJpT/uyXg0GvVgqa32TSQ==
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/1207906126.14112498.1729263938926.JavaMail.zimbra%40gatewaynet.com>
Precedence: bulk

Thanks Tom, sorry for the business-style reply (top post).
The _C* log entries appeared only when we had specified in JDBC : DefaultRo=
wFetchSize . Once we disabled this, it reverted back to "normal" binds and =
executes in the log.
e.g. retrying the same app now we get : (omitting param values)

10.9.0.110(52027) [4107694] 6712788f.3eadae 2024-10-18 18:03:17.355 EEST SM=
A  amantzio@dynacom line:43 LOG:  duration: 0.212 ms  parse <unnamed>: SELE=
CT work_status FROM company_stuff WHERE ldap_cn =3D $1
10.9.0.110(52027) [4107694] 6712788f.3eadae 2024-10-18 18:03:17.356 EEST SM=
A  amantzio@dynacom line:44 LOG:  duration: 0.638 ms  bind <unnamed>: SELEC=
T work_status FROM company_stuff WHERE ldap_cn =3D $1
10.9.0.110(52027) [4107694] 6712788f.3eadae 2024-10-18 18:03:17.356 EEST SM=
A  amantzio@dynacom line:46 LOG:  duration: 0.046 ms  execute <unnamed>: SE=
LECT work_status FROM company_stuff WHERE ldap_cn =3D $1

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Achilleas Mantzios" <a.mantzios@cloud.gatewaynet.com>
Cc: pgsql-admin@lists.postgresql.org, "ITDEV" <itdev@gatewaynet.com>
Sent: Friday, 18 October, 2024 17:36:34
Subject: Re: Migrating from 10 -> 16, PreparedStatements disabled in JDBC a=
nd pgbouncer, I am getting : bind <unnamed>/C_5

Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com> writes:
> I have noticed in the pgsql 16.4 logs some lines with this pattern :

> 10.9.0.110(45201) [4079203] 67122b3b.3e3e63 2024-10-18 12:32:44.260 EEST=
=20
> SMA =C2=A0amantzio@dynacom line:35 LOG: =C2=A0duration: 0.166 ms =C2=A0pa=
rse <unnamed>:=20
> SELECT work_status FROM company_stuff WHERE ldap_cn =3D $
> 1
> 10.9.0.110(45201) [4079203] 67122b3b.3e3e63 2024-10-18 12:32:44.261 EEST=
=20
> SMA =C2=A0amantzio@dynacom line:36 LOG: =C2=A0duration: 0.553 ms =C2=A0bi=
nd=20
> <unnamed>/C_5: SELECT work_status FROM company_stuff WHERE ldap_cn
> =3D $1
> 10.9.0.110(45201) [4079203] 67122b3b.3e3e63 2024-10-18 12:32:44.261 EEST=
=20
> SMA =C2=A0amantzio@dynacom line:38 LOG: =C2=A0duration: 0.036 ms =C2=A0ex=
ecute=20
> <unnamed>/C_5: SELECT work_status FROM company_stuff WHERE ldap_
> cn =3D $1

> So the parse is done on an unnamed prepared statement, however the bind=
=20
> and the execute show this : /C_5 after<unnamed>. We haven't got any log=
=20
> entries with this /C_* pattern on the "parse" phase, only on "bind" and=
=20
> "execute". I am curious what those represent.

Here C_5 would be a portal name, identifying the bound-and-ready-
to-execute query.  See

https://www.postgresql.org/docs/current/protocol-flow.html#PROTOCOL-FLOW-EX=
T-QUERY

=09=09=09regards, tom lane