explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Bea

Settings
# exclusive inclusive rows x rows loops node
1. 14.992 651,861.135 ↓ 1.3 12,555 1

Unique (cost=358,458,935.05..358,459,603.91 rows=9,909 width=732) (actual time=651,841.350..651,861.135 rows=12,555 loops=1)

2. 73.501 651,846.143 ↓ 1.3 12,555 1

Sort (cost=358,458,935.05..358,458,959.82 rows=9,909 width=732) (actual time=651,841.346..651,846.143 rows=12,555 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,326kB
3. 5.441 651,772.642 ↓ 1.3 12,555 1

Append (cost=20,242.08..358,458,277.37 rows=9,909 width=732) (actual time=373.464..651,772.642 rows=12,555 loops=1)

4. 200.838 558,439.314 ↓ 1.0 4,539 1

Gather (cost=20,242.08..357,114,235.73 rows=4,501 width=484) (actual time=373.461..558,439.314 rows=4,539 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 1.397 263.745 ↑ 1.2 1,513 3 / 3

Hash Left Join (cost=19,242.08..30,691.07 rows=1,875 width=222) (actual time=240.133..263.745 rows=1,513 loops=3)

  • Hash Cond: (tblveuanveicoli001.idcambio = tblveucambio001.idcambio)
6. 1.309 262.313 ↑ 1.2 1,513 3 / 3

Hash Left Join (cost=19,240.60..30,683.68 rows=1,875 width=205) (actual time=240.082..262.313 rows=1,513 loops=3)

  • Hash Cond: (tblveuanveicoli001.flcommerciale = tblveucatveicoli001.codice)
7. 3.636 260.980 ↑ 1.2 1,513 3 / 3

Parallel Hash Left Join (cost=19,239.45..30,674.62 rows=1,875 width=196) (actual time=240.008..260.980 rows=1,513 loops=3)

  • Hash Cond: (tblveuanveicoli001.idveicolo = tblveucontatti001.idveicolo)
8. 3.350 216.404 ↑ 1.2 1,513 3 / 3

Parallel Hash Left Join (cost=15,829.97..27,253.28 rows=1,875 width=196) (actual time=198.710..216.404 rows=1,513 loops=3)

  • Hash Cond: (tblveuanveicoli001.idveicolo = tblveuritiro001.idveicolo)
9. 3.369 169.837 ↑ 1.2 1,513 3 / 3

Parallel Hash Left Join (cost=11,917.64..23,329.46 rows=1,875 width=196) (actual time=155.316..169.837 rows=1,513 loops=3)

  • Hash Cond: ((tblveuanveicoli001.idazienda = tblveucommerciali001.idazienda) AND (tblveuanveicoli001.idveicolo = tblveucommerciali001.idveicolo))
10. 1.413 68.094 ↑ 1.2 1,513 3 / 3

Hash Left Join (cost=4,939.61..16,341.59 rows=1,875 width=194) (actual time=56.420..68.094 rows=1,513 loops=3)

  • Hash Cond: (tblveuanveicoli001.idcolesterno = tblveucolesterno001.idcolesterno)
11. 1.291 66.619 ↑ 1.2 1,513 3 / 3

Hash Left Join (cost=4,937.28..16,334.04 rows=1,875 width=180) (actual time=56.340..66.619 rows=1,513 loops=3)

  • Hash Cond: (tblveuanveicoli001.idalimentazione = tblveualimentazione001.idalimentazione)
12. 3.389 65.296 ↑ 1.2 1,513 3 / 3

Parallel Hash Left Join (cost=4,935.97..16,326.31 rows=1,875 width=163) (actual time=56.287..65.296 rows=1,513 loops=3)

  • Hash Cond: ((tblveuanveicoli001.idmarca = tblveuversioni001.idmarca) AND (tblveuanveicoli001.idmodello = tblveuversioni001.idmodello) AND ((tblveuanveicoli001.idversione)::bpchar = tblveuversioni001.idversione))
13. 6.647 6.852 ↑ 1.2 1,513 3 / 3

Parallel Bitmap Heap Scan on tblveuanveicoli001 (cost=118.79..11,494.37 rows=1,875 width=208) (actual time=0.877..6.852 rows=1,513 loops=3)

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

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

  • Index Cond: ((idstato = 'STO'::bpchar) AND (idazienda = 1))
15. 29.903 55.055 ↑ 1.2 47,717 3 / 3

Parallel Hash (cost=3,773.43..3,773.43 rows=59,643 width=39) (actual time=55.054..55.055 rows=47,717 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 11,712kB
16. 25.152 25.152 ↑ 1.2 47,717 3 / 3

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

17. 0.011 0.032 ↑ 1.0 14 3 / 3

Hash (cost=1.14..1.14 rows=14 width=25) (actual time=0.032..0.032 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.016..0.021 rows=14 loops=3)

19. 0.030 0.062 ↑ 1.0 59 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
20. 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.011..0.032 rows=59 loops=3)

21. 52.426 98.374 ↑ 1.2 85,856 3 / 3

Parallel Hash (cost=5,368.38..5,368.38 rows=107,310 width=36) (actual time=98.373..98.374 rows=85,856 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 14,656kB
22. 45.948 45.948 ↑ 1.2 85,856 3 / 3

Parallel Seq Scan on tblveucommerciali001 (cost=0.00..5,368.38 rows=107,310 width=36) (actual time=0.013..45.948 rows=85,856 loops=3)

  • Filter: (idazienda = 1)
23. 22.241 43.217 ↑ 1.8 38,854 3 / 3

Parallel Hash (cost=3,055.48..3,055.48 rows=68,548 width=13) (actual time=43.217..43.217 rows=38,854 loops=3)

  • Buckets: 131,072 Batches: 1 Memory Usage: 6,528kB
24. 20.976 20.976 ↑ 1.8 38,854 3 / 3

Parallel Seq Scan on tblveuritiro001 (cost=0.00..3,055.48 rows=68,548 width=13) (actual time=0.010..20.976 rows=38,854 loops=3)

25. 23.038 40.940 ↑ 1.8 42,056 3 / 3

Parallel Hash (cost=2,481.99..2,481.99 rows=74,199 width=10) (actual time=40.939..40.940 rows=42,056 loops=3)

  • Buckets: 131,072 Batches: 1 Memory Usage: 7,008kB
26. 17.902 17.902 ↑ 1.8 42,056 3 / 3

Parallel Seq Scan on tblveucontatti001 (cost=0.00..2,481.99 rows=74,199 width=10) (actual time=0.012..17.902 rows=42,056 loops=3)

27. 0.007 0.024 ↑ 1.0 7 3 / 3

Hash (cost=1.07..1.07 rows=7 width=13) (actual time=0.023..0.024 rows=7 loops=3)

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

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

29. 0.016 0.035 ↑ 1.0 21 3 / 3

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

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

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

31.          

SubPlan (for Gather)

32. 49.929 280,977.717 ↑ 6.5 2 4,539

Sort (cost=39,706.89..39,706.92 rows=13 width=43) (actual time=61.902..61.903 rows=2 loops=4,539)

  • Sort Key: tblveuopricerca001.codopricerca
  • Sort Method: quicksort Memory: 25kB
33. 57.066 280,927.788 ↑ 6.5 2 4,539

Nested Loop Left Join (cost=0.71..39,706.65 rows=13 width=43) (actual time=60.348..61.892 rows=2 loops=4,539)

34. 280,809.774 280,809.774 ↑ 6.5 2 4,539

Index Scan using pk_tblveuopveicolo001 on tblveuopveicolo001 (cost=0.43..39,622.60 rows=13 width=11) (actual time=60.331..61.866 rows=2 loops=4,539)

  • Index Cond: (idveicolo = tblveuanveicoli001.idveicolo)
  • Filter: (stato = 'S'::bpchar)
  • Rows Removed by Filter: 0
35. 60.948 60.948 ↑ 1.0 1 10,158

Index Scan using pk_tblveuopricerca001 on tblveuopricerca001 (cost=0.28..6.45 rows=1 width=112) (actual time=0.006..0.006 rows=1 loops=10,158)

  • Index Cond: ((idazienda = 1) AND (codopricerca = tblveuopveicolo001.codopricerca))
36. 27.234 276,997.014 ↓ 0.0 0 4,539

Sort (cost=39,626.99..39,626.99 rows=1 width=43) (actual time=61.026..61.026 rows=0 loops=4,539)

  • Sort Key: tblveuopricerca001_1.codopricerca
  • Sort Method: quicksort Memory: 25kB
37. 21.154 276,969.780 ↓ 0.0 0 4,539

Nested Loop Left Join (cost=0.71..39,626.98 rows=1 width=43) (actual time=60.810..61.020 rows=0 loops=4,539)

38. 276,942.546 276,942.546 ↓ 0.0 0 4,539

Index Scan using pk_tblveuopveicolo001 on tblveuopveicolo001 tblveuopveicolo001_1 (cost=0.43..39,622.60 rows=1 width=112) (actual time=60.805..61.014 rows=0 loops=4,539)

  • Index Cond: (idveicolo = tblveuanveicoli001.idveicolo)
  • Filter: (stato = 'O'::bpchar)
  • Rows Removed by Filter: 2
39. 6.080 6.080 ↑ 1.0 1 1,216

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

  • Index Cond: ((idazienda = 1) AND (codopricerca = tblveuopveicolo001_1.codopricerca))
  • Heap Fetches: 0
40. 21.807 93,327.887 ↓ 1.5 8,016 1

Subquery Scan on *SELECT* 2 (cost=43,678.61..1,343,947.08 rows=5,408 width=581) (actual time=290.878..93,327.887 rows=8,016 loops=1)

41. 256.385 93,306.080 ↓ 1.5 8,016 1

Hash Left Join (cost=43,678.61..1,343,825.40 rows=5,408 width=570) (actual time=290.868..93,306.080 rows=8,016 loops=1)

  • Hash Cond: (tblaunmotorizzazioni001.idalimentazione = tblveualimentazione001_1.idalimentazione)
42. 14.936 1,106.135 ↓ 1.5 8,016 1

Nested Loop Left Join (cost=43,677.29..197,243.75 rows=5,408 width=601) (actual time=281.785..1,106.135 rows=8,016 loops=1)

43. 21.895 1,027.071 ↓ 1.5 8,016 1

Nested Loop Left Join (cost=43,677.01..194,580.92 rows=5,408 width=596) (actual time=281.747..1,027.071 rows=8,016 loops=1)

44. 10.483 852.872 ↓ 1.5 8,016 1

Hash Left Join (cost=43,676.45..149,836.45 rows=5,408 width=362) (actual time=281.676..852.872 rows=8,016 loops=1)

  • Hash Cond: (tblvenordine001.idtipveicolo = tblventipveicolo001.idtipveicolo)
45. 24.361 842.370 ↓ 1.5 8,016 1

Hash Left Join (cost=43,675.30..149,812.49 rows=5,408 width=331) (actual time=281.636..842.370 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))
46. 14.116 755.911 ↓ 1.5 8,016 1

Hash Left Join (cost=39,849.07..145,915.29 rows=5,408 width=259) (actual time=219.467..755.911 rows=8,016 loops=1)

  • Hash Cond: ((tblvenordine001.idmarca = tblaunlinea001.idmarca) AND (tblvenordine001.idlinea = tblaunlinea001.idlinea) AND (tblvenordine001.modelyear = tblaunlinea001.modelyear))
47. 10.090 741.033 ↓ 1.5 8,016 1

Hash Left Join (cost=39,800.28..145,823.91 rows=5,408 width=208) (actual time=218.683..741.033 rows=8,016 loops=1)

  • Hash Cond: (tblvenordine001.idmarca = tbldfnmrc001.idmarchio)
48. 11.900 730.866 ↓ 1.5 8,016 1

Hash Join (cost=39,791.52..145,799.18 rows=5,408 width=163) (actual time=218.586..730.866 rows=8,016 loops=1)

  • Hash Cond: (tblvenordine001.idsede = tbldfnsde001.idsede)
49. 188.917 718.828 ↓ 1.5 8,016 1

Hash Right Join (cost=39,781.52..145,774.02 rows=5,408 width=163) (actual time=218.414..718.828 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
50. 324.421 344.942 ↑ 1.0 177,855 1

Bitmap Heap Scan on tblcrmofferte001 (cost=3,534.86..108,057.00 rows=179,411 width=22) (actual time=30.435..344.942 rows=177,855 loops=1)

  • Recheck Cond: (idazstock = 1)
  • Heap Blocks: exact=74,854
51. 20.521 20.521 ↑ 1.0 177,873 1

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

  • Index Cond: (idazstock = 1)
52. 7.118 184.969 ↓ 1.3 10,713 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 2,153kB
53. 63.420 177.851 ↓ 1.3 10,713 1

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

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

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

  • Filter: (idazienda = 1)
55. 7.300 53.611 ↓ 1.3 10,713 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 2,303kB
56. 40.140 46.311 ↓ 1.3 10,713 1

Bitmap Heap Scan on tblvenordine001 (cost=4,652.87..31,078.09 rows=8,389 width=174) (actual time=7.233..46.311 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,630
57. 6.171 6.171 ↓ 1.2 13,689 1

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

  • Index Cond: (datconsacquirente IS NULL)
58. 0.031 0.138 ↑ 1.0 62 1

Hash (cost=9.22..9.22 rows=62 width=8) (actual time=0.138..0.138 rows=62 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
59. 0.107 0.107 ↑ 1.0 62 1

Index Only Scan using pk_tbldfnsde001 on tbldfnsde001 (cost=0.14..9.22 rows=62 width=8) (actual time=0.028..0.107 rows=62 loops=1)

  • Index Cond: (idazienda = 1)
  • Heap Fetches: 37
60. 0.018 0.077 ↑ 1.0 34 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
61. 0.059 0.059 ↑ 1.0 34 1

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

62. 0.385 0.762 ↑ 1.0 865 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 108kB
63. 0.377 0.377 ↑ 1.0 865 1

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

64. 32.802 62.098 ↑ 1.0 53,607 1

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

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

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

66. 0.006 0.019 ↑ 1.0 7 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
67. 0.013 0.013 ↑ 1.0 7 1

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

68. 152.304 152.304 ↑ 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.019..0.019 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))
69. 64.128 64.128 ↑ 1.0 1 8,016

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

  • Index Cond: ((idmarca = tblvenordine001.idmarca) AND (idmotorizzazione = tblaunversioni001.idmotorizzazione))
70. 0.011 0.040 ↑ 1.0 14 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
71. 0.029 0.029 ↑ 1.0 14 1

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

72.          

SubPlan (for Hash Left Join)

73. 71.920 553.104 ↑ 1.0 1 8,016

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

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

Index Scan using pk_tblaunoptionals001 on tblaunoptionals001 (cost=0.56..8.58 rows=1 width=284) (actual time=0.011..0.016 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))
75. 352.928 352.928 ↓ 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.016 rows=6 loops=22,058)

  • Index Cond: ((idazienda = tblvenordine001.idazienda) AND (idordine = tblvenordine001.idordine))
  • Filter: (idtipoptional = 'S'::bpchar)
  • Rows Removed by Filter: 48
76. 35,070.602 91,390.416 ↓ 33.0 33 8,016

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

  • Join Filter: (tblvenopordine001_1.codoptional = tblaunoptionals001_1.codoptional)
  • Rows Removed by Join Filter: 12,005
77. 2,380.752 2,380.752 ↓ 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.297 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))
78. 53,939.062 53,939.062 ↓ 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.034 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 : 12.945 ms
Execution time : 651,873.550 ms