explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l8Gw

Settings
# exclusive inclusive rows x rows loops node
1. 295.403 930.080 ↓ 5.8 1,268,865 1

Hash Join (cost=72.03..5,079,943.66 rows=219,473 width=46) (actual time=0.509..930.080 rows=1,268,865 loops=1)

  • Hash Cond: ((popstats.display_unit_id)::text = (display_unit.display_unit_id)::text)
2. 121.988 634.217 ↓ 5.8 1,268,865 1

Nested Loop (cost=0.86..5,076,854.73 rows=219,473 width=45) (actual time=0.037..634.217 rows=1,268,865 loops=1)

3. 0.016 0.016 ↑ 4.0 1 1

Index Scan using idx_campaign_data_sales_order_number on campaign_data (cost=0.29..13.71 rows=4 width=20) (actual time=0.014..0.016 rows=1 loops=1)

  • Index Cond: ((sales_order_number)::text = 'SO02777064'::text)
4. 512.213 512.213 ↓ 3.4 1,268,865 1

Index Scan using campaign_id_index on popstats (cost=0.57..1,265,512.33 rows=369,793 width=45) (actual time=0.021..512.213 rows=1,268,865 loops=1)

  • Index Cond: ((campaign_id)::text = (campaign_data.campaign_id)::text)
5. 0.291 0.460 ↑ 1.0 1,314 1

Hash (cost=54.41..54.41 rows=1,341 width=19) (actual time=0.460..0.460 rows=1,314 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 84kB
6. 0.169 0.169 ↑ 1.0 1,314 1

Seq Scan on display_unit (cost=0.00..54.41 rows=1,341 width=19) (actual time=0.004..0.169 rows=1,314 loops=1)