Re: pg_stat_activity query_id

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_stat_activity query_id
Date: 2023-05-11 15:54:42
Message-ID: 1976126051.239630.1683820482344@office.mailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On 11/05/2023 17:35 CEST kaido vaikla <kaido(dot)vaikla(at)gmail(dot)com> wrote:
>
> * compute_query_id=off
> it is onpostgres=# show compute_query_id;
>  compute_query_id
> ------------------
>  on
> (1 row)

Is compute_query_id=on configured globally in postgresql.conf or only set for
specific databases and users? Please check pg_catalog.pg_db_role_setting.

Any chance that the JDBC connections set compute_query_id=off?

--
Erik

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-05-11 16:09:15 Re: Index recreation details with REINDEX TABLE CONCURRENTLY
Previous Message Doug Reynolds 2023-05-11 15:46:26 Re: nextval() on serial using old, existing value on insert?