
Example:
dbadmin=> SELECT node_name, component, description
dbadmin-> FROM data_collector
dbadmin-> WHERE table_name = 'dc_features_used';
node_name | component | description
--------------------+--------------+--------------------------------
v_test_db_node0001 | FeaturesUsed | Vertica features used recently
(1 row)
dbadmin-> SELECT split_part(feature, '::', 1) feature, COUNT(*) uses, MAX(feature) example
dbadmin-> FROM dc_features_used
dbadmin-> GROUP BY 1
dbadmin-> ORDER BY 1;
feature | uses | example
-------------+------+-------------------------------------------
command | 2109 | command::UPDATE
error | 1572 | error::8537
flextable | 632 | flextable::parse_query::maplookup_rewrite
metafunction | 593 | metafunction::vertica_start_command
opt | 93 | opt::multi_level_agg
udx | 275 | udx::upgrade_model_format()
voption | 1 | voption::BASIC::DISABLE_DEPARSE_CHECK
(7 rows)
Helpful Links:https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/DATA_COLLECTOR.htm
https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/EnablingAndDisablingDataCollector.htm
Have fun!