This is the plan that is returned with profile=true
{
"columns" : [ "j1.jurt_id", "j2.jurt_id", "commonterms" ],
"data" : [ [ "J69478", "J70059", 281 ], [ "J69478", "J75545", 214 ], [
"J69478", "J72887", 209 ] ],
"plan" : {
"args" : {
"returnItemNames" : [ "j1.jurt_id", "j2.jurt_id", "commonterms" ],
"_rows" : 3,
"_db_hits" : 0,
"symKeys" : [ "j1", "j2.jurt_id", "j1.jurt_id", "commonterms", "j2" ]
},
"dbHits" : 0,
"name" : "ColumnFilter",
"children" : [ {
"args" : {
"limit" : "Literal(3)",
"orderBy" : [ "SortItem(commonterms,false)" ],
"_rows" : 3,
"_db_hits" : 0
},
"dbHits" : 0,
"name" : "Top",
"children" : [ {
"args" : {
"_rows" : 9995,
"_db_hits" : 19990,
"exprKeys" : [ "j1.jurt_id", "j2.jurt_id" ],
"symKeys" : [ "j1", "j2", "commonterms" ]
},
"dbHits" : 19990,
"name" : "Extract",
"children" : [ {
"args" : {
"returnItemNames" : [ "j1", "j2", "commonterms" ],
"_rows" : 9995,
"_db_hits" : 0,
"symKeys" : [ "j1", "j2", "
INTERNAL_AGGREGATE2ee63722-f8bd-482b-b98d-12f0aaf4460d" ]
},
"dbHits" : 0,
"name" : "ColumnFilter",
"children" : [ {
"args" : {
"keys" : [ "j1", "j2" ],
"_rows" : 9995,
"aggregates" : [ "(
INTERNAL_AGGREGATE2ee63722-f8bd-482b-b98d-12f0aaf4460d,Count(t))" ],
"_db_hits" : 0
},
"dbHits" : 0,
"name" : "EagerAggregation",
"children" : [ {
"args" : {
"_rows" : 519772,
"_db_hits" : 0,
"pred" : "(NOT(IdFunction(j1) == IdFunction(j2)) AND
hasLabel(j2:jurt(3)))"
},
"dbHits" : 0,
"name" : "Filter",
"children" : [ {
"args" : {
"start" : {
"identifiers" : [ "j1" ],
"query" : "Literal(J69478)",
"producer" : "SchemaIndex",
"property" : "jurt_id",
"label" : "jurt"
},
"trail" : "(j1)-[ UNNAMED15:HAS_TERM WHERE
(hasLabel(NodeIdentifier():Term(1)) AND hasLabel(NodeIdentifier():Term(1)))
AND true]->(t)<-[ UNNAMED37:HAS_TERM WHERE
hasLabel(NodeIdentifier():jurt(3)) AND true]-(j2)",
"_rows" : 519772,
"_db_hits" : 520531
},
"dbHits" : 520531,
"name" : "TraversalMatcher",
"children" : [ ],
"rows" : 519772
} ],
"rows" : 519772
} ],
"rows" : 9995
} ],
"rows" : 9995
} ],
"rows" : 9995
} ],
"rows" : 3
} ],
"rows" : 3
}
}
--
You received this message because you are subscribed to the Google Groups
"Neo4j" 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.
