explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VsUw

Settings
# exclusive inclusive rows x rows loops node
1. 2,436.005 28,399.328 ↓ 0.0 0 1

Insert on desserte_tmp (cost=7,322,763.56..13,278,372.64 rows=1,740,528 width=623) (actual time=28,399.328..28,399.328 rows=0 loops=1)

2. 1,633.833 25,963.323 ↓ 1.3 2,210,456 1

Hash Left Join (cost=7,322,763.56..13,278,372.64 rows=1,740,528 width=623) (actual time=8,848.529..25,963.323 rows=2,210,456 loops=1)

  • Hash Cond: (t_real.id_vehicule = v.id_vehicule)
3. 3,531.718 24,323.078 ↓ 1.3 2,210,456 1

Hash Left Join (cost=7,319,418.86..13,261,756.39 rows=1,740,528 width=448) (actual time=8,842.102..24,323.078 rows=2,210,456 loops=1)

  • Hash Cond: (d_theo.id_point_arret_parcours = pap.id_point_arret_parcours)
4. 866.163 19,902.201 ↓ 1.3 2,210,456 1

Hash Left Join (cost=6,302,982.32..12,038,335.45 rows=1,740,528 width=440) (actual time=7,944.533..19,902.201 rows=2,210,456 loops=1)

  • Hash Cond: (d_real.id_point_arret_variante = pavar.id_point_arret)
5. 1,498.693 16,963.134 ↓ 1.3 2,210,456 1

Hash Left Join (cost=6,071,523.00..11,573,257.24 rows=1,740,528 width=452) (actual time=5,871.535..16,963.134 rows=2,210,456 loops=1)

  • Hash Cond: (va.id_service_agent = sa.id_service_agent)
6. 1,625.023 15,455.243 ↓ 1.3 2,210,456 1

Hash Left Join (cost=6,067,266.18..11,564,431.49 rows=1,740,528 width=454) (actual time=5,862.322..15,455.243 rows=2,210,456 loops=1)

  • Hash Cond: (rp_theo.id_parcours = p.id_parcours)
7. 1,507.170 13,683.302 ↓ 1.3 2,210,456 1

Hash Left Join (cost=6,018,079.87..11,508,276.23 rows=1,740,528 width=429) (actual time=5,715.353..13,683.302 rows=2,210,456 loops=1)

  • Hash Cond: (d_real.id_travail_depart = t_real.id_travail)
8. 1,380.658 11,684.666 ↓ 1.3 2,210,456 1

Hash Left Join (cost=5,613,642.90..10,915,275.03 rows=1,740,528 width=396) (actual time=5,223.834..11,684.666 rows=2,210,456 loops=1)

  • Hash Cond: ((t_theo.date_travail = c.date_calendrier) AND (t_theo.id_ce_travail = c.id_ce_calendrier))
9. 2,477.302 10,303.936 ↓ 1.3 2,210,456 1

Hash Right Join (cost=5,613,562.03..10,906,048.72 rows=1,740,528 width=356) (actual time=5,223.751..10,303.936 rows=2,210,456 loops=1)

  • Hash Cond: (d_real.id_desserte_theo = d_theo.id_desserte)
10. 2,604.494 2,604.494 ↓ 1.3 3,002,588 1

Index Scan using desserte_date_ce_index on desserte d_real (cost=0.57..5,083,682.73 rows=2,334,033 width=280) (actual time=0.044..2,604.494 rows=3,002,588 loops=1)

  • Index Cond: ((date_desserte >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_desserte <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_ce_desserte = '-1'::numeric) OR (id_ce_desserte = '2'::numeric) OR (id_ce_desserte = '0'::numeric) OR (id_ce_desserte = '1'::numeric))
11. 820.744 5,222.140 ↓ 1.3 2,204,299 1

Hash (cost=5,568,007.85..5,568,007.85 rows=1,740,528 width=84) (actual time=5,222.140..5,222.140 rows=2,204,299 loops=1)

  • Buckets: 131,072 (originally 131072) Batches: 64 (originally 32) Memory Usage: 7,715kB
12. 1,703.701 4,401.396 ↓ 1.3 2,204,299 1

Hash Left Join (cost=440,973.53..5,568,007.85 rows=1,740,528 width=84) (actual time=765.979..4,401.396 rows=2,204,299 loops=1)

  • Hash Cond: (d_theo.id_travail_depart = t_theo.id_travail)
13. 1,932.265 1,932.265 ↓ 1.3 2,204,299 1

Index Scan using desserte_date_ce_index on desserte d_theo (cost=0.57..5,091,143.67 rows=1,740,528 width=40) (actual time=0.035..1,932.265 rows=2,204,299 loops=1)

  • Index Cond: ((date_desserte >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_desserte <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_origine_realisation = '1'::numeric) AND ((id_ce_desserte = '-1'::numeric) OR (id_ce_desserte = '2'::numeric) OR (id_ce_desserte = '0'::numeric) OR (id_ce_desserte = '1'::numeric)))
  • Rows Removed by Filter: 798,289
14. 80.125 765.430 ↓ 1.2 192,696 1

Hash (cost=437,371.54..437,371.54 rows=154,914 width=60) (actual time=765.430..765.430 rows=192,696 loops=1)

  • Buckets: 131,072 (originally 131072) Batches: 4 (originally 2) Memory Usage: 7,715kB
15. 86.122 685.305 ↓ 1.2 192,696 1

Hash Left Join (cost=202,454.74..437,371.54 rows=154,914 width=60) (actual time=229.441..685.305 rows=192,696 loops=1)

  • Hash Cond: (t_theo.id_vacation_agent = va.id_vacation_agent)
16. 151.126 583.703 ↓ 1.2 192,696 1

Hash Left Join (cost=177,623.07..412,133.22 rows=154,914 width=60) (actual time=213.946..583.703 rows=192,696 loops=1)

  • Hash Cond: (t_theo.id_real_parcours = rp_theo.id_real_parcours)
17. 101.117 257.934 ↓ 1.2 192,696 1

Hash Left Join (cost=14,087.01..244,867.51 rows=154,914 width=39) (actual time=39.249..257.934 rows=192,696 loops=1)

  • Hash Cond: (t_theo.id_voiture_continue = vc.id_voiture_continue)
18. 119.090 134.787 ↓ 1.2 192,696 1

Bitmap Heap Scan on travail t_theo (cost=4,322.90..234,478.84 rows=154,914 width=37) (actual time=17.201..134.787 rows=192,696 loops=1)

  • Recheck Cond: ((date_travail >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_travail <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_travail IS NOT NULL) AND ((id_ce_travail = '-1'::numeric) OR (id_ce_travail = '2'::numeric) OR (id_ce_travail = '0'::numeric) OR (id_ce_travail = '1'::numeric)))
  • Heap Blocks: exact=12,912
19. 15.697 15.697 ↑ 1.0 192,696 1

Bitmap Index Scan on travail_date_ce_index (cost=0.00..4,284.17 rows=193,173 width=0) (actual time=15.697..15.697 rows=192,696 loops=1)

  • Index Cond: ((date_travail >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_travail <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
20. 3.214 22.030 ↓ 1.3 12,627 1

Hash (cost=9,641.32..9,641.32 rows=9,823 width=16) (actual time=22.030..22.030 rows=12,627 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 703kB
21. 5.397 18.816 ↓ 1.3 12,627 1

Hash Left Join (cost=3,300.13..9,641.32 rows=9,823 width=16) (actual time=7.951..18.816 rows=12,627 loops=1)

  • Hash Cond: (vc.id_service_voiture = sv.id_service_voiture)
22. 5.514 6.140 ↓ 1.3 12,627 1

Bitmap Heap Scan on voiture_continue vc (cost=284.35..6,599.76 rows=9,823 width=19) (actual time=0.659..6.140 rows=12,627 loops=1)

  • Recheck Cond: ((date_voiture_continue >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_voiture_continue <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_voiture_continue IS NOT NULL) AND ((id_ce_voiture_continue = '-1'::numeric) OR (id_ce_voiture_continue = '2'::numeric) OR (id_ce_voiture_continue = '0'::numeric) OR (id_ce_voiture_continue = '1'::numeric)))
  • Heap Blocks: exact=417
23. 0.626 0.626 ↓ 1.0 12,627 1

Bitmap Index Scan on voiture_continue_date_ce_index (cost=0.00..281.90 rows=12,547 width=0) (actual time=0.626..0.626 rows=12,627 loops=1)

  • Index Cond: ((date_voiture_continue >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_voiture_continue <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
24. 2.445 7.279 ↓ 1.3 12,627 1

Hash (cost=2,891.75..2,891.75 rows=9,922 width=11) (actual time=7.278..7.279 rows=12,627 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 655kB
25. 4.262 4.834 ↓ 1.3 12,627 1

Bitmap Heap Scan on service_voiture sv (cost=289.62..2,891.75 rows=9,922 width=11) (actual time=0.587..4.834 rows=12,627 loops=1)

  • Recheck Cond: ((date_service_voiture >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_service_voiture <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_service_voiture IS NOT NULL) AND ((id_ce_service_voiture = '-1'::numeric) OR (id_ce_service_voiture = '2'::numeric) OR (id_ce_service_voiture = '0'::numeric) OR (id_ce_service_voiture = '1'::numeric)))
  • Heap Blocks: exact=147
26. 0.572 0.572 ↑ 1.0 12,627 1

Bitmap Index Scan on service_voiture_date_ce_index (cost=0.00..287.14 rows=12,671 width=0) (actual time=0.572..0.572 rows=12,627 loops=1)

  • Index Cond: ((date_service_voiture >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_service_voiture <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
27. 44.605 174.643 ↓ 1.3 171,474 1

Hash (cost=160,989.05..160,989.05 rows=131,681 width=29) (actual time=174.643..174.643 rows=171,474 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 6,207kB
28. 118.990 130.038 ↓ 1.3 171,474 1

Bitmap Heap Scan on real_parcours rp_theo (cost=3,783.11..160,989.05 rows=131,681 width=29) (actual time=12.963..130.038 rows=171,474 loops=1)

  • Recheck Cond: ((date_real_parcours >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_real_parcours <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_real_parcours IS NOT NULL) AND ((id_ce_real_parcours = '-1'::numeric) OR (id_ce_real_parcours = '2'::numeric) OR (id_ce_real_parcours = '0'::numeric) OR (id_ce_real_parcours = '1'::numeric)))
  • Heap Blocks: exact=15,454
29. 11.048 11.048 ↓ 1.0 171,474 1

Bitmap Index Scan on real_parcours_date_ce_index (cost=0.00..3,750.19 rows=167,775 width=0) (actual time=11.048..11.048 rows=171,474 loops=1)

  • Index Cond: ((date_real_parcours >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_real_parcours <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
30. 4.459 15.480 ↓ 1.3 19,549 1

Hash (cost=24,646.32..24,646.32 rows=14,828 width=14) (actual time=15.480..15.480 rows=19,549 loops=1)

  • Buckets: 32,768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1,135kB
31. 9.975 11.021 ↓ 1.3 19,549 1

Bitmap Heap Scan on vacation_agent va (cost=457.01..24,646.32 rows=14,828 width=14) (actual time=1.184..11.021 rows=19,549 loops=1)

  • Recheck Cond: ((date_vacation_agent >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_vacation_agent <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_vacation_agent IS NOT NULL) AND ((id_ce_vacation_agent = '-1'::numeric) OR (id_ce_vacation_agent = '2'::numeric) OR (id_ce_vacation_agent = '0'::numeric) OR (id_ce_vacation_agent = '1'::numeric)))
  • Heap Blocks: exact=1,379
32. 1.046 1.046 ↑ 1.0 19,549 1

Bitmap Index Scan on vacation_agent_date_ce_index (cost=0.00..453.30 rows=19,687 width=0) (actual time=1.046..1.046 rows=19,549 loops=1)

  • Index Cond: ((date_vacation_agent >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_vacation_agent <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
33. 0.015 0.072 ↓ 1.4 56 1

Hash (cost=80.28..80.28 rows=39 width=47) (actual time=0.072..0.072 rows=56 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
34. 0.044 0.057 ↓ 1.4 56 1

Bitmap Heap Scan on calendrier c (cost=4.86..80.28 rows=39 width=47) (actual time=0.020..0.057 rows=56 loops=1)

  • Recheck Cond: ((date_calendrier >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_calendrier <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_ce_calendrier = '-1'::numeric) OR (id_ce_calendrier = '2'::numeric) OR (id_ce_calendrier = '0'::numeric) OR (id_ce_calendrier = '1'::numeric))
  • Heap Blocks: exact=11
35. 0.013 0.013 ↑ 1.0 56 1

Bitmap Index Scan on pk_calendrier (cost=0.00..4.86 rows=57 width=0) (actual time=0.013..0.013 rows=56 loops=1)

  • Index Cond: ((date_calendrier >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_calendrier <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
36. 59.784 491.466 ↓ 1.2 192,696 1

Hash (cost=401,138.55..401,138.55 rows=154,914 width=41) (actual time=491.466..491.466 rows=192,696 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 7,111kB
37. 135.465 431.682 ↓ 1.2 192,696 1

Hash Left Join (cost=167,858.96..401,138.55 rows=154,914 width=41) (actual time=180.486..431.682 rows=192,696 loops=1)

  • Hash Cond: (t_real.id_real_parcours = rp_real.id_real_parcours)
38. 117.140 127.199 ↓ 1.2 192,696 1

Bitmap Heap Scan on travail t_real (cost=4,322.90..234,478.84 rows=154,914 width=23) (actual time=11.416..127.199 rows=192,696 loops=1)

  • Recheck Cond: ((date_travail >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_travail <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_ce_travail = '-1'::numeric) OR (id_ce_travail = '2'::numeric) OR (id_ce_travail = '0'::numeric) OR (id_ce_travail = '1'::numeric))
  • Heap Blocks: exact=12,912
39. 10.059 10.059 ↑ 1.0 192,696 1

Bitmap Index Scan on travail_date_ce_index (cost=0.00..4,284.17 rows=193,173 width=0) (actual time=10.059..10.059 rows=192,696 loops=1)

  • Index Cond: ((date_travail >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_travail <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
40. 47.679 169.018 ↓ 1.3 171,474 1

Hash (cost=160,989.05..160,989.05 rows=131,681 width=26) (actual time=169.018..169.018 rows=171,474 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 5,686kB
41. 111.581 121.339 ↓ 1.3 171,474 1

Bitmap Heap Scan on real_parcours rp_real (cost=3,783.11..160,989.05 rows=131,681 width=26) (actual time=11.528..121.339 rows=171,474 loops=1)

  • Recheck Cond: ((date_real_parcours >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_real_parcours <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_ce_real_parcours = '-1'::numeric) OR (id_ce_real_parcours = '2'::numeric) OR (id_ce_real_parcours = '0'::numeric) OR (id_ce_real_parcours = '1'::numeric))
  • Heap Blocks: exact=15,454
42. 9.758 9.758 ↓ 1.0 171,474 1

Bitmap Index Scan on real_parcours_date_ce_index (cost=0.00..3,750.19 rows=167,775 width=0) (actual time=9.758..9.758 rows=171,474 loops=1)

  • Index Cond: ((date_real_parcours >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_real_parcours <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
43. 27.059 146.918 ↓ 1.3 92,784 1

Hash (cost=48,296.06..48,296.06 rows=71,220 width=37) (actual time=146.918..146.918 rows=92,784 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 6,708kB
44. 28.392 119.859 ↓ 1.3 92,784 1

Hash Left Join (cost=6,378.20..48,296.06 rows=71,220 width=37) (actual time=8.935..119.859 rows=92,784 loops=1)

  • Hash Cond: (p.id_sens = s.id_sens)
45. 16.501 91.385 ↓ 1.3 92,784 1

Hash Left Join (cost=6,332.74..48,063.51 rows=71,220 width=39) (actual time=8.850..91.385 rows=92,784 loops=1)

  • Hash Cond: (p.id_sous_ligne = sl.id_sous_ligne)
46. 33.518 74.860 ↓ 1.3 92,784 1

Hash Left Join (cost=6,330.80..47,874.61 rows=71,220 width=54) (actual time=8.821..74.860 rows=92,784 loops=1)

  • Hash Cond: (p.id_ligne = l.id_ligne)
47. 32.642 36.960 ↓ 1.3 92,784 1

Bitmap Heap Scan on parcours p (cost=2,156.86..43,513.72 rows=71,220 width=51) (actual time=4.430..36.960 rows=92,784 loops=1)

  • Recheck Cond: ((date_parcours >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_parcours <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_parcours IS NOT NULL) AND ((id_ce_parcours = '-1'::numeric) OR (id_ce_parcours = '2'::numeric) OR (id_ce_parcours = '0'::numeric) OR (id_ce_parcours = '1'::numeric)))
  • Heap Blocks: exact=1,322
48. 4.318 4.318 ↑ 1.0 92,784 1

Bitmap Index Scan on parcours_date_ce_index (cost=0.00..2,139.05 rows=93,862 width=0) (actual time=4.318..4.318 rows=92,784 loops=1)

  • Index Cond: ((date_parcours >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_parcours <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
49. 1.296 4.382 ↓ 1.3 7,630 1

Hash (cost=4,102.07..4,102.07 rows=5,750 width=17) (actual time=4.382..4.382 rows=7,630 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 434kB
50. 2.757 3.086 ↓ 1.3 7,630 1

Bitmap Heap Scan on ligne l (cost=178.17..4,102.07 rows=5,750 width=17) (actual time=0.342..3.086 rows=7,630 loops=1)

  • Recheck Cond: ((date_ligne >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_ligne <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_ligne IS NOT NULL) AND ((id_ce_ligne = '-1'::numeric) OR (id_ce_ligne = '2'::numeric) OR (id_ce_ligne = '0'::numeric) OR (id_ce_ligne = '1'::numeric)))
  • Heap Blocks: exact=106
51. 0.329 0.329 ↑ 1.0 7,630 1

Bitmap Index Scan on ligne_date_ce_index (cost=0.00..176.73 rows=7,630 width=0) (actual time=0.329..0.329 rows=7,630 loops=1)

  • Index Cond: ((date_ligne >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_ligne <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
52. 0.000 0.024 ↓ 0.0 0 1

Hash (cost=1.93..1.93 rows=1 width=12) (actual time=0.024..0.024 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
53. 0.024 0.024 ↓ 0.0 0 1

Seq Scan on sous_ligne sl (cost=0.00..1.93 rows=1 width=12) (actual time=0.024..0.024 rows=0 loops=1)

  • Filter: ((date_sous_ligne >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_sous_ligne <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)) AND ((id_ce_sous_ligne = '-1'::numeric) OR (id_ce_sous_ligne = '2'::numeric) OR (id_ce_sous_ligne = '0'::numeric) OR (id_ce_sous_ligne = '1'::numeric)))
  • Rows Removed by Filter: 31
54. 0.020 0.082 ↓ 1.4 126 1

Hash (cost=44.35..44.35 rows=89 width=12) (actual time=0.082..0.082 rows=126 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
55. 0.049 0.062 ↓ 1.4 126 1

Bitmap Heap Scan on sens s (cost=5.57..44.35 rows=89 width=12) (actual time=0.018..0.062 rows=126 loops=1)

  • Recheck Cond: ((date_sens >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_sens <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_sens IS NOT NULL) AND ((id_ce_sens = '-1'::numeric) OR (id_ce_sens = '2'::numeric) OR (id_ce_sens = '0'::numeric) OR (id_ce_sens = '1'::numeric)))
  • Heap Blocks: exact=2
56. 0.013 0.013 ↑ 1.0 126 1

Bitmap Index Scan on sens_date_ce_index (cost=0.00..5.55 rows=126 width=0) (actual time=0.013..0.013 rows=126 loops=1)

  • Index Cond: ((date_sens >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_sens <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
57. 3.040 9.198 ↓ 1.3 17,757 1

Hash (cost=4,091.18..4,091.18 rows=13,251 width=12) (actual time=9.198..9.198 rows=17,757 loops=1)

  • Buckets: 32,768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1,037kB
58. 5.399 6.158 ↓ 1.3 17,757 1

Bitmap Heap Scan on service_agent sa (cost=407.60..4,091.18 rows=13,251 width=12) (actual time=0.774..6.158 rows=17,757 loops=1)

  • Recheck Cond: ((date_service_agent >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_service_agent <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_service_agent IS NOT NULL) AND ((id_ce_service_agent = '-1'::numeric) OR (id_ce_service_agent = '2'::numeric) OR (id_ce_service_agent = '0'::numeric) OR (id_ce_service_agent = '1'::numeric)))
  • Heap Blocks: exact=114
59. 0.759 0.759 ↓ 1.0 17,757 1

Bitmap Index Scan on service_agent_date_ce_index (cost=0.00..404.29 rows=17,586 width=0) (actual time=0.759..0.759 rows=17,757 loops=1)

  • Index Cond: ((date_service_agent >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_service_agent <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
60. 1,000.387 2,072.904 ↑ 1.0 5,136,281 1

Hash (cost=142,175.81..142,175.81 rows=5,136,281 width=14) (actual time=2,072.904..2,072.904 rows=5,136,281 loops=1)

  • Buckets: 262,144 Batches: 64 Memory Usage: 5,810kB
61. 1,072.517 1,072.517 ↑ 1.0 5,136,281 1

Seq Scan on point_arret pavar (cost=0.00..142,175.81 rows=5,136,281 width=14) (actual time=0.029..1,072.517 rows=5,136,281 loops=1)

62. 158.237 889.159 ↓ 1.3 653,763 1

Hash (cost=1,007,328.28..1,007,328.28 rows=496,101 width=20) (actual time=889.159..889.159 rows=653,763 loops=1)

  • Buckets: 262,144 Batches: 8 Memory Usage: 6,415kB
63. 286.851 730.922 ↓ 1.3 653,763 1

Hash Left Join (cost=150,807.64..1,007,328.28 rows=496,101 width=20) (actual time=220.140..730.922 rows=653,763 loops=1)

  • Hash Cond: (pap.id_point_arret = pa.id_point_arret)
64. 225.158 256.005 ↓ 1.3 653,763 1

Bitmap Heap Scan on point_arret_parcours pap (cost=15,083.29..869,654.67 rows=496,101 width=12) (actual time=32.023..256.005 rows=653,763 loops=1)

  • Recheck Cond: ((date_point_arret_parcours >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_point_arret_parcours <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_point_arret_parcours IS NOT NULL) AND ((id_ce_point_arret_parcours = '-1'::numeric) OR (id_ce_point_arret_parcours = '2'::numeric) OR (id_ce_point_arret_parcours = '0'::numeric) OR (id_ce_point_arret_parcours = '1'::numeric)))
  • Heap Blocks: exact=9,066
65. 30.847 30.847 ↑ 1.0 653,763 1

Bitmap Index Scan on pap_date_ce_index (cost=0.00..14,959.27 rows=656,270 width=0) (actual time=30.847..30.847 rows=653,763 loops=1)

  • Index Cond: ((date_point_arret_parcours >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_point_arret_parcours <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
66. 34.130 188.066 ↓ 1.4 128,646 1

Hash (cost=134,574.10..134,574.10 rows=92,020 width=20) (actual time=188.066..188.066 rows=128,646 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 7,932kB
67. 54.861 153.936 ↓ 1.4 128,646 1

Hash Left Join (cost=34,988.38..134,574.10 rows=92,020 width=20) (actual time=52.137..153.936 rows=128,646 loops=1)

  • Hash Cond: (pa.id_arret = a.id_arret)
68. 47.200 53.124 ↓ 1.4 128,646 1

Bitmap Heap Scan on point_arret pa (cost=3,140.91..102,485.08 rows=92,020 width=20) (actual time=6.156..53.124 rows=128,646 loops=1)

  • Recheck Cond: ((date_point_arret >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_point_arret <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_point_arret IS NOT NULL) AND ((id_ce_point_arret = '-1'::numeric) OR (id_ce_point_arret = '2'::numeric) OR (id_ce_point_arret = '0'::numeric) OR (id_ce_point_arret = '1'::numeric)))
  • Heap Blocks: exact=2,361
69. 5.924 5.924 ↑ 1.0 128,646 1

Bitmap Index Scan on point_arret_date_ce_index (cost=0.00..3,117.91 rows=130,547 width=0) (actual time=5.924..5.924 rows=128,646 loops=1)

  • Index Cond: ((date_point_arret >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_point_arret <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
70. 15.842 45.951 ↓ 1.4 69,370 1

Hash (cost=31,238.18..31,238.18 rows=48,743 width=12) (actual time=45.951..45.951 rows=69,370 loops=1)

  • Buckets: 131,072 (originally 65536) Batches: 1 (originally 1) Memory Usage: 4,140kB
71. 26.972 30.109 ↓ 1.4 69,370 1

Bitmap Heap Scan on arret a (cost=1,664.01..31,238.18 rows=48,743 width=12) (actual time=3.204..30.109 rows=69,370 loops=1)

  • Recheck Cond: ((date_arret >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_arret <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_arret IS NOT NULL) AND ((id_ce_arret = '-1'::numeric) OR (id_ce_arret = '2'::numeric) OR (id_ce_arret = '0'::numeric) OR (id_ce_arret = '1'::numeric)))
  • Heap Blocks: exact=853
72. 3.137 3.137 ↓ 1.0 69,370 1

Bitmap Index Scan on arret_date_ce_index (cost=0.00..1,651.83 rows=69,139 width=0) (actual time=3.137..3.137 rows=69,370 loops=1)

  • Index Cond: ((date_arret >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_arret <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
73. 1.722 6.412 ↓ 1.1 8,073 1

Hash (cost=3,255.14..3,255.14 rows=7,165 width=23) (actual time=6.412..6.412 rows=8,073 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 508kB
74. 4.192 4.690 ↓ 1.1 8,073 1

Bitmap Heap Scan on vehicule v (cost=178.95..3,255.14 rows=7,165 width=23) (actual time=0.561..4.690 rows=8,073 loops=1)

  • Recheck Cond: ((date_vehicule >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_vehicule <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
  • Filter: ((id_ce_vehicule = '-1'::numeric) OR (id_ce_vehicule = '2'::numeric) OR (id_ce_vehicule = '0'::numeric) OR (id_ce_vehicule = '1'::numeric))
  • Heap Blocks: exact=738
75. 0.498 0.498 ↑ 1.0 8,073 1

Bitmap Index Scan on vehicule_date_ce_index (cost=0.00..177.16 rows=8,073 width=0) (actual time=0.498..0.498 rows=8,073 loops=1)

  • Index Cond: ((date_vehicule >= to_date('09/09/2019'::text, 'dd/mm/yyyy'::text)) AND (date_vehicule <= to_date('22/09/2019'::text, 'dd/mm/yyyy'::text)))
Planning time : 11.965 ms
Execution time : 28,399.990 ms