About statementsRanker

Run one query on pg_stat_statements, paste the result (CSV, tab-separated, JSON or psql's table output) and get every statement ranked by its share of the database's total time, not by mean time, which puts a rare slow report above the update that runs 50,000 times. Each row shows calls, mean time, rows per call, disk reads, cache hits and WAL per call, with flags for the shapes worth a second look: many one-row calls (N+1 from app code), a single-row lookup that takes milliseconds (a missing index), slow statements, heavy disk reads, sorts that spill to disk and WAL-heavy writes. Click a query for EXPLAIN to copy into explainViewer. Reads PostgreSQL 12 and older column names too. Runs in your browser.

Runs entirely in your browser: your SQL and files are not uploaded. Signed-in members can keep a history of runs and results.