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
stored36h agotop 80 of 2,719
Neo4j query shapes on automation over the last 48h, 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})<-[: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
6
0 ms
<1 ms
0 ms
flat
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id
docproc
3
0 ms
<1 ms
0 ms
flat
match(crs:ChartReviewStudy{tildaid:$id}) with crs optional match(crs)-[r:PENDING_PATIENTS]->(:Patient) with count(r) as pend, crs with pend, crs optional match(crs)-[r:APPROVED_PATIENTS]->(:Patient) with count(r) as approved, pend, crs wit…
match(crs:ChartReviewStudy{tildaid:$id}) with crs optional match(crs)-[r:PENDING_PATIENTS]->(:Patient) with count(r) as pend, crs with pend, crs optional match(crs)-[r:APPROVED_PATIENTS]->(:Patient) with count(r) as approved, pend, crs with approved, pend, crs optional match(crs)-[r:REJECTED_PATIENTS]->(:Patient) with count(r) as rejected, approved, pend return pend, approved, rejected
enrollsvc
3
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
12
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}
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
48
0 ms
<1 ms
0 ms
flat
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
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
12
0 ms
<1 ms
0 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(q:Query) optional match (cp:CarePlan{tildaid: q.careplanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITI…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(q:Query) optional match (cp:CarePlan{tildaid: q.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 (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pq:ParticipantQuestion{tildaid:q.scopeId})<-[:PARTICIPANT_QUESTION]-(pqn:ParticipantQuestionnaire)<-[:PARTICIPANT_QUESTIONNAIRE]-(pa:ParticipantActivity) optional match (pa)<-[:PARTICIPANT_ACTIVITY]-(pv:ParticipantVisit) optional match (pv)-[:BELONGS_TO_VISIT]->(v) where v:Visit or v:VisitV2 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, q, site, v, p, phi, cu as createdBy, pd.siteNumber as siteNumber, cp return {Task: t, Study: st, Phi: phi, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, Visit: v, User: u, AssignedUser: auCollected, Patient: p, CreatedBy: createdBy, CarePlan: cp}
tusker
24
0 ms
<1 ms
0 ms
flat
match(a:AdvRateRule) where a.portalorgid=$portalOrgId and a.deleted=false and a.studyid=$fieldId set a.deleted=true, a.deltimestamp=timestamp()
match(a:AdvRateRule) where a.portalorgid=$portalOrgId and a.deleted=false and a.studyid=$fieldId set a.deleted=true, a.deltimestamp=timestamp()
writeadvpsvc
6
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
MATCH(a:Organization{tildaid:$a_tildaid}) RETURN a
notifsvc
12
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
53
0 ms
<1 ms
0 ms
flat
WITH $`rel2` as `rel2` , $`node` as `node` , $`tildaid` as `tildaid` OPTIONAL MATCH (existing:Inbox{tildaid: $tildaid}) RETURN existing
WITH $`rel2` as `rel2` , $`node` as `node` , $`tildaid` as `tildaid` OPTIONAL MATCH (existing:Inbox{tildaid: $tildaid}) RETURN existing
regsvc
429
0 ms
<1 ms
0 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
6
0 ms
<1 ms
0 ms
flat
MATCH(a:Job{name:$a_name}) RETURN a limit $a_limit
MATCH(a:Job{name:$a_name}) RETURN a limit $a_limit
notifsvc
6
0 ms
<1 ms
0 ms
flat
MATCH (sref:GraphNodeRef)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protocolid:$protocolId}]->(:VisitV2{tildaid:$visitId}), (sref)-[:ANCHORED_TO{protocolid:$protocolId}]->(ar:GraphNodeRef) WITH ar ORDER BY ar.tildaid LIMIT ? OPTIONAL MATCH (:CarePlan…
MATCH (sref:GraphNodeRef)-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protocolid:$protocolId}]->(:VisitV2{tildaid:$visitId}), (sref)-[:ANCHORED_TO{protocolid:$protocolId}]->(ar:GraphNodeRef) WITH ar ORDER BY ar.tildaid LIMIT ? OPTIONAL MATCH (:CarePlan{tildaid:$cpId})-[:CAREPLAN_TO_ALL_PARTICIPANTVISITS]->(pv:ParticipantVisit)-[:BELONGS_TO_VISIT]->(v:Visit|VisitV2) WHERE EXISTS { (ar)-[:GRAPH_NODE_REF_TO_GRAPH_NODE]->(v) } RETURN pv, v, [ar.tildaid] as refIds, null as ofl
schedsvc
18
0 ms
<1 ms
0 ms
flat
MATCH(a:Inbox{tildaid:$a_tildaid}) DETACH DELETE a
MATCH(a:Inbox{tildaid:$a_tildaid}) DETACH DELETE a
writetusker
48
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
18
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
14
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
14
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
14
0 ms
<1 ms
0 ms
flat
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
MATCH(a:ChartReviewStudy{tildaid:$a_tildaid})-[r:HAS_REPORT]->(b) RETURN b limit $limit
enrollsvc
7
0 ms
<1 ms
0 ms
flat
MATCH (cp:CarePlan {tildaid:$cpId})-[:CAREPLAN_TO_ALL_PARTICIPANTVISITS]-(pv:ParticipantVisit) MATCH (pv)-[:PARTICIPANT_ACTIVITY]-(pa:ParticipantActivity) RETURN coalesce(pv.visitId, ?) AS visitId, coalesce(pa.activityId, ?) AS activityId,…
MATCH (cp:CarePlan {tildaid:$cpId})-[:CAREPLAN_TO_ALL_PARTICIPANTVISITS]-(pv:ParticipantVisit) MATCH (pv)-[:PARTICIPANT_ACTIVITY]-(pa:ParticipantActivity) RETURN coalesce(pv.visitId, ?) AS visitId, coalesce(pa.activityId, ?) AS activityId, coalesce(pa.status, ?) AS status, coalesce(pa.edcStatus, ?) AS edcStatus
execsvc
40
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
3,541
0 ms
<1 ms
0 ms
flat
MATCH(a:Task)-[r:WITH_CONTEXT]->(b:Lead{tildaid:$b_tildaid}) RETURN a limit $limit
MATCH(a:Task)-[r:WITH_CONTEXT]->(b:Lead{tildaid:$b_tildaid}) RETURN a limit $limit
patientsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:User{deltimestamp:$a_deltimestamp,email:$a_email}) RETURN a
MATCH(a:User{deltimestamp:$a_deltimestamp,email:$a_email}) RETURN a
tusker
7
0 ms
<1 ms
0 ms
flat
MATCH(a:DocumentCheckSum{deltimestamp:$a_deltimestamp,orgId:$a_orgId,studyId:$a_studyId,checksum:$a_checksum}) RETURN a
MATCH(a:DocumentCheckSum{deltimestamp:$a_deltimestamp,orgId:$a_orgId,studyId:$a_studyId,checksum:$a_checksum}) RETURN a
docsvc
2
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
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pd, site, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, User: u, AssignedUser: auCollected, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, CreatedBy: createdBy}
tusker
1
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = fa…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false RETURN coalesce(item.itemId, item.tildaid) AS itemId, coalesce(item.itemConfig, ?) AS itemConfig
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE ite…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.expectedAttachmentUnresolvedAt, ?) > ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.workOrderCompletedAt, ?) = ? AND coalesce(item.workOrderId, ?) = ? RETURN DISTINCT inst.tildaid AS instanceId
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE ite…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_INSTANCE]->(inst:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.workOrderActivationFailedAt, ?) > ? AND coalesce(item.workOrderActivationErrorCode, ?) = $code AND coalesce(item.workOrderCompletedAt, ?) = ? AND coalesce(item.workOrderResolvedAt, ?) = ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.workOrderId, ?) <> ? RETURN inst.tildaid AS instanceId, coalesce(item.itemConfig, ?) AS itemConfig
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.agentConfigErrorAt, ?) AS at, coalesce(cfg.agentConfigErrorMessage, ?) AS message, coalesce(cfg.agentConfigAuthorMessage, ?) AS authorMessage
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.agentConfigErrorAt, ?) AS at, coalesce(cfg.agentConfigErrorMessage, ?) AS message, coalesce(cfg.agentConfigAuthorMessage, ?) AS authorMessage
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = fa…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false AND coalesce(item.edlProvisionFailedAt, ?) > ? RETURN count(item) AS n
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE coalesce(item.cfgItemInvalid, false) = false AND coalesce(item.branchCas…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE coalesce(item.cfgItemInvalid, false) = false AND coalesce(item.branchCaseAmbiguity, ?) <> ? RETURN DISTINCT item.branchCaseAmbiguity AS message
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = fa…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId})-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false RETURN sum(CASE WHEN coalesce(item.workOrderConfigFailedAt, ?) > ? THEN ? ELSE ? END) AS failed, sum(CASE WHEN coalesce(item.workOrderConfigWarningAt, ?) > ? THEN ? ELSE ? END) AS warned
workplansvc
47
0 ms
<1 ms
0 ms
flat
MATCH (obj:WorkplanCfg{tildaid:$objId})<-[:WORKPLAN_JOB_TO_OBJ]-(job:WorkplanJob) RETURN job ORDER BY job.createdat DESC LIMIT ?
MATCH (obj:WorkplanCfg{tildaid:$objId})<-[:WORKPLAN_JOB_TO_OBJ]-(job:WorkplanJob) RETURN job ORDER BY job.createdat DESC LIMIT ?
workplansvc
50
0 ms
<1 ms
0 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
4
0 ms
<1 ms
0 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pd:DslPlanDefinition{delpending:false}) optional match (pd)-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (t)-[:CREATED_BY]->(u:User) optional match (t)-[:BELONGS_TO]->(i:Inbox)-[:OWNED_BY]->(au:User) optional match (pd)-[:PLAN_DEFINITION_TO_SITE]->(site:Site) optional match (t)-[:CREATED_BY]-(cu:User) with t, st, u, collect(au) as auCollected, pd, site, cu as createdBy, pd.siteNumber as siteNumber return {Task: t, Study: st, User: u, AssignedUser: auCollected, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, CreatedBy: createdBy}
tusker
1
0 ms
<1 ms
0 ms
flat
MATCH (ctx:WorkPlanContext{tildaid:$tildaid}) SET ctx.delpending = true, ctx.deltimestamp = timestamp() RETURN ctx.tildaid AS id
MATCH (ctx:WorkPlanContext{tildaid:$tildaid}) SET ctx.delpending = true, ctx.deltimestamp = timestamp() RETURN ctx.tildaid AS id
writeworkplansvc
1
0 ms
<1 ms
0 ms
flat
MATCH (ctx:WorkPlanContext{tildaid:$contextId}) SET ctx.checkpointGenId = $genId RETURN ctx.tildaid AS id
MATCH (ctx:WorkPlanContext{tildaid:$contextId}) SET ctx.checkpointGenId = $genId RETURN ctx.tildaid AS id
writeworkplansvc
1
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(proto:FormV2{t…
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(proto:FormV2{tildaid:$protocolId}) merge(proto)-[:PROTOCOL_TO_QUESTION]->(q)
writestudiosvc
5
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]->(rs:ResponseSet) with distinct rs match(proto:FormV2{tildaid:$protocolId}) mer…
match(form:FormV2{tildaid:$formId})-[r:GRAPH_NEXT*?..{graphid:$formId}]->(ref:GraphNode) where r[-?].path[?]=$formId match(ref)-[:GRAPH_NODE_REF_TO_GRAPH_NODE]->(rs:ResponseSet) with distinct rs match(proto:FormV2{tildaid:$protocolId}) merge(proto)-[:PROTOCOL_TO_RESPONSE_SET]->(rs)
writestudiosvc
5
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) OPTIONAL MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg) OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_STUDY]->(study:Study) RETURN coalesce(org.alias, ?), coalesce(org.name, ?), coalesce(st…
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) OPTIONAL MATCH (org:Organization)-[:ORGANIZATION_TO_WORKPLAN_CFG]->(cfg) OPTIONAL MATCH (cfg)-[:WORKPLAN_CFG_TO_STUDY]->(study:Study) RETURN coalesce(org.alias, ?), coalesce(org.name, ?), coalesce(study.tildaid, cfg.studyId, ?), coalesce(study.name, ?), cfg.tildaid, coalesce(cfg.name, ?)
workplansvc
1
0 ms
<1 ms
0 ms
flat
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.variableDeclarations, ?)
MATCH (cfg:WorkplanCfg{tildaid:$cfgId}) RETURN coalesce(cfg.variableDeclarations, ?)
workplansvc
1
0 ms
<1 ms
0 ms
flat
MATCH (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = ? AND j.jobType IN [?, ?, ?] RETURN j.tildaid ORDER BY j.createdat ASC
MATCH (j:TmfStructureJob{deltimestamp:?}) WHERE j.status = ? AND j.jobType IN [?, ?, ?] RETURN j.tildaid ORDER BY j.createdat ASC
docsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Site{tildaid:$a_tildaid}) RETURN a
MATCH(a:Site{tildaid:$a_tildaid}) RETURN a
docsvc
4
0 ms
<1 ms
0 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)
MATCH (o:Organization {alias: $value}) WHERE o.delpending = true AND o.status = $deleted AND coalesce(o.deletionProgress, ?) <> $purged RETURN count(o)
MATCH (o:Organization {alias: $value}) WHERE o.delpending = true AND o.status = $deleted AND coalesce(o.deletionProgress, ?) <> $purged RETURN count(o)
onboardingsvc
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Organization{deltimestamp:$a_deltimestamp,alias:$a_alias}) RETURN a
MATCH(a:Organization{deltimestamp:$a_deltimestamp,alias:$a_alias}) RETURN a
onboardingsvc
1
0 ms
<1 ms
0 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
56
0 ms
<1 ms
0 ms
flat
MATCH(a:BudgetReport)-[r:BUDGET_REPORT_TO_PARTICIPANT_VISIT]->(b:ParticipantVisit{tildaid:$b_tildaid}) RETURN a limit $limit
MATCH(a:BudgetReport)-[r:BUDGET_REPORT_TO_PARTICIPANT_VISIT]->(b:ParticipantVisit{tildaid:$b_tildaid}) RETURN a limit $limit
finsvc
1
0 ms
<1 ms
0 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
writeregsvc
766
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
writeregsvc
922
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
regsvc
612
0 ms
<1 ms
0 ms
flat
MATCH (c:CtmsSyncConfig {enabled: true}) WITH c OPTIONAL MATCH (s:TMFSyncConfig {id: c.source_veeva_config_id, org_alias: c.org_alias}) RETURN c {.*, source_paused_reason: s.sync_paused_reason} AS c ORDER BY c.created_at ASC
MATCH (c:CtmsSyncConfig {enabled: true}) WITH c OPTIONAL MATCH (s:TMFSyncConfig {id: c.source_veeva_config_id, org_alias: c.org_alias}) RETURN c {.*, source_paused_reason: s.sync_paused_reason} AS c ORDER BY c.created_at ASC
tmfsync
2
0 ms
<1 ms
0 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(pv:ParticipantVisit) optional match (cp:CarePlan{tildaid: pv.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 (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) optional match (pv)-[:BELONGS_TO_VISIT]->(v) where v:Visit or v:VisitV2 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, pv, site, v, p, phi, cu as createdBy, pd.siteNumber as siteNumber, cp return {Task: t, Study: st, Phi: phi, Visit: v, Site: {tildaid: site.tildaid, name: site.name, city: site.city, country: site.country, siteNumber: siteNumber}, User: u, AssignedUser: auCollected, Patient: p, CreatedBy: createdBy, CarePlan: cp}
tusker
57
0 ms
<1 ms
0 ms
flat
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(medhist:Procedure|MedicalCondition|Allergy) optional match (medhist)-[:PARTICIPANT_TABLE]->(pt:ParticipantTable) optional match (cp:CarePlan{tildaid: pt.carePlanId})-[:EXECUTE_SOA]->(s:…
WITH $`t` as `t` optional match (t)-[:WITH_CONTEXT]->(medhist:Procedure|MedicalCondition|Allergy) optional match (medhist)-[:PARTICIPANT_TABLE]->(pt:ParticipantTable) optional match (cp:CarePlan{tildaid: pt.carePlanId})-[:EXECUTE_SOA]->(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]->(pd:DslPlanDefinition{delpending:false})-[:PLAN_DEFINITION_TO_STUDY]->(st:Study) optional match (cp)-[: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 (p:Patient{tildaid: cp.participantId}) optional match (phi:Phi{tildaid: p.phiid}) 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(distinct au) as auCollected, medhist, site, p, phi, cu as createdBy, cp return {Task: t, Study: st, Phi: phi, Site: site, Patient: p, User: u, AssignedUser: auCollected, CreatedBy: createdBy, CarePlan: cp}
tusker
33
0 ms
<1 ms
0 ms
flat
MATCH (wp:WorkPlanInstance {hasActivationFailedItem: true})<-[:WORKPLAN_CFG_TO_INSTANCE]-(cfg:WorkplanCfg) WHERE wp.state <> ? MATCH (wp)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(…
MATCH (wp:WorkPlanInstance {hasActivationFailedItem: true})<-[:WORKPLAN_CFG_TO_INSTANCE]-(cfg:WorkplanCfg) WHERE wp.state <> ? MATCH (wp)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.itemType = ? AND coalesce(item.workOrderActivationFailedAt, ?) > ? AND coalesce(item.workOrderActivationErrorCode, ?) = ? AND coalesce(item.workOrderCompletedAt, ?) = ? AND coalesce(item.workOrderResolvedAt, ?) = ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.workOrderId, ?) <> ? AND coalesce(item.workOrderActivationLastRetriedAt, ?) < item.workOrderActivationFailedAt WITH cfg, wp, item ORDER BY item.tildaid SKIP $skip LIMIT $limit OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) RETURN cfg.tildaid AS cfgId, cfg.studyId AS studyId, coalesce(cfg.workOrderEmailAutoSendOnActivate, true) AS autoSend, wp.tildaid AS instanceId, wp.scopeId AS siteId, coalesce(org.alias, ?) AS orgAlias, item.tildaid as id, coalesce(item.cfgMilestoneItemId, ?) as cfgMilestoneItemId, item.itemId as itemId, item.itemType as itemType, item.workOrderId as workOrderId, coalesce(item.edlEventId, ?) as edlEventId, coalesce(item.edlEventScopeId, ?) as edlEventScopeId, coalesce(item.edlScopeActivatedAt, ?) as edlScopeActivatedAt, coalesce(item.edlScopeCompletedAt, ?) as edlScopeCompletedAt, coalesce(item.taskActivatedAt, ?) as taskActivatedAt, coalesce(item.activateRequestedAt, ?) as activateRequestedAt, coalesce(item.workOrderResolvedAt, ?) as workOrderResolvedAt, coalesce(item.workOrderCompletedAt, ?) as workOrderCompletedAt, coalesce(item.workOrderLastSeenStatus, ?) as workOrderLastSeenStatus, coalesce(item.taskCompletedAt, ?) as taskCompletedAt, coalesce(item.skippedAt, ?) as skippedAt, coalesce(item.notApplicableAt, ?) as notApplicableAt, coalesce(item.itemConfig, ?) as itemConfig, coalesce(item.workOrderActivationFailedAt, ?) as workOrderActivationFailedAt, coalesce(item.workOrderActivationErrorCode, ?) as workOrderActivationErrorCode, coalesce(item.workOrderActivationErrorMessage, ?) as workOrderActivationErrorMessage
workplansvc
1
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
writechat-agent
1
0 ms
<1 ms
0 ms
flat
CREATE CONSTRAINT insight_uuid IF NOT EXISTS FOR (i:Insight) REQUIRE i.uuid IS UNIQUE
CREATE CONSTRAINT insight_uuid IF NOT EXISTS FOR (i:Insight) REQUIRE i.uuid IS UNIQUE
writechat-agent
1
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)
writechat-agent
1
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)
writechat-agent
1
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
writechat-agent
1
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)
writechat-agent
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)
writeenrollsvc
16
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
296
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)
writeonboardingsvc
102
0 ms
<1 ms
0 ms
flat
match (c:CarePlan {tildaid: $id})-[:EXECUTE_SOA]-(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study) return st
match (c:CarePlan {tildaid: $id})-[:EXECUTE_SOA]-(s:ScheduleOfActivities)-[:SOA_TO_PLAN_DEFINITION]-(pd:DslPlanDefinition)-[:PLAN_DEFINITION_TO_STUDY]-(st:Study) return st
schedsvc
14
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
13
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
13
0 ms
<1 ms
0 ms
flat
MATCH (i:TMFSyncItem {status: ?, direction: ?}) WHERE i.next_retry_at IS NULL AND coalesce(i.item_kind, ?) = $item_kind RETURN count(i) AS n
MATCH (i:TMFSyncItem {status: ?, direction: ?}) WHERE i.next_retry_at IS NULL AND coalesce(i.item_kind, ?) = $item_kind RETURN count(i) AS n
tmfsync
7
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:AdvRateRuleSet{portalorgid:$a_portalorgid}) RETURN a limit $a_limit
MATCH(a:AdvRateRuleSet{portalorgid:$a_portalorgid}) RETURN a limit $a_limit
advpsvc
11
0 ms
<1 ms
0 ms
flat
match(smoOrg:Organization{alias:$orgAlias, orgType:?}) with smoOrg match(study:Study{tildaid:$studyId}) with smoOrg, study return smoOrg.tildaid, study.srcorgid
match(smoOrg:Organization{alias:$orgAlias, orgType:?}) with smoOrg match(study:Study{tildaid:$studyId}) with smoOrg, study return smoOrg.tildaid, study.srcorgid
advpsvc
2
0 ms
<1 ms
0 ms
flat
MATCH(a:BudgetReport{deltimestamp:$a_deltimestamp,reportId:$a_reportId}) RETURN a
MATCH(a:BudgetReport{deltimestamp:$a_deltimestamp,reportId:$a_reportId}) RETURN a
finsvc
5
0 ms
<1 ms
0 ms
flat
match(a:Patient{tildaid:$tildaId}) with a, case when a.ufid is null or a.ufid=? then $ufid else a.ufid end as val set a.ufid=val
match(a:Patient{tildaid:$tildaId}) with a, case when a.ufid is null or a.ufid=? then $ufid else a.ufid end as val set a.ufid=val
writepatientsvc
23
0 ms
<1 ms
0 ms
flat
match(a:Patient{tildaid:$tildaId}) with a, case when a.status is null or a.status=? then $prospect else a.status end as status set a.status=status
match(a:Patient{tildaid:$tildaId}) with a, case when a.status is null or a.status=? then $prospect else a.status end as status set a.status=status
writepatientsvc
23
0 ms
<1 ms
0 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).