Ledgerline (SaaS platform)

postgres

Technical Inspection Panel • Audit collected 2026-07-31 08:03 UTC

Database Health Score

25Grade FCritical

Catalog Measurement Confidence:100%

Raw Rule Penalty Sum:-201 pts

Applied Decayed Penalty:-75 pts

Trend from previous audit:-2 pts

Revenue Risk Index (RRI)

Modeled conversion loss attributable to DB latency

Estimated Range

Conservative Monthly Risk

$29,730

Band: $29,730 – $69,370 / mo

Annualized Exposure

$594,604

Based on conservative low estimate

DB Latency Delay (ΔTTFB)

2.66s

Lost conversion rate: 15.4%

Model Assumptions & Disclosures

Database-induced delay measured as 2.66s (uncacheable page minus cacheable baseline).
Impact coefficient k=0.0627, blended from 22% mobile traffic.
Baseline conversion 1.40% and AOV supplied by the agency, not read from the database.
Modelled estimate of conversion lost to database latency — not a measured revenue figure.

Active Audit Findings

!!CriticalDB-IDX-01

Indexes that are never used

Weight: -5 pts

3 unused index(es) occupying 24.9 GB

24.9 GB of index storage has not been read once during the observation window. Every one of them still has to be updated on every write.

!!CriticalDB-PG-01

Dead rows waiting to be cleaned up

Weight: -9 pts

public.oban_jobs is 92.4% dead rows (6.0 GB reclaimable)

Postgres does not erase updated or deleted rows immediately — it marks them dead and cleans up later. 92.4% of your busiest table is dead rows.

To unlock additional insights, Sign up

Showing 2 rows of inspection data, to learn more Sign up

!!CriticalLOREM-01

Lorem Ipsum Audit Inspection Check

Weight: -15 pts

Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

!Needs attentionLOREM-02

Lorem Ipsum Storage Allocation Warning

Weight: -10 pts

Lorem ipsum dolor sit amet, consectetur adipiscing elit.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore.

!Needs attentionLOREM-03

Lorem Ipsum Index Efficiency Recommendation

Weight: -5 pts

Lorem ipsum dolor sit amet, consectetur adipiscing elit.