ANALYZE

Synopsis

ANALYZE

Description

The ANALYZE command can be used to collect statistics about the contents of the tables in the CrateDB cluster.

The generated statistics can be viewed in the pg_catalog.pg_stats table.

The query optimizer uses some of those statistics to generate better execution plans.

The statistics are also periodically updated. How often can be configured with the stats.service.interval setting.