ANALYZE

Updates statistics used by the planner to determine the most efficient way to execute a query. Syntax: 
    vacuum analyze table_name;
    vacuum analyze table_name (column_name);

    vacuum verbose analyze table_name;
    vacuum verbose analyze table_name (column_name);

    vacuum full verbose analyze table_name;
    vacuum full verbose analyze table_name (column_name);

    vacuum freeze verbose analyze table_name;
    vacuum freeze verbose analyze table_name (column_name);

    vacuum full freeze verbose analyze table_name;
    vacuum full freeze verbose analyze table_name (column_name);


(Partition)