Tracing in PostgreSQL with Extended Query Protocol - Mailing list pgsql-novice

From Hugo Sousa
Subject Tracing in PostgreSQL with Extended Query Protocol
Date
Msg-id 3F83A3E0-E412-412C-B0F2-9D6C4A19FDF2@hotmail.com
Whole thread Raw
Responses Re: Tracing in PostgreSQL with Extended Query Protocol
List pgsql-novice

Hi,

I'm working on improving observability at my workplace and looking to add tracing at the database level. We use an observability provider that connects to our PostgreSQL instance and can extract traces from SQLCommenter-compliant comments.

However, we make heavy use of the extended query protocol, and from my understanding, SQL comments don’t work in that context. Given this, I was wondering:

  • Is there a way to attach tracing information when using the extended query protocol?
  • Are there any best practices or tools that can help with this?
  • Is there a plan to add more observability to Postgresql, alined maybe with the OpenTelemetry Project?

Any advice or pointers would be greatly appreciated!

Thanks in advance,

pgsql-novice by date:

Previous
From: Rajyalakshmi Sareddy
Date:
Subject: RE: Regarding setClob and getclobval methods in PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Tracing in PostgreSQL with Extended Query Protocol