The same query_id for different queries

From: Maksim Gorkov <mgorkov(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: The same query_id for different queries
Date: 2025-07-01 07:24:14
Message-ID: CA+mz3HiQYrYvvcbzV+mvXdAsEL31UkV_6RTgfcTdARMoOkEeWQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 required I can send it for review.

Why does this happen and how can it be fixed?

Attachment Content-Type Size
query1.sql application/sql 3.2 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2025-07-01 08:16:32 Re: The same query_id for different queries
Previous Message raphi 2025-07-01 04:35:37 Re: Simulate a PITR in postgresql 16