Xray
hourly rollups 1h 6h 24h 48h 3d 5d 7d 14d 30d ‹
Last 3 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-20 15:16:11.
› →|
updated 2d 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 2d ago top 80 of 2,064

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

Columns
Views
Export CSV
Query shape Count Avg p95 ▴ Max p95 drift
MATCH (a:Actor{tildaid:$id})-[:STUDYSITEACTOR_TO_ACTOR]-(ssa:StudySiteActor) OPTIONAL MATCH (ssa)-[:STUDYSITEACTOR_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition) OPTIONAL MATCH (ssa)-[:STUDYSITEDUTY_TO_STUDYSITEACTOR]-(ssd:StudySiteDuty{delpen…
MATCH (a:Actor{tildaid:$id})-[:STUDYSITEACTOR_TO_ACTOR]-(ssa:StudySiteActor) OPTIONAL MATCH (ssa)-[:STUDYSITEACTOR_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition) OPTIONAL MATCH (ssa)-[:STUDYSITEDUTY_TO_STUDYSITEACTOR]-(ssd:StudySiteDuty{delpending:false})-[:DUTY_TO_STUDYSITEDUTY]-(d:Duty) RETURN ssa.tildaid, ssa.roles, ssa.location, pd.scopeId, pd.scopeName, collect(CASE WHEN d IS NOT NULL THEN {dutyId: d.tildaid, title: d.title, number: d.number, status: ssd.status, startDate: ssd.startDate, endDate: ssd.endDate, removed: ssd.removed} END)
enrollsvc
3 0 ms <1 ms 0 ms flat
MATCH (j:TMFSyncJob {status: ?}) WHERE j.claim_expires_at < $now_ms RETURN j.id AS id, j.org_alias AS org_alias, j.study_id AS study_id, j.sync_config_id AS sync_config_id, j.connector_type AS connector_type, j.claimed_by AS dead_pod, j.cl…
MATCH (j:TMFSyncJob {status: ?}) WHERE j.claim_expires_at < $now_ms RETURN j.id AS id, j.org_alias AS org_alias, j.study_id AS study_id, j.sync_config_id AS sync_config_id, j.connector_type AS connector_type, j.claimed_by AS dead_pod, j.claim_expires_at AS claim_expires_at, j.lane AS lane LIMIT ?
tmfsync
9 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
6 0 ms <1 ms 0 ms flat
CREATE CONSTRAINT user_key IF NOT EXISTS FOR (u:User) REQUIRE (u.group_id, u.external_id) IS NODE KEY
CREATE CONSTRAINT user_key IF NOT EXISTS FOR (u:User) REQUIRE (u.group_id, u.external_id) IS NODE KEY
write chat-agent
2 0 ms <1 ms 0 ms flat
CREATE CONSTRAINT org_group IF NOT EXISTS FOR (o:Org) REQUIRE o.group_id IS UNIQUE
CREATE CONSTRAINT org_group IF NOT EXISTS FOR (o:Org) REQUIRE o.group_id IS UNIQUE
write chat-agent
2 0 ms <1 ms 0 ms flat
CREATE INDEX about_ext IF NOT EXISTS FOR ()-[a:ABOUT]-() ON (a.external_id)
CREATE INDEX about_ext IF NOT EXISTS FOR ()-[a:ABOUT]-() ON (a.external_id)
write chat-agent
2 0 ms <1 ms 0 ms flat
CREATE INDEX insight_scope IF NOT EXISTS FOR (i:Insight) ON (i.group_id, i.category)
CREATE INDEX insight_scope IF NOT EXISTS FOR (i:Insight) ON (i.group_id, i.category)
write chat-agent
2 0 ms <1 ms 0 ms flat
CREATE INDEX insight_inval IF NOT EXISTS FOR (i:Insight) ON (i.invalid_at)
CREATE INDEX insight_inval IF NOT EXISTS FOR (i:Insight) ON (i.invalid_at)
write chat-agent
2 0 ms <1 ms 0 ms flat
CREATE CONSTRAINT type_key IF NOT EXISTS FOR (t:EntityType) REQUIRE (t.group_id, t.kind) IS NODE KEY
CREATE CONSTRAINT type_key IF NOT EXISTS FOR (t:EntityType) REQUIRE (t.group_id, t.kind) IS NODE KEY
write chat-agent
2 0 ms <1 ms 0 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
2 0 ms <1 ms 0 ms flat
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
onboardingsvc
7 0 ms <1 ms 0 ms flat
MATCH (n:AIRun {tildaid: $node_id}) RETURN n
MATCH (n:AIRun {tildaid: $node_id}) RETURN n
docproc
1 0 ms <1 ms 0 ms flat
MATCH (a:Recommendation {tildaid: $from_id}) MATCH (b:Organization {tildaid: $to_id}) CREATE (a)-[r:RECOMMENDATION_TO_ORGANIZATION]->(b) SET r = $properties, r.createdat = timestamp() RETURN r
MATCH (a:Recommendation {tildaid: $from_id}) MATCH (b:Organization {tildaid: $to_id}) CREATE (a)-[r:RECOMMENDATION_TO_ORGANIZATION]->(b) SET r = $properties, r.createdat = timestamp() RETURN r
write docproc
1 0 ms <1 ms 0 ms flat
MATCH (d:Document {tildaid: $doc_id}) SET d.cbrRunStatus = $status, d.cbrRunStatusAt = $ts
MATCH (d:Document {tildaid: $doc_id}) SET d.cbrRunStatus = $status, d.cbrRunStatusAt = $ts
write docproc
1 0 ms <1 ms 0 ms flat
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
MATCH (item:WorkplanInstanceMilestoneItem{cfgMilestoneItemId:$cfgMilestoneItemId, scopeId:$scopeId}) RETURN item
workplansvc
7 0 ms <1 ms 0 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
execsvc
1 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
1 0 ms <1 ms 0 ms flat
MATCH (pa:Patient {tildaid: $patientId})-[:RESEARCH_SUBJECT]-(cp:CarePlan) -[:VISIT_APPOINTMENT_TO_CARE_PLAN]-(v:VisitAppointment) WHERE v.startTime < datetime() AND v.state <> ? RETURN v.startTime ORDER BY v.startTime DESC LIMIT ?
MATCH (pa:Patient {tildaid: $patientId})-[:RESEARCH_SUBJECT]-(cp:CarePlan) -[:VISIT_APPOINTMENT_TO_CARE_PLAN]-(v:VisitAppointment) WHERE v.startTime < datetime() AND v.state <> ? RETURN v.startTime ORDER BY v.startTime DESC LIMIT ?
patientsvc
1 0 ms <1 ms 0 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
1 0 ms <1 ms 0 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
7 0 ms <1 ms 0 ms flat
CREATE CONSTRAINT tmfsync_audit_id_unique IF NOT EXISTS FOR (a:TMFSyncConfigAudit) REQUIRE a.id IS UNIQUE
CREATE CONSTRAINT tmfsync_audit_id_unique IF NOT EXISTS FOR (a:TMFSyncConfigAudit) REQUIRE a.id IS UNIQUE
write tmfsync
2 0 ms <1 ms 0 ms flat
CREATE CONSTRAINT tmfsync_item_idempotency_key_unique IF NOT EXISTS FOR (i:TMFSyncItem) REQUIRE i.idempotency_key IS UNIQUE
CREATE CONSTRAINT tmfsync_item_idempotency_key_unique IF NOT EXISTS FOR (i:TMFSyncItem) REQUIRE i.idempotency_key IS UNIQUE
write tmfsync
2 0 ms <1 ms 0 ms flat
CREATE INDEX tmfsync_item_tenant_config IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.org_alias, i.study_id, i.sync_config_id)
CREATE INDEX tmfsync_item_tenant_config IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.org_alias, i.study_id, i.sync_config_id)
write tmfsync
2 0 ms <1 ms 0 ms flat
CREATE CONSTRAINT tmfsync_org_settings_unique IF NOT EXISTS FOR (o:OrgSyncSettings) REQUIRE (o.org_alias, o.connector_type) IS UNIQUE
CREATE CONSTRAINT tmfsync_org_settings_unique IF NOT EXISTS FOR (o:OrgSyncSettings) REQUIRE (o.org_alias, o.connector_type) IS UNIQUE
write tmfsync
2 0 ms <1 ms 0 ms flat
CREATE INDEX tmfsync_item_tenant IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.org_alias, i.study_id)
CREATE INDEX tmfsync_item_tenant IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.org_alias, i.study_id)
write tmfsync
2 0 ms <1 ms 0 ms flat
CREATE CONSTRAINT tmfsync_job_id_unique IF NOT EXISTS FOR (j:TMFSyncJob) REQUIRE j.id IS UNIQUE
CREATE CONSTRAINT tmfsync_job_id_unique IF NOT EXISTS FOR (j:TMFSyncJob) REQUIRE j.id IS UNIQUE
write tmfsync
2 0 ms <1 ms 0 ms flat
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
match(a:AdvCampaign)-[r:DRAFT_CONFIG|PUBLISHED_CONFIG]->(b) where b.studyid=$studyId and b.autositeupdate=true with b match(s:Site{tildaid:$siteId}) merge (b)-[r:HAS_SITES]->(s)
write advpsvc
2 0 ms <1 ms 0 ms flat
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write enrollsvc
20 0 ms <1 ms 0 ms flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
4 0 ms <1 ms 0 ms flat
MATCH (a:StudySiteActor{tildaid:$a_tildaid}),(b:DslPlanDefinition{tildaid:$b_tildaid}) MERGE (a)-[r:STUDYSITEACTOR_TO_PLAN_DEFINITION]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timest…
MATCH (a:StudySiteActor{tildaid:$a_tildaid}),(b:DslPlanDefinition{tildaid:$b_tildaid}) MERGE (a)-[r:STUDYSITEACTOR_TO_PLAN_DEFINITION]->(b) ON CREATE SET r.tildaid = randomUUID(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() RETURN count(r)
write execsvc
2 0 ms <1 ms 0 ms flat
MATCH (doc:Document {tildaid: $doc_id}) MATCH (ph:Document)-[rel:MATCHING_DOCUMENT|ACCEPTED_DOCUMENT]->(doc) MATCH (ph)-[:SCOPED_TO]->(es:EventScope) MATCH (es)-[:PART_OF_EVENT]->(e:Event {orgId: $org_id}) MATCH (d:Deliverable)-[:TRACKS_PL…
MATCH (doc:Document {tildaid: $doc_id}) MATCH (ph:Document)-[rel:MATCHING_DOCUMENT|ACCEPTED_DOCUMENT]->(doc) MATCH (ph)-[:SCOPED_TO]->(es:EventScope) MATCH (es)-[:PART_OF_EVENT]->(e:Event {orgId: $org_id}) MATCH (d:Deliverable)-[:TRACKS_PLACEHOLDER]->(ph) RETURN ph.tildaid AS placeholderId, ph.fileName AS placeholderName, e.tildaid AS eventId, es.tildaid AS eventScopeId, d.tmfTildaId AS subartifactId, es.scopeType AS scopeType, es.scopeId AS scopeId, type(rel) AS relationshipType
virtual-assistant
1 0 ms <1 ms 0 ms flat
MATCH (s:Study {tildaid: $study_id})-[:USES]->(fm:FolderManager)-[:INCLUDES]->(f:Folder) MATCH (f)-[:INCLUDES*]->(sa:SubArtifact {tildaid: $subartifact_id}) MATCH (e:Event {orgId: $org_id})-[:REQUIRES_RESOLUTION_OF]->(d:Deliverable {tmfTil…
MATCH (s:Study {tildaid: $study_id})-[:USES]->(fm:FolderManager)-[:INCLUDES]->(f:Folder) MATCH (f)-[:INCLUDES*]->(sa:SubArtifact {tildaid: $subartifact_id}) MATCH (e:Event {orgId: $org_id})-[:REQUIRES_RESOLUTION_OF]->(d:Deliverable {tmfTildaId: sa.tildaid}) MATCH (e)<-[:PART_OF_EVENT]-(es:EventScope {scopeType: $scope_type, scopeId: $scope_id}) WHERE NOT e.status IN [?, ?, ?] AND es.status = ? RETURN DISTINCT e.tildaid AS eventId
virtual-assistant
1 0 ms <1 ms 0 ms flat
match(a:Study{tildaid:$studyId}) match(b:Organization{tildaid:$orgId}) merge(a)-[r:STUDY_TO_ORG]->(b) set r.inherited=$inherited
match(a:Study{tildaid:$studyId}) match(b:Organization{tildaid:$orgId}) merge(a)-[r:STUDY_TO_ORG]->(b) set r.inherited=$inherited
write enrollsvc
5 0 ms <1 ms 0 ms flat
CREATE INDEX tmfsync_item_config_rec IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.tilda_rec_id)
CREATE INDEX tmfsync_item_config_rec IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.tilda_rec_id)
write tmfsync
1 0 ms <1 ms 0 ms flat
CREATE INDEX tmfsync_job_tenant IF NOT EXISTS FOR (j:TMFSyncJob) ON (j.org_alias, j.study_id)
CREATE INDEX tmfsync_job_tenant IF NOT EXISTS FOR (j:TMFSyncJob) ON (j.org_alias, j.study_id)
write tmfsync
1 0 ms <1 ms 0 ms flat
CREATE INDEX tmfsync_item_config_external IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.external_id)
CREATE INDEX tmfsync_item_config_external IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.external_id)
write tmfsync
1 0 ms <1 ms 0 ms flat
MATCH (c:CtmsSyncConfig {id: $config_id}) WHERE coalesce(c.last_sync_at, ?) < $last_sync_at SET c.last_sync_at = $last_sync_at, c.updated_at = $last_sync_at
MATCH (c:CtmsSyncConfig {id: $config_id}) WHERE coalesce(c.last_sync_at, ?) < $last_sync_at SET c.last_sync_at = $last_sync_at, c.updated_at = $last_sync_at
write tmfsync
4 0 ms <1 ms 0 ms flat
CREATE INDEX tmfsync_item_config_tilda IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.tilda_doc_id)
CREATE INDEX tmfsync_item_config_tilda IF NOT EXISTS FOR (i:TMFSyncItem) ON (i.sync_config_id, i.tilda_doc_id)
write tmfsync
1 0 ms <1 ms 0 ms flat
MATCH (c:CtmsSyncConfig {id: $config_id}) SET c.ingress_last_success_at = $ended_at, c.ingress_failed_items = $failed_items, c.ingress_skipped = $skipped REMOVE c.ingress_failing_since, c.ingress_last_error, c.ingress_paused_reason, c.ingr…
MATCH (c:CtmsSyncConfig {id: $config_id}) SET c.ingress_last_success_at = $ended_at, c.ingress_failed_items = $failed_items, c.ingress_skipped = $skipped REMOVE c.ingress_failing_since, c.ingress_last_error, c.ingress_paused_reason, c.ingress_paused_at
write tmfsync
4 0 ms <1 ms 0 ms flat
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND coalesce(a.ignoreType,?) <> ? RETURN count(a) as total
MATCH (w:WorkOrder {tildaid: $work_order_id})-[:WORK_ORDER_TO_ACTIVITY]->(a:WorkOrderActivity) WHERE ?=? AND coalesce(a.ignoreType,?) <> ? RETURN count(a) as total
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
docsvc
2 0 ms <1 ms 0 ms flat
match(a:Study{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Study{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write tusker
1 0 ms <1 ms 0 ms flat
match(a:Study{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Study{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write tusker
1 0 ms <1 ms 0 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
4 0 ms <1 ms 0 ms flat
MATCH (p:Policy {name:$name}) SET p.state = $state
MATCH (p:Policy {name:$name}) SET p.state = $state
write onboardingsvc
54 0 ms <1 ms 0 ms flat
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
write studiosvc
7,529 <1 ms <1 ms 14 ms flat
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write onboardingsvc
364 <1 ms <1 ms 1 ms flat
match(a:StudySiteActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:StudySiteActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write execsvc
225 <1 ms <1 ms 13 ms flat
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Organization{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write tusker
207 <1 ms <1 ms 1 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
99 <1 ms <1 ms 9 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
97 <1 ms <1 ms 6 ms flat
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
execsvc
97 <1 ms <1 ms 4 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
354 <1 ms <1 ms 1 ms flat
match(a:DocSeqCounter{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:DocSeqCounter{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write onboardingsvc
176 <1 ms <1 ms 9 ms flat
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
unwind $nodeIds as nodeId match(node:GraphNode{tildaid:nodeId})-[r:GRAPH_NODE_TO_ACTIVATION_RULE_CHAIN{graphid:$graphId}]->() delete r
write studiosvc
817 <1 ms <1 ms 3 ms flat
match(node:GraphNode{tildaid:$objId})<-[r:GRAPH_NEXT{graphid:$graphId}]-() where apoc.coll.intersection(apoc.coll.sort(r.path), apoc.coll.sort($path))=apoc.coll.sort($path) set r.flags=apoc.bitwise.op(apoc.bitwise.op(r.flags, ?, apoc.bitwi…
match(node:GraphNode{tildaid:$objId})<-[r:GRAPH_NEXT{graphid:$graphId}]-() where apoc.coll.intersection(apoc.coll.sort(r.path), apoc.coll.sort($path))=apoc.coll.sort($path) set r.flags=apoc.bitwise.op(apoc.bitwise.op(r.flags, ?, apoc.bitwise.op(?, ?,?)), ?, $flags), r.who=$who
write studiosvc
7,529 <1 ms <1 ms 10 ms flat
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Actor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write onboardingsvc
370 <1 ms <1 ms 1 ms flat
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
cypher runtime=slotted return reduce(res=null, x in $list | CASE WHEN res IS NULL OR res<x THEN x ELSE res END) as value
dashrsvc
196 <1 ms <1 ms 2 ms flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pa:ParticipantActivity) optional match (cp:CarePlan{tildaid: pa.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pa:ParticipantActivity) optional match (cp:CarePlan{tildaid: pa.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (pa)-[: BELONGS_TO_ACTIVITY]->(a:Activity) optional match (pa)-[:PARTICIPANT_ACTIVITY]-(:ParticipantVisit)-[:BELONGS_TO_VISIT]-(v) where v:Visit or v:VisitV2 optional match (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pa)-[:PARTICIPANT_DOCUMENTSET]-(pds:ParticipantDocumentSet)-[:BELONGS_TO_DOCUMENTSET]-(ds:DocumentSet) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pa, site, v, p, phi, ds, a, cp, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, Phi: phi, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, User: u, AssignedUser: auCollected, CarePlan: cp, Activity: a, Visit : v, DocumentSet: ds, Patient: p, CreatedBy: createdBy}
tusker
46 <1 ms <1 ms 1 ms flat
MATCH (:WorkPlanInstance{tildaid:$instanceId})-[:WORKPLAN_INSTANCE_TO_RESOLVED_VARIABLE]->(rv:WorkPlanResolvedVariable{variableId:$variableId}) RETURN rv.status, rv.value, rv.fromSourceType, rv.fromSourceRef, rv.resolvedAt, rv.confidence, …
MATCH (:WorkPlanInstance{tildaid:$instanceId})-[:WORKPLAN_INSTANCE_TO_RESOLVED_VARIABLE]->(rv:WorkPlanResolvedVariable{variableId:$variableId}) RETURN rv.status, rv.value, rv.fromSourceType, rv.fromSourceRef, rv.resolvedAt, rv.confidence, rv.rawExcerpt, rv.reason
workplansvc
9,687 <1 ms <1 ms 17 ms flat
match(node:GraphNode{tildaid:$objId})<-[r:GRAPH_NEXT{graphid:$graphId}]-() where apoc.coll.intersection(apoc.coll.sort(r.path), apoc.coll.sort($path))=apoc.coll.sort($path) set r.flags=apoc.bitwise.op(apoc.bitwise.op(r.flags, ?, apoc.bitwi…
match(node:GraphNode{tildaid:$objId})<-[r:GRAPH_NEXT{graphid:$graphId}]-() where apoc.coll.intersection(apoc.coll.sort(r.path), apoc.coll.sort($path))=apoc.coll.sort($path) set r.flags=apoc.bitwise.op(apoc.bitwise.op(r.flags, ?, apoc.bitwise.op(?, ?,?)), ?, $flags), r.who=$who
write studiosvc
817 <1 ms <1 ms 5 ms flat
MATCH (s:Site{tildaid:$siteId})-[:SITE_TO_SMO]->(:Smo)-[:IS_AN_ORG]->(o:Organization) RETURN o
MATCH (s:Site{tildaid:$siteId})-[:SITE_TO_SMO]->(:Smo)-[:IS_AN_ORG]->(o:Organization) RETURN o
onboardingsvc
32 <1 ms <1 ms 1 ms flat
match(a:Site{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:Site{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
write tusker
117 <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
292 <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
258 <1 ms <1 ms 2 ms flat
MATCH (:WorkPlanInstance{tildaid:$instanceId})-[:WORKPLAN_INSTANCE_TO_RESOLVED_VARIABLE]->(rv:WorkPlanResolvedVariable{variableId:$variableId}) RETURN rv.status, rv.value, rv.fromSourceType, rv.fromSourceRef, rv.resolvedAt, rv.confidence, …
MATCH (:WorkPlanInstance{tildaid:$instanceId})-[:WORKPLAN_INSTANCE_TO_RESOLVED_VARIABLE]->(rv:WorkPlanResolvedVariable{variableId:$variableId}) RETURN rv.status, rv.value, rv.fromSourceType, rv.fromSourceRef, rv.resolvedAt, rv.confidence, rv.rawExcerpt, rv.reason
workplansvc
4,956 <1 ms <1 ms 7 ms flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem{tildaid:$cfgMilestoneItemId}) WHERE item.itemType = ? RETURN cfg.tildaid AS cfgId, coa…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem{tildaid:$cfgMilestoneItemId}) WHERE item.itemType = ? RETURN cfg.tildaid AS cfgId, coalesce(item.itemId, ?) AS itemId, coalesce(milestone.name, ?) AS milestoneName, coalesce(item.itemConfig, ?) AS itemConfig, coalesce(item.checkpointPendingGenId, ?) AS pendingGenId, coalesce(item.checkpointLastComputedGenId, ?) AS lastComputedGenId, coalesce(item.checkpointUnsupportedGenId, ?) AS unsupportedGenId LIMIT ?
workplansvc
4,823 <1 ms <1 ms 5 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
220 <1 ms 1 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
72 <1 ms 1 ms 6 ms flat
MATCH (l:SweepLease {key: $key}) RETURN coalesce(l.swept_at, ?) > ? AS swept
MATCH (l:SweepLease {key: $key}) RETURN coalesce(l.swept_at, ?) > ? AS swept
data_monitor
359 <1 ms 1 ms 17 ms flat
MATCH (d:Document {tildaid: $doc_id})-[:DOC_TO_ORG]->(o:Organization) RETURN o.tildaid as org_id
MATCH (d:Document {tildaid: $doc_id})-[:DOC_TO_ORG]->(o:Organization) RETURN o.tildaid as org_id
docproc
16 <1 ms 1 ms 1 ms 0.8× ↓
MATCH (st:Study {tildaid:$studyId})<-[:PLAN_DEFINITION_TO_STUDY]-(pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_SITE]->(:Site {tildaid:$siteId}) WHERE coalesce(pd.delpending, false) = false MATCH (st)-[:HAS_STAFF_LABEL]->(l:StaffLabel)<-[t:TR…
MATCH (st:Study {tildaid:$studyId})<-[:PLAN_DEFINITION_TO_STUDY]-(pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_SITE]->(:Site {tildaid:$siteId}) WHERE coalesce(pd.delpending, false) = false MATCH (st)-[:HAS_STAFF_LABEL]->(l:StaffLabel)<-[t:TRANSLATES_TO]-(r:Role) WHERE t.planDefinitionId = pd.tildaid RETURN pd.tildaid, r.name, l.tildaid, l.displayName, coalesce(l.delpending, false)
execsvc
16 <1 ms 1 ms 1 ms flat
MATCH(a:Role{tildaid:$a_tildaid})-[r:ROLE_TO_SITE_ROLE]->(b:Role) RETURN b limit $limit
MATCH(a:Role{tildaid:$a_tildaid})-[r:ROLE_TO_SITE_ROLE]->(b:Role) RETURN b limit $limit
onboardingsvc
32 <1 ms 1 ms 1 ms flat
MATCH (t:TokenLedger {study_id: $study_id, day: $day}) RETURN coalesce(t.tokens, ?) AS tokens
MATCH (t:TokenLedger {study_id: $study_id, day: $day}) RETURN coalesce(t.tokens, ?) AS tokens
data_monitor
65 <1 ms 1 ms 5 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
337 <1 ms 1 ms 1 ms flat
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
studiosvc
13 <1 ms 1 ms 1 ms flat
MATCH(a:Site{tildaid:$a_tildaid}) RETURN a
MATCH(a:Site{tildaid:$a_tildaid}) RETURN a
execsvc
13 <1 ms 1 ms 1 ms flat
MATCH (:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_FORM]->(obj{tildaid:$objId}) RETURN true LIMIT ?
MATCH (:Organization{tildaid:$orgId})-[:ORGANIZATION_TO_FORM]->(obj{tildaid:$objId}) RETURN true LIMIT ?
studiosvc
1,440 <1 ms 1 ms 2 ms flat
MATCH (o:Organization{tildaid:$id})-[:ORGANIZATION_TO_CONTACT_AREA]->(ca:ContactArea{kind:?, delpending:false}) RETURN ca.seedKey AS result
MATCH (o:Organization{tildaid:$id})-[:ORGANIZATION_TO_CONTACT_AREA]->(ca:ContactArea{kind:?, delpending:false}) RETURN ca.seedKey AS result
onboardingsvc
606 <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
71 <1 ms 1 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).