# kornelszyszka/grafana-clone architecture

> Architecture diagram of the GitHub repository kornelszyszka/grafana-clone, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-30). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/kornelszyszka/grafana-clone
- Repository: https://github.com/kornelszyszka/grafana-clone

## Overview

Grafana Clone is a Django/PostgreSQL performance-monitoring and experiment foundation. The principal workflow seeds shop data, runs repeatable application workloads, captures PostgreSQL statistics and query plans, analyzes findings, and compares before/after snapshots. The README documents the end-to-end stages and API; sampled source confirms key calls and persistence paths. Some command wiring and reporting internals were not sampled, so uncertain connections are omitted.

Main entry points: [`db_monitor/models.py`](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/models.py) (Snapshot records), [`db_monitor/collectors/postgres.py`](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/collectors/postgres.py) (Stats collector), [`load_simulator/services/simulation.py`](https://github.com/kornelszyszka/grafana-clone/blob/main/load_simulator/services/simulation.py) (Load simulation), [`db_monitor/services/comparison.py`](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/comparison.py) (Snapshot comparison)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_shop["Shop API"]
  node_api["Shop endpoints<br/>[views.py]"]
  node_queries["Shop queries<br/>[querying.py]"]
  node_domain["Shop domain<br/>[models.py]"]
end

subgraph group_load["Workload generation"]
  node_seed["Demo seeding<br/>[seeding.py]"]
  node_simulation["Load simulation<br/>[simulation.py]"]
  node_runs["Workload runs<br/>[runs.py]"]
  node_workloaddata[("Workload records<br/>[models.py]")]
end

subgraph group_monitor["Monitoring and analysis"]
  node_collector["Stats collector<br/>[postgres.py]"]
  node_classification["SQL classification"]
  node_snapshots[("Snapshot records<br/>[models.py]")]
  node_plans["Query plans<br/>[query_plans.py]"]
  node_analysis["Heuristic analysis<br/>[analysis.py]"]
  node_comparison["Snapshot comparison<br/>[comparison.py]"]
  node_reporting["Monitoring reports<br/>[reporting.py]"]
end

subgraph group_experiments["Index experiments"]
  node_indexexp["Index experiments"]
  node_benchmark["Index benchmarking"]
end

node_developer(("Developer"))
node_postgres[("PostgreSQL")]

node_developer -->|"seeds data"| node_seed
node_developer -->|"starts workload"| node_simulation
node_developer -->|"collects stats"| node_collector
node_developer -->|"analyzes snapshot"| node_analysis
node_developer -->|"compares snapshots"| node_comparison
node_api -->|"uses queries"| node_queries
node_queries -->|"queries models"| node_domain
node_seed -->|"creates shop data"| node_domain
node_simulation -->|"runs read scenarios"| node_queries
node_simulation -->|"mutates records"| node_domain
node_simulation -.->|"records run"| node_runs
node_runs -->|"persists runs"| node_workloaddata
node_collector -->|"links latest run"| node_runs
node_collector -->|"classifies queries"| node_classification
node_collector -->|"stores statistics"| node_snapshots
node_collector -->|"reads statistics"| node_postgres
node_plans -->|"stores plans"| node_snapshots
node_plans -->|"builds representative queries"| node_domain
node_analysis -->|"analyzes snapshot"| node_snapshots
node_comparison -->|"compares snapshot data"| node_snapshots
node_comparison -->|"classifies operations"| node_classification
node_reporting -->|"reports snapshot data"| node_snapshots
node_reporting -->|"uses comparison results"| node_comparison
node_benchmark -->|"uses index setup"| node_indexexp
node_benchmark -->|"captures plans"| node_plans
node_benchmark -.->|"runs workload"| node_simulation
node_indexexp -->|"stores experiment definitions"| node_snapshots

click node_api "https://github.com/kornelszyszka/grafana-clone/blob/main/shop/views.py"
click node_queries "https://github.com/kornelszyszka/grafana-clone/blob/main/shop/services/querying.py"
click node_domain "https://github.com/kornelszyszka/grafana-clone/blob/main/shop/models.py"
click node_seed "https://github.com/kornelszyszka/grafana-clone/blob/main/load_simulator/services/seeding.py"
click node_simulation "https://github.com/kornelszyszka/grafana-clone/blob/main/load_simulator/services/simulation.py"
click node_runs "https://github.com/kornelszyszka/grafana-clone/blob/main/load_simulator/services/runs.py"
click node_workloaddata "https://github.com/kornelszyszka/grafana-clone/blob/main/load_simulator/models.py"
click node_collector "https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/collectors/postgres.py"
click node_classification "https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/query_classification.py"
click node_snapshots "https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/models.py"
click node_plans "https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/query_plans.py"
click node_analysis "https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/heuristics/analysis.py"
click node_comparison "https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/comparison.py"
click node_reporting "https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/reporting.py"
click node_indexexp "https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/index_experiments.py"
click node_benchmark "https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/benchmark_indexes.py"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_api,node_queries,node_domain toneBlue
class node_seed,node_simulation,node_runs,node_workloaddata,node_postgres toneAmber
class node_collector,node_classification,node_snapshots,node_plans,node_analysis,node_comparison,node_reporting toneMint
class node_indexexp,node_benchmark toneRose
class node_developer toneIndigo
```

## Components

### Shop API

- [Shop endpoints](https://github.com/kornelszyszka/grafana-clone/blob/main/shop/views.py): `shop/views.py`
- [Shop queries](https://github.com/kornelszyszka/grafana-clone/blob/main/shop/services/querying.py): `shop/services/querying.py`
- [Shop domain](https://github.com/kornelszyszka/grafana-clone/blob/main/shop/models.py): `shop/models.py`

### Workload generation

- [Demo seeding](https://github.com/kornelszyszka/grafana-clone/blob/main/load_simulator/services/seeding.py): `load_simulator/services/seeding.py`
- [Load simulation](https://github.com/kornelszyszka/grafana-clone/blob/main/load_simulator/services/simulation.py): `load_simulator/services/simulation.py`
- [Workload runs](https://github.com/kornelszyszka/grafana-clone/blob/main/load_simulator/services/runs.py): `load_simulator/services/runs.py`
- [Workload records](https://github.com/kornelszyszka/grafana-clone/blob/main/load_simulator/models.py): `load_simulator/models.py`

### Monitoring and analysis

- [Stats collector](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/collectors/postgres.py): `db_monitor/collectors/postgres.py`
- [SQL classification](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/query_classification.py): `db_monitor/services/query_classification.py`
- [Snapshot records](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/models.py): `db_monitor/models.py`
- [Query plans](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/query_plans.py): `db_monitor/services/query_plans.py`
- [Heuristic analysis](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/heuristics/analysis.py): `db_monitor/heuristics/analysis.py`
- [Snapshot comparison](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/comparison.py): `db_monitor/services/comparison.py`
- [Monitoring reports](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/reporting.py): `db_monitor/services/reporting.py`

### Index experiments

- [Index experiments](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/index_experiments.py): `db_monitor/services/index_experiments.py`
- [Index benchmarking](https://github.com/kornelszyszka/grafana-clone/blob/main/db_monitor/services/benchmark_indexes.py): `db_monitor/services/benchmark_indexes.py`

### Other components

- **Developer**
- **PostgreSQL**

## Connections

- Developer → Demo seeding: seeds data
- Developer → Load simulation: starts workload
- Developer → Stats collector: collects stats
- Developer → Heuristic analysis: analyzes snapshot
- Developer → Snapshot comparison: compares snapshots
- Shop endpoints → Shop queries: uses queries (evidence: `shop/views.py`)
- Shop queries → Shop domain: queries models (evidence: `shop/services/querying.py`)
- Demo seeding → Shop domain: creates shop data (evidence: `load_simulator/services/seeding.py`)
- Load simulation → Shop queries: runs read scenarios (evidence: `load_simulator/services/simulation.py`)
- Load simulation → Shop domain: mutates records (evidence: `load_simulator/services/simulation.py`)
- Load simulation → Workload runs: records run
- Workload runs → Workload records: persists runs (evidence: `load_simulator/services/runs.py`)
- Stats collector → Workload runs: links latest run (evidence: `db_monitor/collectors/postgres.py`)
- Stats collector → SQL classification: classifies queries (evidence: `db_monitor/collectors/postgres.py`)
- Stats collector → Snapshot records: stores statistics (evidence: `db_monitor/collectors/postgres.py`)
- Stats collector → PostgreSQL: reads statistics (evidence: `db_monitor/collectors/postgres.py`)
- Query plans → Snapshot records: stores plans (evidence: `db_monitor/services/query_plans.py`)
- Query plans → Shop domain: builds representative queries (evidence: `db_monitor/services/query_plans.py`)
- Heuristic analysis → Snapshot records: analyzes snapshot (evidence: `db_monitor/heuristics/analysis.py`)
- Snapshot comparison → Snapshot records: compares snapshot data (evidence: `db_monitor/management/commands/compare_snapshots.py`)
- Snapshot comparison → SQL classification: classifies operations (evidence: `db_monitor/services/comparison.py`)
- Monitoring reports → Snapshot records: reports snapshot data (evidence: `db_monitor/services/reporting.py`)
- Monitoring reports → Snapshot comparison: uses comparison results (evidence: `db_monitor/services/reporting.py`)
- Index benchmarking → Index experiments: uses index setup (evidence: `db_monitor/services/benchmark_indexes.py`)
- Index benchmarking → Query plans: captures plans (evidence: `db_monitor/services/benchmark_indexes.py`)
- Index benchmarking → Load simulation: runs workload (evidence: `db_monitor/services/benchmark_indexes.py`)
- Index experiments → Snapshot records: stores experiment definitions (evidence: `db_monitor/services/index_experiments.py`)
