PostgreSQL 10 High Performance

Extended statistics

Starting from PostgreSQL 10, the following new commands are available:

• CREATE STATISTICS
• ALTER STATISTICS
• DROP STATISTICS

Using these commands, it is possible to create, modify, or delete objects that can monitor the statistics of a specific table, foreign table, or materialized view.

Also, you can refer to the following links:

• https://www.postgresql.org/docs/10/static/sql-createstatistics.html
• https://www.postgresql.org/docs/10/static/sql-alterstatistics.html
• https://www.postgresql.org/docs/10/static/sql-dropstatistics.html