explain.depesz.com

PostgreSQL's explain analyze made readable

Result: blwU

Settings
# exclusive inclusive rows x rows loops node
1. 997.045 144,704.469 ↓ 1.3 2,210,456 1

Gather (cost=6,071,965.28..10,877,139.64 rows=1,740,528 width=420) (actual time=142,570.991..144,704.469 rows=2,210,456 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 414.051 143,707.424 ↓ 1.0 736,819 3 / 3

Parallel Hash Left Join (cost=6,070,965.28..10,702,086.84 rows=725,220 width=420) (actual time=142,554.891..143,707.424 rows=736,819 loops=3)

  • Hash Cond: (t_real.id_vehicule = v.id_vehicule)
3. 1,209.078 143,291.296 ↓ 1.0 736,819 3 / 3

Parallel Hash Left Join (cost=6,067,757.18..10,695,161.97 rows=725,220 width=388) (actual time=142,552.663..143,291.296 rows=736,819 loops=3)

  • Hash Cond: (d_theo.id_point_arret_parcours = pap.id_point_arret_parcours)
4. 1,253.414 141,706.979 ↓ 1.0 736,819 3 / 3

Parallel Hash Left Join (cost=5,375,055.06..9,926,222.23 rows=725,220 width=380) (actual time=141,247.893..141,706.979 rows=736,819 loops=3)

  • Hash Cond: (d_real.id_point_arret_variante = pavar.id_point_arret)
5. 485.457 139,716.283 ↓ 1.0 736,819 3 / 3

Parallel Hash Left Join (cost=5,225,639.43..9,690,796.89 rows=725,220 width=392) (actual time=137,524.618..139,716.283 rows=736,819 loops=3)

  • Hash Cond: (va.id_service_agent = sa.id_service_agent)
6. 447.608 139,226.341 ↓ 1.0 736,819 3 / 3

Parallel Hash Left Join (cost=5,221,786.99..9,685,040.74 rows=725,220 width=394) (actual time=137,520.054..139,226.341 rows=736,819 loops=3)

  • Hash Cond: (d_real.id_travail_depart = t_real.id_travail)
7. 520.160 138,547.926 ↓ 1.0 736,819 3 / 3

Parallel Hash Left Join (cost=4,830,973.56..9,291,420.37 rows=725,220 width=361) (actual time=137,288.725..138,547.926 rows=736,819 loops=3)

  • Hash Cond: (rp_theo.id_parcours = p.id_parcours)
8. 1,076.163 137,967.852 ↓ 1.0 736,819 3 / 3

Parallel Hash Left Join (cost=4,784,451.85..9,242,102.35 rows=725,220 width=336) (actual time=137,228.657..137,967.852 rows=736,819 loops=3)

  • Hash Cond: (d_theo.id_travail_depart = t_theo.id_travail)
9. 849.473 136,562.369 ↓ 1.0 736,819 3 / 3

Parallel Hash Left Join (cost=4,359,170.02..8,814,013.58 rows=725,220 width=257) (actual time=136,006.200..136,562.369 rows=736,819 loops=3)

  • Hash Cond: (d_theo.id_desserte = d_real.id_desserte_theo)
10. 67,113.609 67,113.609 ↓ 1.0 734,766 3 / 3

Parallel Seq Scan on desserte d_theo (cost=0.00..4,409,474.82 rows=725,220 width=40) (actual time=7,458.130..67,113.609 rows=734,766 loops=3)

  • Filter: ((id_origine_realisation = '1'::numeric) AND (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)) 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: 28,977,605
11. 174.811 68,599.287 ↓ 1.0 1,000,863 3 / 3

Parallel Hash (cost=4,316,621.60..4,316,621.60 rows=972,514 width=225) (actual time=68,599.287..68,599.287 rows=1,000,863 loops=3)

  • Buckets: 32,768 Batches: 128 Memory Usage: 864kB
12. 68,424.476 68,424.476 ↓ 1.0 1,000,863 3 / 3

Parallel Seq Scan on desserte d_real (cost=0.00..4,316,621.60 rows=972,514 width=225) (actual time=14,494.415..68,424.476 rows=1,000,863 loops=3)

  • Filter: ((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)) 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: 28,711,509
13. 44.740 329.320 ↑ 1.0 64,232 3 / 3

Parallel Hash (cost=424,474.97..424,474.97 rows=64,548 width=95) (actual time=329.320..329.320 rows=64,232 loops=3)

  • Buckets: 65,536 (originally 262144) Batches: 8 (originally 1) Memory Usage: 4,128kB
14. 28.555 284.580 ↑ 1.0 64,232 3 / 3

Parallel Hash Left Join (cost=196,771.88..424,474.97 rows=64,548 width=95) (actual time=108.088..284.580 rows=64,232 loops=3)

  • Hash Cond: (t_theo.id_vacation_agent = va.id_vacation_agent)
15. 40.119 248.947 ↑ 1.0 64,232 3 / 3

Parallel Hash Left Join (cost=172,392.87..399,926.51 rows=64,548 width=95) (actual time=100.968..248.947 rows=64,232 loops=3)

  • Hash Cond: (t_theo.id_real_parcours = rp_theo.id_real_parcours)
16. 31.007 130.960 ↑ 1.0 64,232 3 / 3

Hash Left Join (cost=13,654.04..241,018.25 rows=64,548 width=74) (actual time=22.863..130.960 rows=64,232 loops=3)

  • Hash Cond: ((t_theo.date_travail = c.date_calendrier) AND (t_theo.id_ce_travail = c.id_ce_calendrier))
17. 33.595 99.854 ↑ 1.0 64,232 3 / 3

Parallel Hash Left Join (cost=13,573.17..240,598.22 rows=64,548 width=34) (actual time=22.715..99.854 rows=64,232 loops=3)

  • Hash Cond: (t_theo.id_voiture_continue = vc.id_voiture_continue)
18. 52.210 55.678 ↑ 1.0 64,232 3 / 3

Parallel Bitmap Heap Scan on travail t_theo (cost=4,322.90..231,098.31 rows=64,548 width=37) (actual time=12.091..55.678 rows=64,232 loops=3)

  • 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=4,252
19. 3.468 3.468 ↑ 1.0 192,696 1 / 3

Bitmap Index Scan on travail_date_ce_index (cost=0.00..4,284.17 rows=193,173 width=0) (actual time=10.405..10.405 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. 1.287 10.581 ↓ 1.0 4,209 3 / 3

Parallel Hash (cost=9,199.11..9,199.11 rows=4,093 width=11) (actual time=10.581..10.581 rows=4,209 loops=3)

  • Buckets: 16,384 Batches: 1 Memory Usage: 768kB
21. 1.983 9.294 ↓ 1.0 4,209 3 / 3

Parallel Hash Left Join (cost=3,092.53..9,199.11 rows=4,093 width=11) (actual time=4.831..9.294 rows=4,209 loops=3)

  • Hash Cond: (vc.id_service_voiture = sv.id_service_voiture)
22. 3.166 3.451 ↓ 1.0 4,209 3 / 3

Parallel Bitmap Heap Scan on voiture_continue vc (cost=284.35..6,380.19 rows=4,093 width=14) (actual time=0.923..3.451 rows=4,209 loops=3)

  • 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=121
23. 0.285 0.285 ↓ 1.0 12,627 1 / 3

Bitmap Index Scan on voiture_continue_date_ce_index (cost=0.00..281.90 rows=12,547 width=0) (actual time=0.855..0.855 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. 1.151 3.860 ↑ 1.4 4,209 3 / 3

Parallel Hash (cost=2,735.22..2,735.22 rows=5,836 width=11) (actual time=3.860..3.860 rows=4,209 loops=3)

  • Buckets: 16,384 Batches: 1 Memory Usage: 736kB
25. 2.489 2.709 ↑ 1.4 4,209 3 / 3

Parallel Bitmap Heap Scan on service_voiture sv (cost=289.62..2,735.22 rows=5,836 width=11) (actual time=0.699..2.709 rows=4,209 loops=3)

  • 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=37
26. 0.220 0.220 ↑ 1.0 12,627 1 / 3

Bitmap Index Scan on service_voiture_date_ce_index (cost=0.00..287.14 rows=12,671 width=0) (actual time=0.659..0.659 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. 0.020 0.099 ↓ 1.4 56 3 / 3

Hash (cost=80.28..80.28 rows=39 width=47) (actual time=0.099..0.099 rows=56 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
28. 0.057 0.079 ↓ 1.4 56 3 / 3

Bitmap Heap Scan on calendrier c (cost=4.86..80.28 rows=39 width=47) (actual time=0.031..0.079 rows=56 loops=3)

  • 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
29. 0.022 0.022 ↑ 1.0 56 3 / 3

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

  • 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)))
30. 20.929 77.868 ↓ 1.0 57,158 3 / 3

Parallel Hash (cost=158,052.99..158,052.99 rows=54,867 width=29) (actual time=77.868..77.868 rows=57,158 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 13,824kB
31. 53.393 56.939 ↓ 1.0 57,158 3 / 3

Parallel Bitmap Heap Scan on real_parcours rp_theo (cost=3,783.11..158,052.99 rows=54,867 width=29) (actual time=13.132..56.939 rows=57,158 loops=3)

  • 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=4,949
32. 3.546 3.546 ↓ 1.0 171,474 1 / 3

Bitmap Index Scan on real_parcours_date_ce_index (cost=0.00..3,750.19 rows=167,775 width=0) (actual time=10.639..10.639 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)))
33. 1.713 7.078 ↓ 1.1 6,516 3 / 3

Parallel Hash (cost=24,301.79..24,301.79 rows=6,178 width=14) (actual time=7.078..7.078 rows=6,516 loops=3)

  • Buckets: 32,768 (originally 16384) Batches: 1 (originally 1) Memory Usage: 1,344kB
34. 4.950 5.365 ↓ 1.1 6,516 3 / 3

Parallel Bitmap Heap Scan on vacation_agent va (cost=457.01..24,301.79 rows=6,178 width=14) (actual time=1.407..5.365 rows=6,516 loops=3)

  • 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=538
35. 0.415 0.415 ↑ 1.0 19,549 1 / 3

Bitmap Index Scan on vacation_agent_date_ce_index (cost=0.00..453.30 rows=19,687 width=0) (actual time=1.245..1.245 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)))
36. 11.167 59.914 ↓ 1.0 30,928 3 / 3

Parallel Hash (cost=46,150.78..46,150.78 rows=29,675 width=37) (actual time=59.913..59.914 rows=30,928 loops=3)

  • Buckets: 131,072 Batches: 1 Memory Usage: 7,104kB
37. 10.079 48.747 ↓ 1.0 30,928 3 / 3

Hash Left Join (cost=6,202.75..46,150.78 rows=29,675 width=37) (actual time=8.676..48.747 rows=30,928 loops=3)

  • Hash Cond: (p.id_sens = s.id_sens)
38. 5.921 38.551 ↓ 1.0 30,928 3 / 3

Hash Left Join (cost=6,157.29..46,027.36 rows=29,675 width=39) (actual time=8.552..38.551 rows=30,928 loops=3)

  • Hash Cond: (p.id_sous_ligne = sl.id_sous_ligne)
39. 11.980 32.571 ↓ 1.0 30,928 3 / 3

Parallel Hash Left Join (cost=6,155.35..45,947.52 rows=29,675 width=54) (actual time=8.485..32.571 rows=30,928 loops=3)

  • Hash Cond: (p.id_ligne = l.id_ligne)
40. 16.245 18.211 ↓ 1.0 30,928 3 / 3

Parallel Bitmap Heap Scan on parcours p (cost=2,156.86..41,871.14 rows=29,675 width=51) (actual time=6.067..18.211 rows=30,928 loops=3)

  • 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=453
41. 1.966 1.966 ↑ 1.0 92,784 1 / 3

Bitmap Index Scan on parcours_date_ce_index (cost=0.00..2,139.05 rows=93,862 width=0) (actual time=5.898..5.898 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)))
42. 0.714 2.380 ↓ 1.1 2,543 3 / 3

Parallel Hash (cost=3,968.54..3,968.54 rows=2,396 width=17) (actual time=2.380..2.380 rows=2,543 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 512kB
43. 1.522 1.666 ↓ 1.1 2,543 3 / 3

Parallel Bitmap Heap Scan on ligne l (cost=178.17..3,968.54 rows=2,396 width=17) (actual time=0.462..1.666 rows=2,543 loops=3)

  • 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=41
44. 0.144 0.144 ↑ 1.0 7,630 1 / 3

Bitmap Index Scan on ligne_date_ce_index (cost=0.00..176.73 rows=7,630 width=0) (actual time=0.433..0.433 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)))
45. 0.000 0.059 ↓ 0.0 0 3 / 3

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
46. 0.059 0.059 ↓ 0.0 0 3 / 3

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

  • 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
47. 0.025 0.117 ↓ 1.4 126 3 / 3

Hash (cost=44.35..44.35 rows=89 width=12) (actual time=0.117..0.117 rows=126 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
48. 0.067 0.092 ↓ 1.4 126 3 / 3

Bitmap Heap Scan on sens s (cost=5.57..44.35 rows=89 width=12) (actual time=0.036..0.092 rows=126 loops=3)

  • 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
49. 0.025 0.025 ↑ 1.0 126 3 / 3

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

  • 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)))
50. 29.296 230.807 ↑ 1.0 64,232 3 / 3

Parallel Hash (cost=390,006.58..390,006.58 rows=64,548 width=41) (actual time=230.807..230.807 rows=64,232 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 14,880kB
51. 47.582 201.511 ↑ 1.0 64,232 3 / 3

Parallel Hash Left Join (cost=163,061.72..390,006.58 rows=64,548 width=41) (actual time=105.058..201.511 rows=64,232 loops=3)

  • Hash Cond: (t_real.id_real_parcours = rp_real.id_real_parcours)
52. 58.591 62.446 ↑ 1.0 64,232 3 / 3

Parallel Bitmap Heap Scan on travail t_real (cost=4,322.90..231,098.31 rows=64,548 width=23) (actual time=13.325..62.446 rows=64,232 loops=3)

  • 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=4,685
53. 3.855 3.855 ↑ 1.0 192,696 1 / 3

Bitmap Index Scan on travail_date_ce_index (cost=0.00..4,284.17 rows=193,173 width=0) (actual time=11.566..11.566 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)))
54. 23.505 91.483 ↓ 1.0 57,158 3 / 3

Parallel Hash (cost=158,052.99..158,052.99 rows=54,867 width=26) (actual time=91.482..91.483 rows=57,158 loops=3)

  • Buckets: 262,144 Batches: 1 Memory Usage: 11,840kB
55. 64.497 67.978 ↓ 1.0 57,158 3 / 3

Parallel Bitmap Heap Scan on real_parcours rp_real (cost=3,783.11..158,052.99 rows=54,867 width=26) (actual time=12.787..67.978 rows=57,158 loops=3)

  • 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=5,585
56. 3.481 3.481 ↓ 1.0 171,474 1 / 3

Bitmap Index Scan on real_parcours_date_ce_index (cost=0.00..3,750.19 rows=167,775 width=0) (actual time=10.444..10.444 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)))
57. 1.244 4.485 ↓ 1.1 5,919 3 / 3

Parallel Hash (cost=3,783.43..3,783.43 rows=5,521 width=12) (actual time=4.485..4.485 rows=5,919 loops=3)

  • Buckets: 16,384 Batches: 1 Memory Usage: 992kB
58. 2.846 3.241 ↓ 1.1 5,919 3 / 3

Parallel Bitmap Heap Scan on service_agent sa (cost=407.60..3,783.43 rows=5,521 width=12) (actual time=1.224..3.241 rows=5,919 loops=3)

  • 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=39
59. 0.395 0.395 ↓ 1.0 17,757 1 / 3

Bitmap Index Scan on service_agent_date_ce_index (cost=0.00..404.29 rows=17,586 width=0) (actual time=1.184..1.184 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. 350.592 737.282 ↑ 1.2 1,712,094 3 / 3

Parallel Hash (cost=112,214.17..112,214.17 rows=2,140,117 width=14) (actual time=737.282..737.282 rows=1,712,094 loops=3)

  • Buckets: 262,144 Batches: 64 Memory Usage: 5,856kB
61. 386.690 386.690 ↑ 1.2 1,712,094 3 / 3

Parallel Seq Scan on point_arret pavar (cost=0.00..112,214.17 rows=2,140,117 width=14) (actual time=0.023..386.690 rows=1,712,094 loops=3)

62. 58.798 375.239 ↓ 1.1 217,921 3 / 3

Parallel Hash (cost=688,906.26..688,906.26 rows=206,709 width=20) (actual time=375.239..375.239 rows=217,921 loops=3)

  • Buckets: 262,144 Batches: 8 Memory Usage: 6,592kB
63. 100.710 316.441 ↓ 1.1 217,921 3 / 3

Parallel Hash Left Join (cost=146,145.84..688,906.26 rows=206,709 width=20) (actual time=126.236..316.441 rows=217,921 loops=3)

  • Hash Cond: (pap.id_point_arret = pa.id_point_arret)
64. 121.136 136.184 ↓ 1.1 217,921 3 / 3

Parallel Bitmap Heap Scan on point_arret_parcours pap (cost=15,083.29..557,053.12 rows=206,709 width=12) (actual time=46.485..136.184 rows=217,921 loops=3)

  • 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=3,148
65. 15.048 15.048 ↑ 1.0 653,763 1 / 3

Bitmap Index Scan on pap_date_ce_index (cost=0.00..14,959.27 rows=656,270 width=0) (actual time=45.142..45.143 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. 12.958 79.547 ↓ 1.1 42,882 3 / 3

Parallel Hash (cost=130,583.28..130,583.28 rows=38,342 width=20) (actual time=79.547..79.547 rows=42,882 loops=3)

  • Buckets: 131,072 Batches: 1 Memory Usage: 8,128kB
67. 19.478 66.589 ↓ 1.1 42,882 3 / 3

Parallel Hash Left Join (cost=33,423.04..130,583.28 rows=38,342 width=20) (actual time=29.677..66.589 rows=42,882 loops=3)

  • Hash Cond: (pa.id_arret = a.id_arret)
68. 22.464 24.727 ↓ 1.1 42,882 3 / 3

Parallel Bitmap Heap Scan on point_arret pa (cost=3,140.91..100,200.50 rows=38,342 width=20) (actual time=7.107..24.727 rows=42,882 loops=3)

  • 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=818
69. 2.263 2.263 ↑ 1.0 128,646 1 / 3

Bitmap Index Scan on point_arret_date_ce_index (cost=0.00..3,117.91 rows=130,547 width=0) (actual time=6.789..6.789 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. 7.045 22.384 ↓ 1.1 23,123 3 / 3

Parallel Hash (cost=30,028.25..30,028.25 rows=20,310 width=12) (actual time=22.384..22.384 rows=23,123 loops=3)

  • Buckets: 131,072 (originally 65536) Batches: 1 (originally 1) Memory Usage: 4,832kB
71. 13.854 15.339 ↓ 1.1 23,123 3 / 3

Parallel Bitmap Heap Scan on arret a (cost=1,664.01..30,028.25 rows=20,310 width=12) (actual time=4.584..15.339 rows=23,123 loops=3)

  • 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=377
72. 1.485 1.485 ↓ 1.0 69,370 1 / 3

Bitmap Index Scan on arret_date_ce_index (cost=0.00..1,651.83 rows=69,139 width=0) (actual time=4.456..4.456 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. 0.566 2.077 ↑ 1.6 2,691 3 / 3

Parallel Hash (cost=3,155.41..3,155.41 rows=4,215 width=18) (actual time=2.077..2.077 rows=2,691 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 512kB
74. 1.351 1.511 ↓ 1.9 8,073 1 / 3

Parallel Bitmap Heap Scan on vehicule v (cost=178.95..3,155.41 rows=4,215 width=18) (actual time=0.567..4.534 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.160 0.160 ↑ 1.0 8,073 1 / 3

Bitmap Index Scan on vehicule_date_ce_index (cost=0.00..177.16 rows=8,073 width=0) (actual time=0.481..0.481 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.215 ms
Execution time : 144,793.176 ms