View Vertica Features Recently Used: Quick Tip

Posted January 24, 2019 by Jim Knicely, Big Data Solutions Architect, Vertica

Three 3D arrows, different colors pointing in different directions
Curious if Vertica features are being used in your database? If so, the data collector table DC_FEATURES_USED stores recently used Vertica features (i.e. commands, meta-functions and UDXs).

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!