← findings
studiosvc runs 270 foreground Neo4j queries per request (180,895 queries / 670 calls, last hour)
info
N+1 fan-out
test27
open
impact 14
Owner: Suresh Boddapati (backup: Madhava Mukkamala)
opened 83d ago · last observed 22h ago · observed 329× · #190 · ef45406d7d5a80087554
What happened template
studiosvc on test27 averaged 270.0 foreground Neo4j queries per API request over the last hour (180,895 queries for 670 calls). Dozens of queries per request is the N+1 signature: a round-trip per row instead of one query. The Journey page shows which screens pay for it, request by request.
One request that runs a large number of Neo4j queries.
The facts
| service | studiosvc |
| qpr | 270.00 |
| calls | 670.00 |
| fg_queries | 180,895 |
| bg_queries | 0 |
| discriminator | |
| window | 2026-11-17 09:40:41 UTC → 2026-11-17 10:40:41 UTC |
History
- 2026-11-15 06:59:37 UTCreopened x-ray · severity=info was=info title=studiosvc runs 261 foreground Neo4j queries per request (66,134 queries / 253 calls, last hour) level=low was_level=low finding={'id': 190, 'fingerprint': 'ef45406d7d5a80087554', 'kind': 'n1.fanout', 'severity': 'info', 'cluster': 'test27', 'subject': 'studiosvc', 'title': 'studiosvc runs 261 foreground Neo4j queries per request (66,134 queries / 253 calls, last hour)', 'facts': {'service': 'studiosvc', 'qpr': 261.4, 'calls': 253.0, 'fg_queries': 66134.0, 'bg_queries': 0, 'window': [1794722377, 1794725977], 'discriminator': ''}, 'evidence': [{'label': 'Neo4j by service', 'href': '/overview?cluster=test27&from=1794722377&to=1794725977'}, {'label': 'Journey (per-request Cypher)', 'href': '/journey?cluster=test27&from=1794722377&to=1794725977'}], 'provenance': {'source': 'rollup', 'collected_at': 1794725976, 'age_seconds': 9, 'stale': False, 'shown': None, 'total': None, 'truncated': False, 'coverage_from': None, 'retain_days': None, 'note': None}, 'impact': 6.1, 'status': 'open', 'first_seen': 1787804784, 'last_seen': 1794725977, 'resolved_at': None, 'acked_by': None, 'acked_at': None, 'snoozed_until': None, 'occurrences': 289, 'narrative': 'studiosvc on test27 averaged 39.3 foreground Neo4j queries per API request over the last hour (4,671 queries for 119 calls). Dozens of queries per request is the N+1 signature: a round-trip per row instead of one query. The Journey page shows which screens pay for it, request by request.', 'narrative_kind': 'template', 'discriminator': '', 'level': 'low', 'told_level': None, 'episode_at': 1794725977, 'chat_thread': None, 'kind_label': 'N+1 fan-out', 'group': 'Journey', 'age_s': 6921200, 'stale_s': 7}
- 2026-11-15 16:57:22 UTCresolved x-ray · reason=not observed grace_s=900 finding={'id': 190, 'fingerprint': 'ef45406d7d5a80087554', 'kind': 'n1.fanout', 'severity': 'info', 'cluster': 'test27', 'subject': 'studiosvc', 'title': 'studiosvc runs 380 foreground Neo4j queries per request (22,793 queries / 60 calls, last hour)', 'facts': {'service': 'studiosvc', 'qpr': 379.9, 'calls': 60.0, 'fg_queries': 22793.0, 'bg_queries': 0, 'window': [1794736697, 1794740297], 'discriminator': ''}, 'evidence': [{'label': 'Neo4j by service', 'href': '/overview?cluster=test27&from=1794736697&to=1794740297'}, {'label': 'Journey (per-request Cypher)', 'href': '/journey?cluster=test27&from=1794736697&to=1794740297'}], 'provenance': {'source': 'rollup', 'collected_at': 1794740295, 'age_seconds': 8, 'stale': False, 'shown': None, 'total': None, 'truncated': False, 'coverage_from': None, 'retain_days': None, 'note': None}, 'impact': 10.6, 'status': 'resolved', 'first_seen': 1787804784, 'last_seen': 1794740297, 'resolved_at': 1794761842, 'acked_by': None, 'acked_at': None, 'snoozed_until': None, 'occurrences': 302, 'narrative': 'studiosvc on test27 averaged 379.9 foreground Neo4j queries per API request over the last hour (22,793 queries for 60 calls). Dozens of queries per request is the N+1 signature: a round-trip per row instead of one query. The Journey page shows which screens pay for it, request by request.', 'narrative_kind': 'template', 'discriminator': '', 'level': 'low', 'told_level': None, 'episode_at': 1794725977, 'chat_thread': None, 'kind_label': 'N+1 fan-out', 'group': 'Journey', 'age_s': 6957063, 'stale_s': 21550}
- 2026-11-15 19:16:14 UTCreopened x-ray · severity=info was=info title=studiosvc runs 144 foreground Neo4j queries per request (8,349 queries / 58 calls, last hour) level=low was_level=low finding={'id': 190, 'fingerprint': 'ef45406d7d5a80087554', 'kind': 'n1.fanout', 'severity': 'info', 'cluster': 'test27', 'subject': 'studiosvc', 'title': 'studiosvc runs 144 foreground Neo4j queries per request (8,349 queries / 58 calls, last hour)', 'facts': {'service': 'studiosvc', 'qpr': 143.9, 'calls': 58.0, 'fg_queries': 8349.0, 'bg_queries': 0, 'window': [1794766574, 1794770174], 'discriminator': ''}, 'evidence': [{'label': 'Neo4j by service', 'href': '/overview?cluster=test27&from=1794766574&to=1794770174'}, {'label': 'Journey (per-request Cypher)', 'href': '/journey?cluster=test27&from=1794766574&to=1794770174'}], 'provenance': {'source': 'rollup', 'collected_at': 1794770172, 'age_seconds': 9, 'stale': False, 'shown': None, 'total': None, 'truncated': False, 'coverage_from': None, 'retain_days': None, 'note': None}, 'impact': 5.2, 'status': 'open', 'first_seen': 1787804784, 'last_seen': 1794770174, 'resolved_at': None, 'acked_by': None, 'acked_at': None, 'snoozed_until': None, 'occurrences': 303, 'narrative': 'studiosvc on test27 averaged 379.9 foreground Neo4j queries per API request over the last hour (22,793 queries for 60 calls). Dozens of queries per request is the N+1 signature: a round-trip per row instead of one query. The Journey page shows which screens pay for it, request by request.', 'narrative_kind': 'template', 'discriminator': '', 'level': 'low', 'told_level': None, 'episode_at': 1794770174, 'chat_thread': None, 'kind_label': 'N+1 fan-out', 'group': 'Journey', 'age_s': 6965396, 'stale_s': 6}
- 2026-11-15 20:33:59 UTCresolved x-ray · reason=not observed grace_s=900 finding={'id': 190, 'fingerprint': 'ef45406d7d5a80087554', 'kind': 'n1.fanout', 'severity': 'info', 'cluster': 'test27', 'subject': 'studiosvc', 'title': 'studiosvc runs 128 foreground Neo4j queries per request (8,329 queries / 65 calls, last hour)', 'facts': {'service': 'studiosvc', 'qpr': 128.1, 'calls': 65.0, 'fg_queries': 8329.0, 'bg_queries': 0, 'window': [1794767928, 1794771528], 'discriminator': ''}, 'evidence': [{'label': 'Neo4j by service', 'href': '/overview?cluster=test27&from=1794767928&to=1794771528'}, {'label': 'Journey (per-request Cypher)', 'href': '/journey?cluster=test27&from=1794767928&to=1794771528'}], 'provenance': {'source': 'rollup', 'collected_at': 1794771526, 'age_seconds': 9, 'stale': False, 'shown': None, 'total': None, 'truncated': False, 'coverage_from': None, 'retain_days': None, 'note': None}, 'impact': 10.2, 'status': 'resolved', 'first_seen': 1787804784, 'last_seen': 1794771528, 'resolved_at': 1794774839, 'acked_by': None, 'acked_at': None, 'snoozed_until': None, 'occurrences': 304, 'narrative': 'studiosvc on test27 averaged 128.1 foreground Neo4j queries per API request over the last hour (8,329 queries for 65 calls). Dozens of queries per request is the N+1 signature: a round-trip per row instead of one query. The Journey page shows which screens pay for it, request by request.', 'narrative_kind': 'template', 'discriminator': '', 'level': 'low', 'told_level': None, 'episode_at': 1794770174, 'chat_thread': None, 'kind_label': 'N+1 fan-out', 'group': 'Journey', 'age_s': 6970062, 'stale_s': 3318}
- 2026-11-16 05:33:15 UTCreopened x-ray · severity=info was=info title=studiosvc runs 185 foreground Neo4j queries per request (48,673 queries / 263 calls, last hour) level=low was_level=low finding={'id': 190, 'fingerprint': 'ef45406d7d5a80087554', 'kind': 'n1.fanout', 'severity': 'info', 'cluster': 'test27', 'subject': 'studiosvc', 'title': 'studiosvc runs 185 foreground Neo4j queries per request (48,673 queries / 263 calls, last hour)', 'facts': {'service': 'studiosvc', 'qpr': 185.1, 'calls': 263.0, 'fg_queries': 48673.0, 'bg_queries': 0, 'window': [1794803595, 1794807195], 'discriminator': ''}, 'evidence': [{'label': 'Neo4j by service', 'href': '/overview?cluster=test27&from=1794803595&to=1794807195'}, {'label': 'Journey (per-request Cypher)', 'href': '/journey?cluster=test27&from=1794803595&to=1794807195'}], 'provenance': {'source': 'rollup', 'collected_at': 1794807006, 'age_seconds': 197, 'stale': False, 'shown': None, 'total': None, 'truncated': False, 'coverage_from': None, 'retain_days': None, 'note': None}, 'impact': 6.6, 'status': 'open', 'first_seen': 1787804784, 'last_seen': 1794807195, 'resolved_at': None, 'acked_by': None, 'acked_at': None, 'snoozed_until': None, 'occurrences': 305, 'narrative': 'studiosvc on test27 averaged 128.1 foreground Neo4j queries per API request over the last hour (8,329 queries for 65 calls). Dozens of queries per request is the N+1 signature: a round-trip per row instead of one query. The Journey page shows which screens pay for it, request by request.', 'narrative_kind': 'template', 'discriminator': '', 'level': 'low', 'told_level': None, 'episode_at': 1794807195, 'chat_thread': None, 'kind_label': 'N+1 fan-out', 'group': 'Journey', 'age_s': 7002419, 'stale_s': 8}
- 2026-11-16 08:15:41 UTCresolved x-ray · reason=not observed grace_s=900 finding={'id': 190, 'fingerprint': 'ef45406d7d5a80087554', 'kind': 'n1.fanout', 'severity': 'info', 'cluster': 'test27', 'subject': 'studiosvc', 'title': 'studiosvc runs 39 foreground Neo4j queries per request (19,987 queries / 509 calls, last hour)', 'facts': {'service': 'studiosvc', 'qpr': 39.3, 'calls': 509.0, 'fg_queries': 19987.0, 'bg_queries': 0, 'window': [1794811916, 1794815516], 'discriminator': ''}, 'evidence': [{'label': 'Neo4j by service', 'href': '/overview?cluster=test27&from=1794811916&to=1794815516'}, {'label': 'Journey (per-request Cypher)', 'href': '/journey?cluster=test27&from=1794811916&to=1794815516'}], 'provenance': {'source': 'rollup', 'collected_at': 1794815515, 'age_seconds': 9, 'stale': False, 'shown': None, 'total': None, 'truncated': False, 'coverage_from': None, 'retain_days': None, 'note': None}, 'impact': 12.0, 'status': 'resolved', 'first_seen': 1787804784, 'last_seen': 1794815516, 'resolved_at': 1794816941, 'acked_by': None, 'acked_at': None, 'snoozed_until': None, 'occurrences': 312, 'narrative': 'studiosvc on test27 averaged 39.3 foreground Neo4j queries per API request over the last hour (19,987 queries for 509 calls). Dozens of queries per request is the N+1 signature: a round-trip per row instead of one query. The Journey page shows which screens pay for it, request by request.', 'narrative_kind': 'template', 'discriminator': '', 'level': 'low', 'told_level': None, 'episode_at': 1794807195, 'chat_thread': None, 'kind_label': 'N+1 fan-out', 'group': 'Journey', 'age_s': 7012166, 'stale_s': 1434}
- 2026-11-16 18:54:59 UTCreopened x-ray · severity=info was=info title=studiosvc runs 46 foreground Neo4j queries per request (31,773 queries / 689 calls, last hour) level=low was_level=low finding={'id': 190, 'fingerprint': 'ef45406d7d5a80087554', 'kind': 'n1.fanout', 'severity': 'info', 'cluster': 'test27', 'subject': 'studiosvc', 'title': 'studiosvc runs 46 foreground Neo4j queries per request (31,773 queries / 689 calls, last hour)', 'facts': {'service': 'studiosvc', 'qpr': 46.1, 'calls': 689.0, 'fg_queries': 31773.0, 'bg_queries': 229.0, 'window': [1794851699, 1794855299], 'discriminator': ''}, 'evidence': [{'label': 'Neo4j by service', 'href': '/overview?cluster=test27&from=1794851699&to=1794855299'}, {'label': 'Journey (per-request Cypher)', 'href': '/journey?cluster=test27&from=1794851699&to=1794855299'}], 'provenance': {'source': 'rollup', 'collected_at': 1794855295, 'age_seconds': 14, 'stale': False, 'shown': None, 'total': None, 'truncated': False, 'coverage_from': None, 'retain_days': None, 'note': None}, 'impact': 7.8, 'status': 'open', 'first_seen': 1787804784, 'last_seen': 1794855299, 'resolved_at': None, 'acked_by': None, 'acked_at': None, 'snoozed_until': None, 'occurrences': 313, 'narrative': 'studiosvc on test27 averaged 39.3 foreground Neo4j queries per API request over the last hour (19,987 queries for 509 calls). Dozens of queries per request is the N+1 signature: a round-trip per row instead of one query. The Journey page shows which screens pay for it, request by request.', 'narrative_kind': 'template', 'discriminator': '', 'level': 'low', 'told_level': None, 'episode_at': 1794855299, 'chat_thread': None, 'kind_label': 'N+1 fan-out', 'group': 'Journey', 'age_s': 7050524, 'stale_s': 9}
- 2026-11-16 20:29:07 UTCresolved x-ray · reason=not observed grace_s=900 finding={'id': 190, 'fingerprint': 'ef45406d7d5a80087554', 'kind': 'n1.fanout', 'severity': 'info', 'cluster': 'test27', 'subject': 'studiosvc', 'title': 'studiosvc runs 52 foreground Neo4j queries per request (26,571 queries / 507 calls, last hour)', 'facts': {'service': 'studiosvc', 'qpr': 52.4, 'calls': 507.0, 'fg_queries': 26571.0, 'bg_queries': 202.0, 'window': [1794856376, 1794859976], 'discriminator': ''}, 'evidence': [{'label': 'Neo4j by service', 'href': '/overview?cluster=test27&from=1794856376&to=1794859976'}, {'label': 'Journey (per-request Cypher)', 'href': '/journey?cluster=test27&from=1794856376&to=1794859976'}], 'provenance': {'source': 'rollup', 'collected_at': 1794859804, 'age_seconds': 182, 'stale': False, 'shown': None, 'total': None, 'truncated': False, 'coverage_from': None, 'retain_days': None, 'note': None}, 'impact': 13.7, 'status': 'resolved', 'first_seen': 1787804784, 'last_seen': 1794859976, 'resolved_at': 1794860947, 'acked_by': None, 'acked_at': None, 'snoozed_until': None, 'occurrences': 317, 'narrative': 'studiosvc on test27 averaged 52.4 foreground Neo4j queries per API request over the last hour (26,571 queries for 507 calls). Dozens of queries per request is the N+1 signature: a round-trip per row instead of one query. The Journey page shows which screens pay for it, request by request.', 'narrative_kind': 'template', 'discriminator': '', 'level': 'low', 'told_level': None, 'episode_at': 1794855299, 'chat_thread': None, 'kind_label': 'N+1 fan-out', 'group': 'Journey', 'age_s': 7056179, 'stale_s': 987}
- 2026-11-17 06:42:35 UTCreopened x-ray · severity=info was=info title=studiosvc runs 76 foreground Neo4j queries per request (61,212 queries / 808 calls, last hour) level=low was_level=low finding={'id': 190, 'fingerprint': 'ef45406d7d5a80087554', 'kind': 'n1.fanout', 'severity': 'info', 'cluster': 'test27', 'subject': 'studiosvc', 'title': 'studiosvc runs 76 foreground Neo4j queries per request (61,212 queries / 808 calls, last hour)', 'facts': {'service': 'studiosvc', 'qpr': 75.8, 'calls': 808.0, 'fg_queries': 61212.0, 'bg_queries': 0, 'window': [1794894155, 1794897755], 'discriminator': ''}, 'evidence': [{'label': 'Neo4j by service', 'href': '/overview?cluster=test27&from=1794894155&to=1794897755'}, {'label': 'Journey (per-request Cypher)', 'href': '/journey?cluster=test27&from=1794894155&to=1794897755'}], 'provenance': {'source': 'rollup', 'collected_at': 1794897586, 'age_seconds': 179, 'stale': False, 'shown': None, 'total': None, 'truncated': False, 'coverage_from': None, 'retain_days': None, 'note': None}, 'impact': 6.6, 'status': 'open', 'first_seen': 1787804784, 'last_seen': 1794897755, 'resolved_at': None, 'acked_by': None, 'acked_at': None, 'snoozed_until': None, 'occurrences': 318, 'narrative': 'studiosvc on test27 averaged 52.4 foreground Neo4j queries per API request over the last hour (26,571 queries for 507 calls). Dozens of queries per request is the N+1 signature: a round-trip per row instead of one query. The Journey page shows which screens pay for it, request by request.', 'narrative_kind': 'template', 'discriminator': '', 'level': 'low', 'told_level': None, 'episode_at': 1794897755, 'chat_thread': None, 'kind_label': 'N+1 fan-out', 'group': 'Journey', 'age_s': 7092980, 'stale_s': 9}
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 | 1794911730 |
| age_seconds | 323 |
| stale | False |
| shown | None |
| total | None |
| truncated | False |
| coverage_from | None |
| retain_days | None |
| note | None |
| detector | fanout |