{ "query": { "text": "PROFILE MATCH p=shortestPath(\n(u1:User {userID:\"3514890218\"})-[:follows*1..5]->(u2:User {userID:\"184460715\"})\n)\nRETURN nodes(p)", "parameters": {} }, "queryType": "r", "counters": { "_stats": { "nodesCreated": 0, "nodesDeleted": 0, "relationshipsCreated": 0, "relationshipsDeleted": 0, "propertiesSet": 0, "labelsAdded": 0, "labelsRemoved": 0, "indexesAdded": 0, "indexesRemoved": 0, "constraintsAdded": 0, "constraintsRemoved": 0 }, "_systemUpdates": 0 }, "updateStatistics": { "_stats": { "nodesCreated": 0, "nodesDeleted": 0, "relationshipsCreated": 0, "relationshipsDeleted": 0, "propertiesSet": 0, "labelsAdded": 0, "labelsRemoved": 0, "indexesAdded": 0, "indexesRemoved": 0, "constraintsAdded": 0, "constraintsRemoved": 0 }, "_systemUpdates": 0 }, "plan": { "operatorType": "ProduceResults@mydata", "identifiers": [ "u1", "anon_54", "`nodes(p)`", "p", "u2" ], "arguments": { "GlobalMemory": { "low": 78966944, "high": 0 }, "planner-impl": "IDP", "runtime": "PIPELINED", "Time": { "low": 98983, "high": 0 }, "runtime-impl": "PIPELINED", "version": "CYPHER 4.2", "DbHits": { "low": 10, "high": 0 }, "Details": "`nodes(p)`", "PipelineInfo": "In Pipeline 1", "planner-version": "4.2", "runtime-version": "4.2", "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "planner": "COST", "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 10, "high": 0 } }, "children": [ { "operatorType": "Projection@mydata", "identifiers": [ "u1", "anon_54", "`nodes(p)`", "p", "u2" ], "arguments": { "Details": "nodes(p) AS `nodes(p)`", "PipelineInfo": "In Pipeline 1", "Time": { "low": 82870, "high": 0 }, "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 0, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 2, "high": 0 } }, "children": [ { "operatorType": "ShortestPath@mydata", "identifiers": [ "u1", "u2", "p", "anon_54" ], "arguments": { "Details": "p = (u1)-[anon_54:follows*..5]->(u2)", "Memory": { "low": 78966944, "high": 0 }, "PipelineInfo": "In Pipeline 1", "EstimatedRows": 1, "DbHits": { "low": 1, "high": 0 }, "Rows": { "low": 1, "high": 0 } }, "children": [ { "operatorType": "MultiNodeIndexSeek@mydata", "identifiers": [ "u1", "u2" ], "arguments": { "Details": "UNIQUE u1:User(userID) WHERE userID = $autostring_0, UNIQUE u2:User(userID) WHERE userID = $autostring_1", "Memory": { "low": 72, "high": 0 }, "PipelineInfo": "In Pipeline 0", "Time": { "low": 201179, "high": 0 }, "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 4, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 8, "high": 0 } }, "children": [] } ] } ] } ] }, "profile": { "operatorType": "ProduceResults@mydata", "identifiers": [ "u1", "anon_54", "`nodes(p)`", "p", "u2" ], "arguments": { "GlobalMemory": { "low": 78966944, "high": 0 }, "planner-impl": "IDP",1 "runtime": "PIPELINED", "Time": { "low": 98983, "high": 0 }, "runtime-impl": "PIPELINED", "version": "CYPHER 4.2", "DbHits": { "low": 10, "high": 0 }, "Details": "`nodes(p)`", "PipelineInfo": "In Pipeline 1", "planner-version": "4.2", "runtime-version": "4.2", "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "planner": "COST", "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 10, "high": 0 } }, "dbHits": 10, "rows": 1, "pageCacheMisses": 0, "pageCacheHits": 10, "pageCacheHitRatio": 1, "time": 98983, "children": [ { "operatorType": "Projection@mydata", "identifiers": [ "u1", "anon_54", "`nodes(p)`", "p", "u2" ], "arguments": { "Details": "nodes(p) AS `nodes(p)`", "PipelineInfo": "In Pipeline 1", "Time": { "low": 82870, "high": 0 }, "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 0, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 2, "high": 0 } }, "dbHits": 0, "rows": 1, "pageCacheMisses": 0, "pageCacheHits": 2, "pageCacheHitRatio": 1, "time": 82870, "children": [ { "operatorType": "ShortestPath@mydata", "identifiers": [ "u1", "u2", "p", "anon_54" ], "arguments": { "Details": "p = (u1)-[anon_54:follows*..5]->(u2)", "Memory": { "low": 78966944, "high": 0 }, "PipelineInfo": "In Pipeline 1", "EstimatedRows": 1, "DbHits": { "low": 1, "high": 0 }, "Rows": { "low": 1, "high": 0 } }, "dbHits": 1, "rows": 1, "pageCacheMisses": 0, "pageCacheHits": 0, "pageCacheHitRatio": 0, "time": 0, "children": [ { "operatorType": "MultiNodeIndexSeek@mydata", "identifiers": [ "u1", "u2" ], "arguments": { "Details": "UNIQUE u1:User(userID) WHERE userID = $autostring_0, UNIQUE u2:User(userID) WHERE userID = $autostring_1", "Memory": { "low": 72, "high": 0 }, "PipelineInfo": "In Pipeline 0", "Time": { "low": 201179, "high": 0 }, "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 4, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 8, "high": 0 } }, "dbHits": 4, "rows": 1, "pageCacheMisses": 0, "pageCacheHits": 8, "pageCacheHitRatio": 1, "time": 201179, "children": [] } ] } ] } ] }, "notifications": [], "server": { "address": "138.197.194.169:7687", "version": "Neo4j/4.2.3", "protocolVersion": 4.2 }, "resultConsumedAfter": { "low": 3173, "high": 0 }, "resultAvailableAfter": { "low": 12, "high": 0 }, "database": { "name": "mydata" } }