explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7GfA

Settings
# exclusive inclusive rows x rows loops node
1. 14.571 97,396.974 ↑ 18.0 12,560 1

Unique (cost=48,669,719.21..48,684,989.67 rows=226,229 width=732) (actual time=97,377.822..97,396.974 rows=12,560 loops=1)

2. 54.828 97,382.403 ↑ 18.0 12,560 1

Sort (cost=48,669,719.21..48,670,284.78 rows=226,229 width=732) (actual time=97,377.817..97,382.403 rows=12,560 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((SubPlan 1), '|'::text)), (array_to_string((SubPlan 2), '|'::text)), ('true'::text), tblveuversioni001.codaltidentificazione, tblveuanveicoli001.idversione, tblveuanveicoli001.idsede
  • Sort Method: quicksort Memory: 16,322kB
3. 4.066 97,327.575 ↑ 18.0 12,560 1

Append (cost=12,920.27..48,576,137.55 rows=226,229 width=732) (actual time=167.912..97,327.575 rows=12,560 loops=1)

4. 24.752 579.962 ↓ 1.0 4,544 1

Gather (cost=12,920.27..615,011.34 rows=4,501 width=484) (actual time=167.911..579.962 rows=4,544 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 1.166 178.058 ↑ 1.2 1,515 3 / 3

Hash Left Join (cost=11,920.27..23,345.91 rows=1,875 width=226) (actual time=163.183..178.058 rows=1,515 loops=3)

  • Hash Cond: (tblveuanveicoli001.idcambio = tblveucambio001.idcambio)
6. 1.121 176.860 ↑ 1.2 1,515 3 / 3

Hash Left Join (cost=11,918.79..23,338.52 rows=1,875 width=209) (actual time=163.136..176.860 rows=1,515 loops=3)

  • Hash Cond: (tblveuanveicoli001.flcommerciale = tblveucatveicoli001.codice)
7. 3.281 175.720 ↑ 1.2 1,515 3 / 3

Parallel Hash Left Join (cost=11,917.64..23,329.46 rows=1,875 width=200) (actual time=163.069..175.720 rows=1,515 loops=3)

  • Hash Cond: ((tblveuanveicoli001.idazienda = tblveucommerciali001.idazienda) AND (tblveuanveicoli001.idveicolo = tblveucommerciali001.idveicolo))
8. 1.163 71.865 ↑ 1.2 1,515 3 / 3

Hash Left Join (cost=4,939.61..16,341.59 rows=1,875 width=194) (actual time=61.650..71.865 rows=1,515 loops=3)

  • Hash Cond: (tblveuanveicoli001.idcolesterno = tblveucolesterno001.idcolesterno)
9. 1.114 70.639 ↑ 1.2 1,515 3 / 3

Hash Left Join (cost=4,937.28..16,334.04 rows=1,875 width=180) (actual time=61.572..70.639 rows=1,515 loops=3)

  • Hash Cond: (tblveuanveicoli001.idalimentazione = tblveualimentazione001.idalimentazione)
10. 2.953 69.492 ↑ 1.2 1,515 3 / 3

Parallel Hash Left Join (cost=4,935.97..16,326.31 rows=1,875 width=163) (actual time=61.521..69.492 rows=1,515 loops=3)

  • Hash Cond: ((tblveuanveicoli001.idmarca = tblveuversioni001.idmarca) AND (tblveuanveicoli001.idmodello = tblveuversioni001.idmodello) AND ((tblveuanveicoli001.idversione)::bpchar = tblveuversioni001.idversione))
11. 6.350 6.581 ↑ 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.995..6.581 rows=1,515 loops=3)

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

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

  • Index Cond: ((idstato = 'STO'::bpchar) AND (idazienda = 1))
13. 32.315 59.958 ↑ 1.2 47,718 3 / 3

Parallel Hash (cost=3,773.43..3,773.43 rows=59,643 width=39) (actual time=59.958..59.958 rows=47,718 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 11,712kB
14. 27.643 27.643 ↑ 1.2 47,718 3 / 3

Parallel Seq Scan on tblveuversioni001 (cost=0.00..3,773.43 rows=59,643 width=39) (actual time=0.014..27.643 rows=47,718 loops=3)

15. 0.012 0.033 ↑ 1.0 14 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
16. 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)

17. 0.031 0.063 ↑ 1.0 59 3 / 3

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

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

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

19. 52.416 100.574 ↑ 1.2 85,860 3 / 3

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

  • Buckets: 262,144 Batches: 1 Memory Usage: 14,592kB
20. 48.158 48.158 ↑ 1.2 85,860 3 / 3

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

  • Filter: (idazienda = 1)
21. 0.007 0.019 ↑ 1.0 7 3 / 3

Hash (cost=1.07..1.07 rows=7 width=13) (actual time=0.018..0.019 rows=7 loops=3)

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

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

23. 0.012 0.032 ↑ 1.0 21 3 / 3

Hash (cost=1.21..1.21 rows=21 width=25) (actual time=0.032..0.032 rows=21 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
24. 0.020 0.020 ↑ 1.0 21 3 / 3

Seq Scan on tblveucambio001 (cost=0.00..1.21 rows=21 width=25) (actual time=0.011..0.020 rows=21 loops=3)

25.          

SubPlan (for Gather)

26. 18.176 349.888 ↑ 6.5 2 4,544

Sort (cost=95.18..95.21 rows=13 width=43) (actual time=0.076..0.077 rows=2 loops=4,544)

  • Sort Key: tblveuopricerca001.codopricerca
  • Sort Method: quicksort Memory: 25kB
27. 124.731 331.712 ↑ 6.5 2 4,544

Hash Right Join (cost=36.76..94.94 rows=13 width=43) (actual time=0.033..0.073 rows=2 loops=4,544)

  • Hash Cond: (tblveuopricerca001.codopricerca = tblveuopveicolo001.codopricerca)
28. 154.825 166.085 ↑ 1.0 107 2,815

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

  • Recheck Cond: (idazienda = 1)
  • Heap Blocks: exact=123,860
29. 11.260 11.260 ↑ 1.0 107 2,815

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

  • Index Cond: (idazienda = 1)
30. 9.088 40.896 ↑ 6.5 2 4,544

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
31. 31.808 31.808 ↑ 6.5 2 4,544

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

  • Index Cond: ((idazienda = tblveuanveicoli001.idazienda) AND (idveicolo = tblveuanveicoli001.idveicolo))
  • Filter: (stato = 'S'::bpchar)
  • Rows Removed by Filter: 0
32. 4.544 27.264 ↓ 0.0 0 4,544

Sort (cost=35.88..35.88 rows=1 width=43) (actual time=0.006..0.006 rows=0 loops=4,544)

  • Sort Key: tblveuopricerca001_1.codopricerca
  • Sort Method: quicksort Memory: 25kB
33. 6.650 22.720 ↓ 0.0 0 4,544

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

34. 13.632 13.632 ↓ 0.0 0 4,544

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

  • Index Cond: ((idazienda = tblveuanveicoli001.idazienda) AND (idveicolo = tblveuanveicoli001.idveicolo))
  • Filter: (stato = 'O'::bpchar)
  • Rows Removed by Filter: 2
35. 2.438 2.438 ↑ 1.0 1 1,219

Index Only Scan using pk_tblveuopricerca001 on tblveuopricerca001 tblveuopricerca001_1 (cost=0.28..4.30 rows=1 width=11) (actual time=0.002..0.002 rows=1 loops=1,219)

  • Index Cond: ((idazienda = 1) AND (codopricerca = tblveuopveicolo001_1.codopricerca))
  • Heap Fetches: 0
36. 19.840 96,743.547 ↑ 27.7 8,016 1

Subquery Scan on *SELECT* 2 (cost=585,793.47..47,959,950.06 rows=221,728 width=581) (actual time=7,730.403..96,743.547 rows=8,016 loops=1)

37. 250.360 96,723.707 ↑ 27.7 8,016 1

Hash Left Join (cost=585,793.47..47,954,961.18 rows=221,728 width=570) (actual time=7,730.391..96,723.707 rows=8,016 loops=1)

  • Hash Cond: (tblaunmotorizzazioni001.idalimentazione = tblveualimentazione001_1.idalimentazione)
38. 18.472 9,323.368 ↑ 27.7 8,016 1

Hash Left Join (cost=585,792.15..945,166.45 rows=221,728 width=601) (actual time=7,671.579..9,323.368 rows=8,016 loops=1)

  • Hash Cond: ((tblaunversioni001.idmotorizzazione = tblaunmotorizzazioni001.idmotorizzazione) AND (tblvenordine001.idmarca = tblaunmotorizzazioni001.idmarca))
39. 1,293.855 9,291.546 ↑ 27.7 8,016 1

Hash Left Join (cost=585,107.83..943,318.01 rows=221,728 width=596) (actual time=7,658.111..9,291.546 rows=8,016 loops=1)

  • Hash Cond: ((tblvenordine001.idmarca = tbloptesterno.idmarca) AND (tblvenordine001.idlinea = tbloptesterno.idlinea) AND (tblvenordine001.modelyear = tbloptesterno.modelyear) AND (tblvenordine001.idmodello = tbloptesterno.idmodello) AND (tblvenordine001.idversione = tbloptesterno.idversione) AND (tblvenordine001.idtipopcolesterno = tbloptesterno.tipoptional) AND (tblvenordine001.idopcolesterno = tbloptesterno.codoptional))
40. 11.350 744.841 ↑ 27.7 8,016 1

Nested Loop Left Join (cost=43,666.88..204,242.80 rows=221,728 width=362) (actual time=245.066..744.841 rows=8,016 loops=1)

41. 5.934 605.235 ↓ 1.5 8,016 1

Hash Left Join (cost=43,666.45..149,811.28 rows=5,408 width=362) (actual time=244.991..605.235 rows=8,016 loops=1)

  • Hash Cond: (tblvenordine001.idtipveicolo = tblventipveicolo001.idtipveicolo)
42. 11.911 599.286 ↓ 1.5 8,016 1

Hash Left Join (cost=43,665.30..149,787.33 rows=5,408 width=331) (actual time=244.965..599.286 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))
43. 7.804 531.436 ↓ 1.5 8,016 1

Hash Left Join (cost=39,839.07..145,890.12 rows=5,408 width=259) (actual time=188.818..531.436 rows=8,016 loops=1)

  • Hash Cond: ((tblvenordine001.idmarca = tblaunlinea001.idmarca) AND (tblvenordine001.idlinea = tblaunlinea001.idlinea) AND (tblvenordine001.modelyear = tblaunlinea001.modelyear))
44. 5.792 522.885 ↓ 1.5 8,016 1

Hash Left Join (cost=39,790.28..145,798.75 rows=5,408 width=208) (actual time=188.059..522.885 rows=8,016 loops=1)

  • Hash Cond: (tblvenordine001.idmarca = tbldfnmrc001.idmarchio)
45. 158.056 517.036 ↓ 1.5 8,016 1

Hash Right Join (cost=39,781.52..145,774.02 rows=5,408 width=163) (actual time=187.987..517.036 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,697
46. 182.696 198.483 ↑ 1.0 177,867 1

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

  • Recheck Cond: (idazstock = 1)
  • Heap Blocks: exact=74,853
47. 15.787 15.787 ↑ 1.0 177,872 1

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

  • Index Cond: (idazstock = 1)
48. 6.739 160.497 ↓ 1.3 10,713 1

Hash (cost=36,120.82..36,120.82 rows=8,389 width=167) (actual time=160.496..160.497 rows=10,713 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 2,153kB
49. 61.807 153.758 ↓ 1.3 10,713 1

Hash Right Join (cost=31,203.93..36,120.82 rows=8,389 width=167) (actual time=36.030..153.758 rows=10,713 loops=1)

  • Hash Cond: ((tblvenspedizione001.idazienda = tblvenordine001.idazienda) AND (tblvenspedizione001.idordine = tblvenordine001.idordine))
50. 55.978 55.978 ↓ 1.0 140,283 1

Seq Scan on tblvenspedizione001 (cost=0.00..4,180.44 rows=140,275 width=28) (actual time=0.011..55.978 rows=140,283 loops=1)

  • Filter: (idazienda = 1)
51. 7.041 35.973 ↓ 1.3 10,713 1

Hash (cost=31,078.09..31,078.09 rows=8,389 width=174) (actual time=35.972..35.973 rows=10,713 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 2,303kB
52. 24.534 28.932 ↓ 1.3 10,713 1

Bitmap Heap Scan on tblvenordine001 (cost=4,652.87..31,078.09 rows=8,389 width=174) (actual time=5.437..28.932 rows=10,713 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,669
53. 4.398 4.398 ↓ 1.2 13,745 1

Bitmap Index Scan on tblvenordine00110 (cost=0.00..4,650.77 rows=11,078 width=0) (actual time=4.397..4.398 rows=13,745 loops=1)

  • Index Cond: (datconsacquirente IS NULL)
54. 0.020 0.057 ↑ 1.0 34 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
55. 0.037 0.037 ↑ 1.0 34 1

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

56. 0.416 0.747 ↑ 1.0 865 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 108kB
57. 0.331 0.331 ↑ 1.0 865 1

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

58. 31.167 55.939 ↑ 1.0 53,607 1

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

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

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

60. 0.006 0.015 ↑ 1.0 7 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
61. 0.009 0.009 ↑ 1.0 7 1

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

62. 8.016 128.256 ↑ 41.0 1 8,016

Result (cost=0.42..9.25 rows=41 width=22) (actual time=0.007..0.016 rows=1 loops=8,016)

63. 32.064 120.240 ↑ 41.0 1 8,016

Unique (cost=0.42..9.25 rows=41 width=22) (actual time=0.006..0.015 rows=1 loops=8,016)

64. 88.176 88.176 ↑ 2.9 14 8,016

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

  • Index Cond: ((idazienda = tblvenordine001.idazienda) AND (idordine = tblvenordine001.idordine))
  • Heap Fetches: 864
65. 3,248.938 7,252.850 ↑ 1.0 3,596,398 1

Hash (cost=270,061.92..270,061.92 rows=3,601,492 width=365) (actual time=7,252.850..7,252.850 rows=3,596,398 loops=1)

  • Buckets: 65,536 Batches: 128 Memory Usage: 11,551kB
66. 4,003.912 4,003.912 ↑ 1.0 3,596,398 1

Seq Scan on tblaunoptionals001 tbloptesterno (cost=0.00..270,061.92 rows=3,601,492 width=365) (actual time=0.014..4,003.912 rows=3,596,398 loops=1)

67. 6.858 13.350 ↑ 1.0 15,493 1

Hash (cost=451.93..451.93 rows=15,493 width=51) (actual time=13.350..13.350 rows=15,493 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,173kB
68. 6.492 6.492 ↑ 1.0 15,493 1

Seq Scan on tblaunmotorizzazioni001 (cost=0.00..451.93 rows=15,493 width=51) (actual time=0.012..6.492 rows=15,493 loops=1)

69. 0.011 0.027 ↑ 1.0 14 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
70. 0.016 0.016 ↑ 1.0 14 1

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

71.          

SubPlan (for Hash Left Join)

72. 77.946 561.120 ↑ 1.0 1 8,016

Nested Loop (cost=0.99..105.69 rows=1 width=32) (actual time=0.054..0.070 rows=1 loops=8,016)

  • Join Filter: (tblvenopordine001.codoptional = tblaunoptionals001.codoptional)
  • Rows Removed by Join Filter: 16
73. 152.304 152.304 ↓ 3.0 3 8,016

Index Scan using pk_tblaunoptionals001 on tblaunoptionals001 (cost=0.56..8.58 rows=1 width=284) (actual time=0.014..0.019 rows=3 loops=8,016)

  • 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))
74. 330.870 330.870 ↓ 3.0 6 22,058

Index Scan using pk_tblvenopordine001 on tblvenopordine001 (cost=0.43..97.08 rows=2 width=25) (actual time=0.013..0.015 rows=6 loops=22,058)

  • Index Cond: ((idazienda = tblvenordine001.idazienda) AND (idordine = tblvenordine001.idordine))
  • Filter: (idtipoptional = 'S'::bpchar)
  • Rows Removed by Filter: 48
75. 33,730.480 86,588.832 ↓ 33.0 33 8,016

Nested Loop (cost=0.99..106.28 rows=1 width=32) (actual time=0.266..10.802 rows=33 loops=8,016)

  • Join Filter: (tblvenopordine001_1.codoptional = tblaunoptionals001_1.codoptional)
  • Rows Removed by Join Filter: 12,005
76. 2,092.176 2,092.176 ↓ 198.0 198 8,016

Index Scan using pk_tblaunoptionals001 on tblaunoptionals001 tblaunoptionals001_1 (cost=0.56..8.58 rows=1 width=284) (actual time=0.014..0.261 rows=198 loops=8,016)

  • 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))
77. 50,766.176 50,766.176 ↓ 1.2 61 1,586,443

Index Scan using pk_tblvenopordine001 on tblvenopordine001 tblvenopordine001_1 (cost=0.43..97.08 rows=49 width=25) (actual time=0.004..0.032 rows=61 loops=1,586,443)

  • Index Cond: ((idazienda = tblvenordine001.idazienda) AND (idordine = tblvenordine001.idordine))
  • Filter: (idtipoptional = 'O'::bpchar)
  • Rows Removed by Filter: 0
Planning time : 16.868 ms
Execution time : 97,406.713 ms