Explaining the execution plan


(mfeingold) #1

Is there a way to understand how the query will be executed -
something similar to the explain feature in SQL? As explained in the
manual explain flag on the query only covers the score computation


(Shay Banon) #2

Explain flag is as detailed as it goes. What else are you missing?

On Sat, Aug 20, 2011 at 8:16 PM, Michael Feingold mfeingold@hill30.comwrote:

Is there a way to understand how the query will be executed -
something similar to the explain feature in SQL? As explained in the
manual explain flag on the query only covers the score computation


(mfeingold) #3

What I am looking for is a way to get some understanding as to what
makes my query slow and may be some hints about how to make it
faster.

Something similar to what is available for SQL - for a query if a
proper index is missing it would tell you that table scan was used, so
it becomes clear that adding an index will speed it up - may be.

I am not sure how much (if any) of this stuff can be applied here, but
I am certainly missing it.

On Aug 22, 1:41 pm, Shay Banon kim...@gmail.com wrote:

Explain flag is as detailed as it goes. What else are you missing?

On Sat, Aug 20, 2011 at 8:16 PM, Michael Feingold mfeing...@hill30.comwrote:

Is there a way to understand how the query will be executed -
something similar to the explain feature in SQL? As explained in the
manual explain flag on the query only covers the score computation


(Shay Banon) #4

I see, yea, that can be interesting. Need to think a bit on how something
like that can be recorded and then exposed.

On Mon, Aug 29, 2011 at 7:12 PM, Michael Feingold mfeingold@hill30.comwrote:

What I am looking for is a way to get some understanding as to what
makes my query slow and may be some hints about how to make it
faster.

Something similar to what is available for SQL - for a query if a
proper index is missing it would tell you that table scan was used, so
it becomes clear that adding an index will speed it up - may be.

I am not sure how much (if any) of this stuff can be applied here, but
I am certainly missing it.

On Aug 22, 1:41 pm, Shay Banon kim...@gmail.com wrote:

Explain flag is as detailed as it goes. What else are you missing?

On Sat, Aug 20, 2011 at 8:16 PM, Michael Feingold <mfeing...@hill30.com
wrote:

Is there a way to understand how the query will be executed -
something similar to the explain feature in SQL? As explained in the
manual explain flag on the query only covers the score computation


(system) #5