explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OHU1

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

Aggregate (cost=9,132.41..9,157.91 rows=680 width=146) (never executed)

2. 0.000 0.000 ↓ 0.0

Sort (cost=9,132.41..9,134.11 rows=680 width=72) (never executed)

  • Sort Key: d_ts_campaign_widgets.traffic_source_internal_widget_id, d_ts_campaign_widgets.traffic_source_internal_widget_name
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=79.02..9,100.41 rows=680 width=72) (never executed)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=78.59..8,757.21 rows=680 width=26) (never executed)

5. 0.000 0.000 ↓ 0.0

Index Scan using d_ts_campaigns_account_id_account_traffic_source_id_traffic_key on d_ts_campaigns d_ts_campaigns (cost=0.28..8.3 rows=1 width=4) (never executed)

  • Index Cond: ((account_id = 1) AND (account_traffic_source_id = 11) AND ((traffic_source_internal_campaign_id)::text = '3223666'::text))
6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on f_ts_campaign_widget_stats f_ts_campaign_widget_stats (cost=78.31..8,725.58 rows=2,333 width=30) (never executed)

7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_f_ts_campaign_widget_stats_d_ts_camp_id_start_end (cost=0..77.72 rows=2,333 width=0) (never executed)

  • Index Cond: ((d_ts_campaign_id = d_ts_campaigns.d_ts_campaign_id) AND (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))
8. 0.000 0.000 ↓ 0.0

Index Scan using d_ts_campaign_widgets_pkey on d_ts_campaign_widgets d_ts_campaign_widgets (cost=0.43..0.5 rows=1 width=54) (never executed)

  • Index Cond: (d_ts_campaign_widget_id = f_ts_campaign_widget_stats.d_ts_campaign_widget_id)