explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F2KH

Settings
# exclusive inclusive rows x rows loops node
1. 2,503.038 28,854.831 ↓ 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,854.831..28,854.831 rows=0 loops=1)

2. 1,691.282 26,351.793 ↓ 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,881.964..26,351.793 rows=2,210,456 loops=1)

  • Hash Cond: (t_real.id_vehicule = v.id_vehicule)
3. 3,640.131 24,654.459 ↓ 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,875.898..24,654.459 rows=2,210,456 loops=1)

  • Hash Cond: (d_theo.id_point_arret_parcours = pap.id_point_arret_parcours)
4. 893.270 20,145.204 ↓ 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,998.593..20,145.204 rows=2,210,456 loops=1)

  • Hash Cond: (d_real.id_point_arret_variante = pavar.id_point_arret)
5. 1,522.570 17,188.603 ↓ 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,935.155..17,188.603 rows=2,210,456 loops=1)

  • Hash Cond: (va.id_service_agent = sa.id_service_agent)
6. 1,655.767 15,655.622 ↓ 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,924.728..15,655.622 rows=2,210,456 loops=1)

  • Hash Cond: (rp_theo.id_parcours = p.id_parcours)
7. 1,525.484 13,854.285 ↓ 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,779.108..13,854.285 rows=2,210,456 loops=1)

  • Hash Cond: (d_real.id_travail_depart = t_real.id_travail)
8. 1,396.849 11,813.588 ↓ 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,263.844..11,813.588 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,505.418 10,416.666 ↓ 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,263.760..10,416.666 rows=2,210,456 loops=1)

  • Hash Cond: (d_real.id_desserte_theo = d_theo.id_desserte)
10. 2,649.013 2,649.013 ↓ 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.043..2,649.013 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. 838.210 5,262.235 ↓ 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,262.235..5,262.235 rows=2,204,299 loops=1)

  • Buckets: 131,072 (originally 131072) Batches: 64 (originally 32) Memory Usage: 7,715kB
12. 1,719.550 4,424.025 ↓ 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=729.096..4,424.025 rows=2,204,299 loops=1)

  • Hash Cond: (d_theo.id_travail_depart = t_theo.id_travail)
13. 1,975.944 1,975.944 ↓ 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.040..1,975.944 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. 76.308 728.531 ↓ 1.2 192,696 1

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

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

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

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

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

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

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

  • Hash Cond: (t_theo.id_voiture_continue = vc.id_voiture_continue)
18. 111.586 121.772 ↓ 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=11.587..121.772 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. 10.186 10.186 ↑ 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.186..10.186 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. 2.444 19.101 ↓ 1.3 12,627 1

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

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

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

  • Hash Cond: (vc.id_service_voiture = sv.id_service_voiture)
22. 4.756 5.348 ↓ 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.623..5.348 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.592 0.592 ↓ 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.592..0.592 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.064 6.824 ↓ 1.3 12,627 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 655kB
25. 4.228 4.760 ↓ 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.545..4.760 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.532 0.532 ↑ 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.532..0.532 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. 43.543 169.917 ↓ 1.3 171,474 1

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

  • Buckets: 131,072 Batches: 2 Memory Usage: 6,207kB
28. 115.550 126.374 ↓ 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.883..126.374 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. 10.824 10.824 ↓ 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=10.823..10.824 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. 3.767 14.862 ↓ 1.3 19,549 1

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

  • Buckets: 32,768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1,135kB
31. 10.040 11.095 ↓ 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.179..11.095 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.055 1.055 ↑ 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.055..1.055 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.016 0.073 ↓ 1.4 56 1

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

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

Bitmap Heap Scan on calendrier c (cost=4.86..80.28 rows=39 width=47) (actual time=0.021..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.014 0.014 ↑ 1.0 56 1

Bitmap Index Scan on pk_calendrier (cost=0.00..4.86 rows=57 width=0) (actual time=0.014..0.014 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. 63.867 515.213 ↓ 1.2 192,696 1

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

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

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

  • Hash Cond: (t_real.id_real_parcours = rp_real.id_real_parcours)
38. 117.982 127.926 ↓ 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.358..127.926 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. 9.944 9.944 ↑ 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=9.944..9.944 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. 51.119 181.279 ↓ 1.3 171,474 1

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

  • Buckets: 131,072 Batches: 2 Memory Usage: 5,686kB
41. 120.176 130.160 ↓ 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.787..130.160 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.984 9.984 ↓ 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.984..9.984 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. 26.617 145.570 ↓ 1.3 92,784 1

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

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

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

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

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

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

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

  • Hash Cond: (p.id_ligne = l.id_ligne)
47. 31.979 36.438 ↓ 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.575..36.438 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.459 4.459 ↑ 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.459..4.459 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.339 4.524 ↓ 1.3 7,630 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 434kB
50. 2.859 3.185 ↓ 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.339..3.185 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.326 0.326 ↑ 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.326..0.326 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.001 0.025 ↓ 0.0 0 1

Hash (cost=1.93..1.93 rows=1 width=12) (actual time=0.025..0.025 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.021 0.083 ↓ 1.4 126 1

Hash (cost=44.35..44.35 rows=89 width=12) (actual time=0.083..0.083 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.019..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.695 10.411 ↓ 1.3 17,757 1

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

  • Buckets: 32,768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1,037kB
58. 5.884 6.716 ↓ 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.848..6.716 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.832 0.832 ↓ 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.832..0.832 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. 998.454 2,063.331 ↑ 1.0 5,136,281 1

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

  • Buckets: 262,144 Batches: 64 Memory Usage: 5,810kB
61. 1,064.877 1,064.877 ↑ 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.042..1,064.877 rows=5,136,281 loops=1)

62. 158.974 869.124 ↓ 1.3 653,763 1

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

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

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

  • Hash Cond: (pap.id_point_arret = pa.id_point_arret)
64. 226.940 258.274 ↓ 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.339..258.274 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. 31.334 31.334 ↑ 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=31.334..31.334 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. 32.863 184.059 ↓ 1.4 128,646 1

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

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

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

  • Hash Cond: (pa.id_arret = a.id_arret)
68. 48.216 54.770 ↓ 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.764..54.770 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. 6.554 6.554 ↑ 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=6.554..6.554 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. 12.760 43.188 ↓ 1.4 69,370 1

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

  • Buckets: 131,072 (originally 65536) Batches: 1 (originally 1) Memory Usage: 4,140kB
71. 27.176 30.428 ↓ 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.320..30.428 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.252 3.252 ↓ 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.252..3.252 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.552 6.052 ↓ 1.1 8,073 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 508kB
74. 4.073 4.500 ↓ 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.489..4.500 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.427 0.427 ↑ 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.427..0.427 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 : 12.791 ms
Execution time : 28,855.610 ms