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 708
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(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
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
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 (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: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` , $`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
1,882
<1 ms
<1 ms
14 ms
flat
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
execsvc
1,882
<1 ms
<1 ms
15 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
1,882
<1 ms
<1 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
616
<1 ms
<1 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
620
<1 ms
1 ms
2 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
709
<1 ms
2 ms
5 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
669
<1 ms
2 ms
10 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
434
<1 ms
2 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
429
<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
43
<1 ms
2 ms
1 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
256
<1 ms
2 ms
1 ms
0.7× ↓
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
656
<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 (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
56
<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
42
<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
65
<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
workplansvc
5
<1 ms
2 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
43
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
14
<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 (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
22
<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
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
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 (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
186
<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
300
<1 ms
2 ms
2 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 (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
645
<1 ms
2 ms
2 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
287
<1 ms
2 ms
2 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
14
<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 (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
256
<1 ms
2 ms
1 ms
flat
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
workplansvc
9
<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
11
<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
149
<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
130
<1 ms
2 ms
4 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 (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
69
<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
2
<1 ms
2 ms
1 ms
2.1× ↑
MATCH(a:CarePlan{tildaid:$a_tildaid}) RETURN a
MATCH(a:CarePlan{tildaid:$a_tildaid}) RETURN a
execsvc
6
<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
4
<1 ms
2 ms
1 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 (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
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 (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
231
<1 ms
2 ms
1 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
423
<1 ms
2 ms
6 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
677
<1 ms
2 ms
5 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
228
<1 ms
2 ms
2 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
37
<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
workplansvc
11
<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
144
<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
9
<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
185
<1 ms
2 ms
24 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(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
7
<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
40
<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
69
<1 ms
2 ms
1 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
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).