MIME-Version: 1.0
From: Costa Alexoglou <costa@dbtune.com>
Date: Fri, 6 Dec 2024 15:32:18 +0100
Message-ID: <CAJ+5Ff4sLuTMpg__fZH67UdaC2bWpLK1U3a8kkj_BvqO8ScYQw@mail.gmail.com>
Subject: Empty query_id in pg_stat_activity
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006724f506289ae24b"
Archived-At: <https://www.postgresql.org/message-id/CAJ%2B5Ff4sLuTMpg__fZH67UdaC2bWpLK1U3a8kkj_BvqO8ScYQw%40mail.gmail.com>
Precedence: bulk

--0000000000006724f506289ae24b
Content-Type: text/plain; charset="UTF-8"

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 state = 'active' AND backend_type = 'client backend'
ORDER BY duration DESC LIMIT 5; query_id | duration | query
---------------------+------------------+------------------------------------------------------------------------
| 00:00:00.223544 | SELECT + | | s_suppkey, + | | s_name, + | | s_address,
+ | | s_phone, + | | total_revenue + | | FROM + | | supplier, + | |
revenue0 + | | WHERE + | | s_suppkey = supplier_no + | | AND total_revenue
= ( + | | SELECT + | | MAX(total_revenue) + | | FROM + | | revenue0 + | | )
+ | | ORDER BY + | | s_suppkey + | | 3080582906387216276 | 00:00:00.000032
| UPDATE pgbench_branches SET bbalance = bbalance + -4897 WHERE bid = 8;
3080582906387216276 | -00:00:00.000321 | UPDATE pgbench_branches SET
bbalance = bbalance + -377 WHERE bid = 6; 2064869707185898531 |
-00:00:00.000501 | END; 2064869707185898531 | -00:00:00.000502 | END; (5
rows)
```

Cheers,
Costa

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

<div dir=3D"ltr"><div>Hey folks, I am running Benchbase and pgbench at the =
same time just for debugging=C2=A0purposes, and I notice that sometimes que=
ry_id is missing</div><div>from pg_stat_activity. Any clue why this is=C2=
=A0happening?</div><div><br></div><div>```</div><div><span style=3D"font-fa=
mily:Monaco,Menlo,Consolas,&quot;Courier New&quot;,monospace;font-size:12px=
;font-variant-ligatures:none;background-color:rgba(232,232,232,0.04)"><font=
 color=3D"#000000">benchbase=3D# SELECT query_id, now() - query_start as du=
ration, query
            FROM pg_stat_activity
            WHERE state =3D &#39;active&#39; AND backend_type =3D &#39;clie=
nt backend&#39;
            ORDER BY duration DESC
            LIMIT 5;
      query_id       |     duration     |                                 q=
uery
---------------------+------------------+----------------------------------=
--------------------------------------
                     | 00:00:00.223544  | SELECT                           =
                                     +
                     |                  |    s_suppkey,                    =
                                     +
                     |                  |    s_name,                       =
                                     +
                     |                  |    s_address,                    =
                                     +
                     |                  |    s_phone,                      =
                                     +
                     |                  |    total_revenue                 =
                                     +
                     |                  | FROM                             =
                                     +
                     |                  |    supplier,                     =
                                     +
                     |                  |    revenue0                      =
                                     +
                     |                  | WHERE                            =
                                     +
                     |                  |    s_suppkey =3D supplier_no     =
                                       +
                     |                  |    AND total_revenue =3D (       =
                                       +
                     |                  |       SELECT                     =
                                     +
                     |                  |          MAX(total_revenue)      =
                                     +
                     |                  |       FROM                       =
                                     +
                     |                  |          revenue0                =
                                     +
                     |                  |    )                             =
                                     +
                     |                  | ORDER BY                         =
                                     +
                     |                  |    s_suppkey                     =
                                     +
                     |                  |
 3080582906387216276 | 00:00:00.000032  | UPDATE pgbench_branches SET bbala=
nce =3D bbalance + -4897 WHERE bid =3D 8;
 3080582906387216276 | -00:00:00.000321 | UPDATE pgbench_branches SET bbala=
nce =3D bbalance + -377 WHERE bid =3D 6;
 2064869707185898531 | -00:00:00.000501 | END;
 2064869707185898531 | -00:00:00.000502 | END;
(5 rows)</font></span></div>```<br><br>Cheers,<br>Costa</div>

--0000000000006724f506289ae24b--