explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aOfe

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 1,955.970 ↓ 45.0 45 1

Limit (cost=35,023.13..35,023.18 rows=1 width=2,288) (actual time=1,955.887..1,955.970 rows=45 loops=1)

2.          

CTE main_fact

3. 1,819.903 1,900.050 ↓ 18,363.0 18,363 1

Nested Loop Left Join (cost=1,445.94..35,023.01 rows=1 width=291) (actual time=4.846..1,900.050 rows=18,363 loops=1)

4. 0.000 43.421 ↓ 18,363.0 18,363 1

Gather (cost=1,445.52..35,020.55 rows=1 width=88) (actual time=4.735..43.421 rows=18,363 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
5. 51.614 57.593 ↓ 4,591.0 4,591 4

Nested Loop (cost=445.52..34,020.45 rows=1 width=88) (actual time=1.157..57.593 rows=4,591 loops=4)

6. 2.963 5.973 ↓ 1.2 6,683 4

Parallel Bitmap Heap Scan on delivery_facts_agg (cost=445.08..19,609.87 rows=5,625 width=48) (actual time=1.068..5.973 rows=6,683 loops=4)

  • Recheck Cond: ((brand_id = 13996) AND (date_id >= 2018090100) AND (date_id <= 2018090523))
  • Filter: (brand_data_source_instance_id <> 1453302)
  • Heap Blocks: exact=1
7. 3.010 3.010 ↓ 1.5 26,731 1

Bitmap Index Scan on delivery_facts_agg_main (cost=0.00..440.72 rows=17,436 width=0) (actual time=3.010..3.010 rows=26,731 loops=1)

  • Index Cond: ((brand_id = 13996) AND (date_id >= 2018090100) AND (date_id <= 2018090523))
8. 0.006 0.006 ↑ 1.0 1 26,731

Index Scan using delivery_media_buys_media_buy2_id_pkey on delivery_media_buys (cost=0.44..2.56 rows=1 width=56) (actual time=0.006..0.006 rows=1 loops=26,731)

  • Index Cond: (media_buy_id = delivery_facts_agg.media_buy_id)
  • Filter: (((name)::text !~~* '%junglex%'::text) AND ((trans_custom_attribute5)::text = ANY ('{"DoubleClick Bid Manager (DBM)",DV360}'::text[])) AND (brand_id = 13996))
  • Rows Removed by Filter: 0
9. 36.726 36.726 ↑ 1.0 1 18,363

Index Scan using brand_data_source_instances_brand_data_source_instance_id_pkey on brand_data_source_instances_dw (cost=0.42..2.05 rows=1 width=43) (actual time=0.002..0.002 rows=1 loops=18,363)

  • Index Cond: (delivery_facts_agg.brand_data_source_instance_id = brand_data_source_instance_id)
  • Filter: (brand_id = 13996)
10. 33.570 1,955.950 ↓ 45.0 45 1

HashAggregate (cost=0.12..0.18 rows=1 width=2,288) (actual time=1,955.885..1,955.950 rows=45 loops=1)

  • Group Key: main_fact."MEDIA_BUY_CUSTOM_ATTRIBUTE26", main_fact."MEDIA_BUY_CUSTOM_ATTRIBUTE13", main_fact."MEDIA_BUY_CUSTOM_ATTRIBUTE5", main_fact."DATE_DAY
11. 1,922.380 1,922.380 ↓ 18,363.0 18,363 1

CTE Scan on main_fact (cost=0.00..0.02 rows=1 width=1,832) (actual time=4.850..1,922.380 rows=18,363 loops=1)