The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

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