explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.987 2,027.699 ↓ 63.0 63 1

Nested Loop Semi Join (cost=641.15..1,165.75 rows=1 width=465) (actual time=61.789..2,027.699 rows=63 loops=1)

2. 1.029 1,870.409 ↓ 63.0 63 1

Nested Loop Semi Join (cost=619.47..1,136.90 rows=1 width=515) (actual time=59.844..1,870.409 rows=63 loops=1)

3. 0.943 1,720.952 ↓ 63.0 63 1

Nested Loop Semi Join (cost=597.79..1,108.05 rows=1 width=510) (actual time=57.710..1,720.952 rows=63 loops=1)

4. 0.920 1,559.548 ↓ 63.0 63 1

Nested Loop Semi Join (cost=576.11..1,079.19 rows=1 width=505) (actual time=53.470..1,559.548 rows=63 loops=1)

5. 0.882 1,391.363 ↓ 63.0 63 1

Nested Loop Semi Join (cost=554.43..1,050.34 rows=1 width=500) (actual time=50.271..1,391.363 rows=63 loops=1)

6. 0.996 1,211.435 ↓ 63.0 63 1

Nested Loop Semi Join (cost=532.75..1,021.49 rows=1 width=495) (actual time=46.762..1,211.435 rows=63 loops=1)

7. 0.998 1,013.627 ↓ 63.0 63 1

Nested Loop Semi Join (cost=511.07..992.64 rows=1 width=490) (actual time=42.523..1,013.627 rows=63 loops=1)

8. 0.902 855.003 ↓ 63.0 63 1

Nested Loop Semi Join (cost=489.39..963.79 rows=1 width=485) (actual time=40.489..855.003 rows=63 loops=1)

9. 1.912 701.389 ↓ 21.0 63 1

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

10. 1.627 388.749 ↓ 6.7 107 1

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

11. 2.497 49.340 ↓ 1.1 114 1

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

12. 1.906 24.727 ↓ 1.1 114 1

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

  • Group Key: ddc.dimension_set_id
13. 1.881 22.821 ↓ 1.1 117 1

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

14. 0.987 0.987 ↑ 1.0 1 1

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

  • Filter: ((value)::text = '015220'::text)
  • Rows Removed by Filter: 829
15. 19.686 19.953 ↑ 1.3 117 1

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

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

  • Index Cond: (dimension_value_id = cdv.id)
17. 22.116 22.116 ↑ 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.188..0.194 rows=1 loops=114)

  • Index Cond: (id = ddc.dimension_set_id)
18. 154.362 337.782 ↑ 1.0 1 114

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

  • Hash Cond: (ddc_2.dimension_value_id = cdv_2.id)
19. 179.550 179.550 ↓ 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.112..1.575 rows=276 loops=114)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
20. 0.069 3.870 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
21. 3.801 3.801 ↑ 1.0 1 1

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

  • Filter: ((value)::text = '056059'::text)
  • Rows Removed by Filter: 829
22. 139.818 310.728 ↑ 1.0 1 107

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

  • Hash Cond: (ddc_1.dimension_value_id = cdv_1.id)
23. 170.558 170.558 ↓ 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.137..1.594 rows=286 loops=107)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
24. 0.038 0.352 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
25. 0.314 0.314 ↑ 1.0 1 1

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

  • Filter: ((value)::text = '072027'::text)
  • Rows Removed by Filter: 829
26. 72.329 152.712 ↑ 1.0 1 63

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

  • Hash Cond: (ddc_6.dimension_value_id = cdv_6.id)
27. 80.199 80.199 ↓ 1.8 268 63

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_6 (cost=0.29..3.31 rows=148 width=10) (actual time=0.120..1.273 rows=268 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
28. 0.018 0.184 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
29. 0.166 0.166 ↑ 1.0 1 1

Seq Scan on cfg_dimension_value cdv_6 (cost=0.00..21.38 rows=1 width=5) (actual time=0.080..0.166 rows=1 loops=1)

  • Filter: ((value)::text = '057059'::text)
  • Rows Removed by Filter: 829
30. 71.842 157.626 ↑ 1.0 1 63

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

  • Hash Cond: (ddc_5.dimension_value_id = cdv_5.id)
31. 85.617 85.617 ↓ 1.8 268 63

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_5 (cost=0.29..3.31 rows=148 width=10) (actual time=0.089..1.359 rows=268 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
32. 0.029 0.167 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
33. 0.138 0.138 ↑ 1.0 1 1

Seq Scan on cfg_dimension_value cdv_5 (cost=0.00..21.38 rows=1 width=5) (actual time=0.060..0.138 rows=1 loops=1)

  • Filter: ((value)::text = '099013'::text)
  • Rows Removed by Filter: 829
34. 84.383 196.812 ↑ 1.0 1 63

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

  • Hash Cond: (ddc_4.dimension_value_id = cdv_4.id)
35. 111.006 111.006 ↓ 2.0 302 63

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_4 (cost=0.29..3.31 rows=148 width=10) (actual time=0.027..1.762 rows=302 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
36. 0.019 1.423 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
37. 1.404 1.404 ↑ 1.0 1 1

Seq Scan on cfg_dimension_value cdv_4 (cost=0.00..21.38 rows=1 width=5) (actual time=0.073..1.404 rows=1 loops=1)

  • Filter: ((value)::text = '024105'::text)
  • Rows Removed by Filter: 829
38. 82.726 179.046 ↑ 1.0 1 63

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

  • Hash Cond: (ddc_3.dimension_value_id = cdv_3.id)
39. 96.138 96.138 ↓ 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.085..1.526 rows=301 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
40. 0.020 0.182 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
41. 0.162 0.162 ↑ 1.0 1 1

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

  • Filter: ((value)::text = '024116'::text)
  • Rows Removed by Filter: 829
42. 87.241 167.265 ↑ 1.0 1 63

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

  • Hash Cond: (ddc_10.dimension_value_id = cdv_10.id)
43. 79.821 79.821 ↓ 1.8 262 63

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_10 (cost=0.29..3.31 rows=148 width=10) (actual time=0.067..1.267 rows=262 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
44. 0.018 0.203 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
45. 0.185 0.185 ↑ 1.0 1 1

Seq Scan on cfg_dimension_value cdv_10 (cost=0.00..21.38 rows=1 width=5) (actual time=0.065..0.185 rows=1 loops=1)

  • Filter: ((value)::text = '088012'::text)
  • Rows Removed by Filter: 829
46. 67.340 160.461 ↑ 1.0 1 63

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

  • Hash Cond: (ddc_9.dimension_value_id = cdv_9.id)
47. 92.799 92.799 ↓ 1.5 222 63

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_9 (cost=0.29..3.31 rows=148 width=10) (actual time=0.035..1.473 rows=222 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
48. 0.039 0.322 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
49. 0.283 0.283 ↑ 1.0 1 1

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

  • Filter: ((value)::text = '039007'::text)
  • Rows Removed by Filter: 829
50. 65.688 148.428 ↑ 1.0 1 63

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

  • Hash Cond: (ddc_8.dimension_value_id = cdv_8.id)
51. 82.530 82.530 ↓ 1.6 231 63

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_8 (cost=0.29..3.31 rows=148 width=10) (actual time=0.133..1.310 rows=231 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
52. 0.022 0.210 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
53. 0.188 0.188 ↑ 1.0 1 1

Seq Scan on cfg_dimension_value cdv_8 (cost=0.00..21.38 rows=1 width=5) (actual time=0.106..0.188 rows=1 loops=1)

  • Filter: ((value)::text = '039010'::text)
  • Rows Removed by Filter: 829
54. 70.090 156.303 ↑ 1.0 1 63

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

  • Hash Cond: (ddc_7.dimension_value_id = cdv_7.id)
55. 86.058 86.058 ↓ 1.7 245 63

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_7 (cost=0.29..3.31 rows=148 width=10) (actual time=0.078..1.366 rows=245 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
56. 0.017 0.155 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
57. 0.138 0.138 ↑ 1.0 1 1

Seq Scan on cfg_dimension_value cdv_7 (cost=0.00..21.38 rows=1 width=5) (actual time=0.060..0.138 rows=1 loops=1)

  • Filter: ((value)::text = '039012'::text)
  • Rows Removed by Filter: 829
Planning time : 23.762 ms
Execution time : 2,030.486 ms