The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

View Vertica Features Recently Used

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

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/EnablingAndDisablingDataCollector.htm

Have fun!

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.