Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u5492-00Be8l-8n for pgsql-general@arkaria.postgresql.org; Wed, 16 Apr 2025 14:53:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u5490-00GXIs-6Y for pgsql-general@arkaria.postgresql.org; Wed, 16 Apr 2025 14:53:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u548z-00GXIi-RN for pgsql-general@lists.postgresql.org; Wed, 16 Apr 2025 14:53:42 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u548x-000PRO-0S for pgsql-general@postgresql.org; Wed, 16 Apr 2025 14:53:42 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 53GErbBW1900178; Wed, 16 Apr 2025 10:53:37 -0400 From: Tom Lane To: Anton Shepelev cc: pgsql-general@postgresql.org Subject: Re: Cannot turn track_counts on In-reply-to: <20250416122749.2b2d25cafcd76aa7d633ed07@gmail.com> References: <20250416122749.2b2d25cafcd76aa7d633ed07@gmail.com> Comments: In-reply-to Anton Shepelev message dated "Wed, 16 Apr 2025 12:27:49 +0300" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1900176.1744815217.1@sss.pgh.pa.us> Date: Wed, 16 Apr 2025 10:53:37 -0400 Message-ID: <1900177.1744815217@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Anton Shepelev writes: > pg_settings shows: > name | track_counts > setting | on > source | override > What does 'override' mean in the 'source' column? How can I > find where in the system this setting is overridden? 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. What extensions do you have installed? regards, tom lane