explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2vpu

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

Nested Loop (cost=4,084,127.24..14,953,468.35 rows=1,085,477 width=18) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=4,084,126.67..5,949,371.90 rows=1,085,477 width=16) (actual rows= loops=)

  • Hash Cond: (bsel.rampselectionid = rsel.selectionid)
  • Filter: (bsel.selectionid IS NULL)
3. 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=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=4,064,526.98..4,064,526.98 rows=1,127,495 width=10) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ramp_w_selection rsel (cost=234,201.39..4,064,526.98 rows=1,127,495 width=10) (actual rows= loops=)

  • Recheck Cond: ((ods_modified_tsp >= '2018-09-03 00:00:00'::timestamp without time zone) AND (ods_modified_tsp < '2018-09-04 00:00:00'::timestamp without time zone))
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_ramp_w_selection_ods_modified_tsp (cost=0.00..233,919.52 rows=1,127,495 width=0) (actual rows= loops=)

  • Index Cond: ((ods_modified_tsp >= '2018-09-03 00:00:00'::timestamp without time zone) AND (ods_modified_tsp < '2018-09-04 00:00:00'::timestamp without time zone))
7. 0.000 0.000 ↓ 0.0

Index Scan using pk_retail_ramp_w_selection on ramp_w_selection (cost=0.57..8.29 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (selectionid = rsel.selectionid)