Skip to main content
Question

Query spends more time on before plan

  • Sep 25, 2019 6:35 AM UTC
  • 2 replies
  • 20 views

VigneshN

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.

2 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • Oct 6, 2019 2:27 AM UTC

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_gupta
Forum|alt.badge.img
  • Participating Frequently
  • Nov 11, 2019 8:38 PM UTC

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