explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sUfg

Settings
# exclusive inclusive rows x rows loops node
1. 2,633.834 40,656.986 ↓ 0.0 0 1

Insert on desserte_tmp (cost=7,315,765.84..13,131,429.49 rows=1,780,213 width=612) (actual time=40,656.986..40,656.986 rows=0 loops=1)

2. 1,688.788 38,023.152 ↓ 1.2 2,210,456 1

Hash Left Join (cost=7,315,765.84..13,131,429.49 rows=1,780,213 width=612) (actual time=21,216.650..38,023.152 rows=2,210,456 loops=1)

  • Hash Cond: (t_real.id_vehicule = v.id_vehicule)
3. 3,636.851 36,248.439 ↓ 1.2 2,210,456 1

Hash Left Join (cost=7,312,421.13..13,114,510.64 rows=1,780,213 width=429) (actual time=21,130.709..36,248.439 rows=2,210,456 loops=1)

  • Hash Cond: (d_theo.id_point_arret_parcours = pap.id_point_arret_parcours)
4. 1,529.845 31,406.303 ↓ 1.2 2,210,456 1

Hash Left Join (cost=6,295,984.59..11,893,390.20 rows=1,780,213 width=421) (actual time=19,910.537..31,406.303 rows=2,210,456 loops=1)

  • Hash Cond: (va.id_service_agent = sa.id_service_agent)
5. 1,641.727 29,861.756 ↓ 1.2 2,210,456 1

Hash Left Join (cost=6,291,727.77..11,884,460.28 rows=1,780,213 width=423) (actual time=19,895.817..29,861.756 rows=2,210,456 loops=1)

  • Hash Cond: (rp_theo.id_parcours = p.id_parcours)
6. 1,502.746 28,065.512 ↓ 1.2 2,210,456 1

Hash Left Join (cost=6,242,541.47..11,828,146.12 rows=1,780,213 width=398) (actual time=19,741.250..28,065.512 rows=2,210,456 loops=1)

  • Hash Cond: (d_real.id_travail_depart = t_real.id_travail)
7. 1,391.133 25,823.015 ↓ 1.2 2,210,456 1

Hash Left Join (cost=5,787,913.79..11,198,069.93 rows=1,780,213 width=359) (actual time=19,001.445..25,823.015 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))
8. 2,512.990 24,431.544 ↓ 1.2 2,210,456 1

Hash Right Join (cost=5,787,818.58..11,188,620.78 rows=1,780,213 width=319) (actual time=19,001.096..24,431.544 rows=2,210,456 loops=1)

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

Index Scan using desserte_date_ce_index on desserte d_real (cost=0.57..5,205,753.61 rows=2,389,110 width=243) (actual time=0.078..2,919.897 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))
10. 880.704 18,998.657 ↓ 1.2 2,204,299 1

Hash (cost=5,741,226.34..5,741,226.34 rows=1,780,213 width=84) (actual time=18,998.657..18,998.657 rows=2,204,299 loops=1)

  • Buckets: 131,072 (originally 131072) Batches: 64 (originally 32) Memory Usage: 7,715kB
11. 1,841.376 18,117.953 ↓ 1.2 2,204,299 1

Hash Left Join (cost=491,164.24..5,741,226.34 rows=1,780,213 width=84) (actual time=1,041.572..18,117.953 rows=2,204,299 loops=1)

  • Hash Cond: (d_theo.id_travail_depart = t_theo.id_travail)
12. 15,258.793 15,258.793 ↓ 1.2 2,204,299 1

Index Scan using desserte_date_ce_index on desserte d_theo (cost=0.57..5,213,391.17 rows=1,780,213 width=40) (actual time=0.479..15,258.793 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
13. 77.245 1,017.784 ↓ 1.2 192,696 1

Hash (cost=487,562.24..487,562.24 rows=154,914 width=60) (actual time=1,017.784..1,017.784 rows=192,696 loops=1)

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

Hash Left Join (cost=252,621.44..487,562.24 rows=154,914 width=60) (actual time=473.593..940.539 rows=192,696 loops=1)

  • Hash Cond: (t_theo.id_vacation_agent = va.id_vacation_agent)
15. 142.579 773.111 ↓ 1.2 192,696 1

Hash Left Join (cost=227,789.77..462,323.92 rows=154,914 width=60) (actual time=387.032..773.111 rows=192,696 loops=1)

  • Hash Cond: (t_theo.id_real_parcours = rp_theo.id_real_parcours)
16. 95.275 314.636 ↓ 1.2 192,696 1

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

  • Hash Cond: (t_theo.id_voiture_continue = vc.id_voiture_continue)
17. 149.781 171.034 ↓ 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=22.666..171.034 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
18. 21.253 21.253 ↑ 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=21.252..21.253 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)))
19. 3.111 48.327 ↓ 1.3 12,627 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 703kB
20. 5.574 45.216 ↓ 1.3 12,627 1

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

  • Hash Cond: (vc.id_service_voiture = sv.id_service_voiture)
21. 24.342 26.361 ↓ 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=2.253..26.361 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
22. 2.019 2.019 ↓ 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=2.019..2.019 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)))
23. 2.496 13.281 ↓ 1.3 12,627 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 655kB
24. 8.381 10.785 ↓ 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=2.581..10.785 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
25. 2.404 2.404 ↑ 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=2.404..2.404 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)))
26. 47.477 315.896 ↓ 1.3 171,474 1

Hash (cost=211,086.73..211,086.73 rows=135,283 width=29) (actual time=315.896..315.896 rows=171,474 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 6,207kB
27. 254.529 268.419 ↓ 1.3 171,474 1

Bitmap Heap Scan on real_parcours rp_theo (cost=4,641.72..211,086.73 rows=135,283 width=29) (actual time=15.727..268.419 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
28. 13.890 13.890 ↑ 1.0 171,474 1

Bitmap Index Scan on real_parcours_date_ce_index (cost=0.00..4,607.90 rows=172,346 width=0) (actual time=13.890..13.890 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)))
29. 5.089 86.536 ↓ 1.3 19,549 1

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

  • Buckets: 32,768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1,135kB
30. 78.596 81.447 ↓ 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=3.373..81.447 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
31. 2.851 2.851 ↑ 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=2.851..2.851 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)))
32. 0.043 0.338 ↓ 1.4 56 1

Hash (cost=94.62..94.62 rows=39 width=47) (actual time=0.338..0.338 rows=56 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
33. 0.046 0.295 ↓ 1.4 56 1

Bitmap Heap Scan on calendrier c (cost=4.86..94.62 rows=39 width=47) (actual time=0.257..0.295 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
34. 0.249 0.249 ↑ 1.0 56 1

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

Hash (cost=451,329.26..451,329.26 rows=154,914 width=47) (actual time=739.751..739.751 rows=192,696 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 7,111kB
36. 138.916 678.206 ↓ 1.2 192,696 1

Hash Left Join (cost=218,025.66..451,329.26 rows=154,914 width=47) (actual time=389.026..678.206 rows=192,696 loops=1)

  • Hash Cond: (t_real.id_real_parcours = rp_real.id_real_parcours)
37. 151.656 163.598 ↓ 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=13.284..163.598 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
38. 11.942 11.942 ↑ 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=11.942..11.942 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)))
39. 52.239 375.692 ↓ 1.3 171,474 1

Hash (cost=211,086.73..211,086.73 rows=135,283 width=32) (actual time=375.692..375.692 rows=171,474 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 5,686kB
40. 311.908 323.453 ↓ 1.3 171,474 1

Bitmap Heap Scan on real_parcours rp_real (cost=4,641.72..211,086.73 rows=135,283 width=32) (actual time=13.455..323.453 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
41. 11.545 11.545 ↑ 1.0 171,474 1

Bitmap Index Scan on real_parcours_date_ce_index (cost=0.00..4,607.90 rows=172,346 width=0) (actual time=11.545..11.545 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)))
42. 27.280 154.517 ↓ 1.3 92,784 1

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

  • Buckets: 131,072 Batches: 1 Memory Usage: 6,708kB
43. 29.591 127.237 ↓ 1.3 92,784 1

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

  • Hash Cond: (p.id_sens = s.id_sens)
44. 16.614 97.286 ↓ 1.3 92,784 1

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

  • Hash Cond: (p.id_sous_ligne = sl.id_sous_ligne)
45. 34.636 80.643 ↓ 1.3 92,784 1

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

  • Hash Cond: (p.id_ligne = l.id_ligne)
46. 33.567 40.433 ↓ 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=6.981..40.433 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
47. 6.866 6.866 ↑ 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=6.866..6.866 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)))
48. 1.371 5.574 ↓ 1.3 7,630 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 434kB
49. 2.882 4.203 ↓ 1.3 7,630 1

Bitmap Heap Scan on ligne l (cost=178.17..4,102.07 rows=5,750 width=17) (actual time=1.339..4.203 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
50. 1.321 1.321 ↑ 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=1.321..1.321 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)))
51. 0.000 0.029 ↓ 0.0 0 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
52. 0.029 0.029 ↓ 0.0 0 1

Seq Scan on sous_ligne sl (cost=0.00..1.93 rows=1 width=12) (actual time=0.029..0.029 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
53. 0.021 0.360 ↓ 1.4 126 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
54. 0.052 0.339 ↓ 1.4 126 1

Bitmap Heap Scan on sens s (cost=5.57..44.35 rows=89 width=12) (actual time=0.295..0.339 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
55. 0.287 0.287 ↑ 1.0 126 1

Bitmap Index Scan on sens_date_ce_index (cost=0.00..5.55 rows=126 width=0) (actual time=0.287..0.287 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)))
56. 3.907 14.702 ↓ 1.3 17,757 1

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

  • Buckets: 32,768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1,037kB
57. 8.291 10.795 ↓ 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=2.704..10.795 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
58. 2.504 2.504 ↓ 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=2.504..2.504 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)))
59. 188.836 1,205.285 ↓ 1.3 653,763 1

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

  • Buckets: 262,144 Batches: 8 Memory Usage: 6,415kB
60. 339.020 1,016.449 ↓ 1.3 653,763 1

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

  • Hash Cond: (pap.id_point_arret = pa.id_point_arret)
61. 346.990 389.672 ↓ 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=43.954..389.672 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
62. 42.682 42.682 ↑ 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=42.682..42.682 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)))
63. 41.958 287.757 ↓ 1.4 128,646 1

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

  • Buckets: 131,072 Batches: 1 Memory Usage: 7,932kB
64. 68.878 245.799 ↓ 1.4 128,646 1

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

  • Hash Cond: (pa.id_arret = a.id_arret)
65. 88.904 98.683 ↓ 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=10.232..98.683 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
66. 9.779 9.779 ↑ 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=9.779..9.779 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)))
67. 18.328 78.238 ↓ 1.4 69,370 1

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

  • Buckets: 131,072 (originally 65536) Batches: 1 (originally 1) Memory Usage: 4,140kB
68. 54.095 59.910 ↓ 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=6.186..59.910 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
69. 5.815 5.815 ↓ 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=5.815..5.815 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)))
70. 2.214 85.925 ↓ 1.1 8,073 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 508kB
71. 82.166 83.711 ↓ 1.1 8,073 1

Bitmap Heap Scan on vehicule v (cost=178.95..3,255.14 rows=7,165 width=23) (actual time=1.889..83.711 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
72. 1.545 1.545 ↑ 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=1.545..1.545 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 : 31.809 ms
Execution time : 40,657.655 ms