explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BalT

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

Aggregate (cost=20,350.01..20,350.41 rows=1 width=184) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=364.01..19,660.31 rows=5,016 width=36) (actual rows= loops=)

  • Join Filter: (widget.id = p.widget_id)
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on widget (cost=363.44..19,576.48 rows=5,016 width=8) (actual rows= loops=)

  • Recheck Cond: (campaign_id = 1063288641)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on widget_campaign_id_traffic_source_widget_id (cost=0.00..362.19 rows=5,016 width=0) (actual rows= loops=)

  • Index Cond: (campaign_id = 1063288641)
5. 0.000 0.000 ↓ 0.0

Materialize (cost=0.57..8.59 rows=1 width=44) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using widget_performance_date_index on widget_performance p (cost=0.57..8.59 rows=1 width=44) (actual rows= loops=)

  • Index Cond: ((date >= '2019-06-06'::date) AND (date <= '2019-06-06'::date))