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.
PostgreSQLdatabase- Load pg_stat_statements. This is a crutial step, although you have
Postgres,pg_stat_statementstable still needs to be configured in order for the app to work! - Install
pgPerformanceand enter your database information accordingly inconfig.yml(see example.ymlfile included)
- PostgreSQL
- Ruby
- CSS
- HTML
- Sinatra
- pry
- Sequel
- Rogue
- Configurability
- pJax
This software is licensed under the MIT license
Copyright(c) 2017 Aleena Watson