Online Documentation for SQL Manager for PostgreSQL

Creating/editing statistics


Use the Statistics tab of Statistics Editor to create/edit a Statistics object and specify its definition.

 

Statistics Editor - Editing range type

 

Name

Set the name for the statistics.

 

Table

Select the table containing columns to calculate statistics.

 

Owner

Set the owner of the statistics object.

 

Columns

Select the columns to be covered by the computed statistics using the corresponding buttons. At least two column names or expressions must be specified, and their order is not significant.

 

Kind

Select statistics types to be calculated. If none is selecte, all supported statistics kinds are included in the statistics object.

CheckBox N-distinct

CheckBox Functional dependency

CheckBox Most-common values

 

Expression

Specify an expression to be covered by the computed statistics. This may be used to build univariate statistics on a single expression, or as part of a list of multiple column names and/or expressions to build multivariate statistics.