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
stored31h agotop 80 of 4,657
Neo4j query shapes on automation over the last 7d, grouped by plan hash.
Click a column to sort; p95 drift (late-half ÷ early-half of the window) ranks the queries getting slower.
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 (x:StudyNotificationDigestSend) WHERE x.claimedAt < $cutoff OR NOT EXISTS { MATCH (:StudyNotificationDigest {tildaid: x.digestId}) } WITH x LIMIT $batch DELETE x RETURN count(*) AS deleted
MATCH (x:StudyNotificationDigestSend) WHERE x.claimedAt < $cutoff OR NOT EXISTS { MATCH (:StudyNotificationDigest {tildaid: x.digestId}) } WITH x LIMIT $batch DELETE x RETURN count(*) AS deleted
writevirtual-assistant
3
0 ms
<1 ms
0 ms
flat
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writedocsvc
6
0 ms
<1 ms
0 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pd, site, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, User: u, AssignedUser: auCollected, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, CreatedBy: createdBy}
tusker
6
0 ms
<1 ms
0 ms
flat
MATCH (w:WorkOrder)-[:WORK_ORDER_TO_DOCUMENT]->(d:Document {tildaid: $doc_id}) WHERE w.delpending = false RETURN w ORDER BY coalesce(w.updatedat, w.createdat) DESC LIMIT ?
MATCH (w:WorkOrder)-[:WORK_ORDER_TO_DOCUMENT]->(d:Document {tildaid: $doc_id}) WHERE w.delpending = false RETURN w ORDER BY coalesce(w.updatedat, w.createdat) DESC LIMIT ?
virtual-assistant
6
0 ms
<1 ms
0 ms
flat
MATCH (o:Organization {tildaid: $orgId}) SET o._LOCK_ = true REMOVE o._LOCK_ WITH o WHERE o.jobRunId = $run AND NOT coalesce(o.deletionProgress, ?) IN [?, ?, ?] SET o.deletionProgress = $step, o.deletionMarkedCount = $total
MATCH (o:Organization {tildaid: $orgId}) SET o._LOCK_ = true REMOVE o._LOCK_ WITH o WHERE o.jobRunId = $run AND NOT coalesce(o.deletionProgress, ?) IN [?, ?, ?] SET o.deletionProgress = $step, o.deletionMarkedCount = $total
writeonboardingsvc
12
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(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 (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: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 (b:Budget) WHERE b.status = ? AND date(b.effectiveDate) <= date() RETURN b.tildaid
MATCH (b:Budget) WHERE b.status = ? AND date(b.effectiveDate) <= date() RETURN b.tildaid
finsvc
6
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 (c:WorkOrderConfig) WHERE c.child_creation_pending = true AND c.delpending = false AND c.updatedat < $updated_before WITH c ORDER BY c.tildaid SET c.recovery_claim_token = CASE WHEN c.updatedat < $updated_before THEN $token ELSE c.re…
MATCH (c:WorkOrderConfig) WHERE c.child_creation_pending = true AND c.delpending = false AND c.updatedat < $updated_before WITH c ORDER BY c.tildaid SET c.recovery_claim_token = CASE WHEN c.updatedat < $updated_before THEN $token ELSE c.recovery_claim_token END WITH c WHERE c.recovery_claim_token = $token SET c.updatedat = $now RETURN c
writevirtual-assistant
2
0 ms
<1 ms
0 ms
flat
MATCH (c:CtmsSyncConfig {enabled: true}) WITH c OPTIONAL MATCH (s:TMFSyncConfig {id: c.source_veeva_config_id, org_alias: c.org_alias}) RETURN c {.*, source_paused_reason: s.sync_paused_reason} AS c ORDER BY c.created_at ASC
MATCH (c:CtmsSyncConfig {enabled: true}) WITH c OPTIONAL MATCH (s:TMFSyncConfig {id: c.source_veeva_config_id, org_alias: c.org_alias}) RETURN c {.*, source_paused_reason: s.sync_paused_reason} AS c ORDER BY c.created_at ASC
tmfsync
4
0 ms
<1 ms
0 ms
flat
MATCH (wp:WorkPlanInstance {hasActivationFailedItem: true})<-[:WORKPLAN_CFG_TO_INSTANCE]-(cfg:WorkplanCfg) WHERE true OPTIONAL MATCH (wp)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(…
MATCH (wp:WorkPlanInstance {hasActivationFailedItem: true})<-[:WORKPLAN_CFG_TO_INSTANCE]-(cfg:WorkplanCfg) WHERE true OPTIONAL MATCH (wp)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(failed:WorkplanInstanceMilestoneItem) WHERE coalesce(failed.workOrderActivationFailedAt, ?) > ? WITH wp, count(failed) AS failedCount WHERE failedCount = ? SET wp.hasActivationFailedItem = false RETURN count(wp) AS cleared
writeworkplansvc
2
0 ms
<1 ms
0 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
2
0 ms
<1 ms
0 ms
flat
MATCH(a:User{tildaid:$a_tildaid})-[r:ACTIVE_SIGNATURE]->(b:ESignature) RETURN b limit $limit
MATCH(a:User{tildaid:$a_tildaid})-[r:ACTIVE_SIGNATURE]->(b:ESignature) RETURN b limit $limit
onboardingsvc
1
0 ms
<1 ms
0 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pd, site, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, User: u, AssignedUser: auCollected, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, CreatedBy: createdBy}
tusker
1
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = fa…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false RETURN coalesce(item.itemId, item.tildaid) AS itemId, coalesce(item.itemConfig, ?) AS itemConfig
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE ite…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.expectedAttachmentUnresolvedAt, ?) > ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.workOrderCompletedAt, ?) = ? AND coalesce(item.workOrderId, ?) = ? RETURN DISTINCT inst.tildaid AS instanceId
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE ite…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.workOrderActivationFailedAt, ?) > ? AND coalesce(item.workOrderActivationErrorCode, ?) = $code AND coalesce(item.workOrderCompletedAt, ?) = ? AND coalesce(item.workOrderResolvedAt, ?) = ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.workOrderId, ?) <> ? RETURN inst.tildaid AS instanceId, coalesce(item.itemConfig, ?) AS itemConfig
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.agentConfigErrorAt, ?) AS at, coalesce(cfg.agentConfigErrorMessage, ?) AS message, coalesce(cfg.agentConfigAuthorMessage, ?) AS authorMessage
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.agentConfigErrorAt, ?) AS at, coalesce(cfg.agentConfigErrorMessage, ?) AS message, coalesce(cfg.agentConfigAuthorMessage, ?) AS authorMessage
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = fa…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false AND coalesce(item.edlProvisionFailedAt, ?) > ? RETURN count(item) AS n
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE coalesce(item.cfgItemInvalid, false) = false AND coalesce(item.branchCas…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE coalesce(item.cfgItemInvalid, false) = false AND coalesce(item.branchCaseAmbiguity, ?) <> ? RETURN DISTINCT item.branchCaseAmbiguity AS message
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = fa…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false RETURN sum(CASE WHEN coalesce(item.workOrderConfigFailedAt, ?) > ? THEN ? ELSE ? END) AS failed, sum(CASE WHEN coalesce(item.workOrderConfigWarningAt, ?) > ? THEN ? ELSE ? END) AS warned
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (obj:WorkplanCfg{tildaid:$objId})<-[:WORKPLAN_JOB_TO_OBJ]-(job:WorkplanJob) RETURN job ORDER BY job.createdat DESC LIMIT ?
MATCH (obj:WorkplanCfg{tildaid:$objId})<-[:WORKPLAN_JOB_TO_OBJ]-(job:WorkplanJob) RETURN job ORDER BY job.createdat DESC LIMIT ?
workplansvc
50
0 ms
<1 ms
0 ms
flat
MATCH (pobj:ParticipantQuestionnaire{nodeId:$pobjId})-[:PARTICIPANT_VARIABLE]-(pv:ParticipantVariable)-[:BELONGS_TO_VARIABLE]->(v:VariableV2) return {v:v, pv:pv}
MATCH (pobj:ParticipantQuestionnaire{nodeId:$pobjId})-[:PARTICIPANT_VARIABLE]-(pv:ParticipantVariable)-[:BELONGS_TO_VARIABLE]->(v:VariableV2) return {v:v, pv:pv}
execsvc
4
0 ms
<1 ms
0 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pd, site, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, User: u, AssignedUser: auCollected, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, CreatedBy: createdBy}
tusker
1
0 ms
<1 ms
0 ms
flat
MATCH (ctx:WorkPlanContext{tildaid:$tildaid}) SET ctx.delpending = true, ctx.deltimestamp = timestamp() RETURN ctx.tildaid AS id
MATCH (ctx:WorkPlanContext{tildaid:$tildaid}) SET ctx.delpending = true, ctx.deltimestamp = timestamp() RETURN ctx.tildaid AS id
writeworkplansvc
1
0 ms
<1 ms
0 ms
flat
MATCH (ctx:WorkPlanContext{tildaid:$contextId}) SET ctx.checkpointGenId = $genId RETURN ctx.tildaid AS id
MATCH (ctx:WorkPlanContext{tildaid:$contextId}) SET ctx.checkpointGenId = $genId RETURN ctx.tildaid AS id
writeworkplansvc
1
0 ms
<1 ms
0 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(proto:FormV2{t…
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(proto:FormV2{tildaid:$protocolId}) merge(proto)-[:PROTOCOL_TO_QUESTION]->(q)
writestudiosvc
5
0 ms
<1 ms
0 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(proto:FormV2{tildaid:$protocolId}) mer…
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(proto:FormV2{tildaid:$protocolId}) merge(proto)-[:PROTOCOL_TO_RESPONSE_SET]->(rs)
writestudiosvc
5
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) OPTIONAL MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg) OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_STUDY]->(study:Study) RETURN coalesce(org.alias, ?), coalesce(org.name, ?), coalesce(st…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) OPTIONAL MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg) OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_STUDY]->(study:Study) RETURN coalesce(org.alias, ?), coalesce(org.name, ?), coalesce(study.tildaid, cfg.studyId, ?), coalesce(study.name, ?), cfg.tildaid, coalesce(cfg.name, ?)
workplansvc
1
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.variableDeclarations, ?)
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.variableDeclarations, ?)
workplansvc
1
0 ms
<1 ms
0 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
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Site{tildaid:$a_tildaid}) RETURN a
MATCH(a:Site{tildaid:$a_tildaid}) RETURN a
docsvc
4
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 (o:Organization {alias: $value}) WHERE o.delpending = true AND o.status = $deleted AND coalesce(o.deletionProgress, ?) <> $purged RETURN count(o)
MATCH (o:Organization {alias: $value}) WHERE o.delpending = true AND o.status = $deleted AND coalesce(o.deletionProgress, ?) <> $purged RETURN count(o)
onboardingsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{deltimestamp:$a_deltimestamp,alias:$a_alias}) RETURN a
MATCH(a:Organization{deltimestamp:$a_deltimestamp,alias:$a_alias}) RETURN a
onboardingsvc
1
0 ms
<1 ms
0 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
1
0 ms
<1 ms
0 ms
flat
match (pv:ParticipantVisit)-[:BELONGS_TO_PARTICIPANT_VISIT]-(v:VisitAppointment)-[:VISIT_APPOINTMENT_TO_CARE_PLAN]-(c:CarePlan)-[:RESEARCH_SUBJECT] -(p:Patient)-[:HAS_PROTECTED_DATA_IN]-(phi:Phi) where c.status IN [?,?] and v.startTime >= …
match (pv:ParticipantVisit)-[:BELONGS_TO_PARTICIPANT_VISIT]-(v:VisitAppointment)-[:VISIT_APPOINTMENT_TO_CARE_PLAN]-(c:CarePlan)-[:RESEARCH_SUBJECT] -(p:Patient)-[:HAS_PROTECTED_DATA_IN]-(phi:Phi) where c.status IN [?,?] and v.startTime >= datetime({epochMillis:$day1Start}) and v.startTime <= datetime({epochMillis:$day1End}) and coalesce(v.reminderStatus, ?) = ? match (c)-[:EXECUTE_SOA]-(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION] -(pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_SITE]-(si:Site)-[:SITE_TO_SMO]->(smo:Smo)-[:IS_AN_ORG]->(o:Organization) return v,phi,si,p,o
schedsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid})-[r:USES]->(b:FolderManager{name:$b_name,scopeId:$b_scopeId}) RETURN b limit $limit
MATCH(a:Organization{tildaid:$a_tildaid})-[r:USES]->(b:FolderManager{name:$b_name,scopeId:$b_scopeId}) RETURN b limit $limit
docsvc
5
0 ms
<1 ms
0 ms
flat
match(q:QuestionV2{tildaid:$objId}) match(form:FormV2{tildaid:$graphId})-[r:GRAPH_NEXT*?..{graphid:$graphId}]->(ref:GraphNode) where r[-?].path[?]=$graphId and ref.objtype=? with ref, q match(ref)-[r:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE…
match(q:QuestionV2{tildaid:$objId}) match(form:FormV2{tildaid:$graphId})-[r:GRAPH_NEXT*?..{graphid:$graphId}]->(ref:GraphNode) where r[-?].path[?]=$graphId and ref.objtype=? with ref, q match(ref)-[r:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE_REF_TO_QUESTION{graphid:$graphId}]->(q2:QuestionV2) where q2.variablename=q.variablename return ref
studiosvc
4
0 ms
<1 ms
0 ms
flat
match(form:FormV2{tildaid:$graphId}) where ? in labels(form) or ? in labels(form) or ? in labels(form) match(ref:GraphNodeRef{tildaid:$refId}) merge(form)-[:CONTAINS_LEAF]->(ref)
match(form:FormV2{tildaid:$graphId}) where ? in labels(form) or ? in labels(form) or ? in labels(form) match(ref:GraphNodeRef{tildaid:$refId}) merge(form)-[:CONTAINS_LEAF]->(ref)
writestudiosvc
4
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
10
0 ms
<1 ms
0 ms
flat
match(a:StudyCountryActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:StudyCountryActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeexecsvc
20
0 ms
<1 ms
0 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
54
0 ms
<1 ms
0 ms
flat
MATCH(a:Document{tildaid:$a_tildaid})-[r:HAS]->(b:DocumentAnnotation) RETURN b limit $limit
MATCH(a:Document{tildaid:$a_tildaid})-[r:HAS]->(b:DocumentAnnotation) RETURN b limit $limit
docsvc
2
0 ms
<1 ms
0 ms
flat
match (obj0:Document{tildaid:$hdmParentId})-[:BELONGS_TO]-(obj1:ParticipantDocOverlay)-[:PARTICIPANT_DOC_OVERLAY]-(obj2:ParticipantDocumentSet)-[:PARTICIPANT_DOCUMENTSET]-(obj3:ParticipantActivity)-[:BELONGS_TO_ACTIVITY]-(obj4:ActivityV2) …
match (obj0:Document{tildaid:$hdmParentId})-[:BELONGS_TO]-(obj1:ParticipantDocOverlay)-[:PARTICIPANT_DOC_OVERLAY]-(obj2:ParticipantDocumentSet)-[:PARTICIPANT_DOCUMENTSET]-(obj3:ParticipantActivity)-[:BELONGS_TO_ACTIVITY]-(obj4:ActivityV2) return obj4 order by obj4.createdat
docsvc
4
0 ms
<1 ms
0 ms
flat
MATCH (pObj:ParticipantQuestionnaire{tildaid:$pObjId}) SET pObj.status = $status, pObj.updatedat = timestamp()
MATCH (pObj:ParticipantQuestionnaire{tildaid:$pObjId}) SET pObj.status = $status, pObj.updatedat = timestamp()
writeexecsvc
5
0 ms
<1 ms
0 ms
flat
MATCH(a:User{tildaid:$a_tildaid})-[r:INTERNAL_DATA]->(b:UserInternal) RETURN b limit $limit
MATCH(a:User{tildaid:$a_tildaid})-[r:INTERNAL_DATA]->(b:UserInternal) RETURN b limit $limit
onboardingsvc
1
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
4
0 ms
<1 ms
0 ms
flat
match(a:User{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:User{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeonboardingsvc
2
0 ms
<1 ms
0 ms
flat
MATCH (o:Organization {tildaid: $orgId}) SET o._LOCK_ = true REMOVE o._LOCK_ WITH o WHERE o.jobRunId = $run AND NOT coalesce(o.deletionProgress, ?) IN [?, ?, ?] SET o.deletionProgress = $step, o.deletionMarkedCount = $total
MATCH (o:Organization {tildaid: $orgId}) SET o._LOCK_ = true REMOVE o._LOCK_ WITH o WHERE o.jobRunId = $run AND NOT coalesce(o.deletionProgress, ?) IN [?, ?, ?] SET o.deletionProgress = $step, o.deletionMarkedCount = $total
writeonboardingsvc
2
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(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(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeonboardingsvc
58
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
32
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 ?
schedsvc
27
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
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).