cancel
Showing results for 
Search instead for 
Did you mean: 

Neo4j query log(Client read time calculus)

ricardo_lopes
Node Link

Good morning.
Currently, I'm trying to monitor a Neo4j v4.3.1 Enterprise Edition database.

{"time":"2021-10-12 09:18:15.671+0000","level":"INFO","event":"success","type":"query","elapsedTimeMs":108,"planning":60,"cpu":109,"waiting":0,"allocatedBytes":0,"pageHits":0,"pageFaults":0,"source":"embedded-session\t","database":"neo4j","username":"neo4j","query":"EXPLAIN CALL apoc.load.csv('https://data.neo4j.com/v4.0-intro-neo4j/movies2.csv' ) YIELD map AS row RETURN row","annotationData":"{}","transactionId":3}

{"time":"2021-10-12 09:18:17.281+0000","level":"INFO","event":"success","type":"query","elapsedTimeMs":145,"planning":123,"cpu":140,"waiting":0,"allocatedBytes":1252,"pageHits":50,"pageFaults":0,"source":"embedded-session\t","database":"neo4j","username":"neo4j","query":" WITH  $`p` as `p` ,  $`person` as `person` ,  $`m` as `m` MERGE (p)-[:ACTED_IN {roles: person.roles}]->(m)\n                 ON CREATE SET p:Actor","annotationData":"{}","transactionId":4}

For some of the queries logged(e.g. the first one), total time(assuming it is the elapsed time) is lower than cpu time, so the equation represented below will result in negative values. Why is this occurring and is this correct?

1 REPLY 1

stanrogo
Node

I am also having this issue. Did you manage to figure out why this is happening?