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: rake server (or run rake console to have command line)
4. ???
5. PROFIT

Made by Kir Shatrov, sponsored by Evil Martians.

Thanks to Ivan Evtuhovich for advice about making this app.