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.kla...@aklaver.com
