workplansvc shape 50B96E05: p95 1.45 s now vs 488 ms earlier (3.0×, 223 runs)
warning
Query shape degrading
test27
resolved
impact 15
Owner: Suresh Boddapati (backup: Madhava Mukkamala)
opened 1d ago · last observed 1d ago · observed 4× · #17511 · 0cd7cda24a82eee8a9f6
What happened template
A workplansvc query shape on test27 has p95 1.4 s in the second half of the window against 488 ms in the first (3.0×, 223 executions). The shape reads: “MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO…”. Slower can mean more data, a lost index, or lock contention — the shape page has the CPU/wait split. Shapes whose p95 stays under a second are never reported: below that nobody notices, whatever the ratio.
A Cypher shape whose p95 is worsening across the window and is at least 1 s now; spikes under a second are ignored.
The facts
| service | workplansvc |
| plan_hash | 50B96E05 |
| queries | 223 |
| floor_ms | 1,000 |
| p95_early | 487.50 |
| p95_late | 1,450 |
| ratio | 2.97 |
| avg_ms | 424.41 |
| sample | MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE wp.state <> ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND (coalesce(item.workOrderCreateUnresolvableAt, ?) = ? OR $nowMs - item.workOrderCreateUnresolvableAt >= $windowMs) AND ( (item.itemTyp |
| rw | read |
| discriminator | 50B96E05 |
| window | 2026-11-17 02:04:09 UTC → 2026-11-17 08:04:09 UTC |
The story — No workplansvc deploy or hand change is recorded in the hour before this opened. Everything below is workplansvc only.
- 2026-11-17 07:09:11 UTCthis finding workplansvc shape 50B96E05: p95 1.45 s now vs 488 ms earlier (3.0×, 223 runs)
History
- 2026-11-17 07:09:11 UTCopened x-ray · severity=warning title=workplansvc shape 50B96E05: p95 1.09 s now vs 490 ms earlier (2.2×, 266 runs) finding={'id': 17511, 'fingerprint': '0cd7cda24a82eee8a9f6', 'kind': 'shape.degrading', 'severity': 'warning', 'cluster': 'test27', 'subject': 'workplansvc', 'title': 'workplansvc shape 50B96E05: p95 1.09 s now vs 490 ms earlier (2.2×, 266 runs)', 'facts': {'service': 'workplansvc', 'plan_hash': '50B96E05', 'queries': 266, 'floor_ms': 1000, 'p95_early': 490.02941176470586, 'p95_late': 1087.4999999999986, 'ratio': 2.219254546545823, 'avg_ms': 395.7593984962406, 'sample': 'MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE wp.state <> ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND (coalesce(item.workOrderCreateUnresolvableAt, ?) = ? OR $nowMs - item.workOrderCreateUnresolvableAt >= $windowMs) AND ( (item.itemTyp', 'rw': 'read', 'window': [1794877751, 1794899351], 'recent_deploys': [], 'discriminator': '50B96E05'}, 'evidence': [{'label': 'Query shape', 'href': '/neo/shape/50B96E05?cluster=test27&from=1794877751&to=1794899351'}, {'label': 'Degrading shapes', 'href': '/neo/queries?cluster=test27&from=1794877751&to=1794899351&order=degrading'}], 'provenance': {'source': 'rollup', 'collected_at': 1794899130, 'age_seconds': 228, 'stale': False, 'shown': None, 'total': None, 'truncated': False, 'coverage_from': None, 'retain_days': None, 'note': None}, 'impact': 14.0, 'status': 'open', 'first_seen': 1794899351, 'last_seen': 1794899351, 'resolved_at': None, 'acked_by': None, 'acked_at': None, 'snoozed_until': None, 'occurrences': 1, 'narrative': None, 'narrative_kind': None, 'discriminator': '50B96E05', 'level': 'low', 'told_level': None, 'episode_at': 1794899351, 'chat_thread': None, 'kind_label': 'Query shape degrading', 'group': 'Neo4j', 'age_s': 7, 'stale_s': 7}
- 2026-11-17 08:26:41 UTCresolved x-ray · reason=not observed grace_s=900 finding={'id': 17511, 'fingerprint': '0cd7cda24a82eee8a9f6', 'kind': 'shape.degrading', 'severity': 'warning', 'cluster': 'test27', 'subject': 'workplansvc', 'title': 'workplansvc shape 50B96E05: p95 1.45 s now vs 488 ms earlier (3.0×, 223 runs)', 'facts': {'service': 'workplansvc', 'plan_hash': '50B96E05', 'queries': 223, 'floor_ms': 1000, 'p95_early': 487.5, 'p95_late': 1449.9999999999993, 'ratio': 2.974358974358973, 'avg_ms': 424.41255605381167, 'sample': 'MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO_ITEM]->(item:WorkplanInstanceMilestoneItem) WHERE wp.state <> ? AND coalesce(item.skippedAt, ?) = ? AND coalesce(item.notApplicableAt, ?) = ? AND (coalesce(item.workOrderCreateUnresolvableAt, ?) = ? OR $nowMs - item.workOrderCreateUnresolvableAt >= $windowMs) AND ( (item.itemTyp', 'rw': 'read', 'window': [1794881049, 1794902649], 'recent_deploys': [], 'discriminator': '50B96E05'}, 'evidence': [{'label': 'Query shape', 'href': '/neo/shape/50B96E05?cluster=test27&from=1794881049&to=1794902649'}, {'label': 'Degrading shapes', 'href': '/neo/queries?cluster=test27&from=1794881049&to=1794902649&order=degrading'}], 'provenance': {'source': 'rollup', 'collected_at': 1794902361, 'age_seconds': 295, 'stale': False, 'shown': None, 'total': None, 'truncated': False, 'coverage_from': None, 'retain_days': None, 'note': None}, 'impact': 14.9, 'status': 'resolved', 'first_seen': 1794899351, 'last_seen': 1794902649, 'resolved_at': 1794904001, 'acked_by': None, 'acked_at': None, 'snoozed_until': None, 'occurrences': 4, 'narrative': 'A workplansvc query shape on test27 has p95 1.4 s in the second half of the window against 488 ms in the first (3.0×, 223 executions). The shape reads: “MATCH (wp:WorkPlanInstance)-[:WORKPLAN_INSTANCE_TO_MILESTONE]->(:WorkPlanMilestone)-[:REL_WORKPLAN_INSTANCE_MILESTONE_TO…”. Slower can mean more data, a lost index, or lock contention — the shape page has the CPU/wait split. Shapes whose p95 stays under a second are never reported: below that nobody notices, whatever the ratio.', 'narrative_kind': 'template', 'discriminator': '50B96E05', 'level': 'low', 'told_level': None, 'episode_at': 1794899351, 'chat_thread': None, 'kind_label': 'Query shape degrading', 'group': 'Neo4j', 'age_s': 4658, 'stale_s': 1360}
Check it yourself
Every link carries the finding's own time window, so it shows tomorrow what it shows now.
Actions
Sign in (IAP) to acknowledge, snooze or resolve.
Where the numbers come from
| source | rollup |
| collected_at | 1794902361 |
| age_seconds | 295 |
| stale | False |
| shown | None |
| total | None |
| truncated | False |
| coverage_from | None |
| retain_days | None |
| note | None |
| detector | shapes |