pg_stat_activity query_id

[kaido vaikla <kaido.vaikla@xxxxxxxxx>]

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