| From: | Erik Wienhold <ewie(at)ewie(dot)name> |
|---|---|
| To: | Costa Alexoglou <costa(at)dbtune(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Empty query_id in pg_stat_activity |
| Date: | 2024-12-06 15:44:29 |
| Message-ID: | ae6ef509-7bba-4d5b-aac4-82def6797e61@ewie.name |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zacher, Stacy | 2024-12-06 21:19:00 | tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed |
| Previous Message | Costa Alexoglou | 2024-12-06 14:32:18 | Empty query_id in pg_stat_activity |