ANALYZE
ANALYZE
Name
ANALYZE -- collect statistics about a databaseSynopsis
ANALYZE [ VERBOSE ] [ table_name [ ( column_name [, ...] ) ] ]
Description
ANALYZE collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system catalog. Subsequently, the query planner uses these statistics to help determine the most efficient execution plans for queries.
With no parameter, ANALYZE examines every table in the current database. With a parameter, ANALYZE examines only that table. It is further possible to give a list of column