Postgres

The Postgres 10 feature you didn’t know about: CREATE STATISTICS
NewsPostgres

The Postgres 10 feature you didn’t know about: CREATE STATISTICS

If you’ve done some performance tuning with Postgres, you might have used EXPLAIN. EXPLAIN shows you the execution plan that the PostgreSQL planner generates for the supplied statement. It shows shows how the table(s) referenced by the statement will be scanned (using a sequential scan, index scan etc), and what join algorithms will be used…