# zicula-postgres-perf-kit — free sample

Real files from the full Postgres Performance Kit (29 files), trimmed to taste so you can
test-drive the method before buying:

- `audit-score.xlsx` — a live slice of the scorecard from `report/`: 5 of the 29 rubric
  criteria (Section 2: Query health), worth 20 of the 100 points. Enter scores and the
  TOTAL and the verdict formula compute themselves — rescaled to this slice — with the
  same working data validation as the full scorecard. Formulas arrive working — open in
  Excel, Google Sheets, Numbers, or LibreOffice.
- `symptom-decision-tree.md` — the first 2 of 4 branches of the 5-minute tree from
  `triage/` that turns "Postgres is slow" (four different problems wearing one adjective)
  into the right first file to open: the slow-queries branch and the throughput branch,
  with every pointer to the file that answers each.
- `bad-plan-cheatsheet.md` — pattern 1 of 12 from `explain/`, in full: what the
  `EXPLAIN (ANALYZE, BUFFERS)` line looks like, why it hurts, how to confirm, and the fix.
  It is the sequential-scan pattern — the one that explains the most real-world slowness —
  plus the titles of the other eleven patterns.

What the full kit adds (the other 26 files — and the rest of these three):

- The firefight track: slow-query intake form, latency budget worksheet (`.md` + `.xlsx`
  with pain-per-day math), and the query → config → schema → hardware decision sequence
- Instrumentation: enable `pg_stat_statements` + `auto_explain` on self-host / RDS /
  Supabase / Neon, plus read-only SQL for top queries by total time, mean, cache misses
  and spills — with a guide to every column
- EXPLAIN: the reading playbook that goes from wall-of-text to problem node with a worked
  example, and the remaining 11 bad-plan patterns plus the healthy-plan closer
- Index audit: read-only SQL for unused/duplicate/invalid indexes, FK gaps and dead
  tuples; the type decision guide (B-tree/partial/expression/covering/GIN/BRIN); the
  write-cost calculator `.xlsx`
- Config: read-only health snapshot SQL, autovacuum tuning with worked math, memory
  sizing (the `work_mem` multiplication trap), and the connection-pooling SOP
- Capacity: growth forecast worksheet, right-size decision sheet, and the fix-vs-upgrade
  calculator
- The agency layer: the full 100-point rubric with evidence requirements and score bands,
  the complete scorecard across all 7 sections with its per-section subtotal sheet, and
  the white-label client report skeleton with pricing appendix
- 10 alert thresholds with their read-only checks — so the $149/month monitor has nothing
  left to tell you that you can't ask the database directly

One-time purchase · free updates for v1.x · 14-day full refund.