{ "query": { "text": "CYPHER runtime=SLOTTED \nPROFILE MATCH p=shortestPath( (u1:User {userID:\"3514890218\"})-[:follows*1..4]->(u2:User {userID:\"184460715\"}) ) RETURN 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@instadata", "identifiers": [ "u1", "anon_54", "`nodes(p)`", "p", "u2" ], "arguments": { "GlobalMemory": { "low": 4124160, "high": 0 }, "planner-impl": "IDP", "runtime": "SLOTTED", "runtime-impl": "SLOTTED", "version": "CYPHER 4.2", "DbHits": { "low": 10, "high": 0 }, "Details": "`nodes(p)`", "planner-version": "4.2", "runtime-version": "4.2", "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "planner": "COST", "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 8, "high": 0 } }, "children": [ { "operatorType": "Projection@instadata", "identifiers": [ "u1", "anon_54", "`nodes(p)`", "p", "u2" ], "arguments": { "Details": "nodes(p) AS `nodes(p)`", "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@instadata", "identifiers": [ "u1", "u2", "p", "anon_54" ], "arguments": { "Details": "p = (u1)-[anon_54:follows*..4]->(u2)", "Memory": { "low": 4124160, "high": 0 }, "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 1, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 42967, "high": 0 } }, "children": [ { "operatorType": "CartesianProduct@instadata", "identifiers": [ "u1", "u2" ], "arguments": { "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 0, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 0, "high": 0 } }, "children": [ { "operatorType": "NodeUniqueIndexSeek@instadata", "identifiers": [ "u1" ], "arguments": { "Details": "UNIQUE u1:User(userID) WHERE userID = $autostring_0", "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 2, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 4, "high": 0 } }, "children": [] }, { "operatorType": "NodeUniqueIndexSeek@instadata", "identifiers": [ "u2" ], "arguments": { "Details": "UNIQUE u2:User(userID) WHERE userID = $autostring_1", "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 2, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 4, "high": 0 } }, "children": [] } ] } ] } ] } ] }, "profile": { "operatorType": "ProduceResults@instadata", "identifiers": [ "u1", "anon_54", "`nodes(p)`", "p", "u2" ], "arguments": { "GlobalMemory": { "low": 4124160, "high": 0 }, "planner-impl": "IDP", "runtime": "SLOTTED", "runtime-impl": "SLOTTED", "version": "CYPHER 4.2", "DbHits": { "low": 10, "high": 0 }, "Details": "`nodes(p)`", "planner-version": "4.2", "runtime-version": "4.2", "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "planner": "COST", "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 8, "high": 0 } }, "dbHits": 10, "rows": 1, "pageCacheMisses": 0, "pageCacheHits": 8, "pageCacheHitRatio": 1, "time": 0, "children": [ { "operatorType": "Projection@instadata", "identifiers": [ "u1", "anon_54", "`nodes(p)`", "p", "u2" ], "arguments": { "Details": "nodes(p) AS `nodes(p)`", "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": 0, "children": [ { "operatorType": "ShortestPath@instadata", "identifiers": [ "u1", "u2", "p", "anon_54" ], "arguments": { "Details": "p = (u1)-[anon_54:follows*..4]->(u2)", "Memory": { "low": 4124160, "high": 0 }, "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 1, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 42967, "high": 0 } }, "dbHits": 1, "rows": 1, "pageCacheMisses": 0, "pageCacheHits": 42967, "pageCacheHitRatio": 1, "time": 0, "children": [ { "operatorType": "CartesianProduct@instadata", "identifiers": [ "u1", "u2" ], "arguments": { "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 0, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 0, "high": 0 } }, "dbHits": 0, "rows": 1, "pageCacheMisses": 0, "pageCacheHits": 0, "pageCacheHitRatio": 0, "time": 0, "children": [ { "operatorType": "NodeUniqueIndexSeek@instadata", "identifiers": [ "u1" ], "arguments": { "Details": "UNIQUE u1:User(userID) WHERE userID = $autostring_0", "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 2, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 4, "high": 0 } }, "dbHits": 2, "rows": 1, "pageCacheMisses": 0, "pageCacheHits": 4, "pageCacheHitRatio": 1, "time": 0, "children": [] }, { "operatorType": "NodeUniqueIndexSeek@instadata", "identifiers": [ "u2" ], "arguments": { "Details": "UNIQUE u2:User(userID) WHERE userID = $autostring_1", "PageCacheMisses": { "low": 0, "high": 0 }, "EstimatedRows": 1, "DbHits": { "low": 2, "high": 0 }, "Rows": { "low": 1, "high": 0 }, "PageCacheHits": { "low": 4, "high": 0 } }, "dbHits": 2, "rows": 1, "pageCacheMisses": 0, "pageCacheHits": 4, "pageCacheHitRatio": 1, "time": 0, "children": [] } ] } ] } ] } ] }, "notifications": [], "server": { "address": "138.197.194.169:7687", "version": "Neo4j/4.2.3", "protocolVersion": 4.2 }, "resultConsumedAfter": { "low": 23, "high": 0 }, "resultAvailableAfter": { "low": 0, "high": 0 }, "database": { "name": "instadata" } }