explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OBSV

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

Nested Loop (cost=47.78..7,118,626.04 rows=1 width=496) (actual time=1.010..4.587 rows=1 loops=1)

2. 0.015 4.551 ↑ 1.0 1 1

Subquery Scan on _position_store (cost=47.35..7,118,617.58 rows=1 width=494) (actual time=0.975..4.551 rows=1 loops=1)

  • Filter: ((_position_store.time_period_cd = 'FALL'::text) AND (_position_store.metric_type = 'VELOCITY'::text))
  • Rows Removed by Filter: 39
3. 0.045 4.536 ↑ 15.0 40 1

Subquery Scan on v_f_position_store_agg_2nf (cost=47.35..7,118,608.58 rows=600 width=1,574) (actual time=0.955..4.536 rows=40 loops=1)

4. 0.004 4.491 ↑ 6.0 1 1

Append (cost=47.35..7,118,605.07 rows=6 width=347) (actual time=0.926..4.491 rows=1 loops=1)

5. 3.970 4.482 ↑ 1.0 1 1

Bitmap Heap Scan on f_position_store_agg_2018_11_27_00_04_00 (cost=47.35..9,246.23 rows=1 width=382) (actual time=0.924..4.482 rows=1 loops=1)

  • Recheck Cond: (position_id = 3455)
  • Filter: ((store_src_cd)::text = '0000591'::text)
  • Rows Removed by Filter: 3461
  • Heap Blocks: exact=3038
6. 0.512 0.512 ↓ 1.4 3,462 1

Bitmap Index Scan on f_position_store_agg_2018_11_27_position_id_premise_type_cd_idx (cost=0.00..47.35 rows=2,523 width=0) (actual time=0.512..0.512 rows=3,462 loops=1)

  • Index Cond: (position_id = 3455)
7. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..499,466.61 rows=1 width=387) (actual time=0.001..0.001 rows=0 loops=1)

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

Seq Scan on f_position_store_pri_pack_agg_2018_11_27_00_01_43 (cost=0.00..499,466.61 rows=1 width=387) (never executed)

9. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 3 (cost=0.00..2,164,957.53 rows=1 width=364) (actual time=0.001..0.001 rows=0 loops=1)

10. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..2,164,957.52 rows=1 width=364) (actual time=0.001..0.001 rows=0 loops=1)

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

Seq Scan on f_position_store_pri_pack_pkg_sku_agg_2018_11_27_00_01_30 (cost=0.00..2,164,957.52 rows=1 width=364) (never executed)

12. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4 (cost=0.00..854,118.72 rows=1 width=353) (actual time=0.001..0.001 rows=0 loops=1)

13. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..854,118.71 rows=1 width=353) (actual time=0.001..0.001 rows=0 loops=1)

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

Seq Scan on f_position_store_brand_agg_2018_11_27_00_38_57 (cost=0.00..854,118.71 rows=1 width=353) (never executed)

15. 0.000 0.001 ↓ 0.0 0 1

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

16. 0.001 0.001 ↓ 0.0 0 1

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

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

Seq Scan on f_position_store_sku_agg_2018_11_26_23_46_24 (cost=0.00..1,825,245.44 rows=1 width=296) (never executed)

18. 0.000 0.001 ↓ 0.0 0 1

Subquery Scan on *SELECT* 6 (cost=0.00..1,765,570.51 rows=1 width=298) (actual time=0.001..0.001 rows=0 loops=1)

19. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..1,765,570.50 rows=1 width=298) (actual time=0.001..0.001 rows=0 loops=1)

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

Seq Scan on f_position_store_sku_pkg_agg_2018_11_27_00_38_29 (cost=0.00..1,765,570.50 rows=1 width=298) (never executed)

21. 0.030 0.030 ↑ 1.0 1 1

Index Scan using d_store_2018_11_30_10_32_15_store_cd_idx on d_store_2018_11_30_10_32_15 (cost=0.43..8.45 rows=1 width=12) (actual time=0.029..0.030 rows=1 loops=1)

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