70.5. Cleaning aqo Storage #

You can clean aqo storage data from databases where the extension is installed.

To clean aqo storage:

  1. In the navigation panel, go to MonitoringQuery plan management.

  2. In the top-right corner of the page, select the instance.

  3. Click and select one of the following values:

    • Partial cleaning: Deletes data related to query classes that are linked to deleted relations (partially or fully). Other objects are not deleted.

      If you select this value, confirm the operation in the opened window.

    • Full cleaning: Deletes machine learning data, query texts, statistics, and query class preferences.

      If you select this value, perform one of the following actions in the opened window:

      • To delete data from all databases, click Clear.

      • To delete data from specific databases, turn off Apply to all databases with the installed aqo extension, enable the checkboxes next to the databases, and click Clear.