View Vertica Features Recently Used
Jim_Knicely
- Select Field - Administrator
Curios 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/9.2.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/DATA_COLLECTOR.htm
Have fun!
0