public inbox for [email protected]
help / color / mirror / Atom feedRe: Cannot turn track_counts on
3+ messages / 2 participants
[nested] [flat]
* Re: Cannot turn track_counts on
@ 2025-04-16 15:11 Adrian Klaver <[email protected]>
2025-04-16 16:25 ` Re: Cannot turn track_counts on Anton Shepelev <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Adrian Klaver @ 2025-04-16 15:11 UTC (permalink / raw)
To: Anton Shepelev <[email protected]>; pgsql-general
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
[email protected]
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Cannot turn track_counts on
2025-04-16 15:11 Re: Cannot turn track_counts on Adrian Klaver <[email protected]>
@ 2025-04-16 16:25 ` Anton Shepelev <[email protected]>
2025-04-16 18:07 ` Re: Cannot turn track_counts on Adrian Klaver <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Anton Shepelev @ 2025-04-16 16:25 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; +Cc: pgsql-general
Adrian Klaver:
> Anton Shepelev:
>
> > have a Postgres sever with the 'track_counts'
> > setting stuck in 'off'.
> > [...]
> > name | track_counts
> > setting | on
> > source | override
>
> 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.
--
() ascii ribbon campaign -- against html e-mail
/\ www.asciiribbon.org -- against proprietary attachments
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Cannot turn track_counts on
2025-04-16 15:11 Re: Cannot turn track_counts on Adrian Klaver <[email protected]>
2025-04-16 16:25 ` Re: Cannot turn track_counts on Anton Shepelev <[email protected]>
@ 2025-04-16 18:07 ` Adrian Klaver <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Adrian Klaver @ 2025-04-16 18:07 UTC (permalink / raw)
To: Anton Shepelev <[email protected]>; +Cc: pgsql-general
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]
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-04-16 18:07 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-04-16 15:11 Re: Cannot turn track_counts on Adrian Klaver <[email protected]>
2025-04-16 16:25 ` Anton Shepelev <[email protected]>
2025-04-16 18:07 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox