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

On 4/16/25 02:27, Anton Shepelev wrote:
> Hello, all.
> 
> I have a Postgres sever with the 'track_counts' setting
> stuck in 'off'.  I cannot seem to enable it with either of
>    a. ALTER SYSTEM,
>    b. ALTER DATABASE,
>    c. ALTER USER,
>    d. or plain SET.
> 
> pg_settings shows:
> 
>    name    | track_counts
>    setting | on
>    source  | override

This shows a setting of 'on' not the 'off' you mention in the first 
paragraph.

> 
> What does 'override' mean in the 'source' column?  How can I
> find where in the system this setting is overridden?
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com