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

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.
Clone the repo
Fill config.yml.example with your credentians and save it as config.yml
Start the app: rake server (or run rake console to have command line)
???
PROFIT

Made by Kir Shatrov, sponsored by Evil Martians.

Thanks to Ivan Evtuhovich for advice about making this app.