explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jJZY

Settings
# exclusive inclusive rows x rows loops node
1. 392.142 508.722 ↓ 4.0 21,704 1

HashAggregate (cost=81,491.21..81,545.11 rows=5,390 width=23) (actual time=505.259..508.722 rows=21,704 loops=1)

  • Group Key: transition_string
2. 116.580 116.580 ↓ 1.0 652,214 1

Seq Scan on main_order (cost=0.00..79,866.57 rows=649,857 width=23) (actual time=0.013..116.580 rows=652,214 loops=1)

Planning time : 0.273 ms
Execution time : 509.856 ms