View Vertica Features Recently Used

Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert

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.