Re: Cannot turn track_counts on

On 4/21/25 09:46, Anton Shepelev wrote:
> I wrote:
>
>> I will test if clearing shared_preload_libraries and
>> restarting Postgres has any effect on track_counts, just
>> in case.
>
> Nope, it didn't unstick track_counts:
>
> db=# show shared_preload_libraries ;
> -[ RECORD 1 ]------------+-
> shared_preload_libraries |
>
> db=# select * from pg_settings where name like '%k_cou%';
> -[ RECORD 1 ]---+--------------------------------------------------
> name | track_counts
> setting | off
> unit |
> category | Statistics / Query and Index Statistics Collector
> short_desc | Collects statistics on database activity.
> extra_desc |
> context | superuser
> vartype | bool
> source | override
> min_val |
> max_val |
> enumvals |
> boot_val | on
> reset_val | off
> sourcefile |
> sourceline |
> pending_restart |
>
> Have you any further ideas how to turn track_counts on?

It is matter of finding out what is setting?:

source | override

There is something different about your setup, as here on Ubuntu(which
uses the Debian packaging) I see:

select * from pg_settings where name like '%k_cou%';

-[ RECORD 1 ]---+---------------------------------------------------
name | track_counts
setting | on
unit | NULL
category | Statistics / Cumulative Query and Index Statistics
short_desc | Collects statistics on database activity.
extra_desc | NULL
context | superuser
vartype | bool
source | default
min_val | NULL
max_val | NULL
enumvals | NULL
boot_val | on
reset_val | on
sourcefile | NULL
sourceline | NULL
pending_restart | f

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com