explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GN5F

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.061 ↓ 0.0 0 1

Nested Loop (cost=0.86..7,170,228.93 rows=1 width=496) (actual time=0.061..0.061 rows=0 loops=1)

  • Buffers: shared hit=2 read=3
2. 0.001 0.059 ↓ 0.0 0 1

Subquery Scan on _position_store (cost=0.43..7,170,220.47 rows=1 width=494) (actual time=0.059..0.059 rows=0 loops=1)

  • Filter: ((position_store.time_period_cd = 'FALL'::text) AND (position_store.metric_type = 'VELOCITY'::text))
  • Buffers: shared hit=2 read=3
3. 0.000 0.058 ↓ 0.0 0 1

Subquery Scan on v_f_position_store_agg_2nf (cost=0.43..7,170,211.47 rows=600 width=1,574) (actual time=0.058..0.058 rows=0 loops=1)

  • Buffers: shared hit=2 read=3
4. 0.001 0.058 ↓ 0.0 0 1

Append (cost=0.43..7,170,207.96 rows=6 width=349) (actual time=0.058..0.058 rows=0 loops=1)

  • Buffers: shared hit=2 read=3
5. 0.052 0.052 ↓ 0.0 0 1

Index Scan using temp_f_position_store_agg_2018_11_27_16_16_10_store_src_cd_idx on f_position_store_agg_2018_11_27_16_16_10 (cost=0.43..57.05 rows=1 width=385) (actual time=0.052..0.052 rows=0 loops=1)

  • Index Cond: ((store_src_cd)::text = '0000591'::text)
  • Filter: (position_id = 8025)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=2 read=3
6. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..501,530.59 rows=1 width=393) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on f_position_store_pri_pack_agg_2018_11_27_16_27_31 (cost=0.00..501,530.59 rows=1 width=393) (never executed)

8. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3 (cost=0.00..2,185,731.05 rows=1 width=366) (actual time=0.001..0.001 rows=0 loops=1)

9. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..2,185,731.04 rows=1 width=366) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on f_position_store_pri_pack_pkg_sku_agg_2018_11_27_22_19_46 (cost=0.00..2,185,731.04 rows=1 width=366) (never executed)

11. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4 (cost=0.00..860,340.27 rows=1 width=355) (actual time=0.001..0.001 rows=0 loops=1)

12. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..860,340.26 rows=1 width=355) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on f_position_store_brand_agg_2018_11_27_16_26_28 (cost=0.00..860,340.26 rows=1 width=355) (never executed)

14. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5 (cost=0.00..1,841,760.53 rows=1 width=296) (actual time=0.001..0.001 rows=0 loops=1)

15. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..1,841,760.52 rows=1 width=296) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on f_position_store_sku_agg_2018_11_27_16_15_33 (cost=0.00..1,841,760.52 rows=1 width=296) (never executed)

17. 0.001 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 6 (cost=0.00..1,780,788.45 rows=1 width=300) (actual time=0.001..0.001 rows=0 loops=1)

18. 0.000 0.000 ↓ 0.0 0 1

Result (cost=0.00..1,780,788.44 rows=1 width=300) (actual time=0.000..0.000 rows=0 loops=1)

  • One-Time Filter: false
19. 0.000 0.000 ↓ 0.0 0

Seq Scan on f_position_store_sku_pkg_agg_2018_11_27_16_15_58 (cost=0.00..1,780,788.44 rows=1 width=300) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Index Scan using d_store_2018_11_29_07_12_09_store_cd_idx on d_store_2018_11_29_07_12_09 (cost=0.43..8.45 rows=1 width=12) (never executed)

  • Index Cond: ((store_cd)::text = (_position_store.store_cd)::text)
  • Filter: ((max_ver_flg)::text = 'Y'::text)