On 2024-12-06 15:32 +0100, Costa Alexoglou wrote:
> Hey folks, I am running Benchbase and pgbench at the same time just for
> debugging purposes, and I notice that sometimes query_id is missing
> from pg_stat_activity. Any clue why this is happening?
What's your Postgres version?
Could be that query_id is not reported because the session is using the
extended query protocol. This has been fixed just recently in releases
14.14/15.9/16.5/17.1. From the 14.14 release notes:
> * Report the active query ID for statistics purposes at the start of
> processing of Bind and Execute protocol messages (Sami Imseih)
> https://postgr.es/c/b36ee879c
>
> This allows more of the work done in extended query protocol to be
> attributed to the correct query.
Another possibility is that the session just disabled compute_query_id:
https://postgr.es/m/472115375.225506.1683812791906%40office.mailbox.org
--
Erik
