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