Cluster: localhost:2717 | Database: sample_analytics | Generated: 2026-05-05 06:34:11 UTC
Complexity score per collection:
C = depth/2 + array_fields + distinct_fields/avg_fields_per_doc.
DB total: 1.5 × collections + Σ Ci.
Thresholds: <30 Easy · 30–80 Medium · >80 Hard.
Width (top): number of top-level fields in the collection schema.
Width (max): highest field count found at any single nesting level, with the level shown in parentheses (probability-weighted).
Depth (max): maximum nesting depth — top-level fields are depth 1, their sub-fields depth 2, etc.
Fields (total): expected number of fields a typical document in the collection
actually has, summed across all nesting levels (probability-weighted). Hover the value for the per-level breakdown.
| Collection | Documents | Sampled | Width (top) | Width (max) | Depth (max) | Fields (total) | Score | PG Tables |
|---|---|---|---|---|---|---|---|---|
| accounts | 1746 | 1000 | 4 | 4.0 (L1) | 2 | 5.0 | 3.00 | 2 |
| customers | 500 | 500 | 9 | 8.0 (L1) | 4 | 14.5 | 4.12 | 4 |
| transactions | 1746 | 1000 | 6 | 6.0 (L3) | 3 | 13.0 | 3.50 | 2 |