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 563
Neo4j query shapes on nexus over the last 3d, grouped by plan hash.
Click a column to sort; p95 drift (late-half ÷ early-half of the window) ranks the queries getting slower.
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
3
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
101
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
5
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
5
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN cfg.recipientOverrideList
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN cfg.recipientOverrideList
workplansvc
5
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
MATCH (o:Organization {tildaid: $org_id}) RETURN o.emailCcList AS ccList
MATCH (o:Organization {tildaid: $org_id}) RETURN o.emailCcList AS ccList
virtual-assistant
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: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
2
0 ms
<1 ms
0 ms
flat
MATCH(a:SMSTemplate{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
MATCH(a:SMSTemplate{deltimestamp:$a_deltimestamp,name:$a_name}) RETURN a
notifsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
onboardingsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Upgrade) RETURN a limit $a_limit
MATCH(a:Upgrade) RETURN a limit $a_limit
onboardingsvc
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 ?
schedsvc
1
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
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Job{tildaid:$a_tildaid}) RETURN a
MATCH(a:Job{tildaid:$a_tildaid}) RETURN a
schedsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_JOBSTATE]->(b:JobState) RETURN b limit $limit
MATCH(a:Job{tildaid:$a_tildaid})-[r:JOB_TO_JOBSTATE]->(b:JobState) RETURN b limit $limit
schedsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Upgrade) RETURN a limit $a_limit
MATCH(a:Upgrade) RETURN a limit $a_limit
schema-migrate
1
0 ms
<1 ms
0 ms
flat
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
101
<1 ms
<1 ms
10 ms
flat
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
101
<1 ms
<1 ms
14 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
427
<1 ms
<1 ms
1 ms
1.2× ↑
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
430
<1 ms
1 ms
1 ms
1.4× ↑
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
562
<1 ms
1 ms
5 ms
flat
MATCH (r:Review {status: ?, scope_type: ?}) WHERE r.started_at IS NULL AND r.createdat < $older_than AND NOT coalesce(r.requeued, false) SET r.requeued = true, r.requeued_at = $at RETURN r ORDER BY r.createdat LIMIT $limit
MATCH (r:Review {status: ?, scope_type: ?}) WHERE r.started_at IS NULL AND r.createdat < $older_than AND NOT coalesce(r.requeued, false) SET r.requeued = true, r.requeued_at = $at RETURN r ORDER BY r.createdat LIMIT $limit
writedata_monitor
120
<1 ms
1 ms
1 ms
0.8× ↓
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
489
<1 ms
2 ms
10 ms
0.8× ↓
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
301
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointDecisionFollowupPendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointDecisionFollowupClaimedAt, ?) >= ? R…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointDecisionFollowupPendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointDecisionFollowupClaimedAt, ?) >= ? RETURN wp.tildaid AS instanceId, cfg.tildaid AS cfgId LIMIT $limit
workplansvc
470
<1 ms
2 ms
2 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
266
<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
141
<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
6
<1 ms
2 ms
1 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
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointDecisionFollowupPendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointDecisionFollowupClaimedAt, ?) >= ? R…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointDecisionFollowupPendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointDecisionFollowupClaimedAt, ?) >= ? RETURN wp.tildaid AS instanceId, cfg.tildaid AS cfgId LIMIT $limit
workplansvc
542
<1 ms
2 ms
7 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
4
<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
4
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
3
<1 ms
2 ms
1 ms
flat
MATCH (u:User {email: $identifier}) RETURN u.tildaid as tildaid, u.name as name, u.email as email, u.phoneNumber as phone, coalesce(u.authzUpdateNum, ?) as authzUpdateNum
MATCH (u:User {email: $identifier}) RETURN u.tildaid as tildaid, u.name as name, u.email as email, u.phoneNumber as phone, coalesce(u.authzUpdateNum, ?) as authzUpdateNum
docproc
3
<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
12
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg) WHERE coalesce(cfg.instanceMilestoneItemCreationPending, false) = true AND cfg.state <> ? AND (coalesce(cfg.instanceItemCreationClaimedAtMs, ?) = ? OR $nowMs - cfg.instanceItemCreationClaimedAtMs >= $windowMs) RETUR…
MATCH (cfg:WorkplanCfg) WHERE coalesce(cfg.instanceMilestoneItemCreationPending, false) = true AND cfg.state <> ? AND (coalesce(cfg.instanceItemCreationClaimedAtMs, ?) = ? OR $nowMs - cfg.instanceItemCreationClaimedAtMs >= $windowMs) RETURN cfg.tildaid as cfgId LIMIT ?
workplansvc
454
<1 ms
2 ms
2 ms
flat
MATCH (r:TmfEvaluationRun {status: $running}) WHERE r.deltimestamp = ? AND coalesce(r.updatedat, r.createdat) < $cutoff RETURN r.tildaid AS tildaid, r.trainingId AS trainingId, r.tmfVersion AS tmfVersion, r.startedBy AS startedBy ORDER BY …
MATCH (r:TmfEvaluationRun {status: $running}) WHERE r.deltimestamp = ? AND coalesce(r.updatedat, r.createdat) < $cutoff RETURN r.tildaid AS tildaid, r.trainingId AS trainingId, r.tmfVersion AS tmfVersion, r.startedBy AS startedBy ORDER BY coalesce(r.updatedat, r.createdat) ASC LIMIT $limit
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
83
<1 ms
2 ms
1 ms
flat
MATCH (l:MonitoringStudyLink {enabled: true}) WITH l.study_id AS study_id, collect(DISTINCT l.org_id) AS org_ids WITH study_id, (CASE WHEN size(org_ids) = ? THEN org_ids[?] ELSE null END) AS org_id OPTIONAL MATCH (o:Organization {tildaid: …
MATCH (l:MonitoringStudyLink {enabled: true}) WITH l.study_id AS study_id, collect(DISTINCT l.org_id) AS org_ids WITH study_id, (CASE WHEN size(org_ids) = ? THEN org_ids[?] ELSE null END) AS org_id OPTIONAL MATCH (o:Organization {tildaid: org_id}) OPTIONAL MATCH (s:MonitoringSchedule {study_id: study_id}) RETURN study_id, org_id, o.alias AS org_alias, s ORDER BY study_id
data_monitor
240
<1 ms
2 ms
2 ms
flat
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
workplansvc
5
<1 ms
2 ms
1 ms
flat
MATCH (wp:WorkPlanInstance{tildaid:$instanceId})-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(m:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.tildaid <> $currentItemId AND item.itemTy…
MATCH (wp:WorkPlanInstance{tildaid:$instanceId})-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(m:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.tildaid <> $currentItemId AND item.itemType = ? AND coalesce(item.workOrderId, ?) <> ? MATCH (w:WorkOrder) WHERE w.tildaid = item.workOrderId AND coalesce(w.rfc_msgid, ?) <> ? RETURN item.tildaid as itemId, coalesce(item.itemConfig, ?) as itemConfig, coalesce(m.name, ?) as milestoneName, w.rfc_msgid as rfcMsgid, coalesce(w.email_subject, w.title, ?) as emailSubject, coalesce(item.activateRequestedAt, ?) as activateRequestedAt ORDER BY item.activateRequestedAt
workplansvc
5
<1 ms
2 ms
1 ms
flat
MATCH (r:Review) WHERE NOT r.status IN $terminal AND ((r.started_at IS NOT NULL AND r.started_at < $older_than) OR (r.started_at IS NULL AND r.createdat < $queued_older_than)) OPTIONAL MATCH (r)-[:HAS_CHILD]->(c:Review) WITH r, [x IN colle…
MATCH (r:Review) WHERE NOT r.status IN $terminal AND ((r.started_at IS NOT NULL AND r.started_at < $older_than) OR (r.started_at IS NULL AND r.createdat < $queued_older_than)) OPTIONAL MATCH (r)-[:HAS_CHILD]->(c:Review) WITH r, [x IN collect(c) WHERE x IS NOT NULL AND NOT x.status IN $terminal] AS pending WHERE size(pending) = ? SET r.status = ?, r.failure = ?, r.outcome = $outcome, r.completed_at = $at RETURN r.tildaid AS review_id, r.parent_review_id AS parent_review_id, r.started_at IS NULL AS never_started
writedata_monitor
120
<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
118
<1 ms
2 ms
1 ms
flat
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) return currentUser as user
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) return currentUser as user
onboardingsvc
62
<1 ms
2 ms
1 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
18
<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
120
<1 ms
2 ms
1 ms
flat
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) return currentUser as user
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) return currentUser as user
notifsvc
13
<1 ms
2 ms
1 ms
2.0× ↑
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
262
<1 ms
2 ms
2 ms
flat
MATCH (r:TmfEvaluationRun {status: $running}) WHERE r.deltimestamp = ? AND coalesce(r.updatedat, r.createdat) < $cutoff RETURN r.tildaid AS tildaid, r.trainingId AS trainingId, r.tmfVersion AS tmfVersion, r.startedBy AS startedBy ORDER BY …
MATCH (r:TmfEvaluationRun {status: $running}) WHERE r.deltimestamp = ? AND coalesce(r.updatedat, r.createdat) < $cutoff RETURN r.tildaid AS tildaid, r.trainingId AS trainingId, r.tmfVersion AS tmfVersion, r.startedBy AS startedBy ORDER BY coalesce(r.updatedat, r.createdat) ASC LIMIT $limit
docproc
162
<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
129
<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
128
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg) WHERE coalesce(cfg.instanceMilestoneItemCreationPending, false) = true AND cfg.state <> ? AND (coalesce(cfg.instanceItemCreationClaimedAtMs, ?) = ? OR $nowMs - cfg.instanceItemCreationClaimedAtMs >= $windowMs) RETUR…
MATCH (cfg:WorkplanCfg) WHERE coalesce(cfg.instanceMilestoneItemCreationPending, false) = true AND cfg.state <> ? AND (coalesce(cfg.instanceItemCreationClaimedAtMs, ?) = ? OR $nowMs - cfg.instanceItemCreationClaimedAtMs >= $windowMs) RETURN cfg.tildaid as cfgId LIMIT ?
workplansvc
526
<1 ms
2 ms
5 ms
flat
MATCH (w:WorkOrder)-[:WORK_ORDER_TO_DOCUMENT]->(d:Document {tildaid: $doc_id}) WHERE w.delpending = false RETURN w.tildaid AS work_order_id, coalesce(w.title, ?) AS work_order_name 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.tildaid AS work_order_id, coalesce(w.title, ?) AS work_order_name ORDER BY coalesce(w.updatedat, w.createdat) DESC LIMIT ?
docproc
2
<1 ms
2 ms
1 ms
flat
MATCH (:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.category = $category AND (r.isIgnoredBySupport IS NULL OR r.isIgnoredBySupport = false) WITH DISTINCT r WHERE NOT EXISTS { MATCH (tai:AIRun)-[:A…
MATCH (:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.category = $category AND (r.isIgnoredBySupport IS NULL OR r.isIgnoredBySupport = false) WITH DISTINCT r WHERE NOT EXISTS { MATCH (tai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE tai.evaluation_run_id IS NOT NULL } AND EXISTS { (r)-[:RECOMMENDATION_TO_ORGANIZATION]->(:Organization {tildaid: $org_id}) } RETURN count(r) as total
docproc
2
<1 ms
2 ms
1 ms
flat
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id
docproc
2
<1 ms
2 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
2
<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
2
<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 (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
execsvc
2
<1 ms
2 ms
1 ms
0.5× ↓
match (patient:Patient{tildaid: $patientId})-[:HAS_PROTECTED_DATA_IN]->(phi:Phi) return phi
match (patient:Patient{tildaid: $patientId})-[:HAS_PROTECTED_DATA_IN]->(phi:Phi) return phi
notifsvc
2
<1 ms
2 ms
1 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
42
<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
4
<1 ms
2 ms
1 ms
flat
match (cp:CarePlan{tildaid:$careplanId}) with cp, EXISTS { MATCH (cp)-[:EXECUTE_SOA]-(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]- (pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study)-[:STUDY_TO_ACTOR]-> (actor:Actor{orgId:$…
match (cp:CarePlan{tildaid:$careplanId}) with cp, EXISTS { MATCH (cp)-[:EXECUTE_SOA]-(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]- (pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study)-[:STUDY_TO_ACTOR]-> (actor:Actor{orgId:$orgId})-[:FOR_USER]->(u:User{email:$userEmail}) WHERE actor.state <> ? } AS isActor, EXISTS { MATCH (cp)-[:RESEARCH_SUBJECT]->(:Patient)- [:USER_TO_PATIENT]-(pu:User{email:$userEmail}) } AS isPatient, EXISTS { MATCH (cp)-[:RESEARCH_SUBJECT]->(:Patient)- [:PATIENT_REPRESENTATIVE_TO_PATIENT]-(:PatientRepresentative)-[:USER_TO_PATIENT_REPRESENTATIVE]- (pru:User{email:$userEmail}) } AS isPatientRepresentative return cp, isActor, isPatient, isPatientRepresentative
execsvc
4
<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
305
<1 ms
2 ms
2 ms
flat
match(org:Organization{tildaid:$id})-[r:ORGANIZATION_TO_FORM]->(form:FormV2{tildaid:$formId}) optional match(form)-[:PUBLISHED_TO_DRAFT|ARCHIVED_TO_DRAFT]->(draft:FormV2{orgid:$id1}) with *, ? as refCount, ? as draftRefCount return form, d…
match(org:Organization{tildaid:$id})-[r:ORGANIZATION_TO_FORM]->(form:FormV2{tildaid:$formId}) optional match(form)-[:PUBLISHED_TO_DRAFT|ARCHIVED_TO_DRAFT]->(draft:FormV2{orgid:$id1}) with *, ? as refCount, ? as draftRefCount return form, draft, exists((form)<-[:GRAPH_NEXT|FORM_INSTANCE_TO_FORM]-()), r.inherited, refCount, draftRefCount
studiosvc
23
<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
226
1 ms
2 ms
164 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
251
<1 ms
2 ms
1 ms
flat
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) return currentUser as user
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) return currentUser as user
notifsvc
22
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) SET cfg.instanceItemCreationClaimedAtMs = ?, cfg.updatedat = timestamp()
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) SET cfg.instanceItemCreationClaimedAtMs = ?, cfg.updatedat = timestamp()
writeworkplansvc
307
<1 ms
2 ms
4 ms
flat
MATCH (item:WorkPlanMilestoneItem{tildaid:$itemId}) OPTIONAL MATCH (item)-[depRel:WORKPLAN_MILESTONE_ITEM_DEPENDENCY]->(dep:WorkPlanMilestoneItemDependency)-[:DEPENDS_ON]->(depItem:WorkPlanMilestoneItem) RETURN item, collect(DISTINCT {depe…
MATCH (item:WorkPlanMilestoneItem{tildaid:$itemId}) OPTIONAL MATCH (item)-[depRel:WORKPLAN_MILESTONE_ITEM_DEPENDENCY]->(dep:WorkPlanMilestoneItemDependency)-[:DEPENDS_ON]->(depItem:WorkPlanMilestoneItem) RETURN item, collect(DISTINCT {dependsOnItemId: dep.dependsOnItemId, dependsOnMilestoneItemTildaid: coalesce(dep.dependsOnMilestoneItemTildaid, ?), dependencyType: dep.dependencyType, deferredDocumentCount: coalesce(dep.deferredDocumentCount, ?), deferredFormCount: coalesce(dep.deferredFormCount, ?), supplyReasoning: coalesce(dep.supplyReasoning, ?), gatesDownstreamItem: coalesce(dep.gatesDownstreamItem, false)}) as deps
workplansvc
5
<1 ms
2 ms
1 ms
flat
MATCH (:Organization{tildaid:$studyId})-[:ORGANIZATION_TO_TRAINING]->(t:Training{delpending:false}) WHERE true AND (NOT ((coalesce(t.siteScope, ?) = $studyTeamScope) OR (coalesce(t.scopeType, ?) = $orgScopeType)) OR (t.orgId <> ? AND t.org…
MATCH (:Organization{tildaid:$studyId})-[:ORGANIZATION_TO_TRAINING]->(t:Training{delpending:false}) WHERE true AND (NOT ((coalesce(t.siteScope, ?) = $studyTeamScope) OR (coalesce(t.scopeType, ?) = $orgScopeType)) OR (t.orgId <> ? AND t.orgId = $callerOrgId)) RETURN t.status, count(t)
execsvc
5
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
8
<1 ms
2 ms
1 ms
flat
MATCH (pa:ParticipantActivity {tildaid:$paId}) MATCH (t:Training {scopeType:$orgScope, delpending:false})-[:TRAINING_TO_ASSIGNMENT]-> (ta:TrainingAssignment {tildaid:pa.carePlanId, userId:$userId, ownerOrgId:$orgId, deltimestamp:?})-[:PART…
MATCH (pa:ParticipantActivity {tildaid:$paId}) MATCH (t:Training {scopeType:$orgScope, delpending:false})-[:TRAINING_TO_ASSIGNMENT]-> (ta:TrainingAssignment {tildaid:pa.carePlanId, userId:$userId, ownerOrgId:$orgId, deltimestamp:?})-[:PARTICIPANT_ACTIVITY]->(pa) WHERE coalesce(ta.studyId, ?) = ? AND ($anyState OR ta.state = $assigned) AND ($activityId = ? OR pa.activityId = $activityId) RETURN ta.tildaid LIMIT ?
execsvc
11
<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
3
<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
3
<1 ms
2 ms
1 ms
flat
MATCH(a:CarePlan{tildaid:$a_tildaid}) RETURN a
MATCH(a:CarePlan{tildaid:$a_tildaid}) RETURN a
execsvc
3
<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
4
<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).