public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Anton Shepelev <[email protected]>
Cc: [email protected]
Subject: Re: Cannot turn track_counts on
Date: Wed, 16 Apr 2025 11:07:37 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
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
[email protected]
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Cannot turn track_counts on
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox