Skip to main content

Benchmarking on Vertica

  • August 23, 2013
  • 1 reply
  • 6 views
Wils_Gomes
Forum|alt.badge.img+1
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

    1 reply

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • August 23, 2013
    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
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement