As discussed earlier, system tables provide a plethora of information regarding various processes running on a database, including queries. However, sometimes we need to store monitoring information. For this, we can employ Data Collector. Information retained by Data Collector is stored on a disk in the DataCollector
directory under the Vertica catalog path.
To enable or disable Data Collector, we can use the SET_CONFIG_PARAMETER()
function. Data Collector is on by default. To disable Data Collector, use the following command:
=> SELECT SET_CONFIG_PARAMETER('EnableDataCollector', '0');
Use the following command to enable Data Collector:
=> SELECT SET_CONFIG_PARAMETER('EnableDataCollector', '1');