Skip to content

pgPerformance was created during my summer internship at Cozy.co to help track slow PostgreSQL queries. This tool is still being used in-house at Cozy to track top 5 slowest running queries.

License

Notifications You must be signed in to change notification settings

aleenaniklaus/pg_performance

Repository files navigation

pgPerformance

Track slow and problem queries such as slowest per total time, slowest per mean time, most frequent queries, long running queries (greater than 1 second long) and all active queries. pgPerformance is made responsively and will resize for any mobile device nicely. It was inspired after a 3 month long internship a Cozy.co tracking slow queries the hard way - tailing the Postgres.log file. This app is an aggregation of all queries, for as long as your pg_stat_statements and pg_stat_activity tables have been loaded; giving better, more accurate information than the Postgres.log which is often times machine dependent. If there are descrepencies or concerns, feel free to contact or open a pull request on it.
By Aleena Watson

What you need:

  • PostgreSQL database
  • Load pg_stat_statements. This is a crutial step, although you have Postgres, pg_stat_statements table still needs to be configured in order for the app to work!
  • Install pgPerformance and enter your database information accordingly in config.yml (see example .yml file included)

Technology/Gems Used

  • PostgreSQL
  • Ruby
  • CSS
  • HTML
  • Sinatra
  • pry
  • Sequel
  • Rogue
  • Configurability
  • pJax

License

This software is licensed under the MIT license

Copyright(c) 2017 Aleena Watson

About

pgPerformance was created during my summer internship at Cozy.co to help track slow PostgreSQL queries. This tool is still being used in-house at Cozy to track top 5 slowest running queries.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published