explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 520X

Settings
# exclusive inclusive rows x rows loops node
1. 19.680 43,595.110 ↑ 12.9 21,760 1

Unique (cost=51,049,615.16..51,068,531.42 rows=280,241 width=732) (actual time=43,564.020..43,595.110 rows=21,760 loops=1)

2. 169.297 43,575.430 ↑ 12.9 21,760 1

Sort (cost=51,049,615.16..51,050,315.76 rows=280,241 width=732) (actual time=43,564.016..43,575.430 rows=21,760 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)), (string_agg(btrim((COALESCE(tblveuopricerca001.desoptional, '-'::bpchar))::text), '|'::text)), (string_agg(btrim((COALESCE(tblveuopricerca001_1.desoptional, '-'::bpchar))::text), '|'::text)), ('true'::text), tblveuversioni001.codaltidentificazione, tblveuanveicoli001.idversione, tblveuanveicoli001.idsede
  • Sort Method: external merge Disk: 13,024kB
3. 13.728 43,406.133 ↑ 12.9 21,760 1

Append (cost=11,248.45..50,933,262.02 rows=280,241 width=732) (actual time=263.766..43,406.133 rows=21,760 loops=1)

4. 39.641 940.664 ↑ 4.3 13,744 1

Hash Left Join (cost=11,248.45..2,817,770.99 rows=58,513 width=484) (actual time=263.765..940.664 rows=13,744 loops=1)

  • Hash Cond: (tblveuanveicoli001.idcambio = tblveucambio001.idcambio)
5. 10.074 900.992 ↑ 4.3 13,744 1

Hash Left Join (cost=11,246.98..2,815,829.55 rows=58,513 width=269) (actual time=263.672..900.992 rows=13,744 loops=1)

  • Hash Cond: (tblveuanveicoli001.flcommerciale = tblveucatveicoli001.codice)
6. 14.819 890.899 ↑ 4.3 13,744 1

Hash Left Join (cost=11,245.82..2,815,581.81 rows=58,513 width=260) (actual time=263.630..890.899 rows=13,744 loops=1)

  • Hash Cond: ((tblveuanveicoli001.idazienda = tblveucommerciali001.idazienda) AND (tblveuanveicoli001.idveicolo = tblveucommerciali001.idveicolo))
7. 9.736 613.856 ↑ 4.3 13,744 1

Nested Loop Left Join (cost=136.36..2,804,165.16 rows=58,513 width=258) (actual time=0.646..613.856 rows=13,744 loops=1)

8. 11.040 508.880 ↑ 4.9 11,905 1

Nested Loop Left Join (cost=96.41..463,729.13 rows=58,513 width=226) (actual time=0.612..508.880 rows=11,905 loops=1)

9. 5.855 102.338 ↓ 1.0 4,546 1

Nested Loop Left Join (cost=0.98..31,571.79 rows=4,501 width=194) (actual time=0.141..102.338 rows=4,546 loops=1)

10. 12.395 87.391 ↓ 1.0 4,546 1

Nested Loop Left Join (cost=0.84..30,852.11 rows=4,501 width=180) (actual time=0.125..87.391 rows=4,546 loops=1)

  • Join Filter: (tblveuanveicoli001.idalimentazione = tblveualimentazione001.idalimentazione)
  • Rows Removed by Join Filter: 17,273
11. 6.699 70.450 ↓ 1.0 4,546 1

Nested Loop Left Join (cost=0.84..29,964.33 rows=4,501 width=163) (actual time=0.107..70.450 rows=4,546 loops=1)

12. 18.291 18.291 ↓ 1.0 4,546 1

Index Scan using tblveuanveicoli00113 on tblveuanveicoli001 (cost=0.42..13,940.63 rows=4,501 width=169) (actual time=0.059..18.291 rows=4,546 loops=1)

  • Index Cond: ((idstato = 'STO'::bpchar) AND (idazienda = 1))
  • Filter: (COALESCE(flprenotatovendita, 'N'::bpchar) <> 'S'::bpchar)
13. 45.460 45.460 ↑ 1.0 1 4,546

Index Scan using pk_tblveuversioni001 on tblveuversioni001 (cost=0.42..3.56 rows=1 width=39) (actual time=0.010..0.010 rows=1 loops=4,546)

  • Index Cond: ((tblveuanveicoli001.idmarca = idmarca) AND (tblveuanveicoli001.idmodello = idmodello) AND ((tblveuanveicoli001.idversione)::bpchar = idversione))
14. 4.530 4.546 ↑ 2.8 5 4,546

Materialize (cost=0.00..1.21 rows=14 width=25) (actual time=0.000..0.001 rows=5 loops=4,546)

15. 0.016 0.016 ↑ 1.1 13 1

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

16. 9.092 9.092 ↑ 1.0 1 4,546

Index Scan using pk_tblveucolesterno001 on tblveucolesterno001 (cost=0.14..0.16 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=4,546)

  • Index Cond: (tblveuanveicoli001.idcolesterno = idcolesterno)
17. 22.730 395.502 ↑ 6.5 2 4,546

GroupAggregate (cost=95.43..95.75 rows=13 width=43) (actual time=0.084..0.087 rows=2 loops=4,546)

  • Group Key: tblveuopricerca001.codopricerca
18. 13.638 372.772 ↑ 6.5 2 4,546

Sort (cost=95.43..95.46 rows=13 width=112) (actual time=0.082..0.082 rows=2 loops=4,546)

  • Sort Key: tblveuopricerca001.codopricerca
  • Sort Method: quicksort Memory: 25kB
19. 119.439 359.134 ↑ 6.5 2 4,546

Hash Right Join (cost=36.79..95.19 rows=13 width=112) (actual time=0.037..0.079 rows=2 loops=4,546)

  • Hash Cond: ((tblveuopricerca001.idazienda = tblveuopveicolo001.idazienda) AND (tblveuopricerca001.codopricerca = tblveuopveicolo001.codopricerca))
20. 182.975 194.235 ↑ 1.0 107 2,815

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

  • Recheck Cond: (idazienda = tblveuanveicoli001.idazienda)
  • Heap Blocks: exact=123,860
21. 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 = tblveuanveicoli001.idazienda)
22. 9.092 45.460 ↑ 6.5 2 4,546

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
23. 36.368 36.368 ↑ 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.008 rows=2 loops=4,546)

  • Index Cond: ((idazienda = tblveuanveicoli001.idazienda) AND (idveicolo = tblveuanveicoli001.idveicolo))
  • Filter: (stato = 'S'::bpchar)
  • Rows Removed by Filter: 0
24. 23.810 95.240 ↓ 0.0 0 11,905

GroupAggregate (cost=39.95..39.98 rows=1 width=43) (actual time=0.007..0.008 rows=0 loops=11,905)

  • Group Key: tblveuopricerca001_1.codopricerca
25. 11.905 71.430 ↓ 0.0 0 11,905

Sort (cost=39.95..39.96 rows=1 width=112) (actual time=0.006..0.006 rows=0 loops=11,905)

  • Sort Key: tblveuopricerca001_1.codopricerca
  • Sort Method: quicksort Memory: 25kB
26. 3.409 59.525 ↓ 0.0 0 11,905

Nested Loop Left Join (cost=0.71..39.94 rows=1 width=112) (actual time=0.004..0.005 rows=0 loops=11,905)

27. 47.620 47.620 ↓ 0.0 0 11,905

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

  • Index Cond: ((idazienda = tblveuanveicoli001.idazienda) AND (idveicolo = tblveuanveicoli001.idveicolo))
  • Filter: (stato = 'O'::bpchar)
  • Rows Removed by Filter: 4
28. 8.496 8.496 ↑ 1.0 1 2,832

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=2,832)

  • Index Cond: ((idazienda = tblveuopveicolo001_1.idazienda) AND (idazienda = tblveuanveicoli001.idazienda) AND (codopricerca = tblveuopveicolo001_1.codopricerca))
29. 129.690 262.224 ↓ 1.0 257,600 1

Hash (cost=7,246.30..7,246.30 rows=257,544 width=16) (actual time=262.224..262.224 rows=257,600 loops=1)

  • Buckets: 262,144 Batches: 1 Memory Usage: 13,804kB
30. 132.534 132.534 ↓ 1.0 257,600 1

Seq Scan on tblveucommerciali001 (cost=0.00..7,246.30 rows=257,544 width=16) (actual time=0.016..132.534 rows=257,600 loops=1)

  • Filter: (idazienda = 1)
31. 0.006 0.019 ↑ 1.0 7 1

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

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

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

33. 0.011 0.031 ↑ 1.0 21 1

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

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

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

35. 16.647 42,451.741 ↑ 27.7 8,016 1

Subquery Scan on *SELECT* 2 (cost=586,014.08..48,113,504.70 rows=221,728 width=581) (actual time=6,679.700..42,451.741 rows=8,016 loops=1)

36. 37.712 42,435.094 ↑ 27.7 8,016 1

Hash Left Join (cost=586,014.08..48,108,515.82 rows=221,728 width=570) (actual time=6,679.686..42,435.094 rows=8,016 loops=1)

  • Hash Cond: (tblaunmotorizzazioni001.idalimentazione = tblveualimentazione001_1.idalimentazione)
37. 15.496 42,397.354 ↑ 27.7 8,016 1

Hash Left Join (cost=586,012.76..48,100,068.21 rows=221,728 width=580) (actual time=6,679.611..42,397.354 rows=8,016 loops=1)

  • Hash Cond: ((tblaunversioni001.idmotorizzazione = tblaunmotorizzazioni001.idmotorizzazione) AND (tblvenordine001.idmarca = tblaunmotorizzazioni001.idmarca))
38. 13.744 42,367.960 ↑ 27.7 8,016 1

Nested Loop Left Join (cost=585,328.44..48,098,219.77 rows=221,728 width=579) (actual time=6,665.618..42,367.960 rows=8,016 loops=1)

39. 19.174 8,751.144 ↑ 27.7 8,016 1

Nested Loop Left Join (cost=585,221.55..24,390,507.69 rows=221,728 width=628) (actual time=6,640.451..8,751.144 rows=8,016 loops=1)

40. 1,294.222 8,371.250 ↑ 27.7 8,016 1

Hash Left Join (cost=585,115.83..943,326.01 rows=221,728 width=596) (actual time=6,640.280..8,371.250 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))
41. 12.988 994.225 ↑ 27.7 8,016 1

Nested Loop Left Join (cost=43,674.88..204,250.80 rows=221,728 width=362) (actual time=304.645..994.225 rows=8,016 loops=1)

42. 6.088 852.981 ↓ 1.5 8,016 1

Hash Left Join (cost=43,674.45..149,819.28 rows=5,408 width=362) (actual time=304.539..852.981 rows=8,016 loops=1)

  • Hash Cond: (tblvenordine001.idtipveicolo = tblventipveicolo001.idtipveicolo)
43. 11.748 846.867 ↓ 1.5 8,016 1

Hash Left Join (cost=43,673.30..149,795.33 rows=5,408 width=331) (actual time=304.489..846.867 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))
44. 7.679 770.011 ↓ 1.5 8,016 1

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

  • Hash Cond: ((tblvenordine001.idmarca = tblaunlinea001.idmarca) AND (tblvenordine001.idlinea = tblaunlinea001.idlinea) AND (tblvenordine001.modelyear = tblaunlinea001.modelyear))
45. 5.704 761.552 ↓ 1.5 8,016 1

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

  • Hash Cond: (tblvenordine001.idmarca = tbldfnmrc001.idmarchio)
46. 214.798 755.736 ↓ 1.5 8,016 1

Hash Right Join (cost=39,789.52..145,782.02 rows=5,408 width=163) (actual time=238.385..755.736 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,698
47. 315.775 337.324 ↑ 1.0 177,875 1

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

  • Recheck Cond: (idazstock = 1)
  • Heap Blocks: exact=74,855
48. 21.549 21.549 ↑ 1.0 177,886 1

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

  • Index Cond: (idazstock = 1)
49. 7.697 203.614 ↓ 1.3 10,714 1

Hash (cost=36,128.82..36,128.82 rows=8,389 width=167) (actual time=203.613..203.614 rows=10,714 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 2,119kB
50. 62.869 195.917 ↓ 1.3 10,714 1

Hash Right Join (cost=31,211.93..36,128.82 rows=8,389 width=167) (actual time=66.608..195.917 rows=10,714 loops=1)

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

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

  • Filter: (idazienda = 1)
52. 7.408 66.513 ↓ 1.3 10,714 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 2,269kB
53. 51.941 59.105 ↓ 1.3 10,714 1

Bitmap Heap Scan on tblvenordine001 (cost=4,660.87..31,086.09 rows=8,389 width=174) (actual time=8.273..59.105 rows=10,714 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,842
54. 7.164 7.164 ↓ 1.3 13,989 1

Bitmap Index Scan on tblvenordine00110 (cost=0.00..4,658.77 rows=11,078 width=0) (actual time=7.163..7.164 rows=13,989 loops=1)

  • Index Cond: (datconsacquirente IS NULL)
55. 0.021 0.112 ↑ 1.0 34 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
56. 0.091 0.091 ↑ 1.0 34 1

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

57. 0.377 0.780 ↑ 1.0 865 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 108kB
58. 0.403 0.403 ↑ 1.0 865 1

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

59. 33.799 65.108 ↑ 1.0 53,607 1

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

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

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

61. 0.010 0.026 ↑ 1.0 7 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
62. 0.016 0.016 ↑ 1.0 7 1

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

63. 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)

64. 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)

65. 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: 884
66. 3,156.939 6,082.803 ↑ 1.0 3,596,398 1

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

  • Buckets: 65,536 Batches: 128 Memory Usage: 11,551kB
67. 2,925.864 2,925.864 ↑ 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.016..2,925.864 rows=3,596,398 loops=1)

68. 16.032 360.720 ↑ 1.0 1 8,016

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

69. 36.724 344.688 ↑ 2.0 1 8,016

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

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

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

  • Index Cond: ((idazienda = tblvenordine001.idazienda) AND (idordine = tblvenordine001.idordine))
  • Filter: (idtipoptional = 'S'::bpchar)
  • Rows Removed by Filter: 33
71. 22.381 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)

72. 13.039 13.039 ↓ 23.0 23 221

Index Scan using pk_tblaunoptionals001 on tblaunoptionals001 (cost=0.56..8.58 rows=1 width=284) (actual time=0.023..0.059 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))
73. 496.992 33,603.072 ↑ 1.0 1 8,016

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

74. 16,926.156 33,106.080 ↑ 1.5 33 8,016

Nested Loop Left Join (cost=0.99..106.52 rows=49 width=259) (actual time=0.323..4.130 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,848
75. 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
76. 13,818.856 15,987.540 ↓ 177.0 177 266,459

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

77. 2,168.684 2,168.684 ↓ 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.019..0.292 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))
78. 6.790 13.898 ↑ 1.0 15,493 1

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

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

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

80. 0.011 0.028 ↑ 1.0 14 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
81. 0.017 0.017 ↑ 1.0 14 1

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

Planning time : 19.723 ms
Execution time : 43,606.301 ms