explain.depesz.com

PostgreSQL's explain analyze made readable

Result: htzN : Optimization for: plan #dD4N

Settings

Optimization path:

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

XN Hash Join DS_BCAST_INNER (cost=4,923,590.40..105,041,992,149,699.94 rows=1,074,561,071 width=493) (actual rows= loops=)

  • Hash Cond: (("outer".uuid = "inner".uuid) AND (("outer".operator_id)::text = ("inner".operator_id)::text))
2. 0.000 0.000 ↓ 0.0

XN Seq Scan on postgres_offer (cost=0.00..8,170,501.76 rows=817,050,176 width=492) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

XN Hash (cost=3,282,393.60..3,282,393.60 rows=328,239,360 width=24) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Seq Scan on modified_orders modo (cost=0.00..3,282,393.60 rows=328,239,360 width=24) (actual rows= loops=)