Skip to content

Instantly share code, notes, and snippets.

@smalyshev

smalyshev/plan-fast

Last active March 7, 2017 23:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save smalyshev/d5d3d436bf49b554c89b94ffa23258be to your computer and use it in GitHub Desktop.
Save smalyshev/d5d3d436bf49b554c89b94ffa23258be to your computer and use it in GitHub Desktop.
Download ZIP
Raw
plan-fast
com.bigdata.bop.solutions.SliceOp[14](ProjectionOp[13])[ BOp.bopId=14, SliceOp.offset=0, SliceOp.limit=20, BOp.evaluationContext=CONTROLLER, PipelineOp.pipelined=true, PipelineOp.maxParallel=1, PipelineOp.reorderSolutions=false, PipelineOp.sharedState=true, BOp.timeout=600000, BOp.namespace=wdq, QueryEngine.queryId=2cf5767b-93ce-46b8-8fad-91307532ea4c, QueryEngine.chunkHandler=com.bigdata.bop.engine.NativeHeapStandloneChunkHandler@7189d0d7]
com.bigdata.bop.solutions.ProjectionOp[13](MemorySortOp[11])[ BOp.bopId=13, BOp.evaluationContext=CONTROLLER, PipelineOp.sharedState=true, JoinAnnotations.select=[id, count], PipelineOp.maxParallel=1, PipelineOp.reorderSolutions=false]
com.bigdata.bop.solutions.MemorySortOp[11](ChunkedMaterializationOp[12])[ BOp.bopId=11, SortOp.sortOrder=[DESC(count)], SortOp.valueComparator=com.bigdata.bop.solutions.IVComparator@9e95c96, BOp.evaluationContext=CONTROLLER, PipelineOp.pipelined=true, PipelineOp.maxParallel=1, PipelineOp.reorderSolutions=false, PipelineOp.lastPass=true]
com.bigdata.bop.rdf.join.ChunkedMaterializationOp[12](FastRangeCountOp[10])[ ChunkedMaterializationOp.vars=[count], IPredicate.relationName=[wdq.lex], IPredicate.timestamp=1488929257353, ChunkedMaterializationOp.materializeAll=false, PipelineOp.sharedState=true, PipelineOp.reorderSolutions=true, PipelineOp.maxParallel=5, BOp.bopId=12]
com.bigdata.bop.join.FastRangeCountOp[10](HTreeSolutionSetHashJoinOp[8])[ BOp.bopId=10, JoinAnnotations.constraints=null, AST2BOpBase.simpleJoin=true, FastRangeCountOp.countVar=count, AccessPathJoinAnnotations.predicate=com.bigdata.rdf.spo.SPOPredicate[9](i=null, Vocab(6)[http://www.wikidata.org/prop/direct/P]:XSDUnsignedByte(31), id=null)[ IPredicate.relationName=[wdq.spo], IPredicate.timestamp=1488929257353, BOp.bopId=9, AST2BOpBase.estimatedCardinality=20493677, AST2BOpBase.originalIndex=POS, IPredicate.flags=[KEYS,VALS,READONLY,PARALLEL]]]
com.bigdata.bop.join.HTreeSolutionSetHashJoinOp[8](HTreeNamedSubqueryOp[7])[ BOp.bopId=8, BOp.evaluationContext=CONTROLLER, PipelineOp.sharedState=true, namedSetRef=NamedSolutionSetRef{localName=-subSelect-1,queryId=2cf5767b-93ce-46b8-8fad-91307532ea4c,joinVars=[]}, JoinAnnotations.constraints=null, SolutionSetHashJoinOp.release=false]
com.bigdata.bop.controller.HTreeNamedSubqueryOp[7]()[ BOp.bopId=7, BOp.evaluationContext=CONTROLLER, PipelineOp.maxParallel=1, PipelineOp.pipelined=false, PipelineOp.maxMemory=9223372036854775807, PipelineOp.sharedState=true, IPredicate.relationName=[wdq.lex], SubqueryAnnotations.subquery=com.bigdata.bop.solutions.ProjectionOp[6](DistinctTermScanOp[5])[ BOp.bopId=6, BOp.evaluationContext=CONTROLLER, PipelineOp.sharedState=true, JoinAnnotations.select=[id], BOp.namespace=wdq], HashJoinAnnotations.joinVars=[], namedSetRef=NamedSolutionSetRef{localName=-subSelect-1,queryId=2cf5767b-93ce-46b8-8fad-91307532ea4c,joinVars=[]}]
@com.bigdata.bop.controller.SubqueryAnnotations.subquery:
com.bigdata.bop.solutions.ProjectionOp[6](DistinctTermScanOp[5])[ BOp.bopId=6, BOp.evaluationContext=CONTROLLER, PipelineOp.sharedState=true, JoinAnnotations.select=[id], BOp.namespace=wdq]
com.bigdata.bop.join.DistinctTermScanOp[5](HTreeDistinctBindingSetsOp[3])[ BOp.bopId=5, JoinAnnotations.constraints=null, AST2BOpBase.simpleJoin=true, DistinctTermScanOp.distinctVar=id, AccessPathJoinAnnotations.predicate=com.bigdata.rdf.spo.SPOPredicate[4](i=null, Vocab(6)[http://www.wikidata.org/prop/direct/P]:XSDUnsignedByte(31), id=null)[ IPredicate.relationName=[wdq.spo], IPredicate.timestamp=1488929257353, BOp.bopId=4, AST2BOpBase.estimatedCardinality=6831225, AST2BOpBase.originalIndex=POS, IPredicate.keyOrder=POS, IPredicate.flags=[KEYS,VALS,READONLY,PARALLEL]], IPredicate.keyOrder=POS]
com.bigdata.bop.solutions.HTreeDistinctBindingSetsOp[3]()[ BOp.bopId=3, HashJoinAnnotations.joinVars=[id], BOp.evaluationContext=CONTROLLER, PipelineOp.sharedState=true, PipelineOp.maxParallel=1, namedSetRef=NamedSolutionSetRef{localName=--distinct-2,queryId=2cf5767b-93ce-46b8-8fad-91307532ea4c,joinVars=[id]}, IPredicate.relationName=[wdq.lex]]
Raw
plan-slow
com.bigdata.bop.solutions.SliceOp[7](ProjectionOp[6])[ BOp.bopId=7, SliceOp.offset=0, SliceOp.limit=20, BOp.evaluationContext=CONTROLLER, PipelineOp.pipelined=true, PipelineOp.maxParallel=1, PipelineOp.reorderSolutions=false, PipelineOp.sharedState=true, BOp.timeout=600000, BOp.namespace=wdq, QueryEngine.queryId=ebb543af-b22e-4759-a235-517028573fbc, QueryEngine.chunkHandler=com.bigdata.bop.engine.NativeHeapStandloneChunkHandler@7189d0d7]
com.bigdata.bop.solutions.ProjectionOp[6](MemorySortOp[4])[ BOp.bopId=6, BOp.evaluationContext=CONTROLLER, PipelineOp.sharedState=true, JoinAnnotations.select=[id, count, x], PipelineOp.maxParallel=1, PipelineOp.reorderSolutions=false]
com.bigdata.bop.solutions.MemorySortOp[4](ChunkedMaterializationOp[5])[ BOp.bopId=4, SortOp.sortOrder=[DESC(count)], SortOp.valueComparator=com.bigdata.bop.solutions.IVComparator@49d328b4, BOp.evaluationContext=CONTROLLER, PipelineOp.pipelined=true, PipelineOp.maxParallel=1, PipelineOp.reorderSolutions=false, PipelineOp.lastPass=true]
com.bigdata.bop.rdf.join.ChunkedMaterializationOp[5](PipelinedAggregationOp[3])[ ChunkedMaterializationOp.vars=[count], IPredicate.relationName=[wdq.lex], IPredicate.timestamp=1488929057469, ChunkedMaterializationOp.materializeAll=false, PipelineOp.sharedState=true, PipelineOp.reorderSolutions=true, PipelineOp.maxParallel=5, BOp.bopId=5]
com.bigdata.bop.solutions.PipelinedAggregationOp[3](PipelineJoin[2])[ BOp.bopId=3, BOp.evaluationContext=CONTROLLER, PipelineOp.pipelined=true, PipelineOp.maxParallel=1, PipelineOp.sharedState=true, GroupByOp.groupByState=GroupByState{select=[com.bigdata.bop.Bind(id,id), com.bigdata.bop.Bind(count,com.bigdata.bop.rdf.aggregate.COUNT(id)), com.bigdata.bop.Bind(x,TermId(11255583L)[x])],groupBy=[com.bigdata.bop.Bind(id,id)],having=null}, GroupByOp.groupByRewrite=GroupByRewriter{aggExpr={com.bigdata.bop.rdf.aggregate.COUNT(id)=4b6f627a-2c13-4977-b0dc-f234ebbd37ae},select2=[com.bigdata.bop.Bind(id,id), com.bigdata.bop.Bind(count,4b6f627a-2c13-4977-b0dc-f234ebbd37ae), com.bigdata.bop.Bind(x,TermId(11255583L)[x])],having2=null}, PipelineOp.lastPass=true]
com.bigdata.bop.join.PipelineJoin[2]()[ BOp.bopId=2, JoinAnnotations.constraints=null, AST2BOpBase.simpleJoin=true, BOp.evaluationContext=ANY, AccessPathJoinAnnotations.predicate=com.bigdata.rdf.spo.SPOPredicate[1](i=null, Vocab(6)[http://www.wikidata.org/prop/direct/P]:XSDUnsignedByte(31), id=null)[ IPredicate.relationName=[wdq.spo], IPredicate.timestamp=1488929057469, BOp.bopId=1, AST2BOpBase.estimatedCardinality=20493678, AST2BOpBase.originalIndex=POS, IPredicate.flags=[KEYS,VALS,READONLY,PARALLEL]]]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment