explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j5Ex

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

Hash Join (cost=10,717,890.78..77,356,068.23 rows=823,481 width=28) (actual rows= loops=)

  • Hash Cond: (d.line_id = l.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on order_line_detail d (cost=0.00..57,928,447.92 rows=2,320,398,592 width=28) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=10,717,563.84..10,717,563.84 rows=26,155 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Join (cost=42,202.77..10,717,563.84 rows=26,155 width=4) (actual rows= loops=)

  • Hash Cond: (l.order_systemid = o.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on order_line l (cost=0.00..9,938,105.76 rows=73,699,376 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=42,061.31..42,061.31 rows=11,317 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using order_last_update_idx on orders o (cost=0.57..42,061.31 rows=11,317 width=4) (actual rows= loops=)

  • Index Cond: (last_update > (now() - '06:00:00'::interval))