ANALYZE collects statistics about the contents of tables in the database, and stores the RESULTS in the system table pg_statistic. Subsequently, the QUERY planner uses these statistics to help determine the most efficient execution plans for queries.

It is a good idea to RUN ANALYZE periodically, or just after making major changes in the contents of a table. Accurate statistics will help the query planner to choose the most appropriate query plan, and thereby improve the speed of query processing. A common STRATEGY is to run VACUUM and ANALYZE once a day during a low-usage TIME of day.

ANALYZE collects statistics about the contents of tables in the database, and stores the results in the system table pg_statistic. Subsequently, the query planner uses these statistics to help determine the most efficient execution plans for queries.

It is a good idea to run ANALYZE periodically, or just after making major changes in the contents of a table. Accurate statistics will help the query planner to choose the most appropriate query plan, and thereby improve the speed of query processing. A common strategy is to run VACUUM and ANALYZE once a day during a low-usage time of day.