The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Query spends more time on before plan

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 Employee

    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.

  • 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.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.