Skip to content

joshrendek/pgdiagnose

Repository files navigation

pg diagnose

checks

  • any querires > 1 min
  • any locks > 1 min
  • any idle in transaction > 1 min
  • any bloat > 50MB and a factor > 10x
  • any unused indexs
  • cache hit rates < 0.98
  • load higher than number of cores for plan
  • connections near plan limit or high for other plans
  • dataset + connections * 5b > plan memory

api

start a report: POST /reports , body: {'url': 'postgres://...'}

view result: GET /reports/:id

license

MIT

Releases

No releases published

Packages

No packages published