We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Query spends more time on before plan — Vertica Forum

Query spends more time on before plan

VigneshNVigneshN Employee
in Tips from the Team

When I run select 1 query in 20 node cluster. It takes 30 seconds and out of which 29 seconds are spent on Before plan phase. Does that mean we do have a network issue? How to debug this.

Tagged:

Answers

  • SruthiASruthiA Administrator

    It may or may not be a network issue. Please profile the query and review the output of execution_engine_profiles to check which operator is taking long time.

  • Nimmi_guptaNimmi_gupta - Select Field - Employee

    How did you check select 1 took 29 seconds on Before plan phase?

  • emorenoemoreno Employee

    You can find where the time is spend with this query :
    select time, node_name, execution_step, completion_time, completion_time - time as Step_Duration from dc_query_executions where transaction_id=<> and statement_id=<< statement_id>> order by 2,1 ;
    Can you confirm that is in the prepare_plan phase? and in the initiator?
    Eugenia

Sign In or Register to comment.