pg_web_stats

Sexy sinatra app for pg_stat_statements.

Features

• Sorting by any column from pg_stat_statements
• Filtering by database or user
• Highlighting important queries && hidding not important queries

Installation

0. Prepare your PG setup: enable the pg_stat_statements extension and execute CREATE EXTENSION pg_stat_statements inside the database you want to inspect. Hint: there is an awesome article about pg_stat_statements in russian.
1. Clone the repo
2. Fill config.yml.example with your credentians and save it as config.yml
3. Start the app: ruby web.rb
4. ???
5. PROFIT

Made by Kir Shatrov, sponsored by Evil Martians.

Thanks to Ivan Evtuhovich for advice about making this app.