MIME-Version: 1.0
From: Maksim Gorkov <mgorkov@gmail.com>
Date: Tue, 1 Jul 2025 10:24:14 +0300
Message-ID: <CA+mz3HiQYrYvvcbzV+mvXdAsEL31UkV_6RTgfcTdARMoOkEeWQ@mail.gmail.com>
Subject: The same query_id for different queries
To: pgsql-general@postgresql.org
Content-Type: multipart/mixed; boundary="000000000000bfb5ba0638d90830"
Archived-At: <https://www.postgresql.org/message-id/CA%2Bmz3HiQYrYvvcbzV%2BmvXdAsEL31UkV_6RTgfcTdARMoOkEeWQ%40mail.gmail.com>
Precedence: bulk

--000000000000bfb5ba0638d90830
Content-Type: multipart/alternative; boundary="000000000000bfb5b80638d9082e"

--000000000000bfb5b80638d9082e
Content-Type: text/plain; charset="UTF-8"

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?

--000000000000bfb5b80638d9082e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi. I noticed that in pg_stat_activity different=C2=A0quer=
ies have the same query_id.<div><br></div><div>SELECT query_id, query FROM =
pg_stat_activity WHERE query_id =3D 2064869707185898531</div><div><br></div=
><div>2064869707185898531;&#39;BEGIN;...&#39; -- the full text in query1.sq=
l attachment<br>2064869707185898531;&#39;COMMIT;&#39;<br></div><div><br></d=
iv><div>there is another example, if required I can send it for review.</di=
v><div><br></div><div>Why does this happen and how can it be fixed?</div></=
div>

--000000000000bfb5b80638d9082e--
--000000000000bfb5ba0638d90830
Content-Type: application/sql; name="query1.sql"
Content-Disposition: attachment; filename="query1.sql"
Content-Transfer-Encoding: base64
Content-ID: <f_mck7787q0>
X-Attachment-Id: f_mck7787q0

QkVHSU47CgpTRVQgTE9DQUwgbG9ja190aW1lb3V0ID0gJzEwMG1zJzsKTE9DSyBUQUJMRSBweCRo
b3N0c3RhdCBJTiBBQ0NFU1MgRVhDTFVTSVZFIE1PREU7CgpBTFRFUiBUQUJMRSBweCRob3N0c3Rh
dCBSRU5BTUUgVE8gcHgkaG9zdHN0YXRfdG1wOwpBTFRFUiBUQUJMRSBweCRob3N0c3RhdF8gUkVO
QU1FIFRPIHB4JGhvc3RzdGF0OwpBTFRFUiBUQUJMRSBweCRob3N0c3RhdF90bXAgUkVOQU1FIFRP
IHB4JGhvc3RzdGF0XzsKCkNPTU1JVDsKCkJFR0lOOwoKRE8gJCQKREVDTEFSRQogICAgY3VycmR0
IGRhdGU7CiAgICBfdGFyZ2V0IHZhcmNoYXIgOj0gJ2hvc3RzdGF0JzsKICAgIHRhcmdldCB2YXJj
aGFyIDo9IHF1b3RlX2lkZW50KF90YXJnZXQpOwogICAgc2VjdGlvbiB2YXJjaGFyOwpCRUdJTgog
ICAgRk9SIGN1cnJkdCBJTgogICAgICAgIFNFTEVDVCBESVNUSU5DVCBkdCBGUk9NIHB4JGhvc3Rz
dGF0XwogICAgTE9PUAogICAgICAgIHNlY3Rpb24gOj0gcXVvdGVfaWRlbnQodGFyZ2V0IHx8IHRv
X2NoYXIoY3VycmR0LCAnX1lZWVlNTUREJykpOwogICAgICAgIExPT1AKICAgICAgICBCRUdJTgog
ICAgICAgIEVYRUNVVEUgJ0lOU0VSVCBJTlRPICcgfHwgc2VjdGlvbiB8fCAnIGFzIGhzdGF0IChk
dCwgaG9zdCwgYnl0ZXMsIHBsYW5zLCBsb2NrLCBsb2NrX2RsLCBlcnJvcl9mYXQsIGVycm9yX2Vy
ciwgZXJyb3Jfd3JuLCBzeXNfYW5sLCBzeXNfdmFjLCBzeXNfY2hwLCBtZWdhcGFyYW1zLCBtZWdh
cXVlcnksIG1lZ2FyZXN1bHQsIG1lZ2FkaWZmLCB0bXBfY250KQogICAgICAgIFNFTEVDVAogICAg
ICAgICAgICBkdAogICAgICAgICwgICBob3N0CiAgICAgICAgLCAgIGNvYWxlc2NlKHN1bShieXRl
cyksMCkgYXMgYnl0ZXMKICAgICAgICAsICAgY29hbGVzY2Uoc3VtKHBsYW5zKSwwKSBhcyBwbGFu
cwogICAgICAgICwgICBjb2FsZXNjZShzdW0obG9jayksMCkgYXMgbG9jawogICAgICAgICwgICBj
b2FsZXNjZShzdW0obG9ja19kbCksMCkgYXMgbG9ja19kbAogICAgICAgICwgICBjb2FsZXNjZShz
dW0oZXJyb3JfZmF0KSwwKSBhcyBlcnJvcl9mYXQKICAgICAgICAsICAgY29hbGVzY2Uoc3VtKGVy
cm9yX2VyciksMCkgYXMgZXJyb3JfZXJyCiAgICAgICAgLCAgIGNvYWxlc2NlKHN1bShlcnJvcl93
cm4pLDApIGFzIGVycm9yX3dybgogICAgICAgICwgICBjb2FsZXNjZShzdW0oc3lzX2FubCksMCkg
YXMgc3lzX2FubAogICAgICAgICwgICBjb2FsZXNjZShzdW0oc3lzX3ZhYyksMCkgYXMgc3lzX3Zh
YwogICAgICAgICwgICBjb2FsZXNjZShzdW0oc3lzX2NocCksMCkgYXMgc3lzX2NocAogICAgICAg
ICwgICBjb2FsZXNjZShzdW0obWVnYXBhcmFtcyksMCkgYXMgbWVnYXBhcmFtcwogICAgICAgICwg
ICBjb2FsZXNjZShzdW0obWVnYXF1ZXJ5KSwwKSBhcyBtZWdhcXVlcnkKICAgICAgICAsICAgY29h
bGVzY2Uoc3VtKG1lZ2FyZXN1bHQpLDApIGFzIG1lZ2FyZXN1bHQKICAgICAgICAsICAgY29hbGVz
Y2Uoc3VtKG1lZ2FkaWZmKSwwKSBhcyBtZWdhZGlmZgogICAgICAgICwgICBjb2FsZXNjZShzdW0o
dG1wX2NudCksMCkgYXMgdG1wX2NudAogICAgICAgIEZST00gcHgkaG9zdHN0YXRfCiAgICAgICAg
V0hFUkUgZHQgPSAkMTo6ZGF0ZQogICAgICAgIEdST1VQIEJZIGR0LCBob3N0CiAgICAgICAgT1JE
RVIgQlkgaG9zdAogICAgICAgIE9OIENPTkZMSUNUIChob3N0KQogICAgICAgIERPIFVQREFURSBT
RVQKICAgICAgICAgICAgYnl0ZXMgICAgID0gY29hbGVzY2UoaHN0YXQuYnl0ZXMsMCkgKyBleGNs
dWRlZC5ieXRlcwogICAgICAgICwgICBwbGFucyAgICAgPSBjb2FsZXNjZShoc3RhdC5wbGFucyww
KSArIGV4Y2x1ZGVkLnBsYW5zCiAgICAgICAgLCAgIGxvY2sgICAgICA9IGNvYWxlc2NlKGhzdGF0
LmxvY2ssMCkgKyBleGNsdWRlZC5sb2NrCiAgICAgICAgLCAgIGxvY2tfZGwgICA9IGNvYWxlc2Nl
KGhzdGF0LmxvY2tfZGwsMCkgKyBleGNsdWRlZC5sb2NrX2RsCiAgICAgICAgLCAgIGVycm9yX2Zh
dCA9IGNvYWxlc2NlKGhzdGF0LmVycm9yX2ZhdCwwKSArIGV4Y2x1ZGVkLmVycm9yX2ZhdAogICAg
ICAgICwgICBlcnJvcl9lcnIgPSBjb2FsZXNjZShoc3RhdC5lcnJvcl9lcnIsMCkgKyBleGNsdWRl
ZC5lcnJvcl9lcnIKICAgICAgICAsICAgZXJyb3Jfd3JuID0gY29hbGVzY2UoaHN0YXQuZXJyb3Jf
d3JuLDApICsgZXhjbHVkZWQuZXJyb3Jfd3JuCiAgICAgICAgLCAgIHN5c19hbmwgICA9IGNvYWxl
c2NlKGhzdGF0LnN5c19hbmwsMCkgKyBleGNsdWRlZC5zeXNfYW5sCiAgICAgICAgLCAgIHN5c192
YWMgICA9IGNvYWxlc2NlKGhzdGF0LnN5c192YWMsMCkgKyBleGNsdWRlZC5zeXNfdmFjCiAgICAg
ICAgLCAgIHN5c19jaHAgICA9IGNvYWxlc2NlKGhzdGF0LnN5c19jaHAsMCkgKyBleGNsdWRlZC5z
eXNfY2hwCiAgICAgICAgLCAgIG1lZ2FwYXJhbXMgPSBjb2FsZXNjZShoc3RhdC5tZWdhcGFyYW1z
LDApICsgZXhjbHVkZWQubWVnYXBhcmFtcwogICAgICAgICwgICBtZWdhcXVlcnkgID0gY29hbGVz
Y2UoaHN0YXQubWVnYXF1ZXJ5LDApICsgZXhjbHVkZWQubWVnYXF1ZXJ5CiAgICAgICAgLCAgIG1l
Z2FyZXN1bHQgPSBjb2FsZXNjZShoc3RhdC5tZWdhcmVzdWx0LDApICsgZXhjbHVkZWQubWVnYXJl
c3VsdAogICAgICAgICwgICBtZWdhZGlmZiAgID0gY29hbGVzY2UoaHN0YXQubWVnYWRpZmYsMCkg
KyBleGNsdWRlZC5tZWdhZGlmZgogICAgICAgICwgICB0bXBfY250ICAgPSBjb2FsZXNjZShoc3Rh
dC50bXBfY250LDApICsgZXhjbHVkZWQudG1wX2NudAogICAgICAgICcgVVNJTkcgY3VycmR0Owog
ICAgICAgIEVYSVQ7CiAgICAgICAgRVhDRVBUSU9OCiAgICAgICAgV0hFTiB1bmRlZmluZWRfdGFi
bGUgVEhFTgogICAgICAgICAgICBFWEVDVVRFICdDUkVBVEUgVEFCTEUgSUYgTk9UIEVYSVNUUyAn
IHx8IHNlY3Rpb24gfHwgJyAoIExJS0UgJyB8fCBfdGFyZ2V0IHx8ICdfb3JpZyBJTkNMVURJTkcg
QUxMCiAgICAgICAgICAgICwgQ0hFQ0sgKGR0ID0gJycnfHxjdXJyZHQ6OnRleHR8fCcnJzo6ZGF0
ZSkpOwogICAgICAgICAgICBBTFRFUiBUQUJMRSAnIHx8IF90YXJnZXQgfHwgJyBBVFRBQ0ggUEFS
VElUSU9OICcgfHwgc2VjdGlvbiB8fCAnIEZPUiBWQUxVRVMgSU4gKCcnJ3x8Y3VycmR0Ojp0ZXh0
fHwnJycpOyc7CiAgICAgICAgRU5EOwogICAgICAgIEVORCBMT09QOwogICAgRU5EIExPT1A7CkVO
RDsKJCQ7CgpUUlVOQ0FURSBUQUJMRSBweCRob3N0c3RhdF87CgpDT01NSVQ7Cg==
--000000000000bfb5ba0638d90830--