Tracing in PostgreSQL with Extended Query Protocol

From: Hugo Sousa <hugos(dot)18(at)hotmail(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Tracing in PostgreSQL with Extended Query Protocol
Date: 2025-02-17 22:52:23
Message-ID: 3F83A3E0-E412-412C-B0F2-9D6C4A19FDF2@hotmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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,

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2025-02-18 04:45:27 Re: Tracing in PostgreSQL with Extended Query Protocol
Previous Message Laurenz Albe 2025-02-03 09:19:23 Re: Regarding setClob and getclobval methods in PostgreSQL