Re: protocol support for labels

2025-03-15 Thread Kirill Reshke
On Tue, 11 Mar 2025 at 11:09, Jeremy Schneider wrote: > observability frameworks like OpenTelemetry support tracing through all > layers of a stack, and trace_ids can even be passed into sql with > extensions like sqlcommenter. however sqlcommenter puts the trace_id > into a comment which effecti

Re: protocol support for labels

2025-03-13 Thread Nico Williams
On Wed, Mar 12, 2025 at 11:39:57PM -0700, Jeremy Schneider wrote: > Isn't multiple queries in one packet only possible with the simple > protocol, but not possible with the extended protocol? So this would be > entirely incompatible with prepared/parameterized statements? It's TCP. Packet and seg

Re: protocol support for labels

2025-03-12 Thread Jeremy Schneider
On Tue, 11 Mar 2025 14:03:12 -0500 Nico Williams wrote: > How about using a `set_config()` to deonte the "application_name" (and > any other details) for the _next_ query, then have those details > appear in the pg_stat_statements rows and logs? > > Clients would send a `SELECT set_config(...)` a

Re: protocol support for labels

2025-03-11 Thread Nico Williams
On Tue, Mar 11, 2025 at 05:23:14PM +0100, Frits Hoogland wrote: > The usecase that I think might be useful is to have a database client send > metadata along with a query. > This partially is possible today by setting application_name, but that is a > separate request, it would be great if that c

Re: protocol support for labels

2025-03-11 Thread Dave Cramer
Dave Cramer www.postgres.rocks On Tue, 11 Mar 2025 at 12:23, Frits Hoogland wrote: > The usecase that I think might be useful is to have a database client send > metadata along with a query. > This partially is possible today by setting application_name, but that is > a separate request, it wou

Re: protocol support for labels

2025-03-11 Thread Frits Hoogland
The usecase that I think might be useful is to have a database client send metadata along with a query. This partially is possible today by setting application_name, but that is a separate request, it would be great if that could be sent along with the query in one go. Another option to pass met

Re: protocol support for labels

2025-03-11 Thread Jeremy Schneider
> On Mar 11, 2025, at 3:03 AM, Kirill Reshke wrote: > > On Tue, 11 Mar 2025 at 11:09, Jeremy Schneider > wrote: > >> observability frameworks like OpenTelemetry support tracing through all >> layers of a stack, and trace_ids can even be passed into sql with >> extensions like sqlcommenter.