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
stored27h agotop 80 of 1,004
Neo4j query shapes on test26 over the last 48h, grouped by plan hash.
Click a column to sort; p95 drift (late-half ÷ early-half of the window) ranks the queries getting slower.
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
3
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
3
0 ms
<1 ms
0 ms
flat
MATCH(a:FolderManager{tildaid:$a_tildaid})-[r:HAS]->(b:FolderManagerInstructions) RETURN b limit $limit
MATCH(a:FolderManager{tildaid:$a_tildaid})-[r:HAS]->(b:FolderManagerInstructions) RETURN b limit $limit
docsvc
3
0 ms
<1 ms
0 ms
flat
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
execsvc
6
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
5
0 ms
<1 ms
0 ms
flat
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
workplansvc
2
0 ms
<1 ms
0 ms
flat
MATCH (o:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_CONTACT_AREA]->(ca:ContactArea{tildaid:$categoryId, delpending:false}) RETURN coalesce(ca.seedKey, ?) AS seedKey
MATCH (o:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_CONTACT_AREA]->(ca:ContactArea{tildaid:$categoryId, delpending:false}) RETURN coalesce(ca.seedKey, ?) AS seedKey
workplansvc
2
0 ms
<1 ms
0 ms
flat
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) RETURN org.tildaid AS orgId
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) RETURN org.tildaid AS orgId
workplansvc
2
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN cfg.recipientOverrideList
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN cfg.recipientOverrideList
workplansvc
2
0 ms
<1 ms
0 ms
flat
MATCH (item:WorkplanInstanceMilestoneItem) WHERE item.cfgMilestoneItemId = $cfgMilestoneItemId AND item.scopeId IN $scopeIds RETURN item.scopeId AS scopeId, item.tildaid AS id
MATCH (item:WorkplanInstanceMilestoneItem) WHERE item.cfgMilestoneItemId = $cfgMilestoneItemId AND item.scopeId IN $scopeIds RETURN item.scopeId AS scopeId, item.tildaid AS id
workplansvc
2
0 ms
<1 ms
0 ms
flat
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) RETURN org.tildaid AS orgId
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) RETURN org.tildaid AS orgId
workplansvc
4
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN cfg.recipientOverrideList
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN cfg.recipientOverrideList
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
enrollsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
2
0 ms
<1 ms
0 ms
flat
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
execsvc
17
0 ms
<1 ms
0 ms
flat
MATCH(a:Job{tildaid:$a_tildaid}) RETURN a
MATCH(a:Job{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
2
0 ms
<1 ms
0 ms
flat
MATCH(a:Phi{tildaid:$a_tildaid}) RETURN a
MATCH(a:Phi{tildaid:$a_tildaid}) RETURN a
notifsvc
2
0 ms
<1 ms
0 ms
flat
MATCH (pd:DslPlanDefinition{tildaid: $id}) MATCH (pd)-[:PLAN_DEFINITION_TO_WORKFLOW]->(workflow:WorkflowV2) OPTIONAL MATCH (workflow)-[:ALL_CHANGELOG]->(cl:ChangeLog) WITH workflow, pd, cl ORDER BY cl.createdat ASC WITH workflow, pd, head(…
MATCH (pd:DslPlanDefinition{tildaid: $id}) MATCH (pd)-[:PLAN_DEFINITION_TO_WORKFLOW]->(workflow:WorkflowV2) OPTIONAL MATCH (workflow)-[:ALL_CHANGELOG]->(cl:ChangeLog) WITH workflow, pd, cl ORDER BY cl.createdat ASC WITH workflow, pd, head(collect(cl)) as cl OPTIONAL MATCH (u:User{tildaid:cl.who}) WITH workflow, pd, CASE WHEN u IS NOT NULL THEN u.name ELSE workflow.createdBy END as user OPTIONAL MATCH (workflow)-[r:PLAN_DEFINITION_TO_ADOPTED_WORKFLOWS|PLAN_DEFINITION_TO_PUBLISHED_WORKFLOWS]- (sitePD:DslPlanDefinition)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study{tildaid:pd.studyId}) OPTIONAL MATCH (sitePD)-[:PLAN_DEFINITION_TO_SITE]-(site:Site) RETURN DISTINCT workflow, user, collect({site:site, r:type(r)})
regsvc
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
regsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:CarePlan{tildaid:$a_tildaid}) RETURN a
MATCH(a:CarePlan{tildaid:$a_tildaid}) RETURN a
schedsvc
4
0 ms
<1 ms
0 ms
flat
MATCH(a:EmailTemplate{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
MATCH(a:EmailTemplate{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
notifsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Job{tildaid:$a_tildaid}) RETURN a
MATCH(a:Job{tildaid:$a_tildaid}) RETURN a
notifsvc
2
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(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:VisitAppointment)-[r:BELONGS_TO_PARTICIPANT_VISIT]->(b:ParticipantVisit{tildaid:$b_tildaid}) RETURN a ORDER BY a.createdat DESC limit $limit
MATCH(a:VisitAppointment)-[r:BELONGS_TO_PARTICIPANT_VISIT]->(b:ParticipantVisit{tildaid:$b_tildaid}) RETURN a ORDER BY a.createdat DESC limit $limit
schedsvc
4
0 ms
<1 ms
0 ms
flat
MATCH(a:CarePlan{tildaid:$a_tildaid}) RETURN a
MATCH(a:CarePlan{tildaid:$a_tildaid}) RETURN a
schedsvc
2
0 ms
<1 ms
0 ms
flat
MATCH (s:Staff{tildaid:$staffId})-[:IS_USER]-(u:User) RETURN u
MATCH (s:Staff{tildaid:$staffId})-[:IS_USER]-(u:User) RETURN u
schedsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Staff)-[r:IS_USER]->(b:User{email:$b_email}) RETURN a limit $limit
MATCH(a:Staff)-[r:IS_USER]->(b:User{email:$b_email}) RETURN a limit $limit
schedsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
studiosvc
17
<1 ms
1 ms
1 ms
flat
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
workplansvc
789
<1 ms
1 ms
23 ms
1.3× ↑
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
enrollsvc
12
<1 ms
1 ms
1 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONA…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) OPTIONAL MATCH (reviewer:User {tildaid: wp.checkpointRejectCascadeReviewerId}) RETURN wp.tildaid AS instanceId, coalesce(wp.checkpointRejectCascadeGateItemId, ?) AS gateItemId, coalesce(wp.checkpointRejectCascadeReviewerId, ?) AS reviewerId, coalesce(reviewer.name, ?) AS reviewerName, coalesce(reviewer.email, ?) AS reviewerEmail, coalesce(wp.checkpointRejectCascadeNotes, ?) AS notes, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
791
<1 ms
1 ms
2 ms
flat
MATCH (:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_PATIENT]->(p:Patient) WHERE p.tildaid IN $ids RETURN collect(DISTINCT p.tildaid) AS found
MATCH (:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_PATIENT]->(p:Patient) WHERE p.tildaid IN $ids RETURN collect(DISTINCT p.tildaid) AS found
docsvc
9
<1 ms
2 ms
1 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
9
<1 ms
2 ms
1 ms
flat
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
MATCH (proto:FormV2 {tildaid: $protoId})-[pd:PROTOCOL_TO_DIRECT_LEAF]->(leaf:GraphNode) WHERE leaf.tildaid IN $targetIds AND leaf.objtype IN $leafObjTypes RETURN leaf.tildaid AS tid, pd.path AS path
studiosvc
16
<1 ms
2 ms
1 ms
flat
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
execsvc
29
<1 ms
2 ms
1 ms
flat
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
execsvc
7
<1 ms
2 ms
1 ms
flat
unwind $refIds as rid match(sref:GraphNodeRef{tildaid:rid})-[:ANCHORED_TO{protocolid:$protocolId}]->(ar:GraphNodeRef) return rid, min(ar.tildaid)
unwind $refIds as rid match(sref:GraphNodeRef{tildaid:rid})-[:ANCHORED_TO{protocolid:$protocolId}]->(ar:GraphNodeRef) return rid, min(ar.tildaid)
studiosvc
7
<1 ms
2 ms
1 ms
flat
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
onboardingsvc
32
<1 ms
2 ms
1 ms
flat
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
enrollsvc
6
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid})-[r:HAS_STUDY_CRITERION]->(b) RETURN b limit $limit
MATCH(a:Study{tildaid:$a_tildaid})-[r:HAS_STUDY_CRITERION]->(b) RETURN b limit $limit
enrollsvc
12
<1 ms
2 ms
1 ms
flat
MATCH(a:Staff{tildaid:$a_tildaid}) RETURN a
MATCH(a:Staff{tildaid:$a_tildaid}) RETURN a
schedsvc
6
<1 ms
2 ms
1 ms
flat
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
workplansvc
818
<1 ms
2 ms
10 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
5
<1 ms
2 ms
1 ms
flat
MATCH(a:Patient{tildaid:$a_tildaid}) RETURN a
MATCH(a:Patient{tildaid:$a_tildaid}) RETURN a
notifsvc
5
<1 ms
2 ms
1 ms
flat
MATCH (o:Organization {tildaid: $org_id}) WHERE o.alias <> ? RETURN o.alias as alias, coalesce(o.aiTeammateName, ?) as aiTeammateName, coalesce(o.aiTeammateEmail, ?) as aiTeammateEmail
MATCH (o:Organization {tildaid: $org_id}) WHERE o.alias <> ? RETURN o.alias as alias, coalesce(o.aiTeammateName, ?) as aiTeammateName, coalesce(o.aiTeammateEmail, ?) as aiTeammateEmail
virtual-assistant
72
<1 ms
2 ms
1 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
18
<1 ms
2 ms
1 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
12
<1 ms
2 ms
1 ms
flat
MATCH (o:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_CONTACT_AREA]->(ca:ContactArea{tildaid:$categoryId, delpending:false}) RETURN coalesce(ca.seedKey, ?) AS seedKey
MATCH (o:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_CONTACT_AREA]->(ca:ContactArea{tildaid:$categoryId, delpending:false}) RETURN coalesce(ca.seedKey, ?) AS seedKey
workplansvc
4
<1 ms
2 ms
1 ms
flat
MATCH (e:Event {tildaid: $eventId, orgId: $id}) OPTIONAL MATCH (e)<-[:EVENTS]-(:EventPlan)-[:PLAN_CONTEXT]->(ctx) RETURN labels(ctx)[?] AS contextType, ctx.tildaid AS contextId LIMIT ?
MATCH (e:Event {tildaid: $eventId, orgId: $id}) OPTIONAL MATCH (e)<-[:EVENTS]-(:EventPlan)-[:PLAN_CONTEXT]->(ctx) RETURN labels(ctx)[?] AS contextType, ctx.tildaid AS contextId LIMIT ?
docsvc
8
<1 ms
2 ms
1 ms
flat
MATCH (pv:ParticipantVisit {tildaid: $participantVisitId})-[:BELONGS_TO_VISIT]-(v:VisitV2{studyPeriod: $studyPeriod}) RETURN v.studyPeriod as studyPeriod LIMIT ?
MATCH (pv:ParticipantVisit {tildaid: $participantVisitId})-[:BELONGS_TO_VISIT]-(v:VisitV2{studyPeriod: $studyPeriod}) RETURN v.studyPeriod as studyPeriod LIMIT ?
dashrsvc
4
<1 ms
2 ms
1 ms
flat
MATCH(a:ParticipantVisit{tildaid:$a_tildaid}) RETURN a
MATCH(a:ParticipantVisit{tildaid:$a_tildaid}) RETURN a
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
805
<1 ms
2 ms
1 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
19
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid})-[r:HAS_STUDY_CRITERION]->(b) RETURN b limit $limit
MATCH(a:Study{tildaid:$a_tildaid})-[r:HAS_STUDY_CRITERION]->(b) RETURN b limit $limit
enrollsvc
53
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
15
<1 ms
2 ms
1 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
15
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.depende…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.dependencyResolutionRequestedAt, ?) > ? AND $nowMs - item.dependencyResolutionRequestedAt >= $windowMs AND wp.state <> ? AND NOT EXISTS { MATCH (ctx:WorkPlanContext{workplanConfigId: wp.tildaid, contextType:?}) } OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) RETURN DISTINCT wp.tildaid AS id, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
768
<1 ms
2 ms
62 ms
flat
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
onboardingsvc
36
<1 ms
2 ms
1 ms
flat
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
MATCH (study:Study{tildaid:$studyId})-[:STUDYCOUNTRYACTOR_TO_STUDY]-(sca:StudyCountryActor)-[:STUDYCOUNTRYACTOR_TO_ACTOR]-(actor:Actor{tildaid:$actorId}) RETURN sca
execsvc
32
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
51
<1 ms
2 ms
1 ms
flat
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
enrollsvc
12
<1 ms
2 ms
1 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
6
<1 ms
2 ms
1 ms
flat
MATCH(a:Site{tildaid:$a_tildaid})-[r:HAS_EQUIPMENT]->(b:Equipment) RETURN b limit $limit
MATCH(a:Site{tildaid:$a_tildaid})-[r:HAS_EQUIPMENT]->(b:Equipment) RETURN b limit $limit
schedsvc
3
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
63
<1 ms
2 ms
9 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
43
<1 ms
2 ms
1 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
27
<1 ms
2 ms
1 ms
flat
MATCH(a:Patient{tildaid:$a_tildaid}) RETURN a
MATCH(a:Patient{tildaid:$a_tildaid}) RETURN a
notifsvc
8
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.depende…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.dependencyResolutionRequestedAt, ?) > ? AND $nowMs - item.dependencyResolutionRequestedAt >= $windowMs AND wp.state <> ? AND NOT EXISTS { MATCH (ctx:WorkPlanContext{workplanConfigId: wp.tildaid, contextType:?}) } OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) RETURN DISTINCT wp.tildaid AS id, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
781
<1 ms
2 ms
27 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
<1 ms
2 ms
1 ms
flat
MATCH(a:Actor{userId:$a_userId,orgId:$a_orgId,scopeId:$a_scopeId,delpending:$a_delpending}) RETURN a
MATCH(a:Actor{userId:$a_userId,orgId:$a_orgId,scopeId:$a_scopeId,delpending:$a_delpending}) RETURN a
docsvc
5
<1 ms
2 ms
1 ms
flat
MATCH (o:Organization {tildaid: $org_id}) WHERE o.alias <> ? RETURN o.alias as alias, coalesce(o.aiTeammateName, ?) as aiTeammateName, coalesce(o.aiTeammateEmail, ?) as aiTeammateEmail
MATCH (o:Organization {tildaid: $org_id}) WHERE o.alias <> ? RETURN o.alias as alias, coalesce(o.aiTeammateName, ?) as aiTeammateName, coalesce(o.aiTeammateEmail, ?) as aiTeammateEmail
virtual-assistant
137
<1 ms
2 ms
5 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
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).