Re: Cannot turn track_counts on

On 4/16/25 09:25, Anton Shepelev wrote:
> Adrian Klaver:
>> Anton Shepelev:
>>

>> This shows a setting of 'on' not the 'off' you mention in
>> the first paragraph.
>
> I beg pardon. Having no immediate access to the system in
> question, I confess to having mocked up those results from
> an analogous query on our reference system. Here is the
> actual result from the affected server (db name changed):
>
> db=# select * from pg_settings where name = 'track_counts';
> -[ 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 | f
>
> It was very wrong of me so to misinform you.
>

Per post from Daniel Gustafsson:

"Also, is this by any chance a managed instance like Amazon RDS or
Azure, or is it a local database under your control?"

And from Tom Lane:

"What extensions do you have installed?"

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