explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RaPz : Optimization for: of-primjer_2; plan #HPca

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1.442 377.319 ↓ 4.0 64 1

Nested Loop Semi Join (cost=446.03..852.19 rows=16 width=465) (actual time=12.427..377.319 rows=64 loops=1)

2. 2.689 33.307 ↓ 1.1 114 1

Nested Loop (cost=424.35..457.04 rows=104 width=470) (actual time=10.125..33.307 rows=114 loops=1)

3. 0.939 10.554 ↓ 1.1 114 1

HashAggregate (cost=424.07..425.11 rows=104 width=5) (actual time=10.059..10.554 rows=114 loops=1)

  • Group Key: ddc.dimension_set_id
4. 0.770 9.615 ↓ 1.1 117 1

Nested Loop (cost=5.43..423.81 rows=104 width=5) (actual time=0.450..9.615 rows=117 loops=1)

5. 0.378 0.378 ↑ 1.0 1 1

Seq Scan on cfg_dimension_value cdv (cost=0.00..21.38 rows=1 width=5) (actual time=0.314..0.378 rows=1 loops=1)

  • Filter: ((value)::text = '015220'::text)
  • Rows Removed by Filter: 829
6. 8.409 8.467 ↑ 1.3 117 1

Bitmap Heap Scan on dta_dimension_combo ddc (cost=5.43..400.97 rows=147 width=10) (actual time=0.120..8.467 rows=117 loops=1)

  • Recheck Cond: (dimension_value_id = cdv.id)
  • Heap Blocks: exact=114
7. 0.058 0.058 ↑ 1.3 117 1

Bitmap Index Scan on dim_set_combo_dim_value_fk_i (cost=0.00..5.40 rows=147 width=0) (actual time=0.058..0.058 rows=117 loops=1)

  • Index Cond: (dimension_value_id = cdv.id)
8. 20.064 20.064 ↑ 1.0 1 114

Index Scan using dta_dimension_set_pkey on dta_dimension_set dds (cost=0.28..0.30 rows=1 width=465) (actual time=0.172..0.176 rows=1 loops=114)

  • Index Cond: (id = ddc.dimension_set_id)
9. 144.395 342.570 ↑ 1.0 1 114

Hash Join (cost=21.68..25.26 rows=1 width=5) (actual time=3.005..3.005 rows=1 loops=114)

  • Hash Cond: (ddc_1.dimension_value_id = cdv_1.id)
10. 198.018 198.018 ↓ 1.8 272 114

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_1 (cost=0.29..3.31 rows=148 width=10) (actual time=0.197..1.737 rows=272 loops=114)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
11. 0.011 0.157 ↑ 1.0 1 1

Hash (cost=21.38..21.38 rows=1 width=5) (actual time=0.157..0.157 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
12. 0.146 0.146 ↑ 1.0 1 1

Seq Scan on cfg_dimension_value cdv_1 (cost=0.00..21.38 rows=1 width=5) (actual time=0.111..0.146 rows=1 loops=1)

  • Filter: ((value)::text = '072027'::text)
  • Rows Removed by Filter: 829
Planning time : 2.038 ms
Execution time : 377.663 ms