Query
MATCH (d:Document)-[:DOC_TO_ORG]->(o:Organization) WHERE d.status IN $statuses OPTIONAL MATCH (d)-[:DOCUMENT_VERSION]->(v:DocumentVersion) WITH d, o, v ORDER BY v.createdat DESC WITH d, o, collect(v)[?] AS latest RETURN o.alias AS org, d.tildaid AS document_id, latest.tildaid AS version_id, d.fileName AS name, d.status AS status
Optimizer suggestions
No suggestion for this shape yet — generate one now and it will read this exact statement and its timings.
p95 latency over time
95th-percentile elapsedTimeMs per bucket
p50 latency over time
Median elapsedTimeMs per bucket
Executions / bucket
How often this shape ran
p50/p95 are recovered from the per-bucket latency histogram. A rising p95 with a flat p50 means the tail is getting slower (lock contention, GC, a cold cache) even when the typical case is fine.