Request a Demo
Home   >   mailing lists

Re: regarding statistics retaining with 18 Upgrade - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: regarding statistics retaining with 18 Upgrade
Date
Msg-id CAKAnmmJ=r_4-bdigQgv4LhUUpB=dF2Lex_4jbQtN+EZC0OdvZg@mail.gmail.com
Whole thread Raw
In response to Re: regarding statistics retaining with 18 Upgrade  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tree view
On Sat, Nov 15, 2025 at 9:32 AM Bruce Momjian <bruce@momjian.us> wrote:
Uh, it is the _optimizer_ statistics that are preserved by pg_upgrade,

Specifically, check out the pg_stats view. Try this on your new cluster:

select count(distinct tablename) from pg_stats where tablename !~ 'pg_|sql_';

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: should we have a fast-path planning for OLTP starjoins?
Next
From: Jelte Fennema-Nio
Date:
Subject: Re: Early December Commitfest app release