Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\))
Subject: Re: Cannot turn track_counts on
From: Daniel Gustafsson <daniel@yesql.se>
In-Reply-To: <1900177.1744815217@sss.pgh.pa.us>
Date: Wed, 16 Apr 2025 17:03:46 +0200
Cc: pgsql-general@postgresql.org,
 Tom Lane <tgl@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Message-Id: <B8898FC6-79BD-48AD-90A6-55A37BE9BA43@yesql.se>
References: <20250416122749.2b2d25cafcd76aa7d633ed07@gmail.com>
 <1900177.1744815217@sss.pgh.pa.us>
To: Anton Shepelev <anton.txt@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/B8898FC6-79BD-48AD-90A6-55A37BE9BA43%40yesql.se>
Precedence: bulk

> On 16 Apr 2025, at 16:53, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> Anton Shepelev <anton.txt@gmail.com> writes:
>> pg_settings shows:
>=20
>>  name    | track_counts
>>  setting | on
>>  source  | override
>=20
>> What does 'override' mean in the 'source' column?  How can I
>> find where in the system this setting is overridden?
>=20
> I am fairly certain that there is nothing in core Postgres that
> would do that.  PGC_S_OVERRIDE is used to lock down the values
> of certain variables that shouldn't be allowed to change, but
> track_counts surely isn't one of those.  And a quick grep
> through the code finds nothing applying PGC_S_OVERRIDE to it.
>=20
> What extensions do you have installed?

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

--
Daniel Gustafsson