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
stored47h agotop 80 of 2,454
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.
MATCH (d:Document {tildaid: $doc_id}) MATCH (ai:AIRun)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(d) WITH ai, d, r, properties(r) AS old_props DELETE r CREATE (ai)-[old_run:AI_RUN_TO_DOCUMENT_OLD]->(d) SET old_run = old_props SET old_run.converted_at…
MATCH (d:Document {tildaid: $doc_id}) MATCH (ai:AIRun)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(d) WITH ai, d, r, properties(r) AS old_props DELETE r CREATE (ai)-[old_run:AI_RUN_TO_DOCUMENT_OLD]->(d) SET old_run = old_props SET old_run.converted_at = timestamp()
writedocproc
3
0 ms
<1 ms
0 ms
flat
MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document {tildaid: $doc_id}) WHERE ai.status IN [?, ?] RETURN ai
MATCH (ai:AIRun)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d:Document {tildaid: $doc_id}) WHERE ai.status IN [?, ?] RETURN ai
docproc
3
0 ms
<1 ms
0 ms
flat
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
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 (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
writedocproc
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
writedocproc
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 (f:ConfigFinding {studyId: $studyId, siteId: $siteId, status: ?}) WITH coalesce(f.entityId, ? + f.entityLabel) AS groupKey, head(collect(f.entityId)) AS entityId, head(collect(f.entityLabel)) AS entityLabel, count(f) AS pending RETUR…
MATCH (f:ConfigFinding {studyId: $studyId, siteId: $siteId, status: ?}) WITH coalesce(f.entityId, ? + f.entityLabel) AS groupKey, head(collect(f.entityId)) AS entityId, head(collect(f.entityLabel)) AS entityLabel, count(f) AS pending RETURN entityId AS entityId, entityLabel AS entityLabel, pending AS pending, entityId IS NULL AS isNew ORDER BY entityLabel
ontologysvc
4
0 ms
<1 ms
0 ms
flat
MATCH (o:Organization{alias:$orgAlias})-[:USES]-(fm:FolderManager) MATCH (s:Study{tildaid:$studyId})-[:USES]-(fm) MATCH (fm)-[:INCLUDES]->(f:Folder{name:$collection}) return f.tildaid
MATCH (o:Organization{alias:$orgAlias})-[:USES]-(fm:FolderManager) MATCH (s:Study{tildaid:$studyId})-[:USES]-(fm) MATCH (fm)-[:INCLUDES]->(f:Folder{name:$collection}) return f.tildaid
docsvc
5
0 ms
<1 ms
0 ms
flat
MATCH (:Study {tildaid:$studyId})-[:HAS_STAFF_LABEL]->(l:StaffLabel)<-[t:TRANSLATES_TO]-(r:Role) WHERE $pdId = ? OR t.planDefinitionId = $pdId RETURN t.planDefinitionId, r.name, l.tildaid, l.displayName, coalesce(l.delpending, false)
MATCH (:Study {tildaid:$studyId})-[:HAS_STAFF_LABEL]->(l:StaffLabel)<-[t:TRANSLATES_TO]-(r:Role) WHERE $pdId = ? OR t.planDefinitionId = $pdId RETURN t.planDefinitionId, r.name, l.tildaid, l.displayName, coalesce(l.delpending, false)
execsvc
2
0 ms
<1 ms
0 ms
flat
MATCH (a:WorkOrderActivity {tildaid: $id}) RETURN a.work_order_id AS workOrderId
MATCH (a:WorkOrderActivity {tildaid: $id}) RETURN a.work_order_id AS workOrderId
feedsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:User{email:$a_email}) RETURN a limit $a_limit
MATCH(a:User{email:$a_email}) RETURN a limit $a_limit
schedsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_MEDIA]->(leaf)
writestudiosvc
4
0 ms
<1 ms
0 ms
flat
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_DOCREVIEW]->(leaf)
writestudiosvc
4
0 ms
<1 ms
0 ms
flat
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE_REF_TO_QUESTION]->(q:QuestionV2) with distinct q match(act:FormV2{til…
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE|GRAPH_NODE_REF_TO_QUESTION]->(q:QuestionV2) with distinct q match(act:FormV2{tildaid:$activityId}) merge(act)-[:ACTIVITY_TO_QUESTION]->(q)
writestudiosvc
4
0 ms
<1 ms
0 ms
flat
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_STATEMENT]->(leaf)
writestudiosvc
4
0 ms
<1 ms
0 ms
flat
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf…
MATCH (act:FormV2 {tildaid: $actId}) MATCH (form:FormV2 {tildaid: $formId}) MATCH (form)-[g:GRAPH_NEXT*?..{graphid: form.tildaid}]->(leaf:GraphNode) WHERE g[-?].path[?] = form.tildaid AND leaf.objtype = $leafObjType WITH DISTINCT act, leaf MERGE (act)-[:ACTIVITY_TO_ESIGN]->(leaf)
writestudiosvc
4
0 ms
<1 ms
0 ms
flat
MATCH (i:EmailIntake) WHERE i.state = $state AND coalesce(i.last_user_reply_at, i.created_at_ms) IS NOT NULL AND coalesce(i.last_user_reply_at, i.created_at_ms) < $cutoff RETURN i AS i
MATCH (i:EmailIntake) WHERE i.state = $state AND coalesce(i.last_user_reply_at, i.created_at_ms) IS NOT NULL AND coalesce(i.last_user_reply_at, i.created_at_ms) < $cutoff RETURN i AS i
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 ?
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
writetmfsync
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
writetmfsync
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)
writetmfsync
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
writetmfsync
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)
writetmfsync
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
writetmfsync
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)
writeadvpsvc
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)
writeenrollsvc
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)
writeexecsvc
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
writeenrollsvc
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)
writetmfsync
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)
writetmfsync
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)
writetmfsync
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
writetmfsync
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)
writetmfsync
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
writetmfsync
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)
writetusker
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)
writetusker
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
writeonboardingsvc
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
writestudiosvc
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)
writeonboardingsvc
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)
writeexecsvc
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)
writetusker
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
writeexecsvc
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
writeexecsvc
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(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)
writeonboardingsvc
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
writestudiosvc
817
<1 ms
<1 ms
3 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
387
<1 ms
<1 ms
1 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
writestudiosvc
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)
writeonboardingsvc
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
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
146
<1 ms
<1 ms
1 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pa:ParticipantActivity) optional match (cp:CarePlan{tildaid: pa.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pa:ParticipantActivity) optional match (cp:CarePlan{tildaid: pa.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (pa)-[: BELONGS_TO_ACTIVITY]->(a:Activity) optional match (pa)-[:PARTICIPANT_ACTIVITY]-(:ParticipantVisit)-[:BELONGS_TO_VISIT]-(v) where v:Visit or v:VisitV2 optional match (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pa)-[:PARTICIPANT_DOCUMENTSET]-(pds:ParticipantDocumentSet)-[:BELONGS_TO_DOCUMENTSET]-(ds:DocumentSet) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pa, site, v, p, phi, ds, a, cp, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, Phi: phi, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, User: u, AssignedUser: auCollected, CarePlan: cp, Activity: a, Visit : v, DocumentSet: ds, Patient: p, CreatedBy: createdBy}
tusker
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, …
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
146
<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
writestudiosvc
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)
writetusker
117
<1 ms
<1 ms
10 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 (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
367
<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 (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 (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
163
<1 ms
1 ms
1 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
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).