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,539
Neo4j query shapes on test26 over the last 30d, grouped by plan hash.
Click a column to sort; p95 drift (late-half ÷ early-half of the window) ranks the queries getting slower.
MATCH(a: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
3
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 (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN cfg.recipientOverrideList
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN cfg.recipientOverrideList
workplansvc
4
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
125
0 ms
<1 ms
0 ms
flat
MATCH(a:ParticipantVisit{tildaid:$a_tildaid}) RETURN a
MATCH(a:ParticipantVisit{tildaid:$a_tildaid}) RETURN a
finsvc
8
0 ms
<1 ms
0 ms
flat
optional match (v:Visit{tildaid:$visitId}) optional match (v2:VisitV2{tildaid:$visitId}) return {v:v, v2:v2}
optional match (v:Visit{tildaid:$visitId}) optional match (v2:VisitV2{tildaid:$visitId}) return {v:v, v2:v2}
finsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
notifsvc
1
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
2
0 ms
<1 ms
0 ms
flat
MATCH(a:ParticipantVisit{tildaid:$a_tildaid}) RETURN a
MATCH(a:ParticipantVisit{tildaid:$a_tildaid}) RETURN a
schedsvc
27
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
1
0 ms
<1 ms
0 ms
flat
UNWIND $graphIds AS gid CALL (gid) { MATCH (host:GraphNode {tildaid:gid})-[r:GRAPH_NEXT*?.. {graphid:gid}]->(n:GraphNode) WHERE r[-?].path[?] = gid AND n.tildaid <> gid RETURN n.tildaid AS objId, min(coalesce(r[-?].addedat, ?)) AS addedAt …
UNWIND $graphIds AS gid CALL (gid) { MATCH (host:GraphNode {tildaid:gid})-[r:GRAPH_NEXT*?.. {graphid:gid}]->(n:GraphNode) WHERE r[-?].path[?] = gid AND n.tildaid <> gid RETURN n.tildaid AS objId, min(coalesce(r[-?].addedat, ?)) AS addedAt } RETURN gid, objId, addedAt
studiosvc
2
0 ms
<1 ms
0 ms
flat
match (:StudyNotification{studyId:$studyId})-[:ALL_CHANGELOG]-(clog:ChangeLog) return clog order by clog.createdat desc
match (:StudyNotification{studyId:$studyId})-[:ALL_CHANGELOG]-(clog:ChangeLog) return clog order by clog.createdat desc
enrollsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (proto:FormV2{tildaid:$protocolID})-[:CONTAINS_FORM*?..]->(f:FormV2{tildaid:$descendantFormID}) RETURN ? LIMIT ?
MATCH (proto:FormV2{tildaid:$protocolID})-[:CONTAINS_FORM*?..]->(f:FormV2{tildaid:$descendantFormID}) RETURN ? LIMIT ?
studiosvc
8
0 ms
<1 ms
0 ms
flat
MATCH(a:Actor{orgId:$a_orgId,scopeId:$a_scopeId,userId:$a_userId,delpending:$a_delpending}) RETURN a
MATCH(a:Actor{orgId:$a_orgId,scopeId:$a_scopeId,userId:$a_userId,delpending:$a_delpending}) RETURN a
execsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:Staff{tildaid:$a_tildaid}) RETURN a
MATCH(a:Staff{tildaid:$a_tildaid}) RETURN a
schedsvc
4
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
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: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: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: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: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
CREATE CONSTRAINT user_key IF NOT EXISTS FOR (u:User) REQUIRE (u.group_id, u.external_id) IS NODE KEY
CREATE CONSTRAINT user_key IF NOT EXISTS FOR (u:User) REQUIRE (u.group_id, u.external_id) IS NODE KEY
writechat-agent
2
0 ms
<1 ms
0 ms
flat
CREATE INDEX insight_inval IF NOT EXISTS FOR (i:Insight) ON (i.invalid_at)
CREATE INDEX insight_inval IF NOT EXISTS FOR (i:Insight) ON (i.invalid_at)
writechat-agent
2
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT org_group IF NOT EXISTS FOR (o:Org) REQUIRE o.group_id IS UNIQUE
CREATE CONSTRAINT org_group IF NOT EXISTS FOR (o:Org) REQUIRE o.group_id IS UNIQUE
writechat-agent
2
0 ms
<1 ms
0 ms
flat
CREATE INDEX about_ext IF NOT EXISTS FOR ()-[a:ABOUT]-() ON (a.external_id)
CREATE INDEX about_ext IF NOT EXISTS FOR ()-[a:ABOUT]-() ON (a.external_id)
writechat-agent
2
0 ms
<1 ms
0 ms
flat
CREATE INDEX insight_scope IF NOT EXISTS FOR (i:Insight) ON (i.group_id, i.category)
CREATE INDEX insight_scope IF NOT EXISTS FOR (i:Insight) ON (i.group_id, i.category)
writechat-agent
2
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT insight_uuid IF NOT EXISTS FOR (i:Insight) REQUIRE i.uuid IS UNIQUE
CREATE CONSTRAINT insight_uuid IF NOT EXISTS FOR (i:Insight) REQUIRE i.uuid IS UNIQUE
writechat-agent
2
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT type_key IF NOT EXISTS FOR (t:EntityType) REQUIRE (t.group_id, t.kind) IS NODE KEY
CREATE CONSTRAINT type_key IF NOT EXISTS FOR (t:EntityType) REQUIRE (t.group_id, t.kind) IS NODE KEY
writechat-agent
2
0 ms
<1 ms
0 ms
flat
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
docsvc
102
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
5
0 ms
<1 ms
0 ms
flat
match (pa:Patient)-[:HAS_PROTECTED_DATA_IN]-(p:Phi) where p.email=$email return pa
match (pa:Patient)-[:HAS_PROTECTED_DATA_IN]-(p:Phi) where p.email=$email return pa
notifsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_SMS_NOTIFICATION]->(b:SMSNotification) RETURN a, b limit ?
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_SMS_NOTIFICATION]->(b:SMSNotification) RETURN a, b limit ?
notifsvc
5
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 ?
schedsvc
4
0 ms
<1 ms
0 ms
flat
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
dashrsvc
383
<1 ms
<1 ms
3 ms
0.4× ↓
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` CALL apoc.create.relationship(from, row.parentRelation, {}, node) yield rel RETURN rel
WITH $`node` as `node` , $`from` as `from` , $`row` as `row` CALL apoc.create.relationship(from, row.parentRelation, {}, node) yield rel RETURN rel
writeexecsvc
125
<1 ms
<1 ms
9 ms
6.1× ↑
WITH $`node` as `node` , $`row` as `row` , $`to` as `to` CALL apoc.create.relationship(node, row.peerRelation, {}, to) yield rel as rel1 RETURN rel1
WITH $`node` as `node` , $`row` as `row` , $`to` as `to` CALL apoc.create.relationship(node, row.peerRelation, {}, to) yield rel as rel1 RETURN rel1
writeexecsvc
125
<1 ms
<1 ms
13 ms
12.1× ↑
match(a:StudySiteActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:StudySiteActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeexecsvc
89
<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
2,872
<1 ms
<1 ms
23 ms
flat
match(campaign:AdvCampaign{portalorgid:$studySrcOrgId})-[:PUBLISHED_CONFIG]->(cfg:AdvCampaignConfig{studyid:$studyId})-[:HAS_SITES]->(site:Site{tildaid:$siteId}) with campaign, cfg match(cfg)-[r:HAS_SITES]->(s:Site) where exists((s)-[:SITE…
match(campaign:AdvCampaign{portalorgid:$studySrcOrgId})-[:PUBLISHED_CONFIG]->(cfg:AdvCampaignConfig{studyid:$studyId})-[:HAS_SITES]->(site:Site{tildaid:$siteId}) with campaign, cfg match(cfg)-[r:HAS_SITES]->(s:Site) where exists((s)-[:SITE_TO_SMO]-(:Smo{orgId:$smoOrgId})) with campaign, count(r) as smoSites where smoSites = ? with campaign match(campaign)-[r:CAMPAIGN_TO_SHARED_CAMPAIGN]->(smoCampaign:AdvCampaign{portalorgid:$smoOrgId}) detach delete smoCampaign
writeadvpsvc
140
<1 ms
<1 ms
1 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
<1 ms
<1 ms
1 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
384
<1 ms
<1 ms
1 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 (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
592
<1 ms
1 ms
1 ms
flat
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun) WHERE ai.status = ? RETURN count(ai) > ? AS has_active_run
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun) WHERE ai.status = ? RETURN count(ai) > ? AS has_active_run
virtual-assistant
612
<1 ms
1 ms
2 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
52
<1 ms
1 ms
4 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
1,498
<1 ms
1 ms
1 ms
flat
MATCH (ds:GoldenDataset)-[:CONTAINS_DOCUMENT]->(:Document {tildaid: $document_id}) RETURN ds.tildaid AS golden_dataset_id LIMIT ?
MATCH (ds:GoldenDataset)-[:CONTAINS_DOCUMENT]->(:Document {tildaid: $document_id}) RETURN ds.tildaid AS golden_dataset_id LIMIT ?
docproc
341
<1 ms
1 ms
3 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
13
<1 ms
1 ms
1 ms
flat
MATCH (t:Training{scopeId:$studyId, status:$activeStatus, delpending:false}) WHERE CASE WHEN (coalesce(t.siteScope, ?) = $studyTeamScope) THEN (t.orgId <> ? AND t.orgId = $orgId) ELSE ANY(r IN t.roles WHERE r IN $roles) END RETURN t
MATCH (t:Training{scopeId:$studyId, status:$activeStatus, delpending:false}) WHERE CASE WHEN (coalesce(t.siteScope, ?) = $studyTeamScope) THEN (t.orgId <> ? AND t.orgId = $orgId) ELSE ANY(r IN t.roles WHERE r IN $roles) END RETURN t
execsvc
85
<1 ms
1 ms
14 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
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
414
<1 ms
1 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
11
<1 ms
1 ms
1 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
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
2,114
<1 ms
1 ms
7 ms
1.3× ↑
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
execsvc
42
<1 ms
1 ms
1 ms
0.6× ↓
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
notifsvc
10
<1 ms
2 ms
1 ms
0.6× ↓
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(b)-[r:HAS_SITES]->(s:Site{tildaid:$siteId}) delete r
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(b)-[r:HAS_SITES]->(s:Site{tildaid:$siteId}) delete r
writeadvpsvc
140
<1 ms
2 ms
1 ms
flat
MATCH (s:Study {tildaid:$studyId})-[:USES]->(fm:FolderManager {name:?})-[:HAS]->(fi:FolderManagerInstructions) RETURN fi.auditPlan AS audit_plan
MATCH (s:Study {tildaid:$studyId})-[:USES]->(fm:FolderManager {name:?})-[:HAS]->(fi:FolderManagerInstructions) RETURN fi.auditPlan AS audit_plan
docproc
354
<1 ms
2 ms
2 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
1,600
<1 ms
2 ms
2 ms
flat
match(visit:VisitV2{tildaid:$visitId})-[:VISIT_TO_PREVISIT]->(pre:PrePostVisitV2) with visit, pre match(visit)-[:VISIT_TO_POSTVISIT]->(post:PrePostVisitV2) with visit, pre, post return pre.tildaid, post.tildaid
match(visit:VisitV2{tildaid:$visitId})-[:VISIT_TO_PREVISIT]->(pre:PrePostVisitV2) with visit, pre match(visit)-[:VISIT_TO_POSTVISIT]->(post:PrePostVisitV2) with visit, pre, post return pre.tildaid, post.tildaid
studiosvc
64
<1 ms
2 ms
1 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(a:Organization{deltimestamp:$a_deltimestamp,alias:$a_alias}) RETURN a
MATCH(a:Organization{deltimestamp:$a_deltimestamp,alias:$a_alias}) RETURN a
regsvc
108
<1 ms
2 ms
11 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
52
<1 ms
2 ms
1 ms
flat
MATCH (j:ZipExtractionJob {status: $status}) WHERE coalesce(j.attempts, ?) < $max_attempts AND j.lastAttemptAt < timestamp() - $stale_ms MATCH (d:Document {tildaid: j.zipDocId}) WHERE coalesce(d.archived, false) = false CALL (j) { MATCH (m…
MATCH (j:ZipExtractionJob {status: $status}) WHERE coalesce(j.attempts, ?) < $max_attempts AND j.lastAttemptAt < timestamp() - $stale_ms MATCH (d:Document {tildaid: j.zipDocId}) WHERE coalesce(d.archived, false) = false CALL (j) { MATCH (m:ZipExtractionMember {zipDocId: j.zipDocId}) RETURN count(m) AS ledger_rows, max(m.updatedAt) AS last_member_at } WITH j, d, ledger_rows, last_member_at // A crash between recording the job and the first ledger write leaves no // members at all; fall back to the job's own timestamp so those are still // found rather than sitting unnoticed forever. WHERE CASE WHEN ledger_rows = ? THEN true ELSE last_member_at < timestamp() - $stale_ms END // Who uploaded the archive: the resume acts as them, so the member documents it // creates through docsvc (and the processing they trigger) are attributed to them. OPTIONAL MATCH (d)-[:UPLOADED_BY]->(uploader:User) WITH j, ledger_rows, head(collect(uploader.email)) AS uploader_email RETURN j.zipDocId AS zip_doc_id, j.orgAlias AS org_alias, coalesce(j.attempts, ?) AS attempts, ledger_rows AS ledger_rows, uploader_email ORDER BY j.lastAttemptAt ASC LIMIT $limit
docproc
42
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
132
<1 ms
2 ms
1 ms
flat
MATCH(a:Phi{tildaid:$a_tildaid}) RETURN a
MATCH(a:Phi{tildaid:$a_tildaid}) RETURN a
notifsvc
8
<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
32
<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
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).