1) Vertica provides functions to encrypt and decrypt data using Voltage SecureData. Some of its advantages: A. The encrypted values have the same overall format as the unencrypted data, so you do not… (View Post)

* Here is a Histogram of Average CPU Usage Percent by Minute query, used in Vadvisor report: select node_name , sum(v80) CountOfAverageLessThan80, sum(v95) CountOfAverageBetween80and95, sum(v99) Coun… (View Post)

* If you want to check top 10 queries with high CPU Cycles use the following query (written in the past by Maurizio Felici): SELECT transaction_id,statement_id, cpu_cycles_us, duration_ms FROM QUERY_… (View Post)

In addition check the recommendations mentioned here: https://forum.vertica.com/discussion/comment/245482#Comment_245482 (View Post)

Please try: SELECT * FROM vs_design_tables; (View Post)