public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Anton Shepelev <[email protected]>
Cc: [email protected]
Subject: Re: Cannot turn track_counts on
Date: Mon, 21 Apr 2025 09:52:34 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
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
[email protected]
view thread (10+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Cannot turn track_counts on
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox