After loading data with pg_restore
or similar tool, you should run ANALYZE
or VACUUM ANALYZE
on your entire database to collect new statistics. If those commands haven't been run after a restore the database won't have up-to-date statistics about the tables and indexes which may lead to bad query plans.
More details about ANALYZE
can be found in PostgreSQL documentation: https://www.postgresql.org/docs/current/static/sql-analyze.html