+1 to include sub-query result. Please could you open a new issue? Lvc@
On 5 March 2015 at 21:32, Jamie Blair <[email protected]> wrote: > Luca, > > Thanks for the reply, yes that will return the correct results. However > the orientdb way seem to be to use quite a few sub queries (correct me if > I'm wrong), so just having the top level EXPLAINed means that its really > hard to profile queries until it hits an environment with a large amount of > data. > > This was why I originally raised it in github issues because I assumed it > was a bug. From what you say I'm guessing its a not, but is there any work > arounds to get those sort of metrics? > > Thanks, > Jamie > Hi Jamie, > What about the result of: > > EXPLAIN select from Vertex > > I think the profiler doesn't collect metrics from sub-queries. > > Lvc@ > > > On 4 March 2015 at 14:20, Jamie Blair <[email protected]> wrote: > >> Given the query >> >> EXPLAIN select from (select from Vertex) LIMIT 1 >> >> I get the results >> >> elapsed: 2514.5999 >> recordReads: 1 >> documentReads: 1 >> resultSize: 1 >> evaluated: 1 >> >> Given the query took 2.5seconds I would have expected some of those >> numbers to be a lot higher (recordReads, documentReads, resultSize, >> evaluated) >> >> Anyone any idea whats going on? Given the issues with the query >> parser/optimiser I really need some data about whats going on with my >> queries before they hit production. >> >> Thanks, >> Jamie >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "OrientDB" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > > --- > You received this message because you are subscribed to a topic in the > Google Groups "OrientDB" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/orient-database/BSuiP8a9nqQ/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
