Re: The same query_id for different queries

2025-07-01 Thread Maksim Gorkov
A few more examples: 1. Why are different query_ids displayed in the log for this test query? 2025-07-01 13:38:47.852 MSK [2518006:549/405366] [postgres] pgAdmin *-11391618518959119* 10.206.112.24(51180) LOG: duration: 101.141 ms plan: Query Text: BEGIN; select pg_sleep(.1);

The same query_id for different queries

2025-07-01 Thread Maksim Gorkov
Hi. I noticed that in pg_stat_activity different queries have the same query_id. SELECT query_id, query FROM pg_stat_activity WHERE query_id = 2064869707185898531 2064869707185898531;'BEGIN;...' -- the full text in query1.sql attachment 2064869707185898531;'COMMIT;' there is another example, if

Re: The same query_id for different queries

2025-07-01 Thread Michael Paquier
On Tue, Jul 01, 2025 at 10:24:14AM +0300, Maksim Gorkov wrote: > 2064869707185898531;'BEGIN;...' -- the full text in query1.sql attachment > 2064869707185898531;'COMMIT;' > > there is another example, if required I can send it for review. > > Why does this happen and how can it be fixed? Hard to