I just upgraded from 9.6 to 12, and am noticing some queries are slow.
I did this kind of query:
SELECT relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze
FROM pg_stat_all_tables
WHERE schemaname = 'myschema';
And noticed null values for everything, including last analyze date.
Does this mean the planner won't be able to optimize for these tables? Do I
need to do something to prep my DB for planning after upgrade?
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>