Feedback-ID: i76984098:Fastmail
Message-ID: <32b6d55b-e1bb-4300-86bc-b24036414a8f@aklaver.com>
Date: Wed, 16 Apr 2025 11:07:37 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Cannot turn track_counts on
To: Anton Shepelev <anton.txt@gmail.com>
Cc: pgsql-general@postgresql.org
References: <20250416122749.2b2d25cafcd76aa7d633ed07@gmail.com>
 <f2510b5c-9ad3-4d31-b3ff-0db3c81a1d26@aklaver.com>
 <20250416192556.1317af210ae075d25f166585@gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <20250416192556.1317af210ae075d25f166585@gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/32b6d55b-e1bb-4300-86bc-b24036414a8f%40aklaver.com>
Precedence: bulk

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