Xray
hourly rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 3 days▾
Ends now. Anything up to this cluster's 30-day retention.
Start and end times
Cancel
Interpreted in UTC (change it at the right of this bar). Earliest available: 2026-10-20 17:16:04.
› →|
updated 2d ago
Sample data. This database was generated by scripts/seed_dev_db.py — every service, deploy, person and figure on this page is synthetic. Names are sample.*@seed.invalid and image tags are prefixed SEED-. Nothing here happened.

Query trends 80

stored 2d ago top 80 of 821

Neo4j query shapes on production over the last 3d, grouped by plan hash. Click a column to sort; p95 drift (late-half ÷ early-half of the window) ranks the queries getting slower.

Columns
Views
Export CSV
Query shape Count Avg p95 ▴ Max p95 drift
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
dashrsvc
722 0 ms <1 ms 0 ms flat
match (sn:StudyNotification{studyId:$studyId }) return sn skip $skip limit $limit
match (sn:StudyNotification{studyId:$studyId }) return sn skip $skip limit $limit
enrollsvc
2 0 ms <1 ms 0 ms flat
MATCH (w:MailgunProcessedWebhook {message_id: $message_id}) WHERE w.processed_at < timestamp() - $ttl_ms DETACH DELETE w
MATCH (w:MailgunProcessedWebhook {message_id: $message_id}) WHERE w.processed_at < timestamp() - $ttl_ms DETACH DELETE w
write virtual-assistant
1 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` CALL apoc.create.relationship(from, row.parentRelation, {}, node) yield rel RETURN rel
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` CALL apoc.create.relationship(from, row.parentRelation, {}, node) yield rel RETURN rel
write execsvc
25 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`row` as `row` , $`to` as `to` CALL apoc.create.relationship(node, row.peerRelation, {}, to) yield rel as rel1 RETURN rel1
WITH $`node` as `node` , $`row` as `row` , $`to` as `to` CALL apoc.create.relationship(node, row.peerRelation, {}, to) yield rel as rel1 RETURN rel1
write execsvc
26 0 ms <1 ms 0 ms flat
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
execsvc
26 0 ms <1 ms 0 ms flat
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
docsvc
26,938 <1 ms <1 ms 82 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pa:ParticipantActivity) optional match (cp:CarePlan{tildaid: pa.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pa:ParticipantActivity) optional match (cp:CarePlan{tildaid: pa.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (pa)-[: BELONGS_TO_ACTIVITY]->(a:Activity) optional match (pa)-[:PARTICIPANT_ACTIVITY]-(:ParticipantVisit)-[:BELONGS_TO_VISIT]-(v) where v:Visit or v:VisitV2 optional match (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pa)-[:PARTICIPANT_DOCUMENTSET]-(pds:ParticipantDocumentSet)-[:BELONGS_TO_DOCUMENTSET]-(ds:DocumentSet) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pa, site, v, p, phi, ds, a, cp, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, Phi: phi, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, User: u, AssignedUser: auCollected, CarePlan: cp, Activity: a, Visit : v, DocumentSet: ds, Patient: p, CreatedBy: createdBy}
tusker
98 5 ms <1 ms 451 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pv)-[:BELONGS_TO_VISIT]->(v) where v:Visit or v:VisitV2 optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)- [:OWNED_BY]->(au:User) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pv, site, v, p, phi, cu as createdBy, pd.siteNumber as siteNumber, cp return {Task: t, Study: st, Phi: phi, Visit: v, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, User: u, AssignedUser: auCollected, Patient: p, CreatedBy: createdBy, CarePlan: cp}
tusker
666 <1 ms <1 ms 236 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(ae:AdverseEvent) optional match (cp:CarePlan{tildaid: ae.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(ae:AdverseEvent) optional match (cp:CarePlan{tildaid: ae.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (ae)<-[:OBJ_TO_ADVERSE_EVENT]-(pv:ParticipantVisit) optional match (pv)-[:BELONGS_TO_VISIT]->(v) where v:Visit or v:VisitV2 optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, ae, site, v, p, phi, cu as createdBy, pd.siteNumber as siteNumber, cp return {Task: t, Study: st, Phi: phi, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, Visit: v, User: u, AssignedUser: auCollected, Patient: p, CreatedBy: createdBy, CarePlan: cp}
tusker
241 <1 ms <1 ms 6 ms flat
WITH $`t` as `t` optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:CREATED_BY]-(cu:User) with t, u, collect(au) as auCollected, cu as createdBy return {Task: …
WITH $`t` as `t` optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:CREATED_BY]-(cu:User) with t, u, collect(au) as auCollected, cu as createdBy return {Task: t, User: u, AssignedUser: auCollected, CreatedBy: createdBy}
tusker
19 <1 ms 1 ms 1 ms 1.2× ↑
match(a:StudySiteActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:StudySiteActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write execsvc
18 <1 ms 1 ms 1 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(q:Query) optional match (cp:CarePlan{tildaid: q.careplanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITI…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(q:Query) optional match (cp:CarePlan{tildaid: q.careplanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pq:ParticipantQuestion{tildaid:q.scopeId})<-[:PARTICIPANT_QUESTION]-(pqn:ParticipantQuestionnaire)<-[:PARTICIPANT_QUESTIONNAIRE]-(pa:ParticipantActivity) optional match (pa)<-[:PARTICIPANT_ACTIVITY]-(pv:ParticipantVisit) optional match (pv)-[:BELONGS_TO_VISIT]->(v) where v:Visit or v:VisitV2 optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, q, site, v, p, phi, cu as createdBy, pd.siteNumber as siteNumber, cp return {Task: t, Study: st, Phi: phi, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, Visit: v, User: u, AssignedUser: auCollected, Patient: p, CreatedBy: createdBy, CarePlan: cp}
tusker
655 <1 ms 1 ms 5 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pv)-[:BELONGS_TO_VISIT]->(v) where v:Visit or v:VisitV2 optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)- [:OWNED_BY]->(au:User) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pv, site, v, p, phi, cu as createdBy, pd.siteNumber as siteNumber, cp return {Task: t, Study: st, Phi: phi, Visit: v, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, User: u, AssignedUser: auCollected, Patient: p, CreatedBy: createdBy, CarePlan: cp}
tusker
4 <1 ms 2 ms 1 ms flat
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
studiosvc
16 <1 ms 2 ms 1 ms flat
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write enrollsvc
4 <1 ms 2 ms 1 ms flat
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
studiosvc
17 <1 ms 2 ms 1 ms flat
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
studiosvc
5 <1 ms 2 ms 1 ms flat
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]…
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]->(clog)
write docsvc
41 <1 ms 2 ms 1 ms flat
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category AND NOT EXISTS { MATCH (ai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE ai.evaluation_run_id IS NOT NULL…
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category AND NOT EXISTS { MATCH (ai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE ai.evaluation_run_id IS NOT NULL } DETACH DELETE r
write docproc
1,146 <1 ms 2 ms 223 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(:StudySiteActor) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(st:Study) optional match (t)-[:BELONGS_TO]…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(:StudySiteActor) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(st:Study) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, collect(au) as auCollected, st, site, cu as createdBy return {Task: t, AssignedUser: auCollected, Study: st, Site: site, CreatedBy: createdBy}
tusker
4 <1 ms 2 ms 1 ms flat
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]…
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]->(clog)
write execsvc
24 <1 ms 2 ms 1 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
4 <1 ms 2 ms 1 ms flat
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category AND NOT EXISTS { MATCH (ai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE ai.evaluation_run_id IS NOT NULL…
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category AND NOT EXISTS { MATCH (ai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE ai.evaluation_run_id IS NOT NULL } DETACH DELETE r
write docproc
1,319 <1 ms 2 ms 48 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
docsvc
492 <1 ms 2 ms 2 ms 0.8× ↓
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
studiosvc
9 <1 ms 2 ms 1 ms flat
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
studiosvc
5 <1 ms 2 ms 1 ms flat
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
execsvc
3,406 <1 ms 2 ms 3 ms flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointDecisionFollowupPendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointDecisionFollowupClaimedAt, ?) >= ? R…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointDecisionFollowupPendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointDecisionFollowupClaimedAt, ?) >= ? RETURN wp.tildaid AS instanceId, cfg.tildaid AS cfgId LIMIT $limit
workplansvc
2,050 <1 ms 2 ms 1 ms flat
UNWIND $ids AS id MATCH (s:Study{tildaid:id}) WHERE s.delpending = true RETURN id LIMIT ?
UNWIND $ids AS id MATCH (s:Study{tildaid:id}) WHERE s.delpending = true RETURN id LIMIT ?
docsvc
39 <1 ms 2 ms 1 ms flat
MATCH(a:Staff{tildaid:$a_tildaid}) RETURN a
MATCH(a:Staff{tildaid:$a_tildaid}) RETURN a
schedsvc
24 <1 ms 2 ms 1 ms flat
match (:StudyNotification{studyId:$studyId})-[:ALL_CHANGELOG]-(clog:ChangeLog) return clog order by clog.createdat desc
match (:StudyNotification{studyId:$studyId})-[:ALL_CHANGELOG]-(clog:ChangeLog) return clog order by clog.createdat desc
enrollsvc
3 <1 ms 2 ms 1 ms flat
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_MEDIA]->(leaf)
write studiosvc
22 <1 ms 2 ms 1 ms flat
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_DOCREVIEW]->(leaf)
write studiosvc
22 <1 ms 2 ms 1 ms flat
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
onboardingsvc
51 <1 ms 2 ms 1 ms flat
MATCH(a:Study{tildaid:$a_tildaid})-[r:HAS_STUDY_CRITERION]->(b) RETURN b limit $limit
MATCH(a:Study{tildaid:$a_tildaid})-[r:HAS_STUDY_CRITERION]->(b) RETURN b limit $limit
enrollsvc
66 <1 ms 2 ms 1 ms flat
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_DOC_UPLOAD]->(leaf)
write studiosvc
22 <1 ms 2 ms 1 ms flat
MATCH (u:User {email: $identifier}) RETURN u.tildaid as tildaid, u.name as name, u.email as email, u.phoneNumber as phone, coalesce(u.authzUpdateNum, ?) as authzUpdateNum
MATCH (u:User {email: $identifier}) RETURN u.tildaid as tildaid, u.name as name, u.email as email, u.phoneNumber as phone, coalesce(u.authzUpdateNum, ?) as authzUpdateNum
docproc
1,418 <1 ms 2 ms 1 ms flat
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id
docproc
792 <1 ms 2 ms 1 ms flat
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]…
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]->(clog)
write docsvc
2,690 <1 ms 2 ms 17 ms flat
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
onboardingsvc
72 <1 ms 2 ms 1 ms flat
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
write studiosvc
20 <1 ms 2 ms 1 ms flat
match (u:User{tildaid:$userId})-[:FOR_USER]-(a:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(o:Organization{alias:$scaleAlias}) where coalesce(a.state, ?) <> ? return a.tildaid
match (u:User{tildaid:$userId})-[:FOR_USER]-(a:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(o:Organization{alias:$scaleAlias}) where coalesce(a.state, ?) <> ? return a.tildaid
docsvc
3,492 <1 ms 2 ms 3 ms flat
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
workplansvc
1,061 <1 ms 2 ms 2 ms flat
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
execsvc
3,281 <1 ms 2 ms 11 ms flat
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE_REF_TO_QUESTION]->(q:QuestionV2) with distinct q match(act:FormV2{til…
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE_REF_TO_QUESTION]->(q:QuestionV2) with distinct q match(act:FormV2{tildaid:$activityId}) merge(act)-[:ACTIVITY_TO_QUESTION]->(q)
write studiosvc
22 <1 ms 2 ms 1 ms flat
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE]->(rs:ResponseSet) with distinct rs match(act:FormV2{tildaid:$activityId}) merge…
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE]->(rs:ResponseSet) with distinct rs match(act:FormV2{tildaid:$activityId}) merge(act)-[:ACTIVITY_TO_RESPONSE_SET]->(rs)
write studiosvc
22 <1 ms 2 ms 1 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
104 <1 ms 2 ms 2 ms flat
CREATE (a:StudySiteActor{deltimestamp:$a_deltimestamp}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=?,a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.roles=$a_roles,a.startDates=…
CREATE (a:StudySiteActor{deltimestamp:$a_deltimestamp}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=?,a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.roles=$a_roles,a.startDates=$a_startDates,a.endDates=$a_endDates,a.location=$a_location RETURN a.tildaid, a.createdat
write execsvc
18 <1 ms 2 ms 1 ms flat
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id
docproc
828 <1 ms 2 ms 1 ms flat
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category RETURN count(r) > ? AS has_resolved
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category RETURN count(r) > ? AS has_resolved
docproc
24 <1 ms 2 ms 1 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
87 <1 ms 2 ms 1 ms flat
match (a:Study{delpending:false})-[:STUDY_TO_ORG]->(:Organization{tildaid:$orgId}) return a.status as status, count(a) as cnt, sum(?) as inScope
match (a:Study{delpending:false})-[:STUDY_TO_ORG]->(:Organization{tildaid:$orgId}) return a.status as status, count(a) as cnt, sum(?) as inScope
enrollsvc
5 <1 ms 2 ms 1 ms flat
match(node:GraphNode{tildaid:$objId})<-[r:GRAPH_NEXT{graphid:$graphId}]-() where apoc.coll.intersection(apoc.coll.sort(r.path), apoc.coll.sort($path))=apoc.coll.sort($path) set r.flags=apoc.bitwise.op(apoc.bitwise.op(r.flags, ?, apoc.bitwi…
match(node:GraphNode{tildaid:$objId})<-[r:GRAPH_NEXT{graphid:$graphId}]-() where apoc.coll.intersection(apoc.coll.sort(r.path), apoc.coll.sort($path))=apoc.coll.sort($path) set r.flags=apoc.bitwise.op(apoc.bitwise.op(r.flags, ?, apoc.bitwise.op(?, ?,?)), ?, $flags), r.who=$who
write studiosvc
20 <1 ms 2 ms 1 ms flat
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
workplansvc
989 <1 ms 2 ms 2 ms flat
MATCH (d:Document) WHERE d.tildaid IN $docIds AND EXISTS { (d)<-[:HAS_SYSTEM_TEMPLATE]-(:Organization {alias:?}) } RETURN d.tildaid LIMIT ?
MATCH (d:Document) WHERE d.tildaid IN $docIds AND EXISTS { (d)<-[:HAS_SYSTEM_TEMPLATE]-(:Organization {alias:?}) } RETURN d.tildaid LIMIT ?
docsvc
164 <1 ms 2 ms 1 ms flat
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
enrollsvc
69 <1 ms 2 ms 1 ms flat
MATCH (d:Document) WHERE d.tildaid IN $docIds AND EXISTS { (d)<-[:HAS_SYSTEM_TEMPLATE]-(:Organization {alias:?}) } RETURN d.tildaid LIMIT ?
MATCH (d:Document) WHERE d.tildaid IN $docIds AND EXISTS { (d)<-[:HAS_SYSTEM_TEMPLATE]-(:Organization {alias:?}) } RETURN d.tildaid LIMIT ?
docsvc
505 <1 ms 2 ms 1 ms flat
MATCH(a:DocumentCheckSum{deltimestamp:$a_deltimestamp,orgId:$a_orgId,studyId:$a_studyId,checksum:$a_checksum}) RETURN a
MATCH(a:DocumentCheckSum{deltimestamp:$a_deltimestamp,orgId:$a_orgId,studyId:$a_studyId,checksum:$a_checksum}) RETURN a
docsvc
54 <1 ms 2 ms 1 ms flat
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_TIMER]->(leaf)
write studiosvc
22 <1 ms 2 ms 1 ms flat
MATCH (u:User {email: $identifier}) RETURN u.tildaid as tildaid, u.name as name, u.email as email, u.phoneNumber as phone, coalesce(u.authzUpdateNum, ?) as authzUpdateNum
MATCH (u:User {email: $identifier}) RETURN u.tildaid as tildaid, u.name as name, u.email as email, u.phoneNumber as phone, coalesce(u.authzUpdateNum, ?) as authzUpdateNum
docproc
1,263 <1 ms 2 ms 2 ms flat
MATCH (ds:GoldenDataset)-[:CONTAINS_DOCUMENT]->(:Document {tildaid: $document_id}) RETURN ds.tildaid AS golden_dataset_id LIMIT ?
MATCH (ds:GoldenDataset)-[:CONTAINS_DOCUMENT]->(:Document {tildaid: $document_id}) RETURN ds.tildaid AS golden_dataset_id LIMIT ?
docproc
601 <1 ms 2 ms 1 ms flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.depende…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.dependencyResolutionRequestedAt, ?) > ? AND $nowMs - item.dependencyResolutionRequestedAt >= $windowMs AND wp.state <> ? AND NOT EXISTS { MATCH (ctx:WorkPlanContext{workplanConfigId: wp.tildaid, contextType:?}) } OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) RETURN DISTINCT wp.tildaid AS id, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
996 <1 ms 2 ms 1 ms flat
MATCH (ds:GoldenDataset)-[:CONTAINS_DOCUMENT]->(:Document {tildaid: $document_id}) RETURN ds.tildaid AS golden_dataset_id LIMIT ?
MATCH (ds:GoldenDataset)-[:CONTAINS_DOCUMENT]->(:Document {tildaid: $document_id}) RETURN ds.tildaid AS golden_dataset_id LIMIT ?
docproc
708 <1 ms 2 ms 1 ms flat
MATCH (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = $inProgress AND NOT j.tildaid IN $exclude AND coalesce(j.heartbeatAt, j.updatedat, j.startedAt, j.createdat, ?) < $idleBefore RETURN j.tildaid LIMIT ?
MATCH (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = $inProgress AND NOT j.tildaid IN $exclude AND coalesce(j.heartbeatAt, j.updatedat, j.startedAt, j.createdat, ?) < $idleBefore RETURN j.tildaid LIMIT ?
docsvc
6 <1 ms 2 ms 1 ms flat
MATCH (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = ? AND j.jobType IN [?, ?, ?] RETURN j.tildaid ORDER BY j.createdat ASC
MATCH (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = ? AND j.jobType IN [?, ?, ?] RETURN j.tildaid ORDER BY j.createdat ASC
docsvc
6 <1 ms 2 ms 1 ms flat
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask) RETURN count(t) as total
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask) RETURN count(t) as total
virtual-assistant
25 <1 ms 2 ms 1 ms flat
match(org:Organization{tildaid:$id})-[r:ORGANIZATION_TO_FORM]->(form:FormV2{tildaid:$formId}) optional match(form)-[:PUBLISHED_TO_DRAFT|ARCHIVED_TO_DRAFT]->(draft:FormV2{orgid:$id1}) with *, ? as refCount, ? as draftRefCount return form, d…
match(org:Organization{tildaid:$id})-[r:ORGANIZATION_TO_FORM]->(form:FormV2{tildaid:$formId}) optional match(form)-[:PUBLISHED_TO_DRAFT|ARCHIVED_TO_DRAFT]->(draft:FormV2{orgid:$id1}) with *, ? as refCount, ? as draftRefCount return form, draft, exists((form)<-[:GRAPH_NEXT|FORM_INSTANCE_TO_FORM]-()), r.inherited, refCount, draftRefCount
studiosvc
71 <1 ms 2 ms 1 ms flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONA…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) OPTIONAL MATCH (reviewer:User {tildaid: wp.checkpointRejectCascadeReviewerId}) RETURN wp.tildaid AS instanceId, coalesce(wp.checkpointRejectCascadeGateItemId, ?) AS gateItemId, coalesce(wp.checkpointRejectCascadeReviewerId, ?) AS reviewerId, coalesce(reviewer.name, ?) AS reviewerName, coalesce(reviewer.email, ?) AS reviewerEmail, coalesce(wp.checkpointRejectCascadeNotes, ?) AS notes, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
1,037 <1 ms 2 ms 2 ms flat
MATCH(a:Organization{deltimestamp:$a_deltimestamp,alias:$a_alias}) RETURN a
MATCH(a:Organization{deltimestamp:$a_deltimestamp,alias:$a_alias}) RETURN a
regsvc
7 <1 ms 2 ms 1 ms flat
MATCH(a:Folder{tildaid:$a_tildaid}) RETURN a
MATCH(a:Folder{tildaid:$a_tildaid}) RETURN a
docsvc
66 <1 ms 2 ms 1 ms flat
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_ESIGN]->(leaf)
write studiosvc
22 <1 ms 2 ms 1 ms flat
MATCH (n:WorkOrderConfig {tildaid: $node_id}) RETURN n
MATCH (n:WorkOrderConfig {tildaid: $node_id}) RETURN n
virtual-assistant
111 <1 ms 2 ms 1 ms flat
MATCH (item:WorkplanInstanceMilestoneItem{workOrderId:$workOrderId})<-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]-(m:WorkPlanMilestone)<-[:WORKPLAN_INSTANCE_TO_MILESTONE]-(wp:WorkPlanInstance) RETURN wp.tildaid as instanceId, item.tildaid a…
MATCH (item:WorkplanInstanceMilestoneItem{workOrderId:$workOrderId})<-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]-(m:WorkPlanMilestone)<-[:WORKPLAN_INSTANCE_TO_MILESTONE]-(wp:WorkPlanInstance) RETURN wp.tildaid as instanceId, item.tildaid as instanceMilestoneItemId
workplansvc
31 <1 ms 2 ms 1 ms flat
MATCH (d:Document {tildaid: $doc_id}) RETURN d.cbrRunStatus AS s
MATCH (d:Document {tildaid: $doc_id}) RETURN d.cbrRunStatus AS s
docproc
48 <1 ms 2 ms 1 ms flat
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
execsvc
8 <1 ms 2 ms 1 ms flat
MATCH (doc:Document{tildaid:$id})-[:DOCUMENT_VERSION]->(dv:DocumentVersion{tildaid:$id1}) WITH doc, dv, CASE WHEN COALESCE(doc.collection, ?) = ? OR doc.collection = ? THEN ? WHEN doc.collection = ? THEN ? ELSE COALESCE(dv.stateTag, ?) END…
MATCH (doc:Document{tildaid:$id})-[:DOCUMENT_VERSION]->(dv:DocumentVersion{tildaid:$id1}) WITH doc, dv, CASE WHEN COALESCE(doc.collection, ?) = ? OR doc.collection = ? THEN ? WHEN doc.collection = ? THEN ? ELSE COALESCE(dv.stateTag, ?) END AS stagingStatus RETURN stagingStatus
docsvc
1,262 <1 ms 2 ms 4 ms 0.6× ↓
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
enrollsvc
85 <1 ms 2 ms 1 ms flat
MATCH (r:Recommendation)-[:RECOMMENDATION_TO_DOCUMENT]->(d:Document {tildaid: $doc_id}) WHERE r.category = $category AND coalesce(r.data, ?) = coalesce($data, ?) AND coalesce(r.data_formatted, ?) = coalesce($data_formatted, ?) AND NOT EXIS…
MATCH (r:Recommendation)-[:RECOMMENDATION_TO_DOCUMENT]->(d:Document {tildaid: $doc_id}) WHERE r.category = $category AND coalesce(r.data, ?) = coalesce($data, ?) AND coalesce(r.data_formatted, ?) = coalesce($data_formatted, ?) AND NOT EXISTS { MATCH (tai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE tai.evaluation_run_id IS NOT NULL } RETURN r LIMIT ?
docproc
18 <1 ms 2 ms 1 ms flat
with datetime($startStr) as start , datetime($endStr) as end match(o:OutOfOffice)-[:RES_TO_OUT_OF_OFFICE]-(:Staff{tildaid:$resId}) where (o.startTime >= start and o.startTime <= end) or (o.endTime >= start and o.endTime <= end) or (o.start…
with datetime($startStr) as start , datetime($endStr) as end match(o:OutOfOffice)-[:RES_TO_OUT_OF_OFFICE]-(:Staff{tildaid:$resId}) where (o.startTime >= start and o.startTime <= end) or (o.endTime >= start and o.endTime <= end) or (o.startTime >= start and o.endTime <= end) return o order by o.startTime
schedsvc
9 <1 ms 2 ms 1 ms flat

p95 drift compares the query's p95 in the recent half of the window to the earlier half — ≥1.2× means it's slowing down. Click a row for its p50/p95 latency trend over time. Latency percentiles come from per-bucket histograms (no individual queries stored).