Worksheet

Slow query diagnosis sheet

Every slow query gets a line on this single sheet. Columns hold the page name, SQL text, time before, the costliest node, estimated against actual rows, the fix tried, time after and date. A tick list covers Seq Scan, unused index, disk sort and N+1.

Name: ______________________   Business: ______________________   Date: ______________

Scroll the table sideways to see every column.

Cross out or rewrite any heading that does not fit your business. From the guide “Why a PostgreSQL query is slow: reading EXPLAIN ANALYZE”, www.gullysystem.com/blog/why-a-postgresql-query-is-slow-reading-explain-analyze