explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0zQ6

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

Delete on ramp_w_selection (cost=39,933,565.95..84,966,832.88 rows=43,231,726 width=18) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=39,933,565.95..84,966,832.88 rows=43,231,726 width=18) (actual rows= loops=)

  • Hash Cond: (ramp_w_selection.selectionid = rsel.selectionid)
3. 0.000 0.000 ↓ 0.0

Seq Scan on ramp_w_selection (cost=0.00..33,628,749.78 rows=163,008,478 width=10) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=39,182,076.38..39,182,076.38 rows=43,231,726 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=36,039,413.47..39,182,076.38 rows=43,231,726 width=16) (actual rows= loops=)

  • Hash Cond: (bsel.rampselectionid = rsel.selectionid)
  • Filter: (bsel.selectionid IS NULL)
6. 0.000 0.000 ↓ 0.0

Seq Scan on pp_arkle_w_bet_selection bsel (cost=0.00..1,601,642.76 rows=19,067,676 width=14) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=35,258,834.56..35,258,834.56 rows=44,905,193 width=10) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on ramp_w_selection rsel (cost=0.00..35,258,834.56 rows=44,905,193 width=10) (actual rows= loops=)

  • Filter: (messagetimestamp < (('now'::cstring)::date - '6 mons'::interval))