39.3. Collecting the Planner Statistics for a Table #
The ANALYZE SQL command is executed when collecting the planner statistics.
To collect the planner statistics for a table:
In the navigation panel, go to Databases.
(Optional) To display system databases, turn on Show system databases.
Click the name of the database.
Click the name of the schema.
Click
→ Analyze next to the table. Specify the statistics collection parameters (parameters marked with an asterisk are required):
Set cron-string execution: Allows specifying the interval for collecting statistics in the crontab format.
If you turn on this toggle, in Execution, enter the string.
Execution: The type of the statistics collection schedule.
Possible values:
Execute now: The statistics will be collected immediately after you perform this instruction.
Once: The statistics will be collected at the specified date and time.
Repeated: The statistics will be collected at the specified interval.
For this value, specify the following parameters:
Interval: The unit of measurement of the interval.
Possible values:
Minutes
Hours
Days
Repeat every: The interval for collecting statistics by minutes or hours.
This parameter is available only if you select Minutes or Hours from Interval.
Execution days: The days when statistics will be collected.
Cron total line: The string in the crontab format that specifies the time interval for collecting statistics.
This parameter is available only if you turn off Set cron-string execution.
Name: The unique name of the statistics collection task.
This parameter is available only if you turn on Set cron-string execution or select Once / Repeated from Execution.
Time: The date and/or time when statistics will be collected.
This parameter is available only if you select Once from Execution or Days from Interval.
Start and Repeat untill: The start and end date and time for the statistics collection.
These parameters are available only if you turn on Set cron-string execution or select Repeated from Execution.
Click Apply.
Confirm the operation.
The statistics collection will start in the asynchronous mode.
Note
Depending on the number of tables and columns, this operation may require significant resources so it is recommended to track it.