explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Yvns : Optimization for: Optimization for: teste; plan #yxAF; plan #aLGM

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 3,033.066 6,856.656 ↓ 1.0 2,136,572 1

Append (cost=0.43..179,332.45 rows=2,131,158 width=67) (actual time=0.029..6,856.656 rows=2,136,572 loops=1)

2. 2,574.285 2,574.285 ↑ 1.0 1,836,560 1

Index Scan using variables_values_2011_year_idx on variables_values_2011 v_1 (cost=0.43..90,558.48 rows=1,836,562 width=67) (actual time=0.027..2,574.285 rows=1,836,560 loops=1)

  • Index Cond: ((year >= 2011) AND (year <= 2012))
  • Filter: ((year_month >= '201101'::numeric) AND (year_month <= '201202'::numeric))
  • Rows Removed by Filter: 2
3. 1,249.305 1,249.305 ↓ 1.0 300,012 1

Index Scan using variables_values_2012_year_idx on variables_values_2012 v_1_1 (cost=0.43..88,773.98 rows=294,596 width=67) (actual time=0.039..1,249.305 rows=300,012 loops=1)

  • Index Cond: ((year >= 2011) AND (year <= 2012))
  • Filter: ((year_month >= '201101'::numeric) AND (year_month <= '201202'::numeric))
  • Rows Removed by Filter: 1500330
Planning time : 0.865 ms
Execution time : 8,361.635 ms