Xray
daily rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 5 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 19:16:50.
› →|
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 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.

Columns
Views
Export CSV
Query shape Count Avg p95 ▴ Max p95 drift
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)
write execsvc
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
write notifsvc
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)
write onboardingsvc
18 0 ms <1 ms 0 ms flat
CREATE (a:Room{deltimestamp:$a_deltimestamp,siteId:$a_siteId,name:$a_name}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=?,a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.status=$…
CREATE (a:Room{deltimestamp:$a_deltimestamp,siteId:$a_siteId,name:$a_name}) SET a.createdat = timestamp(), a.updatedat = timestamp(), a.tildaid = randomUUID(), a.holdbitmap=?,a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.status=$a_status,a.type=$a_type,a.description=$a_description,a.capabilities=$a_capabilities RETURN a.tildaid, a.createdat
write onboardingsvc
3 0 ms <1 ms 0 ms flat
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
write patientsvc
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)
write patientsvc
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
write patientsvc
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()
write advpsvc
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()
write advpsvc
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
write docproc
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
write docsvc
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
write enrollsvc
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}
tusker
3 0 ms <1 ms 0 ms flat
match(graphNode:GraphNode{tildaid:$graphId}) match(page:GraphPage{tildaid:$pageId}) create(graphNode)-[:GRAPH_NODE_TO_PAGE{graphid:$graphId, path:[$graphId]}]->(page)
match(graphNode:GraphNode{tildaid:$graphId}) match(page:GraphPage{tildaid:$pageId}) create(graphNode)-[:GRAPH_NODE_TO_PAGE{graphid:$graphId, path:[$graphId]}]->(page)
write studiosvc
6 0 ms <1 ms 0 ms flat
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)
write onboardingsvc
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()
write advpsvc
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
write onboardingsvc
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
write tusker
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)
write advpsvc
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
write docproc
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)
write onboardingsvc
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)
write patientsvc
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
write studiosvc
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()
write docproc
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
write docproc
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)
write onboardingsvc
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
write onboardingsvc
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
write onboardingsvc
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)
write onboardingsvc
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).