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 3,166
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 (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: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
WITH $`rel2` as `rel2` , $`node` as `node` , $`tildaid` as `tildaid` OPTIONAL MATCH (existing:Inbox{tildaid: $tildaid}) RETURN existing
WITH $`rel2` as `rel2` , $`node` as `node` , $`tildaid` as `tildaid` OPTIONAL MATCH (existing:Inbox{tildaid: $tildaid}) RETURN existing
regsvc
429
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 (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
MATCH (i:TMFSyncItem {status: ?, direction: ?}) WHERE coalesce(i.retry_count, ?) <= $max_retries AND i.next_retry_at IS NOT NULL AND i.next_retry_at <= $now_ms OPTIONAL MATCH (j:TMFSyncJob {id: i.sync_job_id}) RETURN i.idempotency_key AS i…
MATCH (i:TMFSyncItem {status: ?, direction: ?}) WHERE coalesce(i.retry_count, ?) <= $max_retries AND i.next_retry_at IS NOT NULL AND i.next_retry_at <= $now_ms OPTIONAL MATCH (j:TMFSyncJob {id: i.sync_job_id}) RETURN i.idempotency_key AS idempotency_key, i.sync_job_id AS sync_job_id, i.tilda_doc_id AS tilda_doc_id, coalesce(i.retry_count, ?) AS retry_count, j.status AS job_status LIMIT $limit
tmfsync
2
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
1
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONA…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) OPTIONAL MATCH (reviewer:User {tildaid: wp.checkpointRejectCascadeReviewerId}) RETURN wp.tildaid AS instanceId, coalesce(wp.checkpointRejectCascadeGateItemId, ?) AS gateItemId, coalesce(wp.checkpointRejectCascadeReviewerId, ?) AS reviewerId, coalesce(reviewer.name, ?) AS reviewerName, coalesce(reviewer.email, ?) AS reviewerEmail, coalesce(wp.checkpointRejectCascadeNotes, ?) AS notes, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
5
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
2
0 ms
<1 ms
0 ms
flat
MATCH (task:Task) WHERE task.task_number = ? AND EXISTS { (task)-[:BELONGS_TO]->(:Inbox{type:?})-[:MANAGED_BY]->(:Organization) } RETURN task.tildaid LIMIT ?
MATCH (task:Task) WHERE task.task_number = ? AND EXISTS { (task)-[:BELONGS_TO]->(:Inbox{type:?})-[:MANAGED_BY]->(:Organization) } RETURN task.tildaid LIMIT ?
tusker
5
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(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(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)
writetusker
56
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)
writeenrollsvc
16
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)
writeenrollsvc
296
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
102
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
14
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
13
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
schedsvc
13
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
7
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
2
0 ms
<1 ms
0 ms
flat
MATCH(a:AdvRateRuleSet{portalorgid:$a_portalorgid}) RETURN a limit $a_limit
MATCH(a:AdvRateRuleSet{portalorgid:$a_portalorgid}) RETURN a limit $a_limit
advpsvc
11
0 ms
<1 ms
0 ms
flat
match(smoOrg:Organization{alias:$orgAlias, orgType:?}) with smoOrg match(study:Study{tildaid:$studyId}) with smoOrg, study return smoOrg.tildaid, study.srcorgid
match(smoOrg:Organization{alias:$orgAlias, orgType:?}) with smoOrg match(study:Study{tildaid:$studyId}) with smoOrg, study return smoOrg.tildaid, study.srcorgid
advpsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:BudgetReport{deltimestamp:$a_deltimestamp,reportId:$a_reportId}) RETURN a
MATCH(a:BudgetReport{deltimestamp:$a_deltimestamp,reportId:$a_reportId}) RETURN a
finsvc
5
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
writepatientsvc
23
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
23
0 ms
<1 ms
0 ms
flat
match(a:Study{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Study{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeregsvc
7
0 ms
<1 ms
0 ms
flat
MATCH(a:User{email:$a_email}) RETURN a limit $a_limit
MATCH(a:User{email:$a_email}) RETURN a limit $a_limit
schedsvc
32
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
finsvc
4
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
MATCH(a:AdvOrg{deltimestamp:$a_deltimestamp,orgid:$a_orgid}) RETURN a
MATCH(a:AdvOrg{deltimestamp:$a_deltimestamp,orgid:$a_orgid}) RETURN a
advpsvc
2
0 ms
<1 ms
0 ms
flat
MATCH (d:Document {tildaid: $doc_id}) SET d.cbrRunStatus = $status, d.cbrRunStatusAt = $ts
MATCH (d:Document {tildaid: $doc_id}) SET d.cbrRunStatus = $status, d.cbrRunStatusAt = $ts
writedocproc
25
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
25
0 ms
<1 ms
0 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pv)-[:BELONGS_TO_VISIT]->(v) where v:Visit or v:VisitV2 optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)- [:OWNED_BY]->(au:User) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pv, site, v, p, phi, cu as createdBy, pd.siteNumber as siteNumber, cp return {Task: t, Study: st, Phi: phi, Visit: v, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, User: u, AssignedUser: auCollected, Patient: p, CreatedBy: createdBy, CarePlan: cp}
tusker
60
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
29
0 ms
<1 ms
0 ms
flat
MATCH (o:Organization {alias: $alias}) RETURN o.tildaid AS tildaid, o.alias AS alias, o.name AS name LIMIT ?
MATCH (o:Organization {alias: $alias}) RETURN o.tildaid AS tildaid, o.alias AS alias, o.name AS name LIMIT ?
feedsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH (a:Patient{deltimestamp:$a_deltimestamp,phiid:$a_phiid}),(b:MedicalDocument{phiid:$b_phiid}) MERGE (a)-[r:INFO_STORED_IN]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() R…
MATCH (a:Patient{deltimestamp:$a_deltimestamp,phiid:$a_phiid}),(b:MedicalDocument{phiid:$b_phiid}) MERGE (a)-[r:INFO_STORED_IN]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
writepatientsvc
4
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
42
0 ms
<1 ms
0 ms
flat
MATCH(a:AdvRateRuleSet{portalorgid:$a_portalorgid}) RETURN a limit $a_limit
MATCH(a:AdvRateRuleSet{portalorgid:$a_portalorgid}) RETURN a limit $a_limit
advpsvc
10
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
25
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.waitingOn = $waitingOn AND wp.state <> ? RETURN wp.tildaid
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.waitingOn = $waitingOn AND wp.state <> ? RETURN wp.tildaid
workplansvc
35
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).