Re: Empty query_id in pg_stat_activity

2024-12-12 Thread Erik Wienhold
On 2024-12-10 14:33 +0100, Costa Alexoglou wrote: > On Fri, Dec 6, 2024 at 4:44 PM Erik Wienhold wrote: > > What's your Postgres version? > It was `16.1`, run with `16.6` and indeed the query_id is there. Thanks! Please reply to list as well. CC'ed it now. -- Erik

Re: Empty query_id in pg_stat_activity

2024-12-09 Thread Michael Paquier
On Fri, Dec 06, 2024 at 04:44:29PM +0100, Erik Wienhold wrote: > Another possibility is that the session just disabled compute_query_id: > https://postgr.es/m/472115375.225506.1683812791906%40office.mailbox.org Or possibly this uses a path where we're not aggressive enough the query ID while we sh

Re: Empty query_id in pg_stat_activity

2024-12-06 Thread Erik Wienhold
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 qu

Empty query_id in pg_stat_activity

2024-12-06 Thread Costa Alexoglou
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? ``` benchbase=# SELECT query_id, now() - query_start as duration, query FROM pg_stat_activity WHERE sta