pg_stat_activity query_id

From: kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_stat_activity query_id
Date: 2023-05-11 09:11:28
Message-ID: CA+427g8qBArPuqwZOuYVhdoCQUsdbutR18fG7Gt7+3JunuHsjA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Question, when or why query_id in pg_stat_activity is not present

postgres=# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 15.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
20150623 (Red Hat 4.8.5-44), 64-bit
(1 row)

postgres=# select user;
user
----------
postgres
(1 row)

postgres=# show compute_query_id;
compute_query_id
------------------
on
(1 row)

postgres=# select application_name, query_id from pg_stat_activity order
by 1;
application_name | query_id
------------------------+---------------------
|
|
|
|
|
barman_receive_wal |
IntelliJ IDEA 2023.1.1 |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
PostgreSQL JDBC Driver |
psql | 3408001232671049700
(61 rows)

br
Kaido

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Norbert Poellmann 2023-05-11 11:47:11 Re: pg_stat_activity query_id
Previous Message Wells Oliver 2023-05-11 05:10:46 Re: nextval() on serial using old, existing value on insert?