Re: The same query_id for different queries

2025-07-01 Thread Maksim Gorkov
(cost=0.00..0.46 rows=88 width=32) (actual time=0.049..0.098 rows=88 loops=1) -> Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1) -> CTE Scan on progress (cost=0.00..1.76 rows=88 width=16) (actual time=0.085..0.6

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