Re: Cannot turn track_counts on - Mailing list pgsql-general

From Anton Shepelev
Subject Re: Cannot turn track_counts on
Date
Msg-id 20250416192556.1317af210ae075d25f166585@gmail.com
Whole thread Raw
In response to Re: Cannot turn track_counts on  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fwd: Identify system databases
Next
From: Anton Shepelev
Date:
Subject: Re: Cannot turn track_counts on