explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tx7Y : nakon uzimanja stats na dta_dimension_combo

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.905 1,935.592 ↓ 63.0 63 1

Nested Loop Semi Join (cost=641.15..1,159.24 rows=1 width=465) (actual time=29.906..1,935.592 rows=63 loops=1)

2. 0.876 1,793.063 ↓ 63.0 63 1

Nested Loop Semi Join (cost=619.47..1,130.49 rows=1 width=515) (actual time=27.983..1,793.063 rows=63 loops=1)

3. 0.875 1,662.848 ↓ 63.0 63 1

Nested Loop Semi Join (cost=597.79..1,101.73 rows=1 width=510) (actual time=25.996..1,662.848 rows=63 loops=1)

4. 0.966 1,535.658 ↓ 63.0 63 1

Nested Loop Semi Join (cost=576.11..1,072.97 rows=1 width=505) (actual time=23.802..1,535.658 rows=63 loops=1)

5. 0.918 1,367.427 ↓ 63.0 63 1

Nested Loop Semi Join (cost=554.43..1,044.22 rows=1 width=500) (actual time=21.847..1,367.427 rows=63 loops=1)

6. 0.918 1,180.344 ↓ 63.0 63 1

Nested Loop Semi Join (cost=532.75..1,015.46 rows=1 width=495) (actual time=18.876..1,180.344 rows=63 loops=1)

7. 0.856 997.230 ↓ 63.0 63 1

Nested Loop Semi Join (cost=511.07..986.70 rows=1 width=490) (actual time=15.836..997.230 rows=63 loops=1)

8. 0.904 839.378 ↓ 63.0 63 1

Nested Loop Semi Join (cost=489.39..957.94 rows=1 width=485) (actual time=12.541..839.378 rows=63 loops=1)

9. 1.331 681.163 ↓ 21.0 63 1

Nested Loop Semi Join (cost=467.71..925.63 rows=3 width=480) (actual time=10.608..681.163 rows=63 loops=1)

10. 1.488 355.729 ↓ 6.7 107 1

Nested Loop Semi Join (cost=446.03..847.25 rows=16 width=475) (actual time=8.141..355.729 rows=107 loops=1)

11. 2.068 17.257 ↓ 1.1 114 1

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

12. 0.999 5.841 ↓ 1.1 114 1

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

  • Group Key: ddc.dimension_set_id
13. 0.759 4.842 ↓ 1.1 117 1

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

14. 0.336 0.336 ↑ 1.0 1 1

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

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

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

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

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

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

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

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

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_2 (cost=0.29..3.27 rows=146 width=10) (actual time=0.151..1.699 rows=276 loops=114)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
20. 0.014 0.224 ↑ 1.0 1 1

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

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

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

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

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

  • Hash Cond: (ddc_1.dimension_value_id = cdv_1.id)
23. 173.447 173.447 ↓ 2.0 286 107

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_1 (cost=0.29..3.27 rows=146 width=10) (actual time=0.130..1.621 rows=286 loops=107)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
24. 0.013 0.168 ↑ 1.0 1 1

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

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

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

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

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

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

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_6 (cost=0.29..3.27 rows=146 width=10) (actual time=0.079..1.353 rows=268 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
28. 0.012 0.176 ↑ 1.0 1 1

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

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

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

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

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

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

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_5 (cost=0.29..3.27 rows=146 width=10) (actual time=0.071..1.395 rows=268 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
32. 0.011 0.146 ↑ 1.0 1 1

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

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

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

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

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

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

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_4 (cost=0.29..3.27 rows=146 width=10) (actual time=0.040..1.532 rows=302 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
36. 0.013 0.326 ↑ 1.0 1 1

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

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

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

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

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

  • Hash Cond: (ddc_3.dimension_value_id = cdv_3.id)
39. 97.398 97.398 ↓ 2.1 301 63

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_3 (cost=0.29..3.27 rows=146 width=10) (actual time=0.048..1.546 rows=301 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
40. 0.026 0.272 ↑ 1.0 1 1

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

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

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

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

Hash Join (cost=21.68..25.21 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. 92.043 92.043 ↓ 1.8 262 63

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_10 (cost=0.29..3.27 rows=146 width=10) (actual time=0.034..1.461 rows=262 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
44. 0.018 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
45. 0.149 0.149 ↑ 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.149 rows=1 loops=1)

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

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

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

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_9 (cost=0.29..3.27 rows=146 width=10) (actual time=0.028..1.033 rows=222 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
48. 0.022 0.173 ↑ 1.0 1 1

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

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

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

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

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

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

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_8 (cost=0.29..3.27 rows=146 width=10) (actual time=0.024..1.082 rows=231 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
52. 0.012 0.158 ↑ 1.0 1 1

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

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

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

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

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

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

Index Scan using dim_set_combo_dim_set_fk_i on dta_dimension_combo ddc_7 (cost=0.29..3.27 rows=146 width=10) (actual time=0.045..1.227 rows=245 loops=63)

  • Index Cond: (dimension_set_id = ddc.dimension_set_id)
56. 0.013 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
57. 0.154 0.154 ↑ 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.154 rows=1 loops=1)

  • Filter: ((value)::text = '039012'::text)
  • Rows Removed by Filter: 829
Planning time : 15.265 ms
Execution time : 1,936.197 ms