explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wl4V : Optimization for: plan #Xe9r

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 53,349.821 ↑ 413,919.1 7 1

Nested Loop Left Join (cost=2,415,153.24..163,119,077.39 rows=2,897,434 width=4,057) (actual time=13,071.068..53,349.821 rows=7 loops=1)

2.          

Initplan (for Nested Loop Left Join)

3. 7.267 7.267 ↑ 1.0 1 1

Result (cost=0.00..0.26 rows=1 width=8) (actual time=7.267..7.267 rows=1 loops=1)

4. 0.034 53,343.223 ↑ 413,919.1 7 1

Hash Left Join (cost=2,415,144.67..138,968,964.74 rows=2,897,434 width=4,024) (actual time=13,071.049..53,343.223 rows=7 loops=1)

  • Hash Cond: (pv.manufacturer_id = manufacturer_per.id)
5. 0.025 53,326.739 ↑ 413,919.1 7 1

Nested Loop Left Join (cost=2,414,947.41..138,961,161.72 rows=2,897,434 width=4,024) (actual time=13,054.582..53,326.739 rows=7 loops=1)

6. 0.026 53,326.672 ↑ 413,919.1 7 1

Nested Loop Left Join (cost=2,414,947.13..114,861,754.42 rows=2,897,434 width=4,016) (actual time=13,054.573..53,326.672 rows=7 loops=1)

7. 0.012 53,263.072 ↑ 413,919.1 7 1

Nested Loop Left Join (cost=2,414,929.08..62,464,008.75 rows=2,897,434 width=3,824) (actual time=13,054.407..53,263.072 rows=7 loops=1)

8. 0.024 53,262.850 ↑ 413,919.1 7 1

Nested Loop Left Join (cost=2,414,929.08..62,427,790.80 rows=2,897,434 width=3,816) (actual time=13,054.202..53,262.850 rows=7 loops=1)

9. 2,259.691 53,254.818 ↑ 413,919.1 7 1

Nested Loop (cost=2,414,917.79..29,628,837.92 rows=2,897,434 width=3,784) (actual time=13,054.189..53,254.818 rows=7 loops=1)

10. 1,821.796 33,612.725 ↓ 2.0 5,794,134 1

Hash Left Join (cost=2,414,909.33..5,036,866.85 rows=2,897,434 width=3,752) (actual time=7,383.476..33,612.725 rows=5,794,134 loops=1)

  • Hash Cond: (pv.id = pw.pasport_id)
  • Join Filter: (((pv.type_id = ANY ('{1,2}'::bigint[])) AND ((wt.code)::text = '12'::text)) OR ((pv.type_id = '3'::bigint) AND ((wt.code)::text = '27'::text)))
11. 1,967.079 31,778.683 ↓ 2.0 5,794,134 1

Hash Left Join (cost=2,414,526.91..5,025,596.06 rows=2,897,434 width=3,747) (actual time=7,371.218..31,778.683 rows=5,794,134 loops=1)

  • Hash Cond: (pv.country_add = c_8.id)
12. 1,349.127 29,787.094 ↓ 2.0 5,794,134 1

Hash Left Join (cost=2,414,515.48..5,014,105.39 rows=2,897,434 width=3,683) (actual time=7,346.700..29,787.094 rows=5,794,134 loops=1)

  • Hash Cond: (pv.ts_cat_id = c_5.id)
13. 1,334.497 28,425.690 ↓ 2.0 5,794,134 1

Hash Left Join (cost=2,414,512.57..5,003,222.83 rows=2,897,434 width=3,029) (actual time=7,334.416..28,425.690 rows=5,794,134 loops=1)

  • Hash Cond: (pv.ecologic_class_id = c_6.id)
14. 1,290.203 27,081.683 ↓ 2.0 5,794,134 1

Hash Left Join (cost=2,414,509.86..4,992,343.92 rows=2,897,434 width=2,375) (actual time=7,324.888..27,081.683 rows=5,794,134 loops=1)

  • Hash Cond: (pv.ts_trademark_id = c_7.id)
15. 2,361.794 25,746.749 ↓ 2.0 5,794,134 1

Nested Loop Left Join (cost=2,414,398.94..4,981,355.88 rows=2,897,434 width=2,367) (actual time=7,280.141..25,746.749 rows=5,794,134 loops=1)

16. 1,238.850 23,384.955 ↓ 2.0 5,794,134 1

Hash Left Join (cost=2,414,398.79..4,945,129.78 rows=2,897,434 width=2,296) (actual time=7,213.000..23,384.955 rows=5,794,134 loops=1)

  • Hash Cond: (pv.type_id = c_3.id)
17. 1,305.464 22,101.721 ↓ 2.0 5,794,134 1

Hash Left Join (cost=2,414,396.46..4,934,246.82 rows=2,897,434 width=1,642) (actual time=7,168.606..22,101.721 rows=5,794,134 loops=1)

  • Hash Cond: (pv.ts_cu_cat_id = c_4.id)
18. 6,551.992 20,762.856 ↓ 2.0 5,794,134 1

Hash Join (cost=2,414,387.93..4,923,357.89 rows=2,897,434 width=1,501) (actual time=7,135.188..20,762.856 rows=5,794,134 loops=1)

  • Hash Cond: (pv.root_id = root.id)
19. 3,720.138 12,106.662 ↑ 1.0 5,794,869 1

Merge Left Join (cost=2,229,700.15..2,629,024.57 rows=5,794,869 width=1,432) (actual time=4,995.691..12,106.662 rows=5,794,869 loops=1)

  • Merge Cond: (pv.id = sh.pasport_id)
20. 2,252.689 2,252.689 ↑ 1.0 5,794,869 1

Index Scan using fdc_pts_ver_pk on fdc_pts_ver pv (cost=0.43..283,544.82 rows=5,794,869 width=930) (actual time=0.014..2,252.689 rows=5,794,869 loops=1)

21. 415.046 6,133.835 ↓ 1.0 5,794,850 1

Materialize (cost=2,229,699.72..2,258,640.53 rows=5,788,163 width=510) (actual time=4,995.667..6,133.835 rows=5,794,850 loops=1)

22. 2,489.586 5,718.789 ↓ 1.0 5,794,850 1

Sort (cost=2,229,699.72..2,244,170.12 rows=5,788,163 width=510) (actual time=4,995.661..5,718.789 rows=5,794,850 loops=1)

  • Sort Key: sh.pasport_id
  • Sort Method: external merge Disk: 384208kB
23. 860.038 3,229.203 ↓ 1.0 5,794,850 1

Hash Left Join (cost=12.27..254,040.74 rows=5,788,163 width=510) (actual time=5.832..3,229.203 rows=5,794,850 loops=1)

  • Hash Cond: (c.id = t.status_id)
24. 840.764 2,368.870 ↓ 1.0 5,794,850 1

Hash Join (cost=10.24..232,405.46 rows=5,788,163 width=493) (actual time=5.528..2,368.870 rows=5,794,850 loops=1)

  • Hash Cond: (sh.status_id = c.id)
25. 710.015 1,528.091 ↓ 1.0 5,794,850 1

Hash Left Join (cost=9.02..210,770.98 rows=5,788,163 width=347) (actual time=5.498..1,528.091 rows=5,794,850 loops=1)

  • Hash Cond: (sh.reason_id = c_1.id)
26. 812.596 812.596 ↓ 1.0 5,794,850 1

Seq Scan on fdc_pts_status_history sh (cost=0.00..189,056.34 rows=5,788,163 width=24) (actual time=0.007..812.596 rows=5,794,850 loops=1)

  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 48817
27. 0.009 5.480 ↑ 1.0 25 1

Hash (cost=8.70..8.70 rows=25 width=331) (actual time=5.480..5.480 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
28. 0.015 5.471 ↑ 1.0 25 1

Hash Join (cost=2.63..8.70 rows=25 width=331) (actual time=0.119..5.471 rows=25 loops=1)

  • Hash Cond: (c_1.object_type_id = c_2.id)
29. 0.036 5.449 ↑ 1.0 25 1

Hash Right Join (cost=1.56..7.56 rows=25 width=339) (actual time=0.104..5.449 rows=25 loops=1)

  • Hash Cond: (t_1.reason_id = c_1.id)
30. 5.401 5.401 ↑ 1.0 25 1

Seq Scan on fdc_change_status_reason_translation t_1 (cost=0.00..5.92 rows=25 width=193) (actual time=0.079..5.401 rows=25 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 103
31. 0.006 0.012 ↑ 1.0 25 1

Hash (cost=1.25..1.25 rows=25 width=154) (actual time=0.012..0.012 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
32. 0.006 0.006 ↑ 1.0 25 1

Seq Scan on fdc_change_status_reason c_1 (cost=0.00..1.25 rows=25 width=154) (actual time=0.004..0.006 rows=25 loops=1)

33. 0.002 0.007 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=8) (actual time=0.007..0.007 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.005 0.005 ↑ 1.0 3 1

Seq Scan on fdc_object_type c_2 (cost=0.00..1.03 rows=3 width=8) (actual time=0.004..0.005 rows=3 loops=1)

35. 0.007 0.015 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=146) (actual time=0.015..0.015 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
36. 0.008 0.008 ↑ 1.0 10 1

Seq Scan on fdc_status_pts c (cost=0.00..1.10 rows=10 width=146) (actual time=0.006..0.008 rows=10 loops=1)

37. 0.003 0.295 ↑ 1.0 10 1

Hash (cost=1.90..1.90 rows=10 width=33) (actual time=0.295..0.295 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
38. 0.292 0.292 ↑ 1.0 10 1

Seq Scan on fdc_status_pts_translation t (cost=0.00..1.90 rows=10 width=33) (actual time=0.066..0.292 rows=10 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 50
39. 762.239 2,104.202 ↓ 2.0 5,440,311 1

Hash (cost=116,143.24..116,143.24 rows=2,720,523 width=77) (actual time=2,104.202..2,104.202 rows=5,440,311 loops=1)

  • Buckets: 524288 Batches: 16 Memory Usage: 19610kB
40. 1,341.963 1,341.963 ↓ 2.0 5,440,311 1

Index Scan using fdc_pts_root_passport_type_i on fdc_pts_root root (cost=0.43..116,143.24 rows=2,720,523 width=77) (actual time=31.441..1,341.963 rows=5,440,311 loops=1)

  • Index Cond: (passport_type_id = $0)
41. 0.013 33.401 ↑ 1.0 49 1

Hash (cost=7.92..7.92 rows=49 width=149) (actual time=33.401..33.401 rows=49 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
42. 0.025 33.388 ↑ 1.0 49 1

Hash Right Join (cost=2.10..7.92 rows=49 width=149) (actual time=32.062..33.388 rows=49 loops=1)

  • Hash Cond: (t_3.ts_cat_id = c_4.id)
43. 1.412 1.412 ↑ 1.0 49 1

Seq Scan on fdc_ts_cu_cat_translation t_3 (cost=0.00..5.67 rows=49 width=11) (actual time=0.104..1.412 rows=49 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 196
44. 0.011 31.951 ↑ 1.0 49 1

Hash (cost=1.49..1.49 rows=49 width=146) (actual time=31.951..31.951 rows=49 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
45. 31.940 31.940 ↑ 1.0 49 1

Seq Scan on fdc_ts_cu_cat c_4 (cost=0.00..1.49 rows=49 width=146) (actual time=31.936..31.940 rows=49 loops=1)

46. 0.003 44.384 ↑ 1.0 3 1

Hash (cost=2.30..2.30 rows=3 width=662) (actual time=44.384..44.384 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
47. 0.013 44.381 ↑ 1.0 3 1

Hash Right Join (cost=1.07..2.30 rows=3 width=662) (actual time=44.309..44.381 rows=3 loops=1)

  • Hash Cond: (t_2.kind_id = c_3.id)
48. 10.109 10.109 ↓ 3.0 3 1

Seq Scan on fdc_ts_kind_translation t_2 (cost=0.00..1.23 rows=1 width=524) (actual time=10.042..10.109 rows=3 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 12
49. 0.009 34.259 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=146) (actual time=34.259..34.259 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
50. 34.250 34.250 ↑ 1.0 3 1

Seq Scan on fdc_ts_kind c_3 (cost=0.00..1.03 rows=3 width=146) (actual time=34.249..34.250 rows=3 loops=1)

51. 0.000 0.000 ↑ 1.0 1 5,794,134

Materialize (cost=0.15..8.18 rows=1 width=71) (actual time=0.000..0.000 rows=1 loops=5,794,134)

52. 67.135 67.135 ↑ 1.0 1 1

Index Scan using fdc_translate_messages_code_date_uk on fdc_translate_messages m (cost=0.15..8.18 rows=1 width=71) (actual time=67.133..67.135 rows=1 loops=1)

  • Index Cond: (((code)::text = 'SYS.IS_MISSING'::text) AND (languages_id = lang.get_current_lang_id()))
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
53. 0.140 44.731 ↑ 1.0 855 1

Hash (cost=100.23..100.23 rows=855 width=16) (actual time=44.731..44.731 rows=855 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 49kB
54. 0.304 44.591 ↑ 1.0 855 1

Hash Right Join (cost=51.15..100.23 rows=855 width=16) (actual time=7.789..44.591 rows=855 loops=1)

  • Hash Cond: (t_6.trademark_id = c_7.id)
55. 36.522 43.983 ↑ 1.0 855 1

Bitmap Heap Scan on fdc_ts_trademark_translation t_6 (cost=18.91..65.74 rows=855 width=16) (actual time=7.477..43.983 rows=855 loops=1)

  • Recheck Cond: (language_id = lang.get_current_lang_id())
  • Heap Blocks: exact=34
56. 7.461 7.461 ↑ 1.0 855 1

Bitmap Index Scan on fdc_ts_trademark_translation_l_i (cost=0.00..18.70 rows=855 width=0) (actual time=7.461..7.461 rows=855 loops=1)

  • Index Cond: (language_id = lang.get_current_lang_id())
57. 0.159 0.304 ↑ 1.0 855 1

Hash (cost=21.55..21.55 rows=855 width=8) (actual time=0.304..0.304 rows=855 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
58. 0.145 0.145 ↑ 1.0 855 1

Seq Scan on fdc_ts_trademark c_7 (cost=0.00..21.55 rows=855 width=8) (actual time=0.013..0.145 rows=855 loops=1)

59. 0.002 9.510 ↑ 1.0 7 1

Hash (cost=2.63..2.63 rows=7 width=662) (actual time=9.510..9.510 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
60. 0.011 9.508 ↑ 1.0 7 1

Hash Left Join (cost=1.54..2.63 rows=7 width=662) (actual time=9.505..9.508 rows=7 loops=1)

  • Hash Cond: (c_6.id = t_5.ecolog_class_id)
61. 6.336 6.336 ↑ 1.0 7 1

Seq Scan on fdc_ecolog_class c_6 (cost=0.00..1.07 rows=7 width=146) (actual time=6.335..6.336 rows=7 loops=1)

62. 0.004 3.161 ↓ 7.0 7 1

Hash (cost=1.52..1.52 rows=1 width=524) (actual time=3.160..3.161 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
63. 3.157 3.157 ↓ 7.0 7 1

Seq Scan on fdc_ecolog_class_translation t_5 (cost=0.00..1.52 rows=1 width=524) (actual time=2.980..3.157 rows=7 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 28
64. 0.003 12.277 ↑ 1.0 9 1

Hash (cost=2.80..2.80 rows=9 width=662) (actual time=12.277..12.277 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
65. 0.009 12.274 ↑ 1.0 9 1

Hash Left Join (cost=1.69..2.80 rows=9 width=662) (actual time=12.272..12.274 rows=9 loops=1)

  • Hash Cond: (c_5.id = t_4.ts_cat_id)
66. 6.136 6.136 ↑ 1.0 9 1

Seq Scan on fdc_ts_cat c_5 (cost=0.00..1.09 rows=9 width=146) (actual time=6.136..6.136 rows=9 loops=1)

67. 0.004 6.129 ↓ 9.0 9 1

Hash (cost=1.67..1.67 rows=1 width=524) (actual time=6.129..6.129 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
68. 6.125 6.125 ↓ 9.0 9 1

Seq Scan on fdc_ts_cat_translation t_4 (cost=0.00..1.67 rows=1 width=524) (actual time=5.922..6.125 rows=9 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 36
69. 0.005 24.510 ↑ 1.0 5 1

Hash (cost=11.37..11.37 rows=5 width=72) (actual time=24.510..24.510 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
70. 0.070 24.505 ↑ 1.0 5 1

Nested Loop Left Join (cost=1.39..11.37 rows=5 width=72) (actual time=0.049..24.505 rows=5 loops=1)

71. 0.053 0.090 ↑ 1.0 5 1

Hash Join (cost=1.11..7.41 rows=5 width=12) (actual time=0.022..0.090 rows=5 loops=1)

  • Hash Cond: (c_8.id = sl.country_id)
72. 0.029 0.029 ↑ 1.0 236 1

Seq Scan on fdc_country c_8 (cost=0.00..5.36 rows=236 width=12) (actual time=0.009..0.029 rows=236 loops=1)

73. 0.002 0.008 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=8) (actual time=0.008..0.008 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
74. 0.006 0.006 ↑ 1.0 5 1

Seq Scan on fdc_server_list sl (cost=0.00..1.05 rows=5 width=8) (actual time=0.006..0.006 rows=5 loops=1)

75. 24.345 24.345 ↑ 1.0 1 5

Index Scan using fdc_country_translation_vl_i on fdc_country_translation t_7 (cost=0.28..0.79 rows=1 width=68) (actual time=4.869..4.869 rows=1 loops=5)

  • Index Cond: ((c_8.id = country_id) AND (language_id = lang.get_current_lang_id()))
76. 0.346 12.246 ↓ 1.3 2,961 1

Hash (cost=353.66..353.66 rows=2,300 width=151) (actual time=12.246..12.246 rows=2,961 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 180kB
77. 1.386 11.900 ↓ 1.3 2,961 1

Hash Join (cost=1.19..353.66 rows=2,300 width=151) (actual time=0.072..11.900 rows=2,961 loops=1)

  • Hash Cond: (pw.weight_type_id = wt.id)
78. 10.489 10.489 ↑ 1.0 12,648 1

Seq Scan on fdc_pts_weight pw (cost=0.00..306.48 rows=12,648 width=29) (actual time=0.009..10.489 rows=12,648 loops=1)

79. 0.002 0.025 ↑ 1.0 2 1

Hash (cost=1.17..1.17 rows=2 width=146) (actual time=0.025..0.025 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
80. 0.023 0.023 ↑ 1.0 2 1

Seq Scan on fdc_weight_type wt (cost=0.00..1.17 rows=2 width=146) (actual time=0.021..0.023 rows=2 loops=1)

  • Filter: (((code)::text = '12'::text) OR ((code)::text = '27'::text))
  • Rows Removed by Filter: 9
81. 5,794.134 17,382.402 ↓ 0.0 0 5,794,134

Aggregate (cost=8.46..8.47 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=5,794,134)

  • Filter: (string_agg((engine_1.part_number)::text, ', '::text ORDER BY (engine_1.part_number)::text) ~~ '%23423%'::text)
  • Rows Removed by Filter: 1
82. 11,588.268 11,588.268 ↓ 0.0 0 5,794,134

Index Scan using fdc_pts_part_number_psp_i on fdc_pts_part_number engine_1 (cost=0.42..8.45 rows=1 width=10) (actual time=0.002..0.002 rows=0 loops=5,794,134)

  • Index Cond: (pasport_id = pv.id)
  • Filter: (equipment_type_id = nsi.get_equipment_type_id('ENGINE_NUMBER'::character varying))
83. 0.028 8.008 ↑ 1.0 1 7

Aggregate (cost=11.29..11.30 rows=1 width=32) (actual time=1.144..1.144 rows=1 loops=7)

84. 0.007 7.980 ↓ 0.0 0 7

Nested Loop Left Join (cost=0.28..11.28 rows=1 width=516) (actual time=1.140..1.140 rows=0 loops=7)

  • Join Filter: (c_9.id = t_8.color_id)
85. 0.007 7.973 ↓ 0.0 0 7

Nested Loop (cost=0.28..9.52 rows=1 width=8) (actual time=1.139..1.139 rows=0 loops=7)

  • Join Filter: (pc.color_id = c_9.id)
86. 7.966 7.966 ↓ 0.0 0 7

Index Scan using fdc_pts_colors_psp_i on fdc_pts_color pc (cost=0.28..8.30 rows=1 width=8) (actual time=1.138..1.138 rows=0 loops=7)

  • Index Cond: (pasport_id = pv.id)
87. 0.000 0.000 ↓ 0.0 0

Seq Scan on fdc_color c_9 (cost=0.00..1.10 rows=10 width=8) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Seq Scan on fdc_color_translation t_8 (cost=0.00..1.75 rows=1 width=524) (never executed)

  • Filter: (language_id = lang.get_current_lang_id())
89. 0.008 0.210 ↑ 1.0 1 7

Materialize (cost=0.00..0.03 rows=1 width=8) (actual time=0.029..0.030 rows=1 loops=7)

90. 0.202 0.202 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=0.202..0.202 rows=1 loops=1)

91. 0.154 63.574 ↑ 1.0 1 7

Aggregate (cost=18.05..18.06 rows=1 width=208) (actual time=9.082..9.082 rows=1 loops=7)

92. 0.031 63.420 ↑ 1.0 1 7

Nested Loop Left Join (cost=8.86..18.02 rows=1 width=727) (actual time=9.041..9.060 rows=1 loops=7)

  • Join Filter: (c_11.id = t_10.payment_execution_id)
93. 0.030 63.329 ↑ 1.0 1 7

Nested Loop Left Join (cost=8.86..16.78 rows=1 width=211) (actual time=9.028..9.047 rows=1 loops=7)

  • Join Filter: (c_11.id = rdv.payment_execution_id)
94. 0.020 63.287 ↑ 1.0 1 7

Nested Loop Left Join (cost=8.86..15.71 rows=1 width=73) (actual time=9.023..9.041 rows=1 loops=7)

95. 0.330 63.231 ↑ 1.0 1 7

Nested Loop Left Join (cost=8.73..15.50 rows=1 width=81) (actual time=9.015..9.033 rows=1 loops=7)

96. 0.188 62.853 ↑ 1.0 1 7

Hash Right Join (cost=8.45..14.70 rows=1 width=41) (actual time=8.962..8.979 rows=1 loops=7)

  • Hash Cond: (c_10.id = rdv.country_id)
97. 0.120 0.120 ↑ 1.0 236 6

Seq Scan on fdc_country c_10 (cost=0.00..5.36 rows=236 width=8) (actual time=0.005..0.020 rows=236 loops=6)

98. 0.035 62.545 ↑ 1.0 1 7

Hash (cost=8.44..8.44 rows=1 width=33) (actual time=8.935..8.935 rows=1 loops=7)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
99. 62.510 62.510 ↑ 1.0 1 7

Index Scan using fdc_pts_recycling_duty_date_uk on fdc_pts_recycling_duty rdv (cost=0.41..8.44 rows=1 width=33) (actual time=8.930..8.930 rows=1 loops=7)

  • Index Cond: (pasport_root_id = pv.root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
100. 0.048 0.048 ↑ 1.0 1 6

Index Scan using fdc_country_translation_vl_i on fdc_country_translation t_9 (cost=0.28..0.79 rows=1 width=48) (actual time=0.008..0.008 rows=1 loops=6)

  • Index Cond: ((c_10.id = country_id) AND (language_id = lang.get_current_lang_id()))
101. 0.036 0.036 ↑ 1.0 1 6

Index Only Scan using fdc_server_list_country_i on fdc_server_list sl_1 (cost=0.13..0.20 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=6)

  • Index Cond: (country_id = c_10.id)
  • Heap Fetches: 6
102. 0.012 0.012 ↑ 3.0 1 6

Seq Scan on fdc_payment_execution c_11 (cost=0.00..1.03 rows=3 width=146) (actual time=0.002..0.002 rows=1 loops=6)

103. 0.060 0.060 ↑ 1.0 1 6

Seq Scan on fdc_payment_execution_translation t_10 (cost=0.00..1.23 rows=1 width=524) (actual time=0.010..0.010 rows=1 loops=6)

  • Filter: (language_id = lang.get_current_lang_id())
104. 0.007 0.042 ↓ 0.0 0 7

Limit (cost=0.28..8.30 rows=1 width=136) (actual time=0.006..0.006 rows=0 loops=7)

105. 0.035 0.035 ↓ 0.0 0 7

Index Scan using fdc_pts_owner_root_i on fdc_pts_owner own_1 (cost=0.28..8.30 rows=1 width=136) (actual time=0.005..0.005 rows=0 loops=7)

  • Index Cond: (pasport_root_id = pv.root_id)
  • Filter: is_actual
106. 0.607 16.450 ↑ 1.0 6,367 1

Hash (cost=117.67..117.67 rows=6,367 width=16) (actual time=16.450..16.450 rows=6,367 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 363kB
107. 15.843 15.843 ↑ 1.0 6,367 1

Seq Scan on fdc_person manufacturer_per (cost=0.00..117.67 rows=6,367 width=16) (actual time=7.385..15.843 rows=6,367 loops=1)

108. 0.007 6.566 ↓ 0.0 0 7

Limit (cost=8.31..8.31 rows=1 width=108) (actual time=0.938..0.938 rows=0 loops=7)

109. 0.028 6.559 ↓ 0.0 0 7

Sort (cost=8.31..8.31 rows=1 width=108) (actual time=0.937..0.937 rows=0 loops=7)

  • Sort Key: engine_1_1.engine_kind_id
  • Sort Method: quicksort Memory: 25kB
110. 6.531 6.531 ↓ 0.0 0 7

Index Scan using fdc_pts_engine_psp_i on fdc_pts_engine engine_1_1 (cost=0.28..8.30 rows=1 width=108) (actual time=0.933..0.933 rows=0 loops=7)

  • Index Cond: (pasport_id = pv.id)
Planning time : 280.577 ms
Execution time : 53,399.131 ms