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
stored2d agotop 80 of 376
Neo4j query shapes on production 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.
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
126
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
writeexecsvc
5
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
writeexecsvc
5
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
5
0 ms
<1 ms
0 ms
flat
MATCH (w:MailgunProcessedWebhook {message_id: $message_id}) WHERE w.processed_at < timestamp() - $ttl_ms DETACH DELETE w
MATCH (w:MailgunProcessedWebhook {message_id: $message_id}) WHERE w.processed_at < timestamp() - $ttl_ms DETACH DELETE w
writevirtual-assistant
1
0 ms
<1 ms
0 ms
flat
MATCH(a:Folder{tildaid:$a_tildaid}) RETURN a
MATCH(a:Folder{tildaid:$a_tildaid}) RETURN a
docsvc
18
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointDecisionFollowupPendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointDecisionFollowupClaimedAt, ?) >= ? R…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointDecisionFollowupPendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointDecisionFollowupClaimedAt, ?) >= ? RETURN wp.tildaid AS instanceId, cfg.tildaid AS cfgId LIMIT $limit
workplansvc
90
<1 ms
2 ms
1 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)
writedocsvc
41
<1 ms
2 ms
1 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)
writedocsvc
464
<1 ms
2 ms
1 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
319
<1 ms
2 ms
1 ms
flat
match (u:User{tildaid:$userId})-[:FOR_USER]-(a:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(o:Organization{alias:$scaleAlias}) where coalesce(a.state, ?) <> ? return a.tildaid
match (u:User{tildaid:$userId})-[:FOR_USER]-(a:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(o:Organization{alias:$scaleAlias}) where coalesce(a.state, ?) <> ? return a.tildaid
docsvc
439
<1 ms
2 ms
2 ms
flat
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
workplansvc
45
<1 ms
2 ms
1 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
385
<1 ms
2 ms
3 ms
flat
MATCH (s:Study)-[:STUDY_TO_NOTIFICATION_DIGEST]->(d:StudyNotificationDigest) WHERE d.tmfDocumentScope = $scope AND coalesce(s.delpending, false) = false AND size(coalesce(d.daysOfWeek, [])) > ? AND size(coalesce(d.tmfNotifyAbout, [])) > ? …
MATCH (s:Study)-[:STUDY_TO_NOTIFICATION_DIGEST]->(d:StudyNotificationDigest) WHERE d.tmfDocumentScope = $scope AND coalesce(s.delpending, false) = false AND size(coalesce(d.daysOfWeek, [])) > ? AND size(coalesce(d.tmfNotifyAbout, [])) > ? OPTIONAL MATCH (s)-[so:STUDY_TO_ORG]->(o:Organization) WHERE coalesce(so.inherited, false) = false WITH s, d, collect(o.alias)[?] AS orgAlias CALL { WITH d OPTIONAL MATCH (x:StudyNotificationDigestSend {digestId: d.tildaid}) RETURN max(x.slotMs) AS lastSentSlot } RETURN d.tildaid AS id, d.title AS title, d.recipientEmails AS recipientEmails, d.recipientRoles AS recipientRoles, d.recipientActorIds AS recipientActorIds, d.daysOfWeek AS daysOfWeek, d.timeOfDay AS timeOfDay, d.timeZone AS timeZone, d.tmfNotifyAbout AS notifyAbout, d.updatedat AS updatedAt, lastSentSlot, s.tildaid AS studyId, s.name AS studyName, s.protocolnumber AS protocolNumber, orgAlias
virtual-assistant
2
<1 ms
2 ms
1 ms
flat
match (u:User{tildaid:$userId})-[:FOR_USER]-(a:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(o:Organization{alias:$scaleAlias}) ,(a)-[:APPOINTED_AS]-(r:Role{name:$roleName}) where coalesce(a.state, ?) <> ? return a.tildaid
match (u:User{tildaid:$userId})-[:FOR_USER]-(a:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(o:Organization{alias:$scaleAlias}) ,(a)-[:APPOINTED_AS]-(r:Role{name:$roleName}) where coalesce(a.state, ?) <> ? return a.tildaid
onboardingsvc
2
<1 ms
2 ms
1 ms
0.5× ↓
MATCH (u:User {email: $identifier}) RETURN u.tildaid as tildaid, u.name as name, u.email as email, u.phoneNumber as phone, coalesce(u.authzUpdateNum, ?) as authzUpdateNum
MATCH (u:User {email: $identifier}) RETURN u.tildaid as tildaid, u.name as name, u.email as email, u.phoneNumber as phone, coalesce(u.authzUpdateNum, ?) as authzUpdateNum
docproc
39
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
enrollsvc
9
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONA…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) OPTIONAL MATCH (reviewer:User {tildaid: wp.checkpointRejectCascadeReviewerId}) RETURN wp.tildaid AS instanceId, coalesce(wp.checkpointRejectCascadeGateItemId, ?) AS gateItemId, coalesce(wp.checkpointRejectCascadeReviewerId, ?) AS reviewerId, coalesce(reviewer.name, ?) AS reviewerName, coalesce(reviewer.email, ?) AS reviewerEmail, coalesce(wp.checkpointRejectCascadeNotes, ?) AS notes, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
48
<1 ms
2 ms
1 ms
flat
MATCH (doc:Document{tildaid:$id})-[:DOCUMENT_VERSION]->(dv:DocumentVersion{tildaid:$id1}) WITH doc, dv, CASE WHEN COALESCE(doc.collection, ?) = ? OR doc.collection = ? THEN ? WHEN doc.collection = ? THEN ? ELSE COALESCE(dv.stateTag, ?) END…
MATCH (doc:Document{tildaid:$id})-[:DOCUMENT_VERSION]->(dv:DocumentVersion{tildaid:$id1}) WITH doc, dv, CASE WHEN COALESCE(doc.collection, ?) = ? OR doc.collection = ? THEN ? WHEN doc.collection = ? THEN ? ELSE COALESCE(dv.stateTag, ?) END AS stagingStatus RETURN stagingStatus
docsvc
264
<1 ms
2 ms
1 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
8
<1 ms
2 ms
1 ms
flat
UNWIND $ids AS id MATCH (s:Study{tildaid:id}) WHERE s.delpending = true RETURN id LIMIT ?
UNWIND $ids AS id MATCH (s:Study{tildaid:id}) WHERE s.delpending = true RETURN id LIMIT ?
docsvc
38
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
MATCH(a:Study{tildaid:$a_tildaid}) RETURN a
docsvc
189
<1 ms
2 ms
1 ms
flat
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
MATCH (wp:WorkPlanInstance {hasBlockedVariables: true}) WHERE wp.state <> ? AND coalesce(wp.variableWaitCheckedAt, ?) < $before RETURN wp.tildaid ORDER BY coalesce(wp.variableWaitCheckedAt, ?) LIMIT $limit
workplansvc
45
<1 ms
2 ms
1 ms
flat
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
MATCH (m:TildaDataMigration {id: $id}) RETURN m.status = $applied
execsvc
3
<1 ms
2 ms
1 ms
flat
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
MATCH (f:FormV2) WHERE f.tildaid IN $ids AND f.objtype = $visitType RETURN f.tildaid AS id
studiosvc
3
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.depende…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.dependencyResolutionRequestedAt, ?) > ? AND $nowMs - item.dependencyResolutionRequestedAt >= $windowMs AND wp.state <> ? AND NOT EXISTS { MATCH (ctx:WorkPlanContext{workplanConfigId: wp.tildaid, contextType:?}) } OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) RETURN DISTINCT wp.tildaid AS id, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
45
<1 ms
2 ms
1 ms
flat
MATCH (f:Folder)-[:INCLUDES]->(n:Folder|SubArtifact{tildaid: $childId}) RETURN f LIMIT ?
MATCH (f:Folder)-[:INCLUDES]->(n:Folder|SubArtifact{tildaid: $childId}) RETURN f LIMIT ?
docsvc
330
<1 ms
2 ms
1 ms
flat
MATCH (d:Document) WHERE d.tildaid IN $docIds AND EXISTS { (d)<-[:HAS_SYSTEM_TEMPLATE]-(:Organization {alias:?}) } RETURN d.tildaid LIMIT ?
MATCH (d:Document) WHERE d.tildaid IN $docIds AND EXISTS { (d)<-[:HAS_SYSTEM_TEMPLATE]-(:Organization {alias:?}) } RETURN d.tildaid LIMIT ?
docsvc
156
<1 ms
2 ms
1 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
30
<1 ms
2 ms
1 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
18
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONA…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance) WHERE wp.checkpointRejectCascadePendingAt > ? AND coalesce(wp.state, ?) <> $archivedState AND $nowMs - coalesce(wp.checkpointRejectCascadeClaimedAt, ?) >= ? OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) OPTIONAL MATCH (reviewer:User {tildaid: wp.checkpointRejectCascadeReviewerId}) RETURN wp.tildaid AS instanceId, coalesce(wp.checkpointRejectCascadeGateItemId, ?) AS gateItemId, coalesce(wp.checkpointRejectCascadeReviewerId, ?) AS reviewerId, coalesce(reviewer.name, ?) AS reviewerName, coalesce(reviewer.email, ?) AS reviewerEmail, coalesce(wp.checkpointRejectCascadeNotes, ?) AS notes, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
42
<1 ms
2 ms
1 ms
flat
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
MATCH(a:ChartReviewStudy{deltimestamp:$a_deltimestamp,orgid:$a_orgid,studyid:$a_studyid}) RETURN a
enrollsvc
8
<1 ms
2 ms
1 ms
flat
MATCH (dv:DocumentVersion{tildaid:$id})-[:ALL_CHANGELOG]->(ch:ChangeLog{type:?}) RETURN ch ORDER BY ch.createdat DESC limit ?
MATCH (dv:DocumentVersion{tildaid:$id})-[:ALL_CHANGELOG]->(ch:ChangeLog{type:?}) RETURN ch ORDER BY ch.createdat DESC limit ?
docsvc
264
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.depende…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_INSTANCE]->(wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE coalesce(item.dependencyResolutionRequestedAt, ?) > ? AND $nowMs - item.dependencyResolutionRequestedAt >= $windowMs AND wp.state <> ? AND NOT EXISTS { MATCH (ctx:WorkPlanContext{workplanConfigId: wp.tildaid, contextType:?}) } OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) RETURN DISTINCT wp.tildaid AS id, cfg.tildaid AS cfgId, coalesce(org.alias, ?) AS orgAlias LIMIT $limit
workplansvc
45
<1 ms
2 ms
1 ms
flat
MATCH (cfgItem:WorkPlanMilestoneItem) WHERE cfgItem.itemType = ? AND coalesce(cfgItem.cfgItemInvalid, false) = false AND cfgItem.checkpointLastComputedGenId > ? MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMiles…
MATCH (cfgItem:WorkPlanMilestoneItem) WHERE cfgItem.itemType = ? AND coalesce(cfgItem.cfgItemInvalid, false) = false AND cfgItem.checkpointLastComputedGenId > ? MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.cfgMilestoneItemId = cfgItem.tildaid AND wp.state <> ? AND coalesce(item.checkpointQueuedAt, ?) > ? AND coalesce(item.checkpointCompletedAt, ?) = ? AND coalesce(item.checkpointRejectedAt, ?) = ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.checkpointGenId, ?) < cfgItem.checkpointLastComputedGenId AND (coalesce(item.checkpointScoreFailedAt, ?) = ? OR $nowMs - item.checkpointScoreFailedAt >= ?) RETURN item.tildaid AS instanceMilestoneItemId, wp.tildaid AS instanceId, cfgItem.tildaid AS cfgMilestoneItemId, cfgItem.checkpointLastComputedGenId AS lastComputedGenId ORDER BY item.checkpointQueuedAt LIMIT $limit
workplansvc
45
<1 ms
2 ms
1 ms
flat
MATCH(a:Actor{userId:$a_userId,orgId:$a_orgId,scopeId:$a_scopeId,delpending:$a_delpending}) RETURN a
MATCH(a:Actor{userId:$a_userId,orgId:$a_orgId,scopeId:$a_scopeId,delpending:$a_delpending}) RETURN a
docsvc
28
<1 ms
2 ms
1 ms
flat
MATCH(a:User{tildaid:$a_tildaid})-[r:INTERNAL_DATA]->(b:UserInternal) RETURN b limit $limit
MATCH(a:User{tildaid:$a_tildaid})-[r:INTERNAL_DATA]->(b:UserInternal) RETURN b limit $limit
onboardingsvc
14
<1 ms
2 ms
1 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
onboardingsvc
5
<1 ms
2 ms
1 ms
flat
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
MATCH (s:Study{tildaid: $studyID}) RETURN coalesce(s.isLocked, false)
onboardingsvc
5
<1 ms
2 ms
1 ms
flat
MATCH (d:Document) WHERE d.tildaid IN $docIds AND EXISTS { (d)<-[:HAS_SYSTEM_TEMPLATE]-(:Organization {alias:?}) } RETURN d.tildaid LIMIT ?
MATCH (d:Document) WHERE d.tildaid IN $docIds AND EXISTS { (d)<-[:HAS_SYSTEM_TEMPLATE]-(:Organization {alias:?}) } RETURN d.tildaid LIMIT ?
docsvc
150
<1 ms
2 ms
1 ms
flat
MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n
MATCH (n:WorkOrder {tildaid: $node_id}) RETURN n
virtual-assistant
31
<1 ms
2 ms
1 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
52
<1 ms
2 ms
1 ms
flat
MATCH(a:User{tildaid:$a_tildaid})-[r:INTERNAL_DATA]->(b:UserInternal) RETURN b limit $limit
MATCH(a:User{tildaid:$a_tildaid})-[r:INTERNAL_DATA]->(b:UserInternal) RETURN b limit $limit
onboardingsvc
11
<1 ms
2 ms
1 ms
flat
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun) WHERE ai.status = ? RETURN count(ai) > ? AS has_active_run
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun) WHERE ai.status = ? RETURN count(ai) > ? AS has_active_run
virtual-assistant
39
<1 ms
2 ms
1 ms
flat
MATCH (cfgItem:WorkPlanMilestoneItem) WHERE cfgItem.itemType = ? AND coalesce(cfgItem.cfgItemInvalid, false) = false AND cfgItem.checkpointLastComputedGenId > ? MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMiles…
MATCH (cfgItem:WorkPlanMilestoneItem) WHERE cfgItem.itemType = ? AND coalesce(cfgItem.cfgItemInvalid, false) = false AND cfgItem.checkpointLastComputedGenId > ? MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE item.cfgMilestoneItemId = cfgItem.tildaid AND wp.state <> ? AND coalesce(item.checkpointQueuedAt, ?) > ? AND coalesce(item.checkpointCompletedAt, ?) = ? AND coalesce(item.checkpointRejectedAt, ?) = ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND coalesce(item.checkpointGenId, ?) < cfgItem.checkpointLastComputedGenId AND (coalesce(item.checkpointScoreFailedAt, ?) = ? OR $nowMs - item.checkpointScoreFailedAt >= ?) RETURN item.tildaid AS instanceMilestoneItemId, wp.tildaid AS instanceId, cfgItem.tildaid AS cfgMilestoneItemId, cfgItem.checkpointLastComputedGenId AS lastComputedGenId ORDER BY item.checkpointQueuedAt LIMIT $limit
workplansvc
45
<1 ms
2 ms
1 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false AND mileston…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false AND milestone.scoringMode = ? AND item.checkpointPendingGenId > coalesce(item.checkpointLastComputedGenId, ?) AND (coalesce(item.checkpointGenerateRequestGenId, ?) <> item.checkpointPendingGenId OR $nowMs - coalesce(item.checkpointGenerateRequestSentAt, ?) >= ?) AND NOT (coalesce(item.checkpointUnsupportedGenId, ?) = item.checkpointPendingGenId AND coalesce(item.checkpointUnsupportedCount, ?) >= $maxUnsupported) AND coalesce(cfg.state, ?) <> ? OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) RETURN item.tildaid AS cfgMilestoneItemId, cfg.tildaid AS cfgId, milestone.tildaid AS milestoneId, coalesce(item.itemConfig, ?) AS itemConfig, item.checkpointPendingGenId AS pendingGenId, coalesce(org.alias, ?) AS orgAlias, coalesce(item.checkpointPendingBy, ?) AS pendingBy LIMIT $limit
workplansvc
48
<1 ms
2 ms
1 ms
flat
match(org:Organization{tildaid:$id})-[:ORGANIZATION_TO_FORM]->(protocol:ProtocolVersionV2{tildaid:$protocolId}) with protocol match(visit:VisitV2{tildaid:$visitId}) where exists((visit)<-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protocolid:$protocolI…
match(org:Organization{tildaid:$id})-[:ORGANIZATION_TO_FORM]->(protocol:ProtocolVersionV2{tildaid:$protocolId}) with protocol match(visit:VisitV2{tildaid:$visitId}) where exists((visit)<-[:GRAPH_NODE_REF_TO_GRAPH_NODE{protocolid:$protocolId1}]-()) return visit
studiosvc
12
<1 ms
2 ms
1 ms
flat
MATCH (pqn:ParticipantQuestion)-[:HAS_QUERY]-(q:Query)-[:BELONGS_TO]-(cfg:AutoQueryConfig) WHERE pqn.tildaid IN $pqnIds AND cfg.tildaid IN $cfgIds AND q.state IN $states AND coalesce(q.supersededAt, ?) = ? RETURN DISTINCT pqn.tildaid, cfg.…
MATCH (pqn:ParticipantQuestion)-[:HAS_QUERY]-(q:Query)-[:BELONGS_TO]-(cfg:AutoQueryConfig) WHERE pqn.tildaid IN $pqnIds AND cfg.tildaid IN $cfgIds AND q.state IN $states AND coalesce(q.supersededAt, ?) = ? RETURN DISTINCT pqn.tildaid, cfg.tildaid
execsvc
43
<1 ms
2 ms
1 ms
flat
MATCH(a:Actor{userId:$a_userId,orgId:$a_orgId,scopeId:$a_scopeId,delpending:$a_delpending}) RETURN a
MATCH(a:Actor{userId:$a_userId,orgId:$a_orgId,scopeId:$a_scopeId,delpending:$a_delpending}) RETURN a
docsvc
32
<1 ms
2 ms
1 ms
flat
MATCH (u:User {email: $identifier}) RETURN u.tildaid as tildaid, u.name as name, u.email as email, u.phoneNumber as phone, coalesce(u.authzUpdateNum, ?) as authzUpdateNum
MATCH (u:User {email: $identifier}) RETURN u.tildaid as tildaid, u.name as name, u.email as email, u.phoneNumber as phone, coalesce(u.authzUpdateNum, ?) as authzUpdateNum
docproc
33
<1 ms
2 ms
1 ms
flat
match (u:User{tildaid:$userId})-[:FOR_USER]-(a:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(o:Organization{alias:$scaleAlias}) where coalesce(a.state, ?) <> ? return a.tildaid
match (u:User{tildaid:$userId})-[:FOR_USER]-(a:Actor{delpending:false})-[:ORGANIZATION_TO_ACTOR]-(o:Organization{alias:$scaleAlias}) where coalesce(a.state, ?) <> ? return a.tildaid
docsvc
489
<1 ms
2 ms
2 ms
flat
MATCH (ds:GoldenDataset)-[:CONTAINS_DOCUMENT]->(:Document {tildaid: $document_id}) RETURN ds.tildaid AS golden_dataset_id LIMIT ?
MATCH (ds:GoldenDataset)-[:CONTAINS_DOCUMENT]->(:Document {tildaid: $document_id}) RETURN ds.tildaid AS golden_dataset_id LIMIT ?
docproc
91
<1 ms
2 ms
1 ms
flat
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id, o.alias as alias, o.name as name, o.orgType = ? as is_cro, o.orgType as org_type
MATCH (o:Organization {alias: $org_alias}) RETURN o.tildaid as org_id, o.alias as alias, o.name as name, o.orgType = ? as is_cro, o.orgType as org_type
virtual-assistant
508
<1 ms
2 ms
2 ms
flat
MATCH (s:Study {tildaid:$studyId})-[:USES]->(fm:FolderManager {name:?})-[:HAS]->(fi:FolderManagerInstructions) RETURN fi.auditPlan AS audit_plan
MATCH (s:Study {tildaid:$studyId})-[:USES]->(fm:FolderManager {name:?})-[:HAS]->(fi:FolderManagerInstructions) RETURN fi.auditPlan AS audit_plan
docproc
37
<1 ms
2 ms
1 ms
flat
MATCH (ds:GoldenDataset)-[:CONTAINS_DOCUMENT]->(:Document {tildaid: $document_id}) RETURN ds.tildaid AS golden_dataset_id LIMIT ?
MATCH (ds:GoldenDataset)-[:CONTAINS_DOCUMENT]->(:Document {tildaid: $document_id}) RETURN ds.tildaid AS golden_dataset_id LIMIT ?
docproc
135
<1 ms
2 ms
1 ms
flat
MATCH (d:Document {tildaid: $doc_id}) RETURN d.cbrRunStatus AS s
MATCH (d:Document {tildaid: $doc_id}) RETURN d.cbrRunStatus AS s
docproc
48
<1 ms
2 ms
1 ms
flat
MATCH(a:Study{tildaid:$a_tildaid})-[r:HAS_STUDY_CRITERION]->(b) RETURN b limit $limit
MATCH(a:Study{tildaid:$a_tildaid})-[r:HAS_STUDY_CRITERION]->(b) RETURN b limit $limit
enrollsvc
8
<1 ms
2 ms
1 ms
flat
UNWIND $ids AS id CALL { WITH id MATCH (d:Document {tildaid: id}) WHERE d.collection = $staging AND d.stateTag = $notReady RETURN d.tildaid AS notReady } RETURN collect(DISTINCT notReady) AS notReady
UNWIND $ids AS id CALL { WITH id MATCH (d:Document {tildaid: id}) WHERE d.collection = $staging AND d.stateTag = $notReady RETURN d.tildaid AS notReady } RETURN collect(DISTINCT notReady) AS notReady
docsvc
161
<1 ms
2 ms
1 ms
flat
UNWIND $ids AS id CALL { WITH id MATCH (d:Document {tildaid: id}) WHERE d.collection = $staging AND d.stateTag = $notReady RETURN d.tildaid AS notReady } RETURN collect(DISTINCT notReady) AS notReady
UNWIND $ids AS id CALL { WITH id MATCH (d:Document {tildaid: id}) WHERE d.collection = $staging AND d.stateTag = $notReady RETURN d.tildaid AS notReady } RETURN collect(DISTINCT notReady) AS notReady
docsvc
155
<1 ms
2 ms
1 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
28
<1 ms
2 ms
1 ms
flat
MATCH (n:Study{tildaid: $assocId}) MATCH (d:Document{tildaid: $docId}) MERGE (d)-[:BELONGS_TO]->(n) RETURN n.tildaid
MATCH (n:Study{tildaid: $assocId}) MATCH (d:Document{tildaid: $docId}) MERGE (d)-[:BELONGS_TO]->(n) RETURN n.tildaid
writedocsvc
38
<1 ms
2 ms
1 ms
flat
MATCH (r:TmfEvaluationRun {status: $running}) WHERE r.deltimestamp = ? AND coalesce(r.updatedat, r.createdat) < $cutoff RETURN r.tildaid AS tildaid, r.trainingId AS trainingId, r.tmfVersion AS tmfVersion, r.startedBy AS startedBy ORDER BY …
MATCH (r:TmfEvaluationRun {status: $running}) WHERE r.deltimestamp = ? AND coalesce(r.updatedat, r.createdat) < $cutoff RETURN r.tildaid AS tildaid, r.trainingId AS trainingId, r.tmfVersion AS tmfVersion, r.startedBy AS startedBy ORDER BY coalesce(r.updatedat, r.createdat) ASC LIMIT $limit
docproc
10
<1 ms
2 ms
1 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
21
<1 ms
2 ms
1 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
289
<1 ms
2 ms
2 ms
flat
MATCH (task:Task) WHERE task.task_number = ? AND EXISTS { (task)-[:BELONGS_TO]->(:Inbox{type:?})-[:MANAGED_BY]->(:Organization) } RETURN task.tildaid LIMIT ?
MATCH (task:Task) WHERE task.task_number = ? AND EXISTS { (task)-[:BELONGS_TO]->(:Inbox{type:?})-[:MANAGED_BY]->(:Organization) } RETURN task.tildaid LIMIT ?
tusker
24
<1 ms
2 ms
1 ms
flat
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun) WHERE ai.status = ? RETURN count(ai) > ? AS has_active_run
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST]-(ai:AIRun) WHERE ai.status = ? RETURN count(ai) > ? AS has_active_run
virtual-assistant
62
<1 ms
2 ms
1 ms
flat
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category RETURN count(r) > ? AS has_resolved
MATCH (d:Document {tildaid: $doc_id})<-[:RECOMMENDATION_TO_DOCUMENT]-(r:Recommendation) WHERE r.status = ? AND r.category = $category RETURN count(r) > ? AS has_resolved
docproc
256
<1 ms
2 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
602
<1 ms
2 ms
2 ms
flat
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false AND mileston…
MATCH (cfg:WorkplanCfg)-[:WORKPLAN_CFG_TO_MILESTONE]->(milestone:WorkPlanMilestone)-[:WORKPLAN_MILESTONE_TO_MILESTONE_ITEM]->(item:WorkPlanMilestoneItem) WHERE item.itemType = ? AND coalesce(item.cfgItemInvalid, false) = false AND milestone.scoringMode = ? AND item.checkpointPendingGenId > coalesce(item.checkpointLastComputedGenId, ?) AND (coalesce(item.checkpointGenerateRequestGenId, ?) <> item.checkpointPendingGenId OR $nowMs - coalesce(item.checkpointGenerateRequestSentAt, ?) >= ?) AND NOT (coalesce(item.checkpointUnsupportedGenId, ?) = item.checkpointPendingGenId AND coalesce(item.checkpointUnsupportedCount, ?) >= $maxUnsupported) AND coalesce(cfg.state, ?) <> ? OPTIONAL MATCH (org:Organization {tildaid: cfg.orgid}) RETURN item.tildaid AS cfgMilestoneItemId, cfg.tildaid AS cfgId, milestone.tildaid AS milestoneId, coalesce(item.itemConfig, ?) AS itemConfig, item.checkpointPendingGenId AS pendingGenId, coalesce(org.alias, ?) AS orgAlias, coalesce(item.checkpointPendingBy, ?) AS pendingBy LIMIT $limit
workplansvc
42
<1 ms
2 ms
1 ms
flat
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) return currentUser as user
MATCH (currentUser:User{deltimestamp:?,deltimestamp:?,email:$email}) WHERE (currentUser.isDummy IS NULL OR currentUser.isDummy <> true) return currentUser as user
onboardingsvc
114
<1 ms
2 ms
1 ms
flat
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST|AI_RUN_TO_DOCUMENT_OLD]-(ai:AIRun) RETURN ai ORDER BY ai.createdat DESC
MATCH (d:Document {tildaid: $doc_id})<-[:AI_RUN_TO_DOCUMENT_LATEST|AI_RUN_TO_DOCUMENT_OLD]-(ai:AIRun) RETURN ai ORDER BY ai.createdat DESC
virtual-assistant
508
<1 ms
2 ms
2 ms
flat
MATCH (ai:AIRun {tildaid: $aiRunId}) OPTIONAL MATCH (ai)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d1:Document) OPTIONAL MATCH (ai)-[:AI_RUN_TO_RECOMMENDATION]->(r:Recommendation)-[:RECOMMENDATION_TO_DOCUMENT]->(d2:Document) WITH ai.status AS ai_stat…
MATCH (ai:AIRun {tildaid: $aiRunId}) OPTIONAL MATCH (ai)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d1:Document) OPTIONAL MATCH (ai)-[:AI_RUN_TO_RECOMMENDATION]->(r:Recommendation)-[:RECOMMENDATION_TO_DOCUMENT]->(d2:Document) WITH ai.status AS ai_status, coalesce(d1.tildaid, d2.tildaid) AS doc_id WHERE doc_id IS NOT NULL RETURN ai_status, doc_id LIMIT ?
dashrsvc
30
<1 ms
2 ms
1 ms
flat
MATCH (s:Study {tildaid:$studyId})-[:USES]->(fm:FolderManager {name:?})-[:HAS]->(fi:FolderManagerInstructions) RETURN fi.auditPlan AS audit_plan
MATCH (s:Study {tildaid:$studyId})-[:USES]->(fm:FolderManager {name:?})-[:HAS]->(fi:FolderManagerInstructions) RETURN fi.auditPlan AS audit_plan
docproc
45
<1 ms
2 ms
1 ms
flat
MATCH (obj:Document{tildaid:$scopeId}) SET obj._LOCK_ = true REMOVE obj._LOCK_ WITH obj OPTIONAL MATCH (obj)-[oldTail:TAIL_CHANGELOG]->(:ChangeLog) DELETE oldTail WITH DISTINCT obj UNWIND range(?, size($changeLogs) - ?) AS i WITH obj, i, $…
MATCH (obj:Document{tildaid:$scopeId}) SET obj._LOCK_ = true REMOVE obj._LOCK_ WITH obj OPTIONAL MATCH (obj)-[oldTail:TAIL_CHANGELOG]->(:ChangeLog) DELETE oldTail WITH DISTINCT obj UNWIND range(?, size($changeLogs) - ?) AS i WITH obj, i, $changeLogs[i] AS log CREATE (cl:ChangeLog) SET cl = log, cl.createdat = timestamp() + $seqOffset + i, cl.scopeId = $scopeId CREATE (obj)-[r2:ALL_CHANGELOG]->(cl) SET r2.tildaid = randomUUID(), r2.createdat = timestamp() WITH obj, collect(cl) AS createdLogs WITH obj, createdLogs[-?] AS lastLog CREATE (obj)-[r1:TAIL_CHANGELOG]->(lastLog) SET r1.tildaid = randomUUID(), r1.createdat = timestamp()
writedocsvc
541
<1 ms
2 ms
2 ms
flat
MATCH (n:AIRun {tildaid: $node_id}) RETURN n
MATCH (n:AIRun {tildaid: $node_id}) RETURN n
docproc
169
<1 ms
2 ms
1 ms
flat
MATCH (obj:DocumentVersion{tildaid:$scopeId}) SET obj._LOCK_ = true REMOVE obj._LOCK_ WITH obj OPTIONAL MATCH (obj)-[oldTail:TAIL_CHANGELOG]->(:ChangeLog) DELETE oldTail WITH DISTINCT obj UNWIND range(?, size($changeLogs) - ?) AS i WITH ob…
MATCH (obj:DocumentVersion{tildaid:$scopeId}) SET obj._LOCK_ = true REMOVE obj._LOCK_ WITH obj OPTIONAL MATCH (obj)-[oldTail:TAIL_CHANGELOG]->(:ChangeLog) DELETE oldTail WITH DISTINCT obj UNWIND range(?, size($changeLogs) - ?) AS i WITH obj, i, $changeLogs[i] AS log CREATE (cl:ChangeLog) SET cl = log, cl.createdat = timestamp() + $seqOffset + i, cl.scopeId = $scopeId CREATE (obj)-[r2:ALL_CHANGELOG]->(cl) SET r2.tildaid = randomUUID(), r2.createdat = timestamp() WITH obj, collect(cl) AS createdLogs WITH obj, createdLogs[-?] AS lastLog CREATE (obj)-[r1:TAIL_CHANGELOG]->(lastLog) SET r1.tildaid = randomUUID(), r1.createdat = timestamp()
writedocsvc
410
<1 ms
2 ms
17 ms
flat
MATCH (doc:Document {tildaid: $doc_id}) OPTIONAL MATCH (ph:Document)-[:MATCHING_DOCUMENT]->(doc) OPTIONAL MATCH (ph2:Document)-[:ACCEPTED_DOCUMENT]->(doc) RETURN COUNT(DISTINCT ph) AS potentialCount, COUNT(DISTINCT ph2) AS acceptedCount
MATCH (doc:Document {tildaid: $doc_id}) OPTIONAL MATCH (ph:Document)-[:MATCHING_DOCUMENT]->(doc) OPTIONAL MATCH (ph2:Document)-[:ACCEPTED_DOCUMENT]->(doc) RETURN COUNT(DISTINCT ph) AS potentialCount, COUNT(DISTINCT ph2) AS acceptedCount
virtual-assistant
116
<1 ms
2 ms
1 ms
flat
MATCH (w:WorkOrder)-[:WORK_ORDER_TO_DOCUMENT]->(d:Document {tildaid: $doc_id}) WHERE w.delpending = false RETURN w ORDER BY coalesce(w.updatedat, w.createdat) DESC LIMIT ?
MATCH (w:WorkOrder)-[:WORK_ORDER_TO_DOCUMENT]->(d:Document {tildaid: $doc_id}) WHERE w.delpending = false RETURN w ORDER BY coalesce(w.updatedat, w.createdat) DESC LIMIT ?
virtual-assistant
1,169
<1 ms
2 ms
3 ms
flat
UNWIND $entries AS entry OPTIONAL MATCH (f:Folder{tildaid: entry.folderId}) WHERE entry.folderId <> ? AND f.isArchived = true OPTIONAL MATCH (sa:SubArtifact{tildaid: entry.subArtId}) WHERE entry.subArtId <> ? AND sa.isArchived = true RETUR…
UNWIND $entries AS entry OPTIONAL MATCH (f:Folder{tildaid: entry.folderId}) WHERE entry.folderId <> ? AND f.isArchived = true OPTIONAL MATCH (sa:SubArtifact{tildaid: entry.subArtId}) WHERE entry.subArtId <> ? AND sa.isArchived = true RETURN entry.index, f.tildaid, sa.tildaid
docsvc
107
<1 ms
2 ms
1 ms
flat
MATCH (ai:AIRun {tildaid: $aiRunId}) OPTIONAL MATCH (ai)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d1:Document) OPTIONAL MATCH (ai)-[:AI_RUN_TO_RECOMMENDATION]->(r:Recommendation)-[:RECOMMENDATION_TO_DOCUMENT]->(d2:Document) WITH ai.status AS ai_stat…
MATCH (ai:AIRun {tildaid: $aiRunId}) OPTIONAL MATCH (ai)-[:AI_RUN_TO_DOCUMENT_LATEST]->(d1:Document) OPTIONAL MATCH (ai)-[:AI_RUN_TO_RECOMMENDATION]->(r:Recommendation)-[:RECOMMENDATION_TO_DOCUMENT]->(d2:Document) WITH ai.status AS ai_status, coalesce(d1.tildaid, d2.tildaid) AS doc_id WHERE doc_id IS NOT NULL RETURN ai_status, doc_id LIMIT ?
dashrsvc
36
<1 ms
2 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).