Benchmarking on Vertica

Wils_Gomes

Hi, Is there any Vertica tool I could use to help me with benchmark? Right now I am using "time" command on the shell. Basically I am checking the load time of COPY and some queries with JOINS. tkx

[Deleted User]

Hi Wils, There is a system table, query_profiles that have the query_duration_us. You could also label the queries (https://my.vertica.com/docs/6.1.x/HTML/index.htm#18282.htm) and get some metrics such as max, min, avg time. Hope this helps, Eugenia