git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: execution time and planning time from Calcite


Thanks Stamatis.... I will look into that and get back to you....

On Sat, 1 Dec 2018, 10:28 am Stamatis Zampetakis <zabetak@xxxxxxxxx wrote:

> Hi Lekshmi,
>
> I don't think that you can obtain this information easily. The current
> implementation of explain does not seem to provide this information.
> If you are willing to dig in a bit into the code you might find useful the
> following entry points regarding the timing of queries: CalciteTimingTracer
> <
> https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/util/trace/CalciteTimingTracer.java
> >
> , CalciteTrace
> <
> https://github.com/apache/calcite/blob/439ca73b8a335213b5f2764514b14e17c9d3c216/core/src/main/java/org/apache/calcite/util/trace/CalciteTrace.java#L103
> >
> .
>
> Best,
> Stamatis
>
> Στις Παρ, 30 Νοε 2018 στις 11:33 μ.μ., ο/η Lekshmi <lekshmibg09@xxxxxxxxx>
> έγραψε:
>
> > Hi,
> >    I was comparing the performance of PostgreSQL and Calcite. I can
> collect
> > the planning and execution time from PostgreSQL using "explain analyze"
> but
> > from calcite I didnt get all the information using "explain all
> > attributes". I would like to know how can we collect the execution time
> and
> > planning time of a query from calcite..It would be great, if anyone help
> > me..
> >
> > Thanks and Regards
> >
> > Lekshmi B.G
> > Email: lekshmibg09@xxxxxxxxx
> >
>