explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q3J1

Settings
# exclusive inclusive rows x rows loops node
1. 14.375 35,892.972 ↓ 1.3 12,562 1

Unique (cost=1,986,203.59..1,986,872.45 rows=9,909 width=732) (actual time=35,874.163..35,892.972 rows=12,562 loops=1)

2. 46.005 35,878.597 ↓ 1.3 12,562 1

Sort (cost=1,986,203.59..1,986,228.37 rows=9,909 width=732) (actual time=35,874.159..35,878.597 rows=12,562 loops=1)

  • Sort Key: ('-1'::integer), ('-1'::integer), ('U'::text), tblveuanveicoli001.idveicolo, (CASE WHEN (tblveuanveicoli001.flcommerciale = 0) THEN 'Usato'::character varying ELSE tblveucatveicoli001.descrizione END), tblveuanveicoli001.desmarca, tblveuanveicoli001.desmodello, tblveuanveicoli001.desversione, tblveuanveicoli001.tarattuale, tblveuanveicoli001.telaio, tblveualimentazione001.descrizione, tblveucambio001.descrizione, (btrim(to_char((tblveuanveicoli001.cilindrata)::double precision, '99999'::text))), (round(tblveucommerciali001.prvendita, 2)), ('-1'::integer), (round(((tblveuanveicoli001.kilowatt)::numeric * 1.359), 0)), (date_part('month'::text, tblveuanveicoli001.datprimmatricolazione)), (date_part('year'::text, tblveuanveicoli001.datprimmatricolazione)), (COALESCE(tblveuanveicoli001.kmeffettivi, tblveuanveicoli001.km)), (btrim((tblveucolesterno001.descrizione)::text)), (array_to_string($2, '|'::text)), (array_to_string($7, '|'::text)), ('true'::text), tblveuversioni001.codaltidentificazione, tblveuanveicoli001.idversione, tblveuanveicoli001.idsede
  • Sort Method: quicksort Memory: 16,329kB
3. 8.533 35,832.592 ↓ 1.3 12,562 1

Append (cost=13,057.27..1,985,545.91 rows=9,909 width=732) (actual time=156.374..35,832.592 rows=12,562 loops=1)

4. 15.346 616.676 ↓ 1.0 4,546 1

Hash Left Join (cost=13,057.27..635,061.26 rows=4,501 width=484) (actual time=156.372..616.676 rows=4,546 loops=1)

  • Hash Cond: (tblveuanveicoli001.idcambio = tblveucambio001.idcambio)
5. 7.969 601.306 ↓ 1.0 4,546 1

Nested Loop Left Join (cost=13,055.80..634,910.57 rows=4,501 width=269) (actual time=156.321..601.306 rows=4,546 loops=1)

6. 1.892 556.969 ↓ 1.0 4,546 1

Nested Loop Left Join (cost=13,015.84..454,899.53 rows=4,501 width=241) (actual time=156.301..556.969 rows=4,546 loops=1)

7. 0.000 164.121 ↓ 1.0 4,546 1

Gather (cost=12,920.31..24,790.14 rows=4,501 width=209) (actual time=156.054..164.121 rows=4,546 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 1.180 165.264 ↑ 1.2 1,515 3 / 3

Hash Left Join (cost=11,920.31..23,340.04 rows=1,875 width=209) (actual time=151.704..165.264 rows=1,515 loops=3)

  • Hash Cond: (tblveuanveicoli001.flcommerciale = tblveucatveicoli001.codice)
9. 2.827 164.067 ↑ 1.2 1,515 3 / 3

Parallel Hash Left Join (cost=11,919.16..23,330.98 rows=1,875 width=200) (actual time=151.642..164.067 rows=1,515 loops=3)

  • Hash Cond: ((tblveuanveicoli001.idazienda = tblveucommerciali001.idazienda) AND (tblveuanveicoli001.idveicolo = tblveucommerciali001.idveicolo))
10. 1.172 67.541 ↑ 1.2 1,515 3 / 3

Hash Left Join (cost=4,941.13..16,343.11 rows=1,875 width=194) (actual time=57.297..67.541 rows=1,515 loops=3)

  • Hash Cond: (tblveuanveicoli001.idcolesterno = tblveucolesterno001.idcolesterno)
11. 1.124 66.308 ↑ 1.2 1,515 3 / 3

Hash Left Join (cost=4,938.80..16,335.56 rows=1,875 width=180) (actual time=57.218..66.308 rows=1,515 loops=3)

  • Hash Cond: (tblveuanveicoli001.idalimentazione = tblveualimentazione001.idalimentazione)
12. 2.757 65.154 ↑ 1.2 1,515 3 / 3

Parallel Hash Left Join (cost=4,937.49..16,327.83 rows=1,875 width=163) (actual time=57.168..65.154 rows=1,515 loops=3)

  • Hash Cond: ((tblveuanveicoli001.idmarca = tblveuversioni001.idmarca) AND (tblveuanveicoli001.idmodello = tblveuversioni001.idmodello) AND ((tblveuanveicoli001.idversione)::bpchar = tblveuversioni001.idversione))
13. 6.419 6.632 ↑ 1.2 1,515 3 / 3

Parallel Bitmap Heap Scan on tblveuanveicoli001 (cost=118.79..11,494.37 rows=1,875 width=169) (actual time=0.920..6.632 rows=1,515 loops=3)

  • Recheck Cond: ((idstato = 'STO'::bpchar) AND (idazienda = 1))
  • Filter: (COALESCE(flprenotatovendita, 'N'::bpchar) <> 'S'::bpchar)
  • Heap Blocks: exact=2
14. 0.213 0.213 ↓ 1.0 4,560 1 / 3

Bitmap Index Scan on tblveuanveicoli00113 (cost=0.00..117.66 rows=4,524 width=0) (actual time=0.638..0.638 rows=4,560 loops=1)

  • Index Cond: ((idstato = 'STO'::bpchar) AND (idazienda = 1))
15. 29.324 55.765 ↑ 1.3 47,720 3 / 3

Parallel Hash (cost=3,774.62..3,774.62 rows=59,662 width=39) (actual time=55.764..55.765 rows=47,720 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 11,744kB
16. 26.441 26.441 ↑ 1.3 47,720 3 / 3

Parallel Seq Scan on tblveuversioni001 (cost=0.00..3,774.62 rows=59,662 width=39) (actual time=0.013..26.441 rows=47,720 loops=3)

17. 0.009 0.030 ↑ 1.0 14 3 / 3

Hash (cost=1.14..1.14 rows=14 width=25) (actual time=0.030..0.030 rows=14 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
18. 0.021 0.021 ↑ 1.0 14 3 / 3

Seq Scan on tblveualimentazione001 (cost=0.00..1.14 rows=14 width=25) (actual time=0.015..0.021 rows=14 loops=3)

19. 0.030 0.061 ↑ 1.0 59 3 / 3

Hash (cost=1.59..1.59 rows=59 width=28) (actual time=0.061..0.061 rows=59 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
20. 0.031 0.031 ↑ 1.0 59 3 / 3

Seq Scan on tblveucolesterno001 (cost=0.00..1.59 rows=59 width=28) (actual time=0.011..0.031 rows=59 loops=3)

21. 48.849 93.699 ↑ 1.2 85,868 3 / 3

Parallel Hash (cost=5,368.38..5,368.38 rows=107,310 width=16) (actual time=93.698..93.699 rows=85,868 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 14,592kB
22. 44.850 44.850 ↑ 1.2 85,868 3 / 3

Parallel Seq Scan on tblveucommerciali001 (cost=0.00..5,368.38 rows=107,310 width=16) (actual time=0.018..44.850 rows=85,868 loops=3)

  • Filter: (idazienda = 1)
23. 0.006 0.017 ↑ 1.0 7 3 / 3

Hash (cost=1.07..1.07 rows=7 width=13) (actual time=0.016..0.017 rows=7 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
24. 0.011 0.011 ↑ 1.0 7 3 / 3

Seq Scan on tblveucatveicoli001 (cost=0.00..1.07 rows=7 width=13) (actual time=0.008..0.011 rows=7 loops=3)

25. 13.638 390.956 ↑ 1.0 1 4,546

Result (cost=95.53..95.54 rows=1 width=32) (actual time=0.086..0.086 rows=1 loops=4,546)

26.          

Initplan (for Result)

27. 13.638 377.318 ↑ 6.5 2 4,546

Sort (cost=95.49..95.53 rows=13 width=43) (actual time=0.082..0.083 rows=2 loops=4,546)

  • Sort Key: tblveuopricerca001.codopricerca
  • Sort Method: quicksort Memory: 25kB
28. 134.161 363.680 ↑ 6.5 2 4,546

Hash Right Join (cost=36.79..95.25 rows=13 width=43) (actual time=0.036..0.080 rows=2 loops=4,546)

  • Hash Cond: ((tblveuopricerca001.idazienda = tblveuopveicolo001.idazienda) AND (tblveuopricerca001.codopricerca = tblveuopveicolo001.codopricerca))
29. 174.530 188.605 ↑ 1.0 107 2,815

Bitmap Heap Scan on tblveuopricerca001 (cost=5.11..62.92 rows=107 width=116) (actual time=0.007..0.067 rows=107 loops=2,815)

  • Recheck Cond: (idazienda = $0)
  • Heap Blocks: exact=123,860
30. 14.075 14.075 ↑ 1.0 107 2,815

Bitmap Index Scan on pk_tblveuopricerca001 (cost=0.00..5.08 rows=107 width=0) (actual time=0.005..0.005 rows=107 loops=2,815)

  • Index Cond: (idazienda = $0)
31. 9.092 40.914 ↑ 6.5 2 4,546

Hash (cost=31.49..31.49 rows=13 width=15) (actual time=0.009..0.009 rows=2 loops=4,546)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
32. 31.822 31.822 ↑ 6.5 2 4,546

Index Scan using pk_tblveuopveicolo001 on tblveuopveicolo001 (cost=0.43..31.49 rows=13 width=15) (actual time=0.006..0.007 rows=2 loops=4,546)

  • Index Cond: ((idazienda = $0) AND (idveicolo = $1))
  • Filter: (stato = 'S'::bpchar)
  • Rows Removed by Filter: 0
33. 4.546 36.368 ↑ 1.0 1 4,546

Result (cost=39.96..39.97 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=4,546)

34.          

Initplan (for Result)

35. 9.092 31.822 ↓ 0.0 0 4,546

Sort (cost=39.96..39.96 rows=1 width=43) (actual time=0.007..0.007 rows=0 loops=4,546)

  • Sort Key: tblveuopricerca001_1.codopricerca
  • Sort Method: quicksort Memory: 25kB
36. 5.435 22.730 ↓ 0.0 0 4,546

Nested Loop Left Join (cost=0.71..39.95 rows=1 width=43) (actual time=0.004..0.005 rows=0 loops=4,546)

37. 13.638 13.638 ↓ 0.0 0 4,546

Index Scan using pk_tblveuopveicolo001 on tblveuopveicolo001 tblveuopveicolo001_1 (cost=0.43..31.49 rows=1 width=15) (actual time=0.003..0.003 rows=0 loops=4,546)

  • Index Cond: ((idazienda = $3) AND (idveicolo = $4))
  • Filter: (stato = 'O'::bpchar)
  • Rows Removed by Filter: 2
38. 3.657 3.657 ↑ 1.0 1 1,219

Index Scan using pk_tblveuopricerca001 on tblveuopricerca001 tblveuopricerca001_1 (cost=0.28..8.30 rows=1 width=116) (actual time=0.003..0.003 rows=1 loops=1,219)

  • Index Cond: ((idazienda = tblveuopveicolo001_1.idazienda) AND (idazienda = $3) AND (codopricerca = tblveuopveicolo001_1.codopricerca))
39. 0.011 0.024 ↑ 1.0 21 1

Hash (cost=1.21..1.21 rows=21 width=25) (actual time=0.024..0.024 rows=21 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
40. 0.013 0.013 ↑ 1.0 21 1

Seq Scan on tblveucambio001 (cost=0.00..1.21 rows=21 width=25) (actual time=0.004..0.013 rows=21 loops=1)

41. 17.318 35,207.383 ↓ 1.5 8,016 1

Subquery Scan on *SELECT* 2 (cost=43,889.64..1,350,390.09 rows=5,408 width=581) (actual time=266.246..35,207.383 rows=8,016 loops=1)

42. 39.667 35,190.065 ↓ 1.5 8,016 1

Hash Left Join (cost=43,889.64..1,350,268.41 rows=5,408 width=570) (actual time=266.239..35,190.065 rows=8,016 loops=1)

  • Hash Cond: (tblaunmotorizzazioni001.idalimentazione = tblveualimentazione001_1.idalimentazione)
43. 17.412 35,150.378 ↓ 1.5 8,016 1

Nested Loop Left Join (cost=43,888.33..1,350,061.08 rows=5,408 width=580) (actual time=266.200..35,150.378 rows=8,016 loops=1)

44. 11.316 35,068.838 ↓ 1.5 8,016 1

Nested Loop Left Join (cost=43,888.04..1,348,253.05 rows=5,408 width=579) (actual time=266.171..35,068.838 rows=8,016 loops=1)

45. 12.406 1,238.018 ↓ 1.5 8,016 1

Nested Loop Left Join (cost=43,781.15..770,016.17 rows=5,408 width=632) (actual time=263.167..1,238.018 rows=8,016 loops=1)

46. 21.598 945.052 ↓ 1.5 8,016 1

Nested Loop Left Join (cost=43,675.43..198,133.69 rows=5,408 width=600) (actual time=263.127..945.052 rows=8,016 loops=1)

47. 8.742 795.198 ↓ 1.5 8,016 1

Hash Left Join (cost=43,674.88..153,389.22 rows=5,408 width=366) (actual time=263.089..795.198 rows=8,016 loops=1)

  • Hash Cond: (tblvenordine001.idtipveicolo = tblventipveicolo001.idtipveicolo)
48. 10.506 786.442 ↓ 1.5 8,016 1

Nested Loop Left Join (cost=43,673.72..153,365.27 rows=5,408 width=335) (actual time=263.062..786.442 rows=8,016 loops=1)

49. 21.012 687.760 ↓ 1.5 8,016 1

Hash Left Join (cost=43,673.30..149,795.33 rows=5,408 width=335) (actual time=263.031..687.760 rows=8,016 loops=1)

  • Hash Cond: ((tblvenordine001.idmarca = tblaunversioni001.idmarca) AND (tblvenordine001.idlinea = tblaunversioni001.idlinea) AND (tblvenordine001.modelyear = tblaunversioni001.modelyear) AND (tblvenordine001.idmodello = tblaunversioni001.idmodello) AND (tblvenordine001.idversione = tblaunversioni001.versione))
50. 12.396 608.660 ↓ 1.5 8,016 1

Hash Left Join (cost=39,847.07..145,898.12 rows=5,408 width=259) (actual time=204.884..608.660 rows=8,016 loops=1)

  • Hash Cond: ((tblvenordine001.idmarca = tblaunlinea001.idmarca) AND (tblvenordine001.idlinea = tblaunlinea001.idlinea) AND (tblvenordine001.modelyear = tblaunlinea001.modelyear))
51. 8.807 595.485 ↓ 1.5 8,016 1

Hash Left Join (cost=39,798.28..145,806.75 rows=5,408 width=208) (actual time=204.094..595.485 rows=8,016 loops=1)

  • Hash Cond: (tblvenordine001.idmarca = tbldfnmrc001.idmarchio)
52. 204.561 586.611 ↓ 1.5 8,016 1

Hash Right Join (cost=39,789.52..145,782.02 rows=5,408 width=163) (actual time=204.014..586.611 rows=8,016 loops=1)

  • Hash Cond: ((tblcrmofferte001.idazstock = tblvenordine001.idazienda) AND (tblcrmofferte001.idstock = tblvenordine001.idordine))
  • Filter: ((tblvenordine001.idsogprenotante IS NULL) OR (tblvenordine001.idsogprenotante = 0) OR (tblcrmofferte001.idstato IS NULL) OR (btrim((tblcrmofferte001.idstato)::text) = ''::text))
  • Rows Removed by Filter: 2,699
53. 190.658 208.541 ↑ 1.0 177,882 1

Bitmap Heap Scan on tblcrmofferte001 (cost=3,534.86..108,057.00 rows=179,411 width=12) (actual time=28.148..208.541 rows=177,882 loops=1)

  • Recheck Cond: (idazstock = 1)
  • Heap Blocks: exact=74,861
54. 17.883 17.883 ↑ 1.0 177,937 1

Bitmap Index Scan on tblcrmofferte00112 (cost=0.00..3,490.01 rows=179,411 width=0) (actual time=17.883..17.883 rows=177,937 loops=1)

  • Index Cond: (idazstock = 1)
55. 6.956 173.509 ↓ 1.3 10,715 1

Hash (cost=36,128.82..36,128.82 rows=8,389 width=167) (actual time=173.509..173.509 rows=10,715 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 2,119kB
56. 64.650 166.553 ↓ 1.3 10,715 1

Hash Right Join (cost=31,211.93..36,128.82 rows=8,389 width=167) (actual time=39.815..166.553 rows=10,715 loops=1)

  • Hash Cond: ((tblvenspedizione001.idazienda = tblvenordine001.idazienda) AND (tblvenspedizione001.idordine = tblvenordine001.idordine))
57. 62.142 62.142 ↓ 1.0 140,284 1

Seq Scan on tblvenspedizione001 (cost=0.00..4,180.44 rows=140,275 width=28) (actual time=0.010..62.142 rows=140,284 loops=1)

  • Filter: (idazienda = 1)
58. 7.077 39.761 ↓ 1.3 10,715 1

Hash (cost=31,086.09..31,086.09 rows=8,389 width=174) (actual time=39.761..39.761 rows=10,715 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 2,269kB
59. 28.541 32.684 ↓ 1.3 10,715 1

Bitmap Heap Scan on tblvenordine001 (cost=4,660.87..31,086.09 rows=8,389 width=174) (actual time=5.272..32.684 rows=10,715 loops=1)

  • Recheck Cond: (datconsacquirente IS NULL)
  • Filter: (((flblocco = 0) OR (flblocco IS NULL)) AND ((flstato = 0) OR (flstato IS NULL)) AND (idazienda = 1))
  • Rows Removed by Filter: 370
  • Heap Blocks: exact=10,886
60. 4.143 4.143 ↓ 1.3 14,049 1

Bitmap Index Scan on tblvenordine00110 (cost=0.00..4,658.77 rows=11,078 width=0) (actual time=4.142..4.143 rows=14,049 loops=1)

  • Index Cond: (datconsacquirente IS NULL)
61. 0.018 0.067 ↑ 1.0 34 1

Hash (cost=8.34..8.34 rows=34 width=49) (actual time=0.067..0.067 rows=34 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
62. 0.049 0.049 ↑ 1.0 34 1

Seq Scan on tbldfnmrc001 (cost=0.00..8.34 rows=34 width=49) (actual time=0.008..0.049 rows=34 loops=1)

63. 0.399 0.779 ↑ 1.0 865 1

Hash (cost=33.65..33.65 rows=865 width=85) (actual time=0.779..0.779 rows=865 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 108kB
64. 0.380 0.380 ↑ 1.0 865 1

Seq Scan on tblaunlinea001 (cost=0.00..33.65 rows=865 width=85) (actual time=0.005..0.380 rows=865 loops=1)

65. 31.587 58.088 ↑ 1.0 53,607 1

Hash (cost=2,620.07..2,620.07 rows=53,607 width=153) (actual time=58.088..58.088 rows=53,607 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 10,250kB
66. 26.501 26.501 ↑ 1.0 53,607 1

Seq Scan on tblaunversioni001 (cost=0.00..2,620.07 rows=53,607 width=153) (actual time=0.004..26.501 rows=53,607 loops=1)

67. 16.032 88.176 ↑ 1.0 1 8,016

Limit (cost=0.42..0.64 rows=1 width=22) (actual time=0.010..0.011 rows=1 loops=8,016)

68. 72.144 72.144 ↑ 41.0 1 8,016

Index Only Scan using tblvenpravanzamento0011 on tblvenpravanzamento001 (cost=0.42..9.25 rows=41 width=22) (actual time=0.009..0.009 rows=1 loops=8,016)

  • Index Cond: ((idazienda = tblvenordine001.idazienda) AND (idordine = tblvenordine001.idordine))
  • Heap Fetches: 360
69. 0.004 0.014 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=33) (actual time=0.014..0.014 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
70. 0.010 0.010 ↑ 1.0 7 1

Seq Scan on tblventipveicolo001 (cost=0.00..1.07 rows=7 width=33) (actual time=0.006..0.010 rows=7 loops=1)

71. 128.256 128.256 ↑ 1.0 1 8,016

Index Scan using pk_tblaunoptionals001 on tblaunoptionals001 tbloptesterno (cost=0.56..8.27 rows=1 width=365) (actual time=0.016..0.016 rows=1 loops=8,016)

  • Index Cond: ((tblvenordine001.idmarca = idmarca) AND (tblvenordine001.idlinea = idlinea) AND (tblvenordine001.modelyear = modelyear) AND (tblvenordine001.idmodello = idmodello) AND (tblvenordine001.idversione = idversione) AND (tblvenordine001.idtipopcolesterno = tipoptional) AND (tblvenordine001.idopcolesterno = codoptional))
72. 24.048 280.560 ↑ 1.0 1 8,016

Aggregate (cost=105.72..105.73 rows=1 width=32) (actual time=0.034..0.035 rows=1 loops=8,016)

73. 28.708 256.512 ↑ 2.0 1 8,016

Nested Loop Left Join (cost=0.99..105.70 rows=2 width=259) (actual time=0.026..0.032 rows=1 loops=8,016)

  • Join Filter: ((tblaunoptionals001.tipoptional = tblvenopordine001.idtipoptional) AND (tblaunoptionals001.codoptional = tblvenopordine001.codoptional))
  • Rows Removed by Join Filter: 8
74. 192.384 192.384 ↑ 2.0 1 8,016

Index Scan using pk_tblvenopordine001 on tblvenopordine001 (cost=0.43..97.08 rows=2 width=25) (actual time=0.023..0.024 rows=1 loops=8,016)

  • Index Cond: ((idazienda = tblvenordine001.idazienda) AND (idordine = tblvenordine001.idordine))
  • Filter: (idtipoptional = 'S'::bpchar)
  • Rows Removed by Filter: 33
75. 23.707 35.420 ↓ 13.0 13 5,060

Materialize (cost=0.56..8.59 rows=1 width=284) (actual time=0.001..0.007 rows=13 loops=5,060)

76. 11.713 11.713 ↓ 23.0 23 221

Index Scan using pk_tblaunoptionals001 on tblaunoptionals001 (cost=0.56..8.58 rows=1 width=284) (actual time=0.016..0.053 rows=23 loops=221)

  • Index Cond: ((idmarca = tblvenordine001.idmarca) AND (idlinea = tblvenordine001.idlinea) AND (modelyear = tblvenordine001.modelyear) AND (idmodello = tblvenordine001.idmodello) AND (idversione = tblvenordine001.idversione) AND (tipoptional = 'S'::bpchar))
77. 496.992 33,819.504 ↑ 1.0 1 8,016

Aggregate (cost=106.89..106.90 rows=1 width=32) (actual time=4.218..4.219 rows=1 loops=8,016)

78. 16,871.981 33,322.512 ↑ 1.5 33 8,016

Nested Loop Left Join (cost=0.99..106.52 rows=49 width=259) (actual time=0.334..4.157 rows=33 loops=8,016)

  • Join Filter: ((tblaunoptionals001_1.tipoptional = tblvenopordine001_1.idtipoptional) AND (tblaunoptionals001_1.codoptional = tblvenopordine001_1.codoptional))
  • Rows Removed by Join Filter: 5,850
79. 192.384 192.384 ↑ 1.5 33 8,016

Index Scan using pk_tblvenopordine001 on tblvenopordine001 tblvenopordine001_1 (cost=0.43..97.08 rows=49 width=25) (actual time=0.004..0.024 rows=33 loops=8,016)

  • Index Cond: ((idazienda = tblvenordine001.idazienda) AND (idordine = tblvenordine001.idordine))
  • Filter: (idtipoptional = 'O'::bpchar)
  • Rows Removed by Filter: 1
80. 13,926.069 16,258.147 ↓ 177.0 177 266,527

Materialize (cost=0.56..8.59 rows=1 width=284) (actual time=0.001..0.061 rows=177 loops=266,527)

81. 2,332.078 2,332.078 ↓ 205.0 205 7,427

Index Scan using pk_tblaunoptionals001 on tblaunoptionals001 tblaunoptionals001_1 (cost=0.56..8.58 rows=1 width=284) (actual time=0.015..0.314 rows=205 loops=7,427)

  • Index Cond: ((idmarca = tblvenordine001.idmarca) AND (idlinea = tblvenordine001.idlinea) AND (modelyear = tblvenordine001.modelyear) AND (idmodello = tblvenordine001.idmodello) AND (idversione = tblvenordine001.idversione) AND (tipoptional = 'O'::bpchar))
82. 64.128 64.128 ↑ 1.0 1 8,016

Index Scan using pk_tblaunmotorizzazioni001 on tblaunmotorizzazioni001 (cost=0.29..0.33 rows=1 width=51) (actual time=0.008..0.008 rows=1 loops=8,016)

  • Index Cond: ((idmarca = tblaunversioni001.idmarca) AND (idmotorizzazione = tblaunversioni001.idmotorizzazione))
83. 0.008 0.020 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=25) (actual time=0.020..0.020 rows=14 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
84. 0.012 0.012 ↑ 1.0 14 1

Seq Scan on tblveualimentazione001 tblveualimentazione001_1 (cost=0.00..1.14 rows=14 width=25) (actual time=0.006..0.012 rows=14 loops=1)

Planning time : 15.213 ms
Execution time : 35,902.270 ms