explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jVjl

Settings
# exclusive inclusive rows x rows loops node
1. 229.943 229.943 ↑ 1.0 1 1

CTE Scan on _cake (cost=160,591.03..160,591.35 rows=1 width=48) (actual time=229.943..229.943 rows=1 loops=1)

2.          

CTE bids

3. 0.051 0.051 ↑ 1.0 11 1

Values Scan on "*VALUES*" (cost=0.00..1.21 rows=11 width=40) (actual time=0.045..0.051 rows=11 loops=1)

4.          

CTE _cake

5. 1.884 229.913 ↑ 1.0 1 1

Aggregate (cost=160,589.72..160,589.82 rows=1 width=32) (actual time=229.913..229.913 rows=1 loops=1)

6. 5.684 228.029 ↓ 3,231.0 3,231 1

Nested Loop (cost=0.00..160,589.65 rows=1 width=46) (actual time=48.509..228.029 rows=3,231 loops=1)

  • Join Filter: ((data.geo_id = bids.geo_id) AND (data.cat_id = bids.cat_id))
  • Rows Removed by Join Filter: 32332
7. 219.112 219.112 ↓ 3,233.0 3,233 1

Seq Scan on v_forecasting_reach_data data (cost=0.00..160,586.12 rows=1 width=30) (actual time=48.443..219.112 rows=3,233 loops=1)

  • Filter: ((block_id <> 875724) AND (is_ero = ANY ('{f,t}'::boolean[])) AND (block_show_type_id = 8) AND (device_group_id = 20) AND (operation_system_group_id = 11) AND (browser_group_id = A
  • Rows Removed by Filter: 411367
8. 3.233 3.233 ↑ 1.0 11 3,233

CTE Scan on bids (cost=0.00..2.20 rows=11 width=40) (actual time=0.000..0.001 rows=11 loops=3,233)