explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XtwC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=1,529,340.17..5,434,263.77 rows=1 width=236) (actual rows= loops=)

  • Filter: (spree_line_item_id IS NOT NULL)
2. 0.000 0.000 ↓ 0.0

Seq Scan on supplier_line_items (cost=0.00..746,238.32 rows=29,102,532 width=236) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=1,030,240.52..1,030,240.52 rows=30,421,252 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on spree_line_items (cost=0.00..1,030,240.52 rows=30,421,252 width=4) (actual rows= loops=)