explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HPca : of-primjer_2

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=489.39..963.79 rows=1 width=465) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=467.71..931.33 rows=3 width=480) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=446.03..852.19 rows=16 width=475) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=424.35..457.04 rows=104 width=470) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

HashAggregate (cost=424.07..425.11 rows=104 width=5) (actual rows= loops=)

  • Group Key: ddc.dimension_set_id
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.43..423.81 rows=104 width=5) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

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

  • Filter: ((value)::text = '015220'::text)
8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on dta_dimension_combo ddc (cost=5.43..400.97 rows=147 width=10) (actual rows= loops=)

  • Recheck Cond: (dimension_value_id = cdv.id)
9. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (dimension_value_id = cdv.id)
10. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = ddc.dimension_set_id)
11. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (ddc_2.dimension_value_id = cdv_2.id)
12. 0.000 0.000 ↓ 0.0

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_2 (cost=0.29..3.31 rows=148 width=10) (actual rows= loops=)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
13. 0.000 0.000 ↓ 0.0

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

14. 0.000 0.000 ↓ 0.0

Seq Scan on cfg_dimension_value cdv_2 (cost=0.00..21.38 rows=1 width=5) (actual rows= loops=)

  • Filter: ((value)::text = '056059'::text)
15. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (ddc_1.dimension_value_id = cdv_1.id)
16. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
17. 0.000 0.000 ↓ 0.0

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

18. 0.000 0.000 ↓ 0.0

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

  • Filter: ((value)::text = '072027'::text)
19. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (ddc_3.dimension_value_id = cdv_3.id)
20. 0.000 0.000 ↓ 0.0

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_3 (cost=0.29..3.31 rows=148 width=10) (actual rows= loops=)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
21. 0.000 0.000 ↓ 0.0

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

22. 0.000 0.000 ↓ 0.0

Seq Scan on cfg_dimension_value cdv_3 (cost=0.00..21.38 rows=1 width=5) (actual rows= loops=)

  • Filter: ((value)::text = '024116'::text)