explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WrRB

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 12,901.410 ↑ 1.0 25 1

Limit (cost=2.55..246.42 rows=25 width=402) (actual time=3,615.062..12,901.410 rows=25 loops=1)

2. 0.082 12,901.386 ↑ 671.3 25 1

Nested Loop Left Join (cost=2.55..163,705.11 rows=16,782 width=402) (actual time=3,615.060..12,901.386 rows=25 loops=1)

3. 0.105 12,900.304 ↑ 11.0 25 1

Nested Loop Left Join (cost=1.98..45,013.68 rows=276 width=393) (actual time=3,615.048..12,900.304 rows=25 loops=1)

4. 0.075 12,896.249 ↑ 11.0 25 1

Nested Loop Left Join (cost=1.69..42,802.37 rows=276 width=370) (actual time=3,615.029..12,896.249 rows=25 loops=1)

5. 0.078 12,896.024 ↑ 11.0 25 1

Nested Loop Left Join (cost=1.28..41,611.70 rows=276 width=362) (actual time=3,615.018..12,896.024 rows=25 loops=1)

  • Join Filter: (clk.campaign_id = cmp.id)
6. 0.888 12,895.896 ↑ 11.0 25 1

Nested Loop (cost=1.00..41,599.26 rows=276 width=305) (actual time=3,614.997..12,895.896 rows=25 loops=1)

7. 12,892.848 12,892.848 ↑ 4.6 540 1

Index Scan Backward using click_call_created_date_idx on click_call clk (cost=0.57..21,222.43 rows=2,462 width=297) (actual time=143.186..12,892.848 rows=540 loops=1)

  • Index Cond: ((created_date > '2019-06-05 00:00:00-07'::timestamp with time zone) AND (created_date <= '2019-06-06 00:00:00-07'::timestamp with time zone))
  • Filter: (campaign_id = 14340::bigint)
  • Rows Removed by Filter: 156076
8. 2.160 2.160 ↓ 0.0 0 540

Index Scan using click_quarantine_pkey on click_quarantine quar (cost=0.43..8.27 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=540)

  • Index Cond: (click_id = clk.click_id)
9. 0.045 0.050 ↑ 1.0 1 25

Materialize (cost=0.28..8.31 rows=1 width=65) (actual time=0.001..0.002 rows=1 loops=25)

10. 0.005 0.005 ↑ 1.0 1 1

Index Scan using campaigns_id_idx on campaigns cmp (cost=0.28..8.30 rows=1 width=65) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = 14340::bigint)
11. 0.150 0.150 ↑ 1.0 1 25

Index Only Scan using idx_usrs_id_idx on users pu (cost=0.41..4.30 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=25)

  • Index Cond: (id = clk.publisher_id)
  • Heap Fetches: 0
12. 3.950 3.950 ↑ 1.0 1 25

Index Scan using user_profiles_user_id_uniq on user_profiles pup (cost=0.29..8.00 rows=1 width=39) (actual time=0.158..0.158 rows=1 loops=25)

  • Index Cond: (pu.id = user_id)
13. 1.000 1.000 ↑ 2,022.0 1 25

Index Scan using idx_engine_redirect_decisions_redirect_click_id on engine_redirect_decisions r (cost=0.57..409.67 rows=2,022 width=25) (actual time=0.039..0.040 rows=1 loops=25)

  • Index Cond: (quar.click_id = click_id)