Xray
daily rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 30 days▾
Ends now. Anything up to this cluster's 30-day retention.
Start and end times
Cancel
Interpreted in UTC (change it at the right of this bar). Earliest available: 2026-10-19 12:47:11.
› →|
updated 1d ago
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

stored 26h ago top 80 of 904

Neo4j query shapes on nexus 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.

Columns
Views
Export CSV
Query shape Count Avg p95 ▴ Max p95 drift
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(a:Patient{tildaid:$a_tildaid})-[r:HAS_ALLERGY]->(b:Allergy{delpending:$b_delpending}) RETURN count(r)
MATCH(a:Patient{tildaid:$a_tildaid})-[r:HAS_ALLERGY]->(b:Allergy{delpending:$b_delpending}) RETURN count(r)
patientsvc
6 0 ms <1 ms 0 ms flat
MATCH(a:DocumentAnnotation{tildaid:$a_tildaid})-[r:ANNOTATION_FIELD]->(b:DocumentField{uniqueId:$b_uniqueId}) RETURN b limit $limit
MATCH(a:DocumentAnnotation{tildaid:$a_tildaid})-[r:ANNOTATION_FIELD]->(b:DocumentField{uniqueId:$b_uniqueId}) RETURN b limit $limit
docsvc
9 0 ms <1 ms 0 ms flat
MATCH (a:DocumentAnnotation{tildaid:$a_tildaid}),(b:DocumentField{tildaid:$b_tildaid}) MERGE (a)-[r:ANNOTATION_FIELD]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
MATCH (a:DocumentAnnotation{tildaid:$a_tildaid}),(b:DocumentField{tildaid:$b_tildaid}) MERGE (a)-[r:ANNOTATION_FIELD]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
write docsvc
9 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 (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
MATCH (v:TildaDataMigrationVersion {owner: $owner}) RETURN max(v.version)
execsvc
1 0 ms <1 ms 0 ms flat
match (sc:Scope{name:$name}) where sc.version = $version return sc
match (sc:Scope{name:$name}) where sc.version = $version return sc
onboardingsvc
5 0 ms <1 ms 0 ms flat
MATCH (p:Policy)-[:APPLICABLE_IN]->(sc0:Scope{version:?}) MATCH (sc1:Scope{version:?,name:sc0.name}) WHERE NOT (p)-[:APPLICABLE_IN]->(sc1) MERGE (p)-[r:APPLICABLE_IN]->(sc1) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp()…
MATCH (p:Policy)-[:APPLICABLE_IN]->(sc0:Scope{version:?}) MATCH (sc1:Scope{version:?,name:sc0.name}) WHERE NOT (p)-[:APPLICABLE_IN]->(sc1) MERGE (p)-[r:APPLICABLE_IN]->(sc1) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
write onboardingsvc
1 0 ms <1 ms 0 ms flat
MATCH(a:Role{tildaid:$a_tildaid}) WHERE a.updatedat=$a_lastUpdated SET a.updatedat=timestamp(),a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.deltimestamp=$a_deltimestamp,a.name=$a_name,a.displayName=$a_displayName,a.listed=$a_lis…
MATCH(a:Role{tildaid:$a_tildaid}) WHERE a.updatedat=$a_lastUpdated SET a.updatedat=timestamp(),a.holdbitmap=$a_holdbitmap,a.delpending=$a_delpending,a.deltimestamp=$a_deltimestamp,a.name=$a_name,a.displayName=$a_displayName,a.listed=$a_listed,a.assignDuty=$a_assignDuty,a.piiAccess=$a_piiAccess,a.description=$a_description,a.tags=$a_tags,a.external=$a_external RETURN count(a)
write onboardingsvc
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)
studiosvc
1 0 ms <1 ms 0 ms flat
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
MATCH (m:TildaDataMigration {owner: $owner}) RETURN m.id, m.status, m.attempts, m.lastError
studiosvc
1 0 ms <1 ms 0 ms flat
MATCH (w:WorkOrder) WHERE w.source_id IN $sourceIds AND (w.delpending = false OR w.delpending IS NULL) RETURN w.source_id, w.tildaid
MATCH (w:WorkOrder) WHERE w.source_id IN $sourceIds AND (w.delpending = false OR w.delpending IS NULL) RETURN w.source_id, w.tildaid
execsvc
4 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
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:Job{tildaid:$a_tildaid}),(b:SMSNotification{tildaid:$b_tildaid}) MERGE (a)-[r:JOB_TO_SMS_NOTIFICATION]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
MATCH (a:Job{tildaid:$a_tildaid}),(b:SMSNotification{tildaid:$b_tildaid}) MERGE (a)-[r:JOB_TO_SMS_NOTIFICATION]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
write schedsvc
4 0 ms <1 ms 0 ms flat
MATCH (o:Organization {alias: $alias}) RETURN o.tildaid AS tildaid, o.alias AS alias, o.name AS name LIMIT ?
MATCH (o:Organization {alias: $alias}) RETURN o.tildaid AS tildaid, o.alias AS alias, o.name AS name LIMIT ?
ontologysvc
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
write execsvc
2,658 <1 ms <1 ms 14 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
write execsvc
2,658 <1 ms <1 ms 10 ms flat
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
execsvc
2,658 <1 ms <1 ms 15 ms flat
MATCH (root:GraphNode{tildaid:$graphId})-[:GRAPH_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->(chain:ActivationRuleChain) MATCH (rule:ActivationRule)-[ruleRel:ACTIVATION_RULE_TO_CHAIN{graphid:$graphId}]->(chain) MATCH (rule)-[:ACTIVATION_R…
MATCH (root:GraphNode{tildaid:$graphId})-[:GRAPH_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->(chain:ActivationRuleChain) MATCH (rule:ActivationRule)-[ruleRel:ACTIVATION_RULE_TO_CHAIN{graphid:$graphId}]->(chain) MATCH (rule)-[:ACTIVATION_RULE_TO_BRANCH_CONFIG{graphid:$graphId}]->(brConfig:BranchConfig) OPTIONAL MATCH (brConfig)-[:BRANCH_CFG_TO_GRAPH_NODE_REF{graphid:$relPropValue}]->(cfgRef:GraphNodeRef) WITH chain, rule, ruleRel, brConfig, collect(DISTINCT cfgRef.tildaid) as branchCfgRefIds MATCH (ref:GraphNode)-[:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->(chain) OPTIONAL MATCH (ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{graphid:$relPropValue}]->(gnode:GraphNode) WHERE ref.objtype = ? OPTIONAL MATCH (ref)-[:GRAPH_NODE_REF_TO_QUESTION{graphid:$relPropValue}]->(question:QuestionV2) WHERE gnode.objtype = ? RETURN {chain:chain, rule:rule, ruleType:ruleRel.type, branchConfig:brConfig, branchCfgRefIds:branchCfgRefIds, refNodeId:CASE WHEN gnode.objtype = ? THEN question.tildaid ELSE coalesce(gnode.tildaid, ref.tildaid) END}
execsvc
25 <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
299 <1 ms <1 ms 1 ms flat
MATCH (p:FormV2{tildaid:$parentID})-[:CONTAINS_FORM]->(c:FormV2{tildaid:$childID}) RETURN ? LIMIT ?
MATCH (p:FormV2{tildaid:$parentID})-[:CONTAINS_FORM]->(c:FormV2{tildaid:$childID}) RETURN ? LIMIT ?
studiosvc
565 <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
1,036 <1 ms 1 ms 1 ms flat
match(dupVisit:VisitV2{tildaid:$dupVisitId}) match(dupPre:PrePostVisitV2{tildaid:$dupPreId}) match(dupPost:PrePostVisitV2{tildaid:$dupPostId}) merge(dupVisit)-[:VISIT_TO_PREVISIT]->(dupPre) merge(dupVisit)-[:VISIT_TO_POSTVISIT]->(dupPost)
match(dupVisit:VisitV2{tildaid:$dupVisitId}) match(dupPre:PrePostVisitV2{tildaid:$dupPreId}) match(dupPost:PrePostVisitV2{tildaid:$dupPostId}) merge(dupVisit)-[:VISIT_TO_PREVISIT]->(dupPre) merge(dupVisit)-[:VISIT_TO_POSTVISIT]->(dupPost)
write studiosvc
18 <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
582 <1 ms 1 ms 2 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
68 <1 ms 1 ms 2 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) SET cfg.instanceItemCreationClaimedAtMs = ?, cfg.updatedat = timestamp()
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) SET cfg.instanceItemCreationClaimedAtMs = ?, cfg.updatedat = timestamp()
write workplansvc
616 <1 ms 1 ms 2 ms 0.7× ↓
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
302 <1 ms 1 ms 1 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
36 <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
1,104 <1 ms 1 ms 11 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
442 <1 ms 1 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
1,316 <1 ms 1 ms 59 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
1,417 <1 ms 1 ms 4 ms flat
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]…
MATCH (doc:Document{tildaid:$docId})-[:DOCUMENT_VERSION]->(dv:DocumentVersion) WITH dv ORDER BY dv.majorVersion DESC, dv.minorVersion DESC LIMIT ? UNWIND $clogIds AS clogId MATCH (clog:ChangeLog{tildaid:clogId}) MERGE (dv)-[:ALL_CHANGELOG]->(clog)
write docsvc
10 <1 ms 2 ms 1 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
134 <1 ms 2 ms 1 ms 1.6× ↑
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
write data_monitor
1,262 <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
404 <1 ms 2 ms 10 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
1,351 <1 ms 2 ms 29 ms flat
MATCH (pobj:ParticipantTable{nodeId:$pobjId})-[:PARTICIPANT_VARIABLE]-(pv:ParticipantVariable)-[:BELONGS_TO_VARIABLE]->(v:VariableV2) return {v:v, pv:pv}
MATCH (pobj:ParticipantTable{nodeId:$pobjId})-[:PARTICIPANT_VARIABLE]-(pv:ParticipantVariable)-[:BELONGS_TO_VARIABLE]->(v:VariableV2) return {v:v, pv:pv}
execsvc
72 <1 ms 2 ms 27 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
1,417 <1 ms 2 ms 8 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
593 <1 ms 2 ms 3 ms 0.8× ↓
match (obj:QuestionnaireV2{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
match (obj:QuestionnaireV2{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
execsvc
92 <1 ms 2 ms 28 ms flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(instance:WorkPlanInstance)-[:WORKPLAN_TO_SITE]->(site:Site) RETURN DISTINCT site.tildaid as siteId
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(instance:WorkPlanInstance)-[:WORKPLAN_TO_SITE]->(site:Site) RETURN DISTINCT site.tildaid as siteId
workplansvc
591 <1 ms 2 ms 4 ms 0.8× ↓
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
1,084 <1 ms 2 ms 9 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
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(a:Patient{tildaid:$a_tildaid})-[r:HAS_PRESCRIPTION_FOR]->(b:Medication{delpending:$b_delpending}) RETURN count(r)
MATCH(a:Patient{tildaid:$a_tildaid})-[r:HAS_PRESCRIPTION_FOR]->(b:Medication{delpending:$b_delpending}) RETURN count(r)
patientsvc
6 <1 ms 2 ms 1 ms flat
MATCH(a:Patient{tildaid:$a_tildaid})-[r:DIAGNOSED_WITH]->(b:MedicalCondition{delpending:$b_delpending}) RETURN count(r)
MATCH(a:Patient{tildaid:$a_tildaid})-[r:DIAGNOSED_WITH]->(b:MedicalCondition{delpending:$b_delpending}) RETURN count(r)
patientsvc
6 <1 ms 2 ms 1 ms flat
MATCH(a:Patient{tildaid:$a_tildaid})-[r:HAD_PROCEDURE]->(b:Procedure{delpending:$b_delpending}) RETURN count(r)
MATCH(a:Patient{tildaid:$a_tildaid})-[r:HAD_PROCEDURE]->(b:Procedure{delpending:$b_delpending}) RETURN count(r)
patientsvc
6 <1 ms 2 ms 1 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
44 <1 ms 2 ms 3 ms flat
MATCH (m:WorkPlanMilestone{tildaid:$milestoneId})-[r:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) OPTIONAL MATCH (item)-[depRel:WORKPLAN_MILESTONE_ITEM_DEPENDENCY]->(dep:WorkPlanMilestoneItemDependency)-[:DEPENDS_ON]…
MATCH (m:WorkPlanMilestone{tildaid:$milestoneId})-[r:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) 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 ORDER BY item.position
workplansvc
3,486 <1 ms 2 ms 12 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
1,113 <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
621 <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(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
5 <1 ms 2 ms 1 ms flat
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask)-[:TASK_HAS_SUBTASK]->(s:WorkOrderSubtask) WHERE coalesce(t.status, ?) <> ? AND coalesce(s.is_optional, false) = false AND coalesce(s.status, ?) <> ? AND…
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_TASK]->(t:WorkOrderTask)-[:TASK_HAS_SUBTASK]->(s:WorkOrderSubtask) WHERE coalesce(t.status, ?) <> ? AND coalesce(s.is_optional, false) = false AND coalesce(s.status, ?) <> ? AND (coalesce(s.expects_document, false) = true OR s.expects_document IS NULL OR s.placeholder_id IS NOT NULL OR s.sent_doc_id IS NOT NULL OR s.received_doc_id IS NOT NULL) RETURN count(s) AS cnt
virtual-assistant
39 <1 ms 2 ms 1 ms flat
MATCH (n:WorkOrderConfig {tildaid: $node_id}) RETURN n
MATCH (n:WorkOrderConfig {tildaid: $node_id}) RETURN n
virtual-assistant
48 <1 ms 2 ms 1 ms flat
MATCH (cp:CarePlan {tildaid:$cpId})-[:CAREPLAN_TO_ALL_PARTICIPANTVISITS]-(pv:ParticipantVisit) RETURN coalesce(pv.visitId, ?) AS visitId, coalesce(pv.status, ?) AS status, coalesce(pv.edcStatus, ?) AS edcStatus
MATCH (cp:CarePlan {tildaid:$cpId})-[:CAREPLAN_TO_ALL_PARTICIPANTVISITS]-(pv:ParticipantVisit) RETURN coalesce(pv.visitId, ?) AS visitId, coalesce(pv.status, ?) AS status, coalesce(pv.edcStatus, ?) AS edcStatus
execsvc
70 <1 ms 2 ms 1 ms flat
MATCH (d:Document {status: $status, archived: true})-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid, o.tildaid, o.alias LIMIT ?
MATCH (d:Document {status: $status, archived: true})-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid, o.tildaid, o.alias LIMIT ?
docsvc
1,365 <1 ms 2 ms 6 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
455 <1 ms 2 ms 7 ms flat
match (a{tildaid:$aId}) where a:ActivityV2 or a:Activity return {a:a}
match (a{tildaid:$aId}) where a:ActivityV2 or a:Activity return {a:a}
execsvc
69 <1 ms 2 ms 1 ms flat
MATCH (pobj:ParticipantQuestionnaire{nodeId:$pobjId})-[:PARTICIPANT_VARIABLE]-(pv:ParticipantVariable)-[:BELONGS_TO_VARIABLE]->(v:VariableV2) return {v:v, pv:pv}
MATCH (pobj:ParticipantQuestionnaire{nodeId:$pobjId})-[:PARTICIPANT_VARIABLE]-(pv:ParticipantVariable)-[:BELONGS_TO_VARIABLE]->(v:VariableV2) return {v:v, pv:pv}
execsvc
96 <1 ms 2 ms 24 ms 3.2× ↑
MATCH(a:Training{tildaid:$a_tildaid}) RETURN a
MATCH(a:Training{tildaid:$a_tildaid}) RETURN a
execsvc
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
notifsvc
4 <1 ms 2 ms 1 ms flat
MATCH(a:Phi{tildaid:$a_tildaid}) RETURN a
MATCH(a:Phi{tildaid:$a_tildaid}) RETURN a
notifsvc
4 <1 ms 2 ms 1 ms flat
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_STUDY]->(study:Study) OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_PLAN_TYPE]->(pt:WorkPlanType) OPTIONAL MATCH (c…
MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg:WorkplanCfg{tildaid:$cfgId}) OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_STUDY]->(study:Study) OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_PLAN_TYPE]->(pt:WorkPlanType) OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_TEMPLATE]->(template:WorkPlanTemplate) RETURN cfg, org.tildaid as orgId, study.tildaid as studyId, pt.tildaid as planTypeId, template.tildaid as templateId
workplansvc
1,236 <1 ms 2 ms 7 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
1,371 <1 ms 2 ms 23 ms flat
match (u:User{tildaid:$userId})-[:FOR_USER]-(a:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(o:Organization{alias:$scaleAlias}) where coalesce(a.state, ?) <> ? return a.tildaid
match (u:User{tildaid:$userId})-[:FOR_USER]-(a:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(o:Organization{alias:$scaleAlias}) where coalesce(a.state, ?) <> ? return a.tildaid
docsvc
11 <1 ms 2 ms 1 ms flat
MATCH (d:Document {status: $status, archived: true})-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid, o.tildaid, o.alias LIMIT ?
MATCH (d:Document {status: $status, archived: true})-[:DOC_TO_ORG]->(o:Organization) RETURN d.tildaid, o.tildaid, o.alias LIMIT ?
docsvc
1,489 <1 ms 2 ms 14 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).