explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.883 934.724 ↓ 63.0 63 1

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

2. 1.383 744.337 ↓ 21.0 63 1

Nested Loop Semi Join (cost=467.71..931.33 rows=3 width=480) (actual time=26.561..744.337 rows=63 loops=1)

3. 1.815 415.106 ↓ 6.7 107 1

Nested Loop Semi Join (cost=446.03..852.19 rows=16 width=475) (actual time=22.783..415.106 rows=107 loops=1)

4. 2.194 37.889 ↓ 1.1 114 1

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

5. 1.068 20.419 ↓ 1.1 114 1

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

  • Group Key: ddc.dimension_set_id
6. 0.776 19.351 ↓ 1.1 117 1

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

7. 0.331 0.331 ↑ 1.0 1 1

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

  • Filter: ((value)::text = '015220'::text)
  • Rows Removed by Filter: 829
8. 18.174 18.244 ↑ 1.3 117 1

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

  • Recheck Cond: (dimension_value_id = cdv.id)
  • Heap Blocks: exact=114
9. 0.070 0.070 ↑ 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.070..0.070 rows=117 loops=1)

  • Index Cond: (dimension_value_id = cdv.id)
10. 15.276 15.276 ↑ 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.129..0.134 rows=1 loops=114)

  • Index Cond: (id = ddc.dimension_set_id)
11. 159.198 375.402 ↑ 1.0 1 114

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

  • Hash Cond: (ddc_2.dimension_value_id = cdv_2.id)
12. 216.030 216.030 ↓ 1.9 276 114

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 time=0.162..1.895 rows=276 loops=114)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
13. 0.019 0.174 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
14. 0.155 0.155 ↑ 1.0 1 1

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

  • Filter: ((value)::text = '056059'::text)
  • Rows Removed by Filter: 829
15. 155.508 327.848 ↑ 1.0 1 107

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

  • Hash Cond: (ddc_1.dimension_value_id = cdv_1.id)
16. 172.163 172.163 ↓ 1.9 286 107

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.102..1.609 rows=286 loops=107)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
17. 0.020 0.177 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
18. 0.157 0.157 ↑ 1.0 1 1

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

  • Filter: ((value)::text = '072027'::text)
  • Rows Removed by Filter: 829
19. 87.911 189.504 ↑ 1.0 1 63

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

  • Hash Cond: (ddc_3.dimension_value_id = cdv_3.id)
20. 101.430 101.430 ↓ 2.0 301 63

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 time=0.031..1.610 rows=301 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
21. 0.020 0.163 ↑ 1.0 1 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
22. 0.143 0.143 ↑ 1.0 1 1

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

  • Filter: ((value)::text = '024116'::text)
  • Rows Removed by Filter: 829
Planning time : 2.596 ms
Execution time : 935.258 ms