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