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
stored26h agotop 80 of 2,218
Neo4j query shapes on master 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.
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
18
0 ms
<1 ms
0 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(coalesce(r.flags, ?), ?, $flags)
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(coalesce(r.flags, ?), ?, $flags)
writestudiosvc
18
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
41
0 ms
<1 ms
0 ms
flat
MATCH (s:Staff{tildaid:$staffId})-[:IS_USER]-(u:User) RETURN u
MATCH (s:Staff{tildaid:$staffId})-[:IS_USER]-(u:User) RETURN u
schedsvc
3
0 ms
<1 ms
0 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{protocolid:$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{protocolid:$relPropValue}]->(gnode:GraphNode) WHERE ref.objtype = ? OPTIONAL MATCH (ref)-[:GRAPH_NODE_REF_TO_QUESTION{protocolid:$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}
regsvc
3
0 ms
<1 ms
0 ms
flat
MATCH (pv:ParticipantVisit{tildaid:$pvId})<-[:NEXT_PARTICIPANT_VISIT*]- (prev:ParticipantVisit)-[:BELONGS_TO_VISIT]-(v:Visit|VisitV2) WHERE (v.arm is null or v.arm = ? or v.arm = $arm) AND prev.status <> ? AND prev.status <> ? return head(…
MATCH (pv:ParticipantVisit{tildaid:$pvId})<-[:NEXT_PARTICIPANT_VISIT*]- (prev:ParticipantVisit)-[:BELONGS_TO_VISIT]-(v:Visit|VisitV2) WHERE (v.arm is null or v.arm = ? or v.arm = $arm) AND prev.status <> ? AND prev.status <> ? return head(collect({ParticipantVisit:prev,Visit:v})) as prevPV
schedsvc
3
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
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
patientsvc
6
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
23
0 ms
<1 ms
0 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
23
0 ms
<1 ms
0 ms
flat
MATCH (a:AIRun {tildaid: $from_id}) MATCH (b:Document {tildaid: $to_id}) CREATE (a)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(b) SET r = $properties, r.createdat = timestamp() RETURN r
MATCH (a:AIRun {tildaid: $from_id}) MATCH (b:Document {tildaid: $to_id}) CREATE (a)-[r:AI_RUN_TO_DOCUMENT_LATEST]->(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
CREATE (n:AIRun $properties)
CREATE (n:AIRun $properties)
writedocproc
1
0 ms
<1 ms
0 ms
flat
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
1
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
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Document{tildaid:$a_tildaid})-[r:DOCUMENT_TO_SOURCE]->(b:DocumentSource) RETURN b ORDER BY b.majorVersion DESC limit $limit
MATCH(a:Document{tildaid:$a_tildaid})-[r:DOCUMENT_TO_SOURCE]->(b:DocumentSource) RETURN b ORDER BY b.majorVersion DESC limit $limit
execsvc
2
0 ms
<1 ms
0 ms
flat
MATCH (s:Site{delpending:false})-[:SITE_TO_SMO]->(:Smo)-[:IS_AN_ORG]->(o:Organization{tildaid:$callerOrgId}) WHERE true WITH COUNT(s) AS numAll, COUNT(CASE WHEN s.status = ? THEN ? END) AS numActive, COUNT(CASE WHEN s.status = ? THEN ? END…
MATCH (s:Site{delpending:false})-[:SITE_TO_SMO]->(:Smo)-[:IS_AN_ORG]->(o:Organization{tildaid:$callerOrgId}) WHERE true WITH COUNT(s) AS numAll, COUNT(CASE WHEN s.status = ? THEN ? END) AS numActive, COUNT(CASE WHEN s.status = ? THEN ? END) AS numOnboarding, COUNT(CASE WHEN s.status = ? THEN ? END) AS numArchived RETURN distinct apoc.create.vNode([?], { numAll: numAll, numActive: numActive, numOnboarding: numOnboarding, numArchived: numArchived }) AS result
writeonboardingsvc
2
0 ms
<1 ms
0 ms
flat
MATCH (dv:DocumentVersion {tildaid: $version_id})<-[:DOCUMENT_VERSION]-(doc:Document) SET dv.langDetectionStatus = $status, dv.languages = $languages SET doc.languages = $languages, doc.langDetectionStatus = $status
MATCH (dv:DocumentVersion {tildaid: $version_id})<-[:DOCUMENT_VERSION]-(doc:Document) SET dv.langDetectionStatus = $status, dv.languages = $languages SET doc.languages = $languages, doc.langDetectionStatus = $status
writedocproc
2
0 ms
<1 ms
0 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
35
0 ms
<1 ms
0 ms
flat
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category AND NOT EXISTS { MATCH (ai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE ai.evaluation_run_id IS NOT NULL…
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category AND NOT EXISTS { MATCH (ai:AIRun)-[:AI_RUN_TO_RECOMMENDATION]->(r) WHERE ai.evaluation_run_id IS NOT NULL } DETACH DELETE r
writedocproc
2
0 ms
<1 ms
0 ms
flat
MATCH (dv:DocumentVersion {tildaid: $version_id})<-[:DOCUMENT_VERSION]-(doc:Document) SET dv.langDetectionStatus = $status, dv.languages = $languages SET doc.languages = $languages, doc.langDetectionStatus = $status
MATCH (dv:DocumentVersion {tildaid: $version_id})<-[:DOCUMENT_VERSION]-(doc:Document) SET dv.langDetectionStatus = $status, dv.languages = $languages SET doc.languages = $languages, doc.langDetectionStatus = $status
writedocproc
2
0 ms
<1 ms
0 ms
flat
match(visit:VisitV2{tildaid:$id})-[:VISIT_TO_PREVISIT]->(pre:PrePostVisitV2) with visit, pre match(visit)-[:VISIT_TO_POSTVISIT]->(post:PrePostVisitV2) return pre.tildaid, post.tildaid
match(visit:VisitV2{tildaid:$id})-[:VISIT_TO_PREVISIT]->(pre:PrePostVisitV2) with visit, pre match(visit)-[:VISIT_TO_POSTVISIT]->(post:PrePostVisitV2) return pre.tildaid, post.tildaid
studiosvc
5
0 ms
<1 ms
0 ms
flat
MATCH (o:Organization {tildaid: $org_id}) RETURN o.emailCcList AS ccList
MATCH (o:Organization {tildaid: $org_id}) RETURN o.emailCcList AS ccList
virtual-assistant
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid})-[r:USES]->(b:FolderManager{name:$b_name,scopeId:$b_scopeId}) RETURN b limit $limit
MATCH(a:Organization{tildaid:$a_tildaid})-[r:USES]->(b:FolderManager{name:$b_name,scopeId:$b_scopeId}) RETURN b limit $limit
docsvc
2
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 (o:Organization{tildaid: $orgId})-[:USES]->(fm:FolderManager{name:?, scopeId: $studyId}) OPTIONAL MATCH (fm)-[:INSTANTIATED_FROM_TMF_TEMPLATE]->(:TmfTemplate)-[:HAS_PAYLOAD_FOLDER_MANAGER]->(tmplFm:FolderManager) WITH coalesce(tmplFm…
MATCH (o:Organization{tildaid: $orgId})-[:USES]->(fm:FolderManager{name:?, scopeId: $studyId}) OPTIONAL MATCH (fm)-[:INSTANTIATED_FROM_TMF_TEMPLATE]->(:TmfTemplate)-[:HAS_PAYLOAD_FOLDER_MANAGER]->(tmplFm:FolderManager) WITH coalesce(tmplFm, fm) AS dadOwner MATCH (dadOwner)-[:HAS]->(dad:DocAttributeDefinition) RETURN dad ORDER BY toLower(dad.name)
docsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Document{tildaid:$a_tildaid})-[r:REVIEW_IN]->(b:Task) RETURN b limit $limit
MATCH(a:Document{tildaid:$a_tildaid})-[r:REVIEW_IN]->(b:Task) RETURN b limit $limit
docsvc
29
0 ms
<1 ms
0 ms
flat
MATCH(a:DocumentShare)-[r:REFERS_TO]->(b:Document{tildaid:$b_tildaid}) RETURN a limit $limit
MATCH(a:DocumentShare)-[r:REFERS_TO]->(b:Document{tildaid:$b_tildaid}) RETURN a limit $limit
docsvc
29
0 ms
<1 ms
0 ms
flat
MATCH (w:WorkOrder {tildaid: $work_order_id}) OPTIONAL MATCH (cfg:WorkOrderConfig {tildaid: w.parent_id}) WITH w, coalesce(cfg.wp_object_id, ?) AS wp_object_id WHERE wp_object_id <> ? MATCH (item:WorkplanInstanceMilestoneItem) WHERE item.t…
MATCH (w:WorkOrder {tildaid: $work_order_id}) OPTIONAL MATCH (cfg:WorkOrderConfig {tildaid: w.parent_id}) WITH w, coalesce(cfg.wp_object_id, ?) AS wp_object_id WHERE wp_object_id <> ? MATCH (item:WorkplanInstanceMilestoneItem) WHERE item.tildaid = wp_object_id OR ( item.cfgMilestoneItemId = wp_object_id AND ( coalesce(item.workOrderId, ?) = w.tildaid OR (coalesce(w.site_id, ?) <> ? AND item.scopeId = w.site_id) ) ) MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone) -[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item) RETURN wp.tildaid AS workplan_id, wp.name AS workplan_name LIMIT ?
match (a:Study{delpending:false})-[:STUDY_TO_ORG]->(:Organization{tildaid:$orgId}) return a.status as status, count(a) as cnt, sum(?) as inScope
match (a:Study{delpending:false})-[:STUDY_TO_ORG]->(:Organization{tildaid:$orgId}) return a.status as status, count(a) as cnt, sum(?) as inScope
enrollsvc
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 (c:MemoryEstimateConfig) WHERE c.operation IN $ops RETURN c.operation AS operation, c.attribute AS attribute, c.content_type AS content_type, c.source AS source
MATCH (c:MemoryEstimateConfig) WHERE c.operation IN $ops RETURN c.operation AS operation, c.attribute AS attribute, c.content_type AS content_type, c.source AS source
docproc
2
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: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)
writeexecsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:User{tildaid:$a_tildaid}) RETURN a
MATCH(a:User{tildaid:$a_tildaid}) RETURN a
execsvc
1
0 ms
<1 ms
0 ms
flat
MATCH (cp:CarePlan {tildaid: $carePlanId})-[:EXECUTE_SOA]->(:ScheduleOfActivities) -[:SOA_TO_PROTOCOL_VERSION]->(pv:ProtocolVersion|ProtocolVersionV2) RETURN DISTINCT pv.tildaid AS pvId, pv:ProtocolVersionV2 AS isV2
MATCH (cp:CarePlan {tildaid: $carePlanId})-[:EXECUTE_SOA]->(:ScheduleOfActivities) -[:SOA_TO_PROTOCOL_VERSION]->(pv:ProtocolVersion|ProtocolVersionV2) RETURN DISTINCT pv.tildaid AS pvId, pv:ProtocolVersionV2 AS isV2
execsvc
10
0 ms
<1 ms
0 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(:StudySiteActor) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(st:Study) optional match (t)-[:BELONGS_TO]…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(:StudySiteActor) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(st:Study) optional match (t)-[:BELONGS_TO]->(:Inbox)-[:MANAGED_BY]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, collect(au) as auCollected, st, site, cu as createdBy return {Task: t, AssignedUser: auCollected, Study: st, Site: site, CreatedBy: createdBy}
tusker
29
0 ms
<1 ms
0 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
1
0 ms
<1 ms
0 ms
flat
MATCH (e:Event {tildaid: $event_id}) RETURN coalesce(e.name, ?) AS name
MATCH (e:Event {tildaid: $event_id}) RETURN coalesce(e.name, ?) AS name
virtual-assistant
2
0 ms
<1 ms
0 ms
flat
match (t:Task{tildaid:$id})-[:BELONGS_TO]-(i:Inbox{type:?})-[:OWNED_BY]-(u:User) where i.name=u.email return u
match (t:Task{tildaid:$id})-[:BELONGS_TO]-(i:Inbox{type:?})-[:OWNED_BY]-(u:User) where i.name=u.email return u
docsvc
2
0 ms
<1 ms
0 ms
flat
match (task:Task{tildaid:$taskId})-[:BELONGS_TO]-> (inbox:Inbox{type:?})-[:MANAGED_BY]-> (site:Site) return site
match (task:Task{tildaid:$taskId})-[:BELONGS_TO]-> (inbox:Inbox{type:?})-[:MANAGED_BY]-> (site:Site) return site
docsvc
1
0 ms
<1 ms
0 ms
flat
match (task:Task{tildaid:$taskId})-[:BELONGS_TO]-> (inbox:Inbox{type:?})-[:MANAGED_BY]-> (study:Study) return study
match (task:Task{tildaid:$taskId})-[:BELONGS_TO]-> (inbox:Inbox{type:?})-[:MANAGED_BY]-> (study:Study) return study
docsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Task{tildaid:$a_tildaid})-[r:CREATED_BY]->(b:User) RETURN b limit $limit
MATCH(a:Task{tildaid:$a_tildaid})-[r:CREATED_BY]->(b:User) RETURN b limit $limit
docsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:ParticipantActivity{tildaid:$a_tildaid}) RETURN a
MATCH(a:ParticipantActivity{tildaid:$a_tildaid}) RETURN a
regsvc
2
0 ms
<1 ms
0 ms
flat
match (pa:ParticipantActivity{tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]- (pqnr:ParticipantQuestionnaire)-[:PARTICIPANT_QUESTION]-(pqn:ParticipantQuestion) optional match (pqn)-[:PARTICIPANT_SPECNODE]-(psn:ParticipantSpecNode)-[:BELONGS_…
match (pa:ParticipantActivity{tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]- (pqnr:ParticipantQuestionnaire)-[:PARTICIPANT_QUESTION]-(pqn:ParticipantQuestion) optional match (pqn)-[:PARTICIPANT_SPECNODE]-(psn:ParticipantSpecNode)-[:BELONGS_TO_SPECNODE]- (sn:SpecNode) where psn.status=? and psn.deltimestamp=? with distinct sn as dsn,pqn with count(case when dsn.required=? then ? else null end) as incompleteMandatoryQuestionCount, count(case when dsn.required=? then ? else null end) as incompleteQuestionCount,pqn,pqn.status as oldStatus set pqn.status=case when pqn.status = ? then pqn.status when pqn.tildaid in $notDonePQIds then ? when incompleteMandatoryQuestionCount>? then ? when incompleteQuestionCount>? then ? else ? end return {tildaid: pqn.tildaid, oldStatus: oldStatus}
writeregsvc
2
0 ms
<1 ms
0 ms
flat
match (pa:ParticipantActivity{tildaid:$paId})- [:PARTICIPANT_CONTROL]-(pc:ParticipantControl)- [:PCONTROL_TO_CONTROL]-(c:ControlV2) CALL { with pa, pc, c optional match (pc)-[:PARTICIPANT_TASKLIST]-(ptl:ParticipantTaskList) return ptl as x…
match (pa:ParticipantActivity{tildaid:$paId})- [:PARTICIPANT_CONTROL]-(pc:ParticipantControl)- [:PCONTROL_TO_CONTROL]-(c:ControlV2) CALL { with pa, pc, c optional match (pc)-[:PARTICIPANT_TASKLIST]-(ptl:ParticipantTaskList) return ptl as x, COLLECT(ptl.status) as statuses } with pc, apoc.coll.flatten(COLLECT(statuses)) AS allStatuses where ALL(status IN allStatuses WHERE status = ?) set pc.status = ?
writeregsvc
2
0 ms
<1 ms
0 ms
flat
match (pa:ParticipantActivity{tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]- (pqnr:ParticipantQuestionnaire)-[:BELONGS_TO_QUESTIONNAIRE]-(qnr:QuestionnaireV2) where pqnr.status <> ? and pqnr.status <> ? set pqnr.status=?,pqnr.stopWatchEndTi…
match (pa:ParticipantActivity{tildaid:$paId})-[:PARTICIPANT_QUESTIONNAIRE]- (pqnr:ParticipantQuestionnaire)-[:BELONGS_TO_QUESTIONNAIRE]-(qnr:QuestionnaireV2) where pqnr.status <> ? and pqnr.status <> ? set pqnr.status=?,pqnr.stopWatchEndTime= case when qnr.stopwatchenable and pqnr.stopWatchStartTime > ? then timestamp() else ? end return qnr,pqnr
writeregsvc
2
0 ms
<1 ms
0 ms
flat
MATCH (t:Task{tildaid:$taskId}) -[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig) -[:PARTICIPANT_TASKCONFIG]-(ptl:ParticipantTaskList) MATCH (ptl)-[:PARTICIPANT_TASKCONFIG]-(allptc:ParticipantTaskConfig) WITH ptl, COLLECT(allptc.status) AS…
MATCH (t:Task{tildaid:$taskId}) -[:CREATED_FROM_SPEC]-(ptc:ParticipantTaskConfig) -[:PARTICIPANT_TASKCONFIG]-(ptl:ParticipantTaskList) MATCH (ptl)-[:PARTICIPANT_TASKCONFIG]-(allptc:ParticipantTaskConfig) WITH ptl, COLLECT(allptc.status) AS allStatuses WITH ptl, ALL(status IN allStatuses WHERE status = ?) AS allCompleted WITH ptl, allCompleted, CASE WHEN allCompleted THEN ? ELSE ptl.status END as value SET ptl.status = value, ptl.updatedAt = timestamp() RETURN allCompleted
writeregsvc
2
0 ms
<1 ms
0 ms
flat
match (pa:ParticipantActivity{tildaid:$id})-[:PARTICIPANT_DOCUMENTSET]-> (pds:ParticipantDocumentSet)-[:BELONGS_TO_DOCUMENTSET]-> (ds:DocumentSet|DocumentSetV2) return ds, pds
match (pa:ParticipantActivity{tildaid:$id})-[:PARTICIPANT_DOCUMENTSET]-> (pds:ParticipantDocumentSet)-[:BELONGS_TO_DOCUMENTSET]-> (ds:DocumentSet|DocumentSetV2) return ds, pds
regsvc
2
0 ms
<1 ms
0 ms
flat
match (:StudyNotification{studyId:$studyId})-[:ALL_CHANGELOG]-(clog:ChangeLog) return clog order by clog.createdat desc
match (:StudyNotification{studyId:$studyId})-[:ALL_CHANGELOG]-(clog:ChangeLog) return clog order by clog.createdat desc
enrollsvc
2
0 ms
<1 ms
0 ms
flat
match (obj:Table{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
match (obj:Table{tildaid:$objId})-[:GRAPH_TO_VARIABLE{graphid:$objId, path:[$objId]}]->(v:VariableV2) return {v:v}
execsvc
34
0 ms
<1 ms
0 ms
flat
match(a:StudyCountryActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
match(a:StudyCountryActor{tildaid:$tildaid}) set a.holdbitmap=apoc.bitwise.op(a.holdbitmap, ?, $svcBitId)
writeexecsvc
7
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
306
0 ms
<1 ms
0 ms
flat
MATCH(a:Inbox{type:$a_type})-[r:MANAGED_BY]->(b:Study{tildaid:$b_tildaid}) RETURN a limit $limit
MATCH(a:Inbox{type:$a_type})-[r:MANAGED_BY]->(b:Study{tildaid:$b_tildaid}) RETURN a limit $limit
tusker
1
0 ms
<1 ms
0 ms
flat
MATCH (a:AIRun {tildaid: $from_id}) MATCH (b:Recommendation {tildaid: $to_id}) CREATE (a)-[r:AI_RUN_TO_RECOMMENDATION]->(b) SET r = $properties, r.createdat = timestamp() RETURN r
MATCH (a:AIRun {tildaid: $from_id}) MATCH (b:Recommendation {tildaid: $to_id}) CREATE (a)-[r:AI_RUN_TO_RECOMMENDATION]->(b) SET r = $properties, r.createdat = timestamp() RETURN r
writedocproc
26
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
patientsvc
2
0 ms
<1 ms
0 ms
flat
MATCH (w:WorkOrder {tildaid: $work_order_id})<-[:FACT_TO_WORK_ORDER]-(f:Fact {key: $key}) WHERE f.delpending = false RETURN f.key AS key, f.value AS value, f.type AS type ORDER BY f.createdat ASC
MATCH (w:WorkOrder {tildaid: $work_order_id})<-[:FACT_TO_WORK_ORDER]-(f:Fact {key: $key}) WHERE f.delpending = false RETURN f.key AS key, f.value AS value, f.type AS type ORDER BY f.createdat ASC
virtual-assistant
58
0 ms
<1 ms
0 ms
flat
match (obj0:Document{tildaid:$hdmParentId})-[:BELONGS_TO]-(obj1:ParticipantDocOverlay)-[:PARTICIPANT_DOC_OVERLAY]-(obj2:ParticipantDocumentSet)-[:PARTICIPANT_DOCUMENTSET]-(obj3:ParticipantActivity)-[:TRAINING_PARTICIPANT_ACTIVITY]-(obj4:Tr…
match (obj0:Document{tildaid:$hdmParentId})-[:BELONGS_TO]-(obj1:ParticipantDocOverlay)-[:PARTICIPANT_DOC_OVERLAY]-(obj2:ParticipantDocumentSet)-[:PARTICIPANT_DOCUMENTSET]-(obj3:ParticipantActivity)-[:TRAINING_PARTICIPANT_ACTIVITY]-(obj4:Training) optional match (obj3)-[:ALL_CHANGELOG]->(cl:ChangeLog{type:?, newValue:?}) with obj4.validUntil as validUntil, obj4.validUntilUnits as validUntilUnits, obj0.createdat as issuedAt, max(cl.createdat) as completedAt return validUntil, validUntilUnits, coalesce(completedAt, issuedAt) as anchorAt
docsvc
10
0 ms
<1 ms
0 ms
flat
match (obj0:Document{tildaid:$hdmParentId})-[:BELONGS_TO]-(obj1:ParticipantDocOverlay)-[:PARTICIPANT_DOC_OVERLAY]-(obj2:ParticipantDocumentSet)-[:PARTICIPANT_DOCUMENTSET]-(obj3:ParticipantActivity)-[:BELONGS_TO_ACTIVITY]-(obj4:ActivityV2) …
match (obj0:Document{tildaid:$hdmParentId})-[:BELONGS_TO]-(obj1:ParticipantDocOverlay)-[:PARTICIPANT_DOC_OVERLAY]-(obj2:ParticipantDocumentSet)-[:PARTICIPANT_DOCUMENTSET]-(obj3:ParticipantActivity)-[:BELONGS_TO_ACTIVITY]-(obj4:ActivityV2) return obj4 order by obj4.createdat
docsvc
10
0 ms
<1 ms
0 ms
flat
MATCH(a:VisitAppointment{tildaid:$a_tildaid}) RETURN a
MATCH(a:VisitAppointment{tildaid:$a_tildaid}) RETURN a
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 ?
notifsvc
2
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT placeholder_audit_dedupe_unique IF NOT EXISTS FOR (p:PlaceholderAudit) REQUIRE p.dedupeKey IS UNIQUE
CREATE CONSTRAINT placeholder_audit_dedupe_unique IF NOT EXISTS FOR (p:PlaceholderAudit) REQUIRE p.dedupeKey IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT config_finding_key_v2 IF NOT EXISTS FOR (f:ConfigFinding) REQUIRE (f.studyId, f.dedupeKey) IS UNIQUE
CREATE CONSTRAINT config_finding_key_v2 IF NOT EXISTS FOR (f:ConfigFinding) REQUIRE (f.studyId, f.dedupeKey) IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT unit_visit_runid_kind_id_unique IF NOT EXISTS FOR (v:UnitVisit) REQUIRE (v.runId, v.unit_kind, v.unit_id) IS UNIQUE
CREATE CONSTRAINT unit_visit_runid_kind_id_unique IF NOT EXISTS FOR (v:UnitVisit) REQUIRE (v.runId, v.unit_kind, v.unit_id) IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT finding_dedupe_composite_unique IF NOT EXISTS FOR (f:Finding) REQUIRE (f.studyId, f.domain, f.dedupeKey) IS UNIQUE
CREATE CONSTRAINT finding_dedupe_composite_unique IF NOT EXISTS FOR (f:Finding) REQUIRE (f.studyId, f.domain, f.dedupeKey) IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT ontology_auditproc_fp_key IF NOT EXISTS FOR (m:OntologyAuditprocFingerprint) REQUIRE m.key IS UNIQUE
CREATE CONSTRAINT ontology_auditproc_fp_key IF NOT EXISTS FOR (m:OntologyAuditprocFingerprint) REQUIRE m.key IS UNIQUE
writeontologysvc
1
0 ms
<1 ms
0 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
regsvc
2
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
4
0 ms
<1 ms
0 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
finsvc
1
0 ms
<1 ms
0 ms
flat
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
WITH $`node` as `node` , $`row` as `row` RETURN ? as relCount
execsvc
4,312
<1 ms
<1 ms
16 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
docsvc
62,798
<1 ms
<1 ms
240 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
4,307
<1 ms
<1 ms
14 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
4,312
<1 ms
<1 ms
22 ms
flat
WITH $`t_carePlanId` as `t_carePlanId` , $`f_instanceId` as `f_instanceId` , $`t_deltimestamp` as `t_deltimestamp` , $`f_deltimestamp` as `f_deltimestamp` , $`f_carePlanId` as `f_carePlanId` , $`t_instanceId` as `t_instanceId` , $`f_visitI…
WITH $`t_carePlanId` as `t_carePlanId` , $`f_instanceId` as `f_instanceId` , $`t_deltimestamp` as `t_deltimestamp` , $`f_deltimestamp` as `f_deltimestamp` , $`f_carePlanId` as `f_carePlanId` , $`t_instanceId` as `t_instanceId` , $`f_visitId` as `f_visitId` , $`t_visitId` as `t_visitId` MATCH (from:ParticipantVisit{deltimestamp:$f_deltimestamp,visitId:$f_visitId,carePlanId:$f_carePlanId,instanceId:$f_instanceId}) MATCH (to:ParticipantVisit{deltimestamp:$t_deltimestamp,visitId:$t_visitId,carePlanId:$t_carePlanId,instanceId:$t_instanceId}) MERGE (from)-[r:NEXT_PARTICIPANT_VISIT]->(to) ON CREATE SET r.tildaid = apoc.create.uuid(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() return from,to
writeexecsvc
1,021
<1 ms
<1 ms
2 ms
flat
WITH $`t_carePlanId` as `t_carePlanId` , $`f_instanceId` as `f_instanceId` , $`t_deltimestamp` as `t_deltimestamp` , $`f_deltimestamp` as `f_deltimestamp` , $`f_carePlanId` as `f_carePlanId` , $`t_instanceId` as `t_instanceId` , $`f_visitI…
WITH $`t_carePlanId` as `t_carePlanId` , $`f_instanceId` as `f_instanceId` , $`t_deltimestamp` as `t_deltimestamp` , $`f_deltimestamp` as `f_deltimestamp` , $`f_carePlanId` as `f_carePlanId` , $`t_instanceId` as `t_instanceId` , $`f_visitId` as `f_visitId` , $`t_visitId` as `t_visitId` MATCH (from:ParticipantVisit{deltimestamp:$f_deltimestamp,visitId:$f_visitId,carePlanId:$f_carePlanId,instanceId:$f_instanceId}) MATCH (to:ParticipantVisit{deltimestamp:$t_deltimestamp,visitId:$t_visitId,carePlanId:$t_carePlanId,instanceId:$t_instanceId}) MERGE (from)-[r:NEXT_PARTICIPANT_VISIT]->(to) ON CREATE SET r.tildaid = apoc.create.uuid(), r.createdat = timestamp() ON MATCH SET r.updatedat = timestamp() return from,to
writeexecsvc
792
<1 ms
<1 ms
63 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)
writeexecsvc
280
<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).