Skip to main content
Version: Latest-3.3

SHOW ANALYZE STATUS

Description

Views the status of collection tasks.

This statement cannot be used to view the status of custom collection tasks. To view the status of custom collection tasks, use SHOW ANALYZE JOB.

This statement is supported from v2.4.

Syntax

SHOW ANALYZE STATUS [WHERE]

You can use LIKE or WHERE to filter the information to return.

This statement returns the following columns.

List nameDescription
IdThe ID of the collection task.
DatabaseThe database name.
TableThe table name.
ColumnsThe column names.
TypeThe type of statistics, including FULL, SAMPLE, and HISTOGRAM.
ScheduleThe type of scheduling. ONCE means manual and SCHEDULE means automatic.
StatusThe status of the task.
StartTimeThe time when the task starts executing.
EndTimeThe time when the task execution ends.
PropertiesCustom parameters.
ReasonThe reason why the task failed. NULL is returned if the execution was successful.

References

ANALYZE TABLE: create a manual collection task.

KILL ANALYZE: cancel a custom collection task that is running.

For more information about collecting statistics for CBO, see Gather statistics for CBO.