explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W3ET : Optimization for: Optimization for: plan #p6y4; plan #NZOa

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.066 ↓ 0.0 0 1

GroupAggregate (cost=4,696.44..4,698.75 rows=2 width=18) (actual time=0.066..0.066 rows=0 loops=1)

  • Group Key: "Sensus_linktracker".brand_id, "Sensus_linktracker".campaign_type, "Sensus_linktracker".campaign_id, "Sensus_shortlinks".opened
2. 0.020 0.065 ↓ 0.0 0 1

Sort (cost=4,696.44..4,696.82 rows=153 width=10) (actual time=0.065..0.065 rows=0 loops=1)

  • Sort Key: "Sensus_linktracker".campaign_type, "Sensus_shortlinks".opened
  • Sort Method: quicksort Memory: 25kB
3. 0.000 0.045 ↓ 0.0 0 1

Nested Loop (cost=4.83..4,690.88 rows=153 width=10) (actual time=0.045..0.045 rows=0 loops=1)

4. 0.035 0.045 ↓ 0.0 0 1

Bitmap Heap Scan on "Sensus_linktracker" (cost=4.41..55.42 rows=1 width=13) (actual time=0.045..0.045 rows=0 loops=1)

  • Recheck Cond: (brand_id = 70)
  • Filter: ((campaign_id = 60) AND ((campaign_type)::text = ANY ('{reorder,proactive,custom}'::text[])))
  • Rows Removed by Filter: 25
  • Heap Blocks: exact=10
5. 0.010 0.010 ↓ 1.6 25 1

Bitmap Index Scan on "Sensus_linktracker_brand_id_99173e18" (cost=0.00..4.41 rows=16 width=0) (actual time=0.009..0.010 rows=25 loops=1)

  • Index Cond: (brand_id = 70)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using "Sensus_shortlinks_linkTracker_id_a58635b9" on "Sensus_shortlinks" (cost=0.43..4,615.40 rows=2,006 width=5) (never executed)

  • Index Cond: ("linkTracker_id" = "Sensus_linktracker".id)
  • Filter: ((created >= '2018-05-08 21:09:39.944958+00'::timestamp with time zone) AND (created <= '2019-05-08 21:09:39.944958+00'::timestamp with time zone))