Managing Query Profile Data

Vertica retains data for queries until the storage quota for the table is exceeded, when it automatically purges the oldest queries to make room for new ones. You can clear profiled data by manually calling one of the following functions:

Configuring data retention policies

Vertica retains the historical data it gathers based on retention policies, which a superuser can configure. See Retaining Monitoring Information.