public inbox for [email protected]  

help / color / mirror / Atom feed

Re: 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]>
  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 16:25  Anton Shepelev <[email protected]>
  parent: 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 18:07  Adrian Klaver <[email protected]>
  parent: Anton Shepelev <[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