explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UDwo

Settings
# exclusive inclusive rows x rows loops node
1. 67.003 841.478 ↓ 0.0 0 1

Merge Join (cost=125,379.14..125,775.12 rows=3,311 width=29) (actual time=841.478..841.478 rows=0 loops=1)

  • Merge Cond: (a.orderid = b.orderid)
2. 774.475 774.475 ↑ 3.4 16,815 1

Sort (cost=109,737.32..109,881.89 rows=57,828 width=23) (actual time=736.163..774.475 rows=16,815 loops=1)

  • Sort Key: a.orderid
  • Sort Method: quicksort Memory: 1695kB