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?