systay

/**
 * Copyright (c) 2002-2014 "Neo Technology,"
 * Network Engine for Objects in Lund AB [http://neotechnology.com]
 *
 * This file is part of Neo4j.
 *
 * Neo4j is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.

systay

[INFO] ------------------------------------------------------------------------
[INFO] Building Neo4j - Cypher Compiler 2.2 2.2-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[INFO] 
[INFO] --- maven-enforcer-plugin:1.3.1:enforce (enforce-dont-exist) @ neo4j-cypher-compiler-2.2 ---
[INFO] 
[INFO] --- license-maven-plugin:3:check (check-licenses) @ neo4j-cypher-compiler-2.2 ---
[INFO] Checking licenses...
[INFO] 
[INFO] --- maven-antrun-plugin:1.6:run (generate-version) @ neo4j-cypher-compiler-2.2 ---

systay

      "plan": {
        "root": {
          "operatorType": "AllNodesScan",
          "Rows": "Rows(0)",
          "IntroducedIdentifier": "IntroducedIdentifier(n)",
          "DbHits": "DbHits(1)",
          "version": "CYPHER 2.2-cost",
          "EstimatedRows": "EstimatedRows(0)",
          "children": [
            {

systay

"plan": {
        "root": {
          "operatorType": "AllNodesScan",
          "Rows": "0",
          "IntroducedIdentifier": "n",
          "DbHits": "1",
          "version": "CYPHER 2.2-cost",
          "EstimatedRows": "0",
          "children": [
            {

systay

[{
  "plans":["NodeByLabelScan[v](v, Right(LabelId(2)), Set())","Selection[v](ArrayBuffer(HasLabels(v, LabelName(\"Venue\") ⸬ ⬨)))\n↳ AllNodesScan[v](v, Set())"],
  "winner":"NodeByLabelScan[v](v, Right(LabelId(2)), Set())",
  "calculations":[{
    "plan":"Selection[v](ArrayBuffer(HasLabels(v, LabelName(\"Venue\") ⸬ ⬨)))\n↳ AllNodesScan[v](v, Set())",
    "cost":227508.0,
    "cardinalityEstimations":[{
      "plan":"AllNodesScan[v](v, Set())",
      "result":113754.0,
      "expressions":[],

systay

Projection(0)
  |
  +Top
    |
    +Projection(1)
      |
      +EagerAggregation(0)
        |
        +Apply(0)
          |

systay

         Apply
      +----^---+
      |        |       
    <lhs>   Optional
               ^
               |
             <rhs>

systay

neo4j-sh (?)$ profile cypher 2.1                   
> MATCH  p = (n:Topic)-[*0..2]-(m:Topic) 
> where n.name = 'Topic1' and m.name = 'Topic2'  
> return p, reduce(totProximity = 0, n IN relationships(p)| totProximity + n.proximity) AS pathProximity  
> order by pathProximity DESC  LIMIT 6;
+-------------------+
| p | pathProximity |
+-------------------+
+-------------------+
0 row

systay

Thread dumps of pull-requests :: pull-requests #2881 (21 Oct 14 05:09)
Process tree:

Click on an item in the tree to view thread dump.
PID: 17897 /usr/lib/jvm/java-7-openjdk-amd64/jre/bin/java
PID: 1485 /bin/sh
PID: 1488 /usr/lib/jvm/java-7-openjdk-amd64/jre/bin/java
Process ID (PID): 1488

Process command line

systay

neo4j-sh (?)$ profile match (writer:Entity{ Id:"77e452da060a4e09b7d0d5fae20aca82" }), writer-[:wrote]->segment-[r1:regarding_entity]->entity 
> with entity as names, count(entity) as counts 
> order by count(entity) desc 
> limit 100 with names, counts 
> match otherwriters-[:wrote]->segment-[r2:regarding_entity]->names 
> return otherwriters.Name as Name, otherwriters.Id as Id, count(distinct names) as EntityCount 
> order by count(distinct names) desc skip 1 limit 3;
+----------------------------------------------------------------------+
| Name              | Id                                 | EntityCount |
+----------------------------------------------------------------------+