Hi all, Neo4j 4.1 Community Edition I am trying to get a better understanding of the terms inside the profile operators: Rows Estimated rows DB hits Cache hits Cache misses Memory I understand (1) well enough, however I have trouble fully understanding (2-6). For (2) Estimated rows, I don't un…

Here's my take on this: Rows This is arguably the most important thing in a PROFILE plan, since Cypher operations execute per row. The idea with query tuning is to reduce the work done as much as possible while still getting the correct answer, so streamlining a query to reduce unnecessary rows …

Understanding the terms in the Profile operators

General Newbie Questions

Cobra (Cobra) August 11, 2020, 9:05am 4

Andrew gave an explanation about DbHits here

There is an article about memory consumption

Other links about memory:

Memory configuration - Operations Manual
Performance - Operations Manual

1 Like

Topic		Replies	Views
About db hits of Neo4j Cypher performance , cypher	2	1635	December 13, 2019
Why so high db hits in ProduceResults? Cypher	4	927	December 17, 2020
Why different results in these profiles about db hits? Graph Academy & Certifications browser , cypher , profile , tuning	5	354	February 9, 2022
Query Profile : No PageCache Hits Neo4j Graph Platform migrated	0	87	November 4, 2022
Extremely slow query when profile looks very good? Cypher	11	4079	October 3, 2019

July Summer Fun!

Understanding the terms in the Profile operators

Related topics