repowiserepowise
Sign in
pgplex/pgschema
OverviewDocsArchitectureKnowledge GraphFilesCode HealthSecurityRefactoring

People & History

CommitsContributorsDecisions
Chat
Stats
repowiserepowise
ExplorePricingDocs
Sign in
repowisepgplex/pgschema
PG
PG

pgplex / pgschema

gomain319b88c78.7K linessynced 3w ago

Code health

6.8out of 10Fair

This codebase scores 6.8 out of 10 for code health, which we rate fair. It also scores maintainability 7.9 and static performance 9.7 out of 10. The three are scored separately and never blended into one number. Risk is concentrated, as it usually is: 22 of 1,504 files are git hotspots, and they average 2.7 — which is where the fixes pay off most.

Full health report →
Documentation357pages13 with model-written prose, 344 built from the indexScore validation17/2019.1× baselineTop-ranked files that did go on to need a bug fixDead code8exportsUnused exports that nothing in the graph reaches

Do next

Nothing stands out in the week to Sep 10, the last indexed commit.

Improve what Repowise can see

  • Add a test coverage report

    Without one, Repowise cannot tell tested code from untested code, so every test-related action says “unknown”.

    line coverage
    Unknown, no report
    Small effort
Lines of code
78.7K
Files
1,504
Symbols
2,775
Modules
7
Languages
4

Recent activity

All commits →

Commits

  • 319b88c8fix: detect and apply GENERATED ALWAYS AS changes on existing columns (#591) (#592)3w ago
  • 738a3bb4fix: carry ON DELETE SET NULL/SET DEFAULT column list on foreign keys (#589) (#590)4w ago
  • 91c15d6efix: re-emit VALIDATE for an unvalidated PG18 NOT NULL constraint (#564) (#587)4w ago
  • 7c9f7af5fix: stub referenced roles in the plan database (#450) (#586)4w ago
  • bb151461fix: mirror target extensions into the embedded plan database (#584) (#585)4w ago
  • b25a9e9cfeat: manage config table rows declaratively (#559) (#583)4w ago

Decisions

  • Add constraints section to .pgschemaignoreproposed · 3w ago
  • Order function creation using function-to-function dependenciesproposed · 3w ago
  • Fix INSTEAD OF triggers on views missing from dumpproposed · 3w ago
  • Rewrite SET search_path in function definitions for temp schemaproposed · 3w ago
  • Use native NOT NULL NOT VALID constraints on PostgreSQL 18+proposed · 3w ago
  • Stub referenced roles in the plan databaseproposed · 3w ago
▸

Everything we found

1,003 open

Every detector's open count by area, each with its worst example. An inventory, not a to-do list: the actions above are the part worth doing.

  • worst item is critical severity. Code health700Change entropy · ir/normalize.go32 findings · 7.8 deducted→
  • worst item is medium severity. Refactoring138ApplySchema+1.5 health, S effort · internal/postgres/external.go→
  • worst item is medium severity. Decisions59internal/diff/diff.go37 awaiting review · 22 hotspots ungoverned→
  • worst item is medium severity. Ownership103ir/queries/queries.sql.go82% single-owner concentration, 14 commits in 90d→
  • worst item is low severity. Dead code3.claude/hooks/ralph-loop.pyUnreachable symbol (160 lines)→

Composition

Open the graph →
go 84%shell 13%
python 2%dockerfile 1%

Explore this codebase

  • Docs357 pages across 7 modules→
  • ChatAsk this codebase a question and get an answer with its sources.→
  • Files1,504 files with per-file docs, health and history→
  • ArchitectureDependency graph, layers, and 1 entry points→
  • Code healthPer-file scores, 958 open findings, coverage and refactoring targets→
  • Knowledge graphEntities, communities, and the paths between them→
  • Change couplingFiles that keep changing together, mined from commit history→
  • CommitsChange-risk ranked history with agent provenance→
  • ContributorsBus factor, per-file maintainers, and the human/agent split→
  • StatsSize class, origin, lifetime churn, rhythm and records→
  • CostsWhat indexing this snapshot cost, by model and by run.→