Horton

Re: regarding statistics retaining with 18 Upgrade

Greg Sabino Mullane <htamfids@gmail.com>

View thread
From: Greg Sabino Mullane <htamfids@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Rambabu V <ram.wissen@gmail.com>, pgsql-hackers@postgresql.org
Date: 2025-11-15T16:02:23Z
Lists: pgsql-hackers 
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

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support