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
stored2d agotop 80 of 4,826
Neo4j query shapes on automation over the last 5d, grouped by plan hash.
Click a column to sort; p95 drift (late-half ÷ early-half of the window) ranks the queries getting slower.
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
enrollsvc
3
0 ms
<1 ms
0 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)
writeexecsvc
18
0 ms
<1 ms
0 ms
flat
match (j:Job)-[:JOB_TO_JOBSTATE]-(js:JobState) WHERE (js.status=$doneStatus or j.stopped=true) and j.UpdatedAt < $cutoff optional match (j)-[:JOB_TO_EMAIL_NOTIFICATION]-(e:EmailNotification) optional match (j)-[:JOB_TO_EMAIL_NOTIFICATION]-…
match (j:Job)-[:JOB_TO_JOBSTATE]-(js:JobState) WHERE (js.status=$doneStatus or j.stopped=true) and j.UpdatedAt < $cutoff optional match (j)-[:JOB_TO_EMAIL_NOTIFICATION]-(e:EmailNotification) optional match (j)-[:JOB_TO_EMAIL_NOTIFICATION]-(s:SMSNotification) detach delete j,js,e,s
writenotifsvc
6
0 ms
<1 ms
0 ms
flat
match(a:Site{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Site{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Patient{tildaid:$tildaId}) with a, case when a.ufid is null or a.ufid=? then $ufid else a.ufid end as val set a.ufid=val
match(a:Patient{tildaid:$tildaId}) with a, case when a.ufid is null or a.ufid=? then $ufid else a.ufid end as val set a.ufid=val
writepatientsvc
3
0 ms
<1 ms
0 ms
flat
MATCH (a:EhrPhi{tildaid:$a_tildaid}),(b:Phi{tildaid:$b_tildaid}) MERGE (a)-[r:ASSOCIATED_PHI]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
MATCH (a:EhrPhi{tildaid:$a_tildaid}),(b:Phi{tildaid:$b_tildaid}) MERGE (a)-[r:ASSOCIATED_PHI]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
writepatientsvc
3
0 ms
<1 ms
0 ms
flat
match(a:Patient{tildaid:$tildaId}) with a, case when a.status is null or a.status=? then $prospect else a.status end as status set a.status=status
match(a:Patient{tildaid:$tildaId}) with a, case when a.status is null or a.status=? then $prospect else a.status end as status set a.status=status
writepatientsvc
3
0 ms
<1 ms
0 ms
flat
MATCH(a:ParticipantVisit{tildaid:$a_tildaid}) RETURN a
MATCH(a:ParticipantVisit{tildaid:$a_tildaid}) RETURN a
schedsvc
6
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_MILESTONE]->(:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE (item.itemType IN [?, ?] OR (item.itemType = ? AND coalesce(item.branchCaseHead, false) …
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_MILESTONE]->(:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE (item.itemType IN [?, ?] OR (item.itemType = ? AND coalesce(item.branchCaseHead, false) = true)) AND coalesce(item.cfgItemInvalid, false) = false AND item.gatePendingGenId > coalesce(item.gateLastComputedGenId, ?) AND (coalesce(item.gateResolveRequestGenId, ?) <> item.gatePendingGenId OR $nowMs - coalesce(item.gateResolveRequestSentAt, ?) >= ?) AND NOT (coalesce(item.gateUnsupportedGenId, ?) = item.gatePendingGenId AND coalesce(item.gateUnsupportedCount, ?) >= $maxUnsupported) AND coalesce(cfg.state, ?) <> ? OPTIONAL MATCH (item)-[:WORKPLAN_MILESTONE_ITEM_DEPENDENCY]->(dep:WorkPlanMilestoneItemDependency) WHERE coalesce(dep.gatesDownstreamItem, false) = true WITH cfg, item, dep ORDER BY dep.createdat ASC WITH cfg, item, collect(dep)[?] AS firstDep WHERE ((firstDep IS NOT NULL AND coalesce(item.branchGroupId, ?) = ?) OR (coalesce(item.branchCaseHead, false) = true AND coalesce(item.branchCaseDefault, false) = false)) AND coalesce(item.branchCaseAmbiguity, ?) = ? OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_MILESTONE]->(:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(sib:WorkPlanMilestoneItem) WHERE coalesce(item.branchGroupId, ?) <> ? AND sib.branchGroupId = item.branchGroupId AND sib.tildaid <> item.tildaid AND coalesce(sib.branchCaseHead, false) = true AND coalesce(sib.branchCaseDefault, false) = false AND coalesce(sib.cfgItemInvalid, false) = false WITH cfg, item, firstDep, sib ORDER BY sib.branchCaseIndex ASC WITH cfg, item, firstDep, collect(sib.branchCaseSentence) AS siblingSentences OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) RETURN item.tildaid AS cfgMilestoneItemId, cfg.tildaid AS cfgId, CASE WHEN coalesce(item.branchCaseHead, false) = true THEN coalesce(item.branchSourceCfgItemId, ?) ELSE coalesce(firstDep.dependsOnMilestoneItemTildaid, ?) END AS sourceMilestoneItemId, CASE WHEN coalesce(item.branchCaseHead, false) = true AND coalesce(item.branchCaseSentence, ?) <> ? THEN item.branchCaseSentence ELSE coalesce(firstDep.supplyReasoning, ?) END AS supplyReasoning, item.gatePendingGenId AS pendingGenId, coalesce(org.alias, ?) AS orgAlias, coalesce(item.branchCaseSentence, ?) AS caseSentence, siblingSentences, coalesce(item.branchCaseTree, ?) AS caseTree LIMIT $limit
workplansvc
9
0 ms
<1 ms
0 ms
flat
match(a:AdvRateRule) where a.portalorgid=$portalOrgId and a.deleted=false and a.studyid=$fieldId set a.deleted=true, a.deltimestamp=timestamp()
match(a:AdvRateRule) where a.portalorgid=$portalOrgId and a.deleted=false and a.studyid=$fieldId set a.deleted=true, a.deltimestamp=timestamp()
writeadvpsvc
6
0 ms
<1 ms
0 ms
flat
match(a:AdvOrg{orgid:$portalOrgId}) set a.lastschedtimestamp=timestamp()
match(a:AdvOrg{orgid:$portalOrgId}) set a.lastschedtimestamp=timestamp()
writeadvpsvc
6
0 ms
<1 ms
0 ms
flat
MATCH (dv:DocumentVersion {tildaid: $version_id}) SET dv.linearizedPdfStatus = $status, dv.linearizedPdfUrl = $url, dv.pages = $pages, dv.linearizedPdfProcessingStartedAt = CASE WHEN $processing_started_at IS NOT NULL THEN $processing_star…
MATCH (dv:DocumentVersion {tildaid: $version_id}) SET dv.linearizedPdfStatus = $status, dv.linearizedPdfUrl = $url, dv.pages = $pages, dv.linearizedPdfProcessingStartedAt = CASE WHEN $processing_started_at IS NOT NULL THEN $processing_started_at ELSE dv.linearizedPdfProcessingStartedAt END, dv.linearizedPdfProcessingEndedAt = CASE WHEN $processing_ended_at IS NOT NULL THEN $processing_ended_at ELSE dv.linearizedPdfProcessingEndedAt END, dv.linearizedPdfRetryCount = CASE WHEN $status = ? THEN COALESCE(dv.linearizedPdfRetryCount, ?) ELSE dv.linearizedPdfRetryCount END WITH dv OPTIONAL MATCH (dv)<-[:DOCUMENT_VERSION]-(doc:Document) SET doc.linearizedPdfStatus = $status, doc.linearizedPdfUrl = $url, doc.pages = $pages
writedocproc
6
0 ms
<1 ms
0 ms
flat
MATCH(a:Actor{orgId:$a_orgId,userId:$a_userId,scopeId:$a_scopeId,deltimestamp:$a_deltimestamp}) RETURN a
MATCH(a:Actor{orgId:$a_orgId,userId:$a_userId,scopeId:$a_scopeId,deltimestamp:$a_deltimestamp}) RETURN a
enrollsvc
12
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
enrollsvc
3
0 ms
<1 ms
0 ms
flat
MATCH(a:Room{tildaid:$a_tildaid}) RETURN a
MATCH(a:Room{tildaid:$a_tildaid}) RETURN a
schedsvc
3
0 ms
<1 ms
0 ms
flat
MATCH(a:Staff{tildaid:$a_tildaid}) RETURN a
MATCH(a:Staff{tildaid:$a_tildaid}) RETURN a
schedsvc
3
0 ms
<1 ms
0 ms
flat
MATCH(a:EventPlan{tildaid:$a_tildaid}) DETACH DELETE a
MATCH(a:EventPlan{tildaid:$a_tildaid}) DETACH DELETE a
writedocsvc
9
0 ms
<1 ms
0 ms
flat
MATCH (ep:EventPlan {tildaid: $eventPlanId})-[:EVENTS]->(e:Event) RETURN e.tildaid as tildaid
MATCH (ep:EventPlan {tildaid: $eventPlanId})-[:EVENTS]->(e:Event) RETURN e.tildaid as tildaid
docsvc
9
0 ms
<1 ms
0 ms
flat
match(a:Study{tildaid:$studyId}) match(b:Organization{tildaid:$orgId}) merge(a)-[r:STUDY_TO_ORG]->(b) set r.inherited=$inherited
match(a:Study{tildaid:$studyId}) match(b:Organization{tildaid:$orgId}) merge(a)-[r:STUDY_TO_ORG]->(b) set r.inherited=$inherited
writeenrollsvc
3
0 ms
<1 ms
0 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
3
0 ms
<1 ms
0 ms
flat
match(crs:ChartReviewStudy{tildaid:$id}) with crs optional match(crs)-[r:PENDING_PATIENTS]->(:Patient) with count(r) as pend, crs with pend, crs optional match(crs)-[r:APPROVED_PATIENTS]->(:Patient) with count(r) as approved, pend, crs wit…
match(crs:ChartReviewStudy{tildaid:$id}) with crs optional match(crs)-[r:PENDING_PATIENTS]->(:Patient) with count(r) as pend, crs with pend, crs optional match(crs)-[r:APPROVED_PATIENTS]->(:Patient) with count(r) as approved, pend, crs with approved, pend, crs optional match(crs)-[r:REJECTED_PATIENTS]->(:Patient) with count(r) as rejected, approved, pend return pend, approved, rejected
enrollsvc
3
0 ms
<1 ms
0 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
12
0 ms
<1 ms
0 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}
MATCH (:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_FORM]->(obj{tildaid:$objId}) RETURN true LIMIT ?
MATCH (:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_FORM]->(obj{tildaid:$objId}) RETURN true LIMIT ?
studiosvc
48
0 ms
<1 ms
0 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
18
0 ms
<1 ms
0 ms
flat
match(a:Room{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Room{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeonboardingsvc
18
0 ms
<1 ms
0 ms
flat
match (pa:ParticipantActivity{tildaid:$paId})-[:ALL_CHANGELOG]- (clog:ChangeLog) return clog order by clog.createdat desc
match (pa:ParticipantActivity{tildaid:$paId})-[:ALL_CHANGELOG]- (clog:ChangeLog) return clog order by clog.createdat desc
regsvc
12
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
advpsvc
3
0 ms
<1 ms
0 ms
flat
match (c:CarePlan {tildaid: $id})-[:EXECUTE_SOA]- (s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]- (pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study) return st
match (c:CarePlan {tildaid: $id})-[:EXECUTE_SOA]- (s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]- (pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study) return st
schedsvc
18
0 ms
<1 ms
0 ms
flat
MATCH(a:BudgetReport)-[r:BUDGET_REPORT_TO_PARTICIPANT_VISIT]->(b:ParticipantVisit{tildaid:$b_tildaid}) RETURN a limit $limit
MATCH(a:BudgetReport)-[r:BUDGET_REPORT_TO_PARTICIPANT_VISIT]->(b:ParticipantVisit{tildaid:$b_tildaid}) RETURN a limit $limit
finsvc
6
0 ms
<1 ms
0 ms
flat
match (pa:ParticipantActivity{tildaid:$paId})-[:ALL_CHANGELOG]- (clog:ChangeLog) return clog order by clog.createdat desc
match (pa:ParticipantActivity{tildaid:$paId})-[:ALL_CHANGELOG]- (clog:ChangeLog) return clog order by clog.createdat desc
regsvc
3
0 ms
<1 ms
0 ms
flat
match(a:AdvRateRule) where a.portalorgid=$portalOrgId and a.deleted=false and a.studyid=$fieldId set a.deleted=true, a.deltimestamp=timestamp()
match(a:AdvRateRule) where a.portalorgid=$portalOrgId and a.deleted=false and a.studyid=$fieldId set a.deleted=true, a.deltimestamp=timestamp()
writeadvpsvc
6
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
notifsvc
12
0 ms
<1 ms
0 ms
flat
MATCH (p:Policy {name:$name}) SET p.state = $state
MATCH (p:Policy {name:$name}) SET p.state = $state
writeonboardingsvc
53
0 ms
<1 ms
0 ms
flat
MATCH(a:Job{name:$a_name}) RETURN a limit $a_limit
MATCH(a:Job{name:$a_name}) RETURN a limit $a_limit
notifsvc
6
0 ms
<1 ms
0 ms
flat
MATCH (sref:GraphNodeRef)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protocolid:$protocolId}]->(:VisitV2{tildaid:$visitId}), (sref)-[:ANCHORED_TO{protocolid:$protocolId}]->(ar:GraphNodeRef) WITH ar ORDER BY ar.tildaid LIMIT ? OPTIONAL MATCH (:CarePlan…
MATCH (sref:GraphNodeRef)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protocolid:$protocolId}]->(:VisitV2{tildaid:$visitId}), (sref)-[:ANCHORED_TO{protocolid:$protocolId}]->(ar:GraphNodeRef) WITH ar ORDER BY ar.tildaid LIMIT ? OPTIONAL MATCH (:CarePlan{tildaid:$cpId})-[:CAREPLAN_TO_ALL_PARTICIPANTVISITS]->(pv:ParticipantVisit)-[:BELONGS_TO_VISIT]->(v:Visit|VisitV2) WHERE EXISTS { (ar)-[:GRAPH_NODE_REF_TO_GRAPH_NODE]->(v) } RETURN pv, v, [ar.tildaid] as refIds, null as ofl
schedsvc
18
0 ms
<1 ms
0 ms
flat
MATCH(a:Inbox{tildaid:$a_tildaid}) DETACH DELETE a
MATCH(a:Inbox{tildaid:$a_tildaid}) DETACH DELETE a
writetusker
48
0 ms
<1 ms
0 ms
flat
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
writeadvpsvc
18
0 ms
<1 ms
0 ms
flat
MATCH (ai:AIRun {tildaid: $aiRunId}) OPTIONAL MATCH (ai)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d1:Document) OPTIONAL MATCH (ai)-[:AI_RUN_TO_RECOMMENDATION]->(r:Recommendation)-[:RECOMMENDATION_TO_DOCUMENT]->(d2:Document) WITH ai.status AS ai_stat…
MATCH (ai:AIRun {tildaid: $aiRunId}) OPTIONAL MATCH (ai)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d1:Document) OPTIONAL MATCH (ai)-[:AI_RUN_TO_RECOMMENDATION]->(r:Recommendation)-[:RECOMMENDATION_TO_DOCUMENT]->(d2:Document) WITH ai.status AS ai_status, coalesce(d1.tildaid, d2.tildaid) AS doc_id WHERE doc_id IS NOT NULL RETURN ai_status, doc_id LIMIT ?
dashrsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (d:Document {tildaid: $doc_id})-[:DOC_TO_ORG]->(o:Organization) RETURN o.tildaid as org_id
MATCH (d:Document {tildaid: $doc_id})-[:DOC_TO_ORG]->(o:Organization) RETURN o.tildaid as org_id
docproc
7
0 ms
<1 ms
0 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
writedocproc
8
0 ms
<1 ms
0 ms
flat
MATCH(a:Sponsor{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
MATCH(a:Sponsor{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
enrollsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:Role{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
MATCH(a:Role{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
execsvc
10
0 ms
<1 ms
0 ms
flat
MATCH(a:UnknownSender{deltimestamp:$a_deltimestamp,mobilePhone:$a_mobilePhone}) RETURN a
MATCH(a:UnknownSender{deltimestamp:$a_deltimestamp,mobilePhone:$a_mobilePhone}) RETURN a
notifsvc
4
0 ms
<1 ms
0 ms
flat
match(a:Room{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Room{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeonboardingsvc
52
0 ms
<1 ms
0 ms
flat
match(org:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_PATIENT]->(:Patient)-[:HAS_PROTECTED_DATA_IN]->(phi:Phi) where phi.dob=$dOB and (tolower(phi.email)=tolower($email) or phi.mobilephone=$mobilePhone ) return phi
match(org:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_PATIENT]->(:Patient)-[:HAS_PROTECTED_DATA_IN]->(phi:Phi) where phi.dob=$dOB and (tolower(phi.email)=tolower($email) or phi.mobilephone=$mobilePhone ) return phi
patientsvc
4
0 ms
<1 ms
0 ms
flat
MATCH(a:EhrPhi{tildaid:$a_tildaid}) SET a.updatedat=timestamp(),a.phiid=$a_phiid RETURN count(a)
MATCH(a:EhrPhi{tildaid:$a_tildaid}) SET a.updatedat=timestamp(),a.phiid=$a_phiid RETURN count(a)
writepatientsvc
4
0 ms
<1 ms
0 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
writestudiosvc
258
0 ms
<1 ms
0 ms
flat
MATCH (c:TMFSyncConfig) RETURN c {.*} AS c ORDER BY c.created_at DESC SKIP $offset LIMIT $limit
MATCH (c:TMFSyncConfig) RETURN c {.*} AS c ORDER BY c.created_at DESC SKIP $offset LIMIT $limit
tmfsync
1
0 ms
<1 ms
0 ms
flat
MATCH (i:TMFSyncItem {status: ?, direction: ?}) WHERE i.next_retry_at IS NULL AND coalesce(i.item_kind, ?) = $item_kind RETURN count(i) AS n
MATCH (i:TMFSyncItem {status: ?, direction: ?}) WHERE i.next_retry_at IS NULL AND coalesce(i.item_kind, ?) = $item_kind RETURN count(i) AS n
tmfsync
4
0 ms
<1 ms
0 ms
flat
call { match (task:Task{assignment:?}) where (task.state = ? or task.state = ?) and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:?})) and coalesce(task.dist_next_retry_at <= datetime(), coalesce(task.dist_deferred, false) = false) return …
call { match (task:Task{assignment:?}) where (task.state = ? or task.state = ?) and not exists ((task)-[:BELONGS_TO]-(:Inbox{type:?})) and coalesce(task.dist_next_retry_at <= datetime(), coalesce(task.dist_deferred, false) = false) return task } with task where not exists ( (task)-[:CREATED_FROM_SPEC]-(:ParticipantTaskConfig)-[:PARTICIPANT_TASKCONFIG]-(:ParticipantTaskList)-[:PARTICIPANT_TASKLIST]-(:ParticipantControl) ) and not exists ( (task)<-[:CREATED_FROM_SPEC]-(:ParticipantDslSpecNode)<-[:PARTICIPANT_DSLTASK_TO_ALL_PARTICIPANT_DSLSPECNODE]-(:ParticipantDslTask)<-[:PARTICIPANT_DSLTASK]-(:ParticipantControl) ) match (task)-[:WITH_CONTEXT]->() optional match (task)-[:BELONGS_TO]->(userinbox:Inbox{type:?})-[:OWNED_BY]->(user:User) optional match (user)-[:USER_TO_PATIENT]-(patient:Patient) optional match (task)-[:BELONGS_TO]->(:Inbox{type:?})-[:MANAGED_BY]->(org:Organization) optional match (task)-[:BELONGS_TO]->(:Inbox{type:?})-[:MANAGED_BY]->(study:Study) optional match (task)-[:BELONGS_TO]->(:Inbox{type:?})-[:MANAGED_BY]->(site:Site) return distinct task, userinbox, org, study.name, site.name, patient.tildaid skip $skip limit $limit
tusker
1
0 ms
<1 ms
0 ms
flat
match (s:Site {tildaid: $objectId}) return s
match (s:Site {tildaid: $objectId}) return s
tusker
1
0 ms
<1 ms
0 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
4
0 ms
<1 ms
0 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
10
0 ms
<1 ms
0 ms
flat
MATCH (cfgItem:WorkPlanMilestoneItem) WHERE cfgItem.itemType = ? AND coalesce(cfgItem.cfgItemInvalid, false) = false AND cfgItem.checkpointLastComputedGenId > ? MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMiles…
MATCH (cfgItem:WorkPlanMilestoneItem) WHERE cfgItem.itemType = ? AND coalesce(cfgItem.cfgItemInvalid, false) = false AND cfgItem.checkpointLastComputedGenId > ? MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.cfgMilestoneItemId = cfgItem.tildaid AND wp.state <> ? AND coalesce(item.checkpointQueuedAt, ?) > ? AND coalesce(item.checkpointCompletedAt, ?) = ? AND coalesce(item.checkpointRejectedAt, ?) = ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.checkpointGenId, ?) < cfgItem.checkpointLastComputedGenId AND (coalesce(item.checkpointScoreFailedAt, ?) = ? OR $nowMs - item.checkpointScoreFailedAt >= ?) RETURN item.tildaid AS instanceMilestoneItemId, wp.tildaid AS instanceId, cfgItem.tildaid AS cfgMilestoneItemId, cfgItem.checkpointLastComputedGenId AS lastComputedGenId ORDER BY item.checkpointQueuedAt LIMIT $limit
workplansvc
10
0 ms
<1 ms
0 ms
flat
MATCH (d:Document {tildaid: $doc_id}) MATCH (ai:AIRun)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(d) WITH ai, d, r, properties(r) AS old_props DELETE r CREATE (ai)-[old_run:AI_RUN_TO_DOCUMENT_OLD]->(d) SET old_run = old_props SET old_run.converted_at…
MATCH (d:Document {tildaid: $doc_id}) MATCH (ai:AIRun)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(d) WITH ai, d, r, properties(r) AS old_props DELETE r CREATE (ai)-[old_run:AI_RUN_TO_DOCUMENT_OLD]->(d) SET old_run = old_props SET old_run.converted_at = timestamp()
writedocproc
102
0 ms
<1 ms
0 ms
flat
match (obj:VisitV2{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
match (obj:VisitV2{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
execsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_SMS_NOTIFICATION]->(b:SMSNotification) RETURN a, b limit ?
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_SMS_NOTIFICATION]->(b:SMSNotification) RETURN a, b limit ?
notifsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_JOBSTATE]->(b:JobState) RETURN b limit $limit
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_JOBSTATE]->(b:JobState) RETURN b limit $limit
notifsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Phi{tildaid:$a_tildaid}) RETURN a
MATCH(a:Phi{tildaid:$a_tildaid}) RETURN a
notifsvc
4
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
notifsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
notifsvc
8
0 ms
<1 ms
0 ms
flat
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_EMAIL_NOTIFICATION]->(b:EmailNotification) RETURN a, b limit ?
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_EMAIL_NOTIFICATION]->(b:EmailNotification) RETURN a, b limit ?
notifsvc
1
0 ms
<1 ms
0 ms
flat
match (pa:Patient)-[:HAS_PROTECTED_DATA_IN]-(p:Phi) where p.email=$email return pa
match (pa:Patient)-[:HAS_PROTECTED_DATA_IN]-(p:Phi) where p.email=$email return pa
notifsvc
1
0 ms
<1 ms
0 ms
flat
match (c:CarePlan {tildaid: $id})-[:EXECUTE_SOA]- (s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]- (pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study) return st
match (c:CarePlan {tildaid: $id})-[:EXECUTE_SOA]- (s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]- (pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study) return st
schedsvc
5
0 ms
<1 ms
0 ms
flat
optional match (v:Visit{tildaid:$visitId}) optional match (v2:VisitV2{tildaid:$visitId}) return {v:v, v2:v2}
optional match (v:Visit{tildaid:$visitId}) optional match (v2:VisitV2{tildaid:$visitId}) return {v:v, v2:v2}
schedsvc
4
0 ms
<1 ms
0 ms
flat
match(org:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_RESPONSE_SET]->(rs:ResponseSet{state:?}) where (rs.scopeid = ? or rs.scopeid is null) and (tolower(rs.name) contains tolower($searchStr) or any(choice in rs.choices where tolower(ch…
match(org:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_RESPONSE_SET]->(rs:ResponseSet{state:?}) where (rs.scopeid = ? or rs.scopeid is null) and (tolower(rs.name) contains tolower($searchStr) or any(choice in rs.choices where tolower(choice) contains tolower($searchStr))) with distinct rs optional match(rs)<-[r:GRAPH_NODE_REF_TO_GRAPH_NODE]-(:GraphNodeRef) return rs, count(r)
studiosvc
32
0 ms
<1 ms
0 ms
flat
MATCH (cfgItem:WorkPlanMilestoneItem) WHERE cfgItem.itemType = ? AND coalesce(cfgItem.cfgItemInvalid, false) = false AND cfgItem.checkpointLastComputedGenId > ? MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMiles…
MATCH (cfgItem:WorkPlanMilestoneItem) WHERE cfgItem.itemType = ? AND coalesce(cfgItem.cfgItemInvalid, false) = false AND cfgItem.checkpointLastComputedGenId > ? MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.cfgMilestoneItemId = cfgItem.tildaid AND wp.state <> ? AND coalesce(item.checkpointQueuedAt, ?) > ? AND coalesce(item.checkpointCompletedAt, ?) = ? AND coalesce(item.checkpointRejectedAt, ?) = ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.checkpointGenId, ?) < cfgItem.checkpointLastComputedGenId AND (coalesce(item.checkpointScoreFailedAt, ?) = ? OR $nowMs - item.checkpointScoreFailedAt >= ?) RETURN item.tildaid AS instanceMilestoneItemId, wp.tildaid AS instanceId, cfgItem.tildaid AS cfgMilestoneItemId, cfgItem.checkpointLastComputedGenId AS lastComputedGenId ORDER BY item.checkpointQueuedAt LIMIT $limit
workplansvc
1
0 ms
<1 ms
0 ms
flat
MATCH (dv:DocumentVersion {tildaid: $version_id})<-[:DOCUMENT_VERSION]-(doc:Document) SET dv.langDetectionStatus = $status, dv.languages = $languages SET doc.languages = $languages, doc.langDetectionStatus = $status
MATCH (dv:DocumentVersion {tildaid: $version_id})<-[:DOCUMENT_VERSION]-(doc:Document) SET dv.langDetectionStatus = $status, dv.languages = $languages SET doc.languages = $languages, doc.langDetectionStatus = $status
writedocproc
26
0 ms
<1 ms
0 ms
flat
match(a:Study{tildaid:$studyId})-[r:STUDY_TO_ORG]->(b:Organization{tildaid:$orgId}) optional match (a)-[PLAN_DEFINITION_TO_STUDY]-(sitePD:DslPlanDefinition{type:?,delpending:false}) return r.inherited, count(sitePD)
match(a:Study{tildaid:$studyId})-[r:STUDY_TO_ORG]->(b:Organization{tildaid:$orgId}) optional match (a)-[PLAN_DEFINITION_TO_STUDY]-(sitePD:DslPlanDefinition{type:?,delpending:false}) return r.inherited, count(sitePD)
enrollsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
enrollsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (o:Study{tildaid:$scopeId})-[scope:STUDY_TO_ACTOR]->(a:Actor)-[:FOR_USER]->(u:User{tildaid:$userId}) MATCH (a)-[:APPOINTED_AS]->(r:Role) WHERE u.status<>? AND a.state<>? RETURN distinct a
MATCH (o:Study{tildaid:$scopeId})-[scope:STUDY_TO_ACTOR]->(a:Actor)-[:FOR_USER]->(u:User{tildaid:$userId}) MATCH (a)-[:APPOINTED_AS]->(r:Role) WHERE u.status<>? AND a.state<>? RETURN distinct a
enrollsvc
4
0 ms
<1 ms
0 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:ParticipantVisit{tildaid:$a_tildaid}) RETURN a
MATCH(a:ParticipantVisit{tildaid:$a_tildaid}) RETURN a
finsvc
1
0 ms
<1 ms
0 ms
flat
match(a:SiteLocation{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:SiteLocation{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeonboardingsvc
16
0 ms
<1 ms
0 ms
flat
MATCH (s:Site{tildaid:$id}) OPTIONAL MATCH (s)-[:STAFF_TO_ACTOR]-(actor:Actor) OPTIONAL MATCH (s)-[:HAS_LOCATION]->(loc:SiteLocation) OPTIONAL MATCH (s)-[:ALL_CHANGELOG]-(clog:ChangeLog) OPTIONAL MATCH (s)-[:MANAGED_BY]-(in:Inbox) DETACH D…
MATCH (s:Site{tildaid:$id}) OPTIONAL MATCH (s)-[:STAFF_TO_ACTOR]-(actor:Actor) OPTIONAL MATCH (s)-[:HAS_LOCATION]->(loc:SiteLocation) OPTIONAL MATCH (s)-[:ALL_CHANGELOG]-(clog:ChangeLog) OPTIONAL MATCH (s)-[:MANAGED_BY]-(in:Inbox) DETACH DELETE actor,loc,clog,in
writeonboardingsvc
2
0 ms
<1 ms
0 ms
flat
match(a:Site{tildaid:$tildaid}) where apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)=$svcBitId set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, apoc.bitwise.op($svcBitId, ?, ?)) , a.delpending=true, a.deltimestamp=timestamp() with a where a.…
match(a:Site{tildaid:$tildaid}) where apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)=$svcBitId set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, apoc.bitwise.op($svcBitId, ?, ?)) , a.delpending=true, a.deltimestamp=timestamp() with a where a.delpending=true and a.holdbitmap=? detach delete a
writeonboardingsvc
2
0 ms
<1 ms
0 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)
writeonboardingsvc
8
0 ms
<1 ms
0 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).