explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RnOO : Optimization for: plan #1sPg

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.021 205.584 ↑ 1.0 1 1

GroupAggregate (cost=43,371.73..43,371.77 rows=1 width=145) (actual time=205.584..205.584 rows=1 loops=1)

  • Group Key: d_ts_campaign_widgets.traffic_source_internal_widget_id, d_ts_campaign_widgets.traffic_source_internal_widget_name
2. 0.000 205.563 ↓ 14.0 14 1

Sort (cost=43,371.73..43,371.74 rows=1 width=71) (actual time=205.562..205.563 rows=14 loops=1)

  • Sort Key: d_ts_campaign_widgets.traffic_source_internal_widget_name
  • Sort Method: quicksort Memory: 26kB
3. 11.471 209.067 ↓ 14.0 14 1

Gather (cost=1,000.72..43,371.72 rows=1 width=71) (actual time=204.852..209.067 rows=14 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 1.142 197.596 ↓ 5.0 5 3

Nested Loop (cost=0.72..42,371.62 rows=1 width=71) (actual time=137.186..197.596 rows=5 loops=3)

5. 34.930 196.438 ↓ 2.3 68 3

Nested Loop (cost=0.44..42,362.82 rows=29 width=75) (actual time=10.814..196.438 rows=68 loops=3)

6. 158.828 158.828 ↑ 2.1 14 3

Parallel Seq Scan on d_ts_campaign_widgets (cost=0.00..36,550.48 rows=29 width=53) (actual time=10.677..158.828 rows=14 loops=3)

  • Filter: ((traffic_source_internal_widget_id)::text = 'advertisecom-business'::text)
  • Rows Removed by Filter: 716881
7. 2.680 2.680 ↑ 1.0 5 42

Index Scan using idx_f_ts_campaign_widget_stats_d_ts_campaign_widget_id on f_ts_campaign_widget_stats (cost=0.44..200.38 rows=5 width=30) (actual time=1.124..2.680 rows=5 loops=42)

  • Index Cond: (d_ts_campaign_widget_id = d_ts_campaign_widgets.d_ts_campaign_widget_id)
  • Filter: ((start_date >= '2019-11-01 00:00:00'::timestamp without time zone) AND (end_date <= '2019-11-26 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 5
8. 0.016 0.016 ↓ 0.0 0 205

Index Scan using d_ts_campaigns_pkey on d_ts_campaigns (cost=0.28..0.30 rows=1 width=4) (actual time=0.016..0.016 rows=0 loops=205)

  • Index Cond: (d_ts_campaign_id = f_ts_campaign_widget_stats.d_ts_campaign_id)
  • Filter: ((account_traffic_source_id = 11) AND ((traffic_source_internal_campaign_id)::text = '3223666'::text))
  • Rows Removed by Filter: 1
Planning time : 1.189 ms
Execution time : 209.210 ms