explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7QLf

Settings
# exclusive inclusive rows x rows loops node
1. 10,305.115 18,408.280 ↓ 9.9 102,453 1

Sort (cost=199,123.80..199,149.64 rows=10,335 width=1,173) (actual time=18,261.327..18,408.280 rows=102,453 loops=1)

  • Output: e.id_etape, e.consommation, e.code_exploitant, e.distance, e.etat, e.numero_embarque, e.numero_releve, e.type_periode, e.id_position_debut, e.id_position_fin, e.debut_time, e.fin_time, e.ndid, e.geom_debut, e.geom_fin, e.extended_data, pg_deb.id_position_geo, pg_deb.adresse_pos, pg_deb.arrivee_temps_reel_pos, pg_deb.batterie_interne_pos, pg_deb.cap_pos, pg_deb.code_exploitant_pos, pg_deb.code_postal_pos, pg_deb.complement_adresse2_pos, pg_deb.distance_adresse_donnee_pos, pg_deb.distance_depuis_point_prec_pos, pg_deb.etat_region_pos, pg_deb.gmt_pos, pg_deb.gps_hs_pos, pg_deb.heure_stockage_geo, pg_deb.id_etat_mobile, pg_deb.id_pays, pg_deb.id_reset, pg_deb.latitude_y_pos, pg_deb.longitude_x_pos, pg_deb.numero_embarque_pos, pg_deb.numero_releve_pos, pg_deb.numeros_voie_pos, pg_deb.position_reelle_pos, pg_deb.pct_gauge, pg_deb.retour_gprs_pos, pg_deb.roaming_pos, pg_deb.tension_batterie_pos, pg_deb.vie_privee_pos, pg_deb.ville_pos, pg_deb.vitesse_instantanee_pos, pg_fin.id_position_geo, pg_fin.adresse_pos, pg_fin.arrivee_temps_reel_pos, pg_fin.batterie_interne_pos, pg_fin.cap_pos, pg_fin.code_exploitant_pos, pg_fin.code_postal_pos, pg_fin.complement_adresse2_pos, pg_fin.distance_adresse_donnee_pos, pg_fin.distance_depuis_point_prec_pos, pg_fin.etat_region_pos, pg_fin.gmt_pos, pg_fin.gps_hs_pos, pg_fin.heure_stockage_geo, pg_fin.id_etat_mobile, pg_fin.id_pays, pg_fin.id_reset, pg_fin.latitude_y_pos, pg_fin.longitude_x_pos, pg_fin.numero_embarque_pos, pg_fin.numero_releve_pos, pg_fin.numeros_voie_pos, pg_fin.position_reelle_pos, pg_fin.pct_gauge, pg_fin.retour_gprs_pos, pg_fin.roaming_pos, pg_fin.tension_batterie_pos, pg_fin.vie_privee_pos, pg_fin.ville_pos, pg_fin.vitesse_instantanee_pos, (CASE WHEN ((vfj.nomentite)::text ~~ '\_%'::text) THEN 0 ELSE '-1'::integer END), vfj.nomentite, vfj.description, (CASE WHEN (e.type_periode <> 4) THEN 0 ELSE 1 END)
  • Sort Key: (CASE WHEN ((vfj.nomentite)::text ~~ '\_%'::text) THEN 0 ELSE '-1'::integer END), vfj.nomentite, vfj.description, e.debut_time, (CASE WHEN (e.type_periode <> 4) THEN 0 ELSE 1 END), e.fin_time
  • Sort Method: external merge Disk: 48536kB
  • Buffers: shared hit=1238213 read=28597, local hit=18, temp read=6067 written=6068
2. 149.641 8,103.165 ↓ 9.9 102,453 1

Nested Loop (cost=1,026.45..198,434.70 rows=10,335 width=1,173) (actual time=6.017..8,103.165 rows=102,453 loops=1)

  • Output: e.id_etape, e.consommation, e.code_exploitant, e.distance, e.etat, e.numero_embarque, e.numero_releve, e.type_periode, e.id_position_debut, e.id_position_fin, e.debut_time, e.fin_time, e.ndid, e.geom_debut, e.geom_fin, e.extended_data, pg_deb.id_position_geo, pg_deb.adresse_pos, pg_deb.arrivee_temps_reel_pos, pg_deb.batterie_interne_pos, pg_deb.cap_pos, pg_deb.code_exploitant_pos, pg_deb.code_postal_pos, pg_deb.complement_adresse2_pos, pg_deb.distance_adresse_donnee_pos, pg_deb.distance_depuis_point_prec_pos, pg_deb.etat_region_pos, pg_deb.gmt_pos, pg_deb.gps_hs_pos, pg_deb.heure_stockage_geo, pg_deb.id_etat_mobile, pg_deb.id_pays, pg_deb.id_reset, pg_deb.latitude_y_pos, pg_deb.longitude_x_pos, pg_deb.numero_embarque_pos, pg_deb.numero_releve_pos, pg_deb.numeros_voie_pos, pg_deb.position_reelle_pos, pg_deb.pct_gauge, pg_deb.retour_gprs_pos, pg_deb.roaming_pos, pg_deb.tension_batterie_pos, pg_deb.vie_privee_pos, pg_deb.ville_pos, pg_deb.vitesse_instantanee_pos, pg_fin.id_position_geo, pg_fin.adresse_pos, pg_fin.arrivee_temps_reel_pos, pg_fin.batterie_interne_pos, pg_fin.cap_pos, pg_fin.code_exploitant_pos, pg_fin.code_postal_pos, pg_fin.complement_adresse2_pos, pg_fin.distance_adresse_donnee_pos, pg_fin.distance_depuis_point_prec_pos, pg_fin.etat_region_pos, pg_fin.gmt_pos, pg_fin.gps_hs_pos, pg_fin.heure_stockage_geo, pg_fin.id_etat_mobile, pg_fin.id_pays, pg_fin.id_reset, pg_fin.latitude_y_pos, pg_fin.longitude_x_pos, pg_fin.numero_embarque_pos, pg_fin.numero_releve_pos, pg_fin.numeros_voie_pos, pg_fin.position_reelle_pos, pg_fin.pct_gauge, pg_fin.retour_gprs_pos, pg_fin.roaming_pos, pg_fin.tension_batterie_pos, pg_fin.vie_privee_pos, pg_fin.ville_pos, pg_fin.vitesse_instantanee_pos, CASE WHEN ((vfj.nomentite)::text ~~ '\_%'::text) THEN 0 ELSE '-1'::integer END, vfj.nomentite, vfj.description, CASE WHEN (e.type_periode <> 4) THEN 0 ELSE 1 END
  • Buffers: shared hit=1238213 read=28597, local hit=18
3. 75.007 4,367.599 ↓ 9.9 102,455 1

Nested Loop (cost=1,026.31..129,083.35 rows=10,335 width=690) (actual time=5.613..4,367.599 rows=102,455 loops=1)

  • Output: e.id_etape, e.consommation, e.code_exploitant, e.distance, e.etat, e.numero_embarque, e.numero_releve, e.type_periode, e.id_position_debut, e.id_position_fin, e.debut_time, e.fin_time, e.ndid, e.geom_debut, e.geom_fin, e.extended_data, vfj.nomentite, vfj.description, pg_deb.id_position_geo, pg_deb.adresse_pos, pg_deb.arrivee_temps_reel_pos, pg_deb.batterie_interne_pos, pg_deb.cap_pos, pg_deb.code_exploitant_pos, pg_deb.code_postal_pos, pg_deb.complement_adresse2_pos, pg_deb.distance_adresse_donnee_pos, pg_deb.distance_depuis_point_prec_pos, pg_deb.etat_region_pos, pg_deb.gmt_pos, pg_deb.gps_hs_pos, pg_deb.heure_stockage_geo, pg_deb.id_etat_mobile, pg_deb.id_pays, pg_deb.id_reset, pg_deb.latitude_y_pos, pg_deb.longitude_x_pos, pg_deb.numero_embarque_pos, pg_deb.numero_releve_pos, pg_deb.numeros_voie_pos, pg_deb.position_reelle_pos, pg_deb.pct_gauge, pg_deb.retour_gprs_pos, pg_deb.roaming_pos, pg_deb.tension_batterie_pos, pg_deb.vie_privee_pos, pg_deb.ville_pos, pg_deb.vitesse_instantanee_pos
  • Buffers: shared hit=632544 read=18497, local hit=18
4. 19.524 2,960.677 ↓ 9.9 102,455 1

Append (cost=1,026.17..59,783.67 rows=10,335 width=215) (actual time=4.147..2,960.677 rows=102,455 loops=1)

  • Buffers: shared hit=18152 read=17119, local hit=18
5. 136.235 2,581.161 ↓ 10.3 102,072 1

Hash Join (cost=1,026.17..37,454.18 rows=9,902 width=215) (actual time=4.146..2,581.161 rows=102,072 loops=1)

  • Output: e.id_etape, e.consommation, e.code_exploitant, e.distance, e.etat, e.numero_embarque, e.numero_releve, e.type_periode, e.id_position_debut, e.id_position_fin, e.debut_time, e.fin_time, e.ndid, e.geom_debut, e.geom_fin, e.extended_data, vfj.nomentite, vfj.description
  • Hash Cond: (e.numero_embarque = vfj.numembarque)
  • Join Filter: ((e.debut_time >= vfj.startaffectationentite) AND (e.debut_time <= COALESCE(vfj.endaffectationentite, 'infinity'::timestamp without time zone)))
  • Buffers: shared read=16388, local hit=9
6. 1,143.059 2,444.634 ↓ 1.1 102,072 1

Gather (cost=1,000.00..35,756.99 rows=89,121 width=196) (actual time=3.841..2,444.634 rows=102,072 loops=1)

  • Output: e.id_etape, e.consommation, e.code_exploitant, e.distance, e.etat, e.numero_embarque, e.numero_releve, e.type_periode, e.id_position_debut, e.id_position_fin, e.debut_time, e.fin_time, e.ndid, e.geom_debut, e.geom_fin, e.extended_data
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared read=16388
7. 5.710 1,301.575 ↑ 1.1 34,024 3

Append (cost=0.00..25,844.89 rows=37,134 width=196) (actual time=0.788..1,301.575 rows=34,024 loops=3)

  • Buffers: shared read=16388
  • Worker 0: actual time=0.184..1829.210 rows=50551 loops=1
  • Buffers: shared read=8156
  • Worker 1: actual time=0.073..1750.276 rows=50815 loops=1
  • Buffers: shared read=8127
8. 1,295.865 1,295.865 ↑ 1.1 34,024 3

Parallel Seq Scan on aggregation.etape_part_1m9_04 e (cost=0.00..25,844.89 rows=37,134 width=196) (actual time=0.787..1,295.865 rows=34,024 loops=3)

  • Output: e.id_etape, e.consommation, e.code_exploitant, e.distance, e.etat, e.numero_embarque, e.numero_releve, e.type_periode, e.id_position_debut, e.id_position_fin, e.debut_time, e.fin_time, e.ndid, e.geom_debut, e.geom_fin, e.extended_data
  • Filter: ((e.debut_time >= '2019-04-01 22:00:00'::timestamp without time zone) AND (e.debut_time <= '2019-04-08 21:59:59.999'::timestamp without time zone) AND (e.code_exploitant = '1M9'::bpchar) AND (e.type_periode = ANY ('{1,2,3,5}'::smallint[])) AND ((e.type_periode <> 4) OR (date_part('epoch'::text, (e.fin_time - e.debut_time)) > '10'::double precision)))
  • Rows Removed by Filter: 198761
  • Buffers: shared read=16388
  • Worker 0: actual time=0.183..1819.130 rows=50551 loops=1
  • Buffers: shared read=8156
  • Worker 1: actual time=0.072..1743.331 rows=50815 loops=1
  • Buffers: shared read=8127
9. 0.155 0.292 ↑ 1.0 763 1

Hash (cost=16.63..16.63 rows=763 width=39) (actual time=0.292..0.292 rows=763 loops=1)

  • Output: vfj.nomentite, vfj.description, vfj.numembarque, vfj.startaffectationentite, vfj.endaffectationentite
  • Buckets: 1024 Batches: 1 Memory Usage: 58kB
  • Buffers: local hit=9
10. 0.137 0.137 ↑ 1.0 763 1

Seq Scan on pg_temp_6.vehiculesfj vfj (cost=0.00..16.63 rows=763 width=39) (actual time=0.013..0.137 rows=763 loops=1)

  • Output: vfj.nomentite, vfj.description, vfj.numembarque, vfj.startaffectationentite, vfj.endaffectationentite
  • Buffers: local hit=9
11. 2.502 359.992 ↑ 1.1 383 1

Unique (cost=22,218.33..22,226.15 rows=433 width=215) (actual time=355.870..359.992 rows=383 loops=1)

  • Output: e_1.id_etape, e_1.consommation, e_1.code_exploitant, e_1.distance, e_1.etat, e_1.numero_embarque, e_1.numero_releve, e_1.type_periode, e_1.id_position_debut, e_1.id_position_fin, e_1.debut_time, e_1.fin_time, e_1.ndid, e_1.geom_debut, e_1.geom_fin, e_1.extended_data, vfj_1.nomentite, vfj_1.description
  • Buffers: shared hit=18152 read=731, local hit=9
12. 24.542 357.490 ↓ 10.5 16,461 1

Sort (cost=22,218.33..22,222.24 rows=1,564 width=215) (actual time=355.854..357.490 rows=16,461 loops=1)

  • Output: e_1.id_etape, e_1.consommation, e_1.code_exploitant, e_1.distance, e_1.etat, e_1.numero_embarque, e_1.numero_releve, e_1.type_periode, e_1.id_position_debut, e_1.id_position_fin, e_1.debut_time, e_1.fin_time, e_1.ndid, e_1.geom_debut, e_1.geom_fin, e_1.extended_data, vfj_1.nomentite, vfj_1.description
  • Sort Key: e_1.numero_embarque, e_1.debut_time DESC, e_1.id_etape DESC
  • Sort Method: quicksort Memory: 5141kB
  • Buffers: shared hit=18152 read=731, local hit=9
13. 5.533 332.948 ↓ 10.5 16,461 1

Nested Loop (cost=0.15..22,135.35 rows=1,564 width=215) (actual time=1.591..332.948 rows=16,461 loops=1)

  • Output: e_1.id_etape, e_1.consommation, e_1.code_exploitant, e_1.distance, e_1.etat, e_1.numero_embarque, e_1.numero_releve, e_1.type_periode, e_1.id_position_debut, e_1.id_position_fin, e_1.debut_time, e_1.fin_time, e_1.ndid, e_1.geom_debut, e_1.geom_fin, e_1.extended_data, vfj_1.nomentite, vfj_1.description
  • Buffers: shared hit=18152 read=731, local hit=9
14. 0.851 0.851 ↑ 1.0 763 1

Seq Scan on pg_temp_6.vehiculesfj vfj_1 (cost=0.00..16.63 rows=763 width=39) (actual time=0.010..0.851 rows=763 loops=1)

  • Output: vfj_1.numembarque, vfj_1.idvehiculeengin, vfj_1.description, vfj_1.identite, vfj_1.nomentite, vfj_1.startaffectationentite, vfj_1.endaffectationentite
  • Buffers: local hit=9
15. 4.578 326.564 ↓ 3.7 22 763

Append (cost=0.15..28.93 rows=6 width=196) (actual time=0.250..0.428 rows=22 loops=763)

  • Buffers: shared hit=18152 read=731
16. 2.289 2.289 ↓ 0.0 0 763

Index Scan using idx_etape_part_1m9_02_num_debut on aggregation.etape_part_1m9_02 e_1 (cost=0.15..0.25 rows=1 width=208) (actual time=0.003..0.003 rows=0 loops=763)

  • Output: e_1.id_etape, e_1.consommation, e_1.code_exploitant, e_1.distance, e_1.etat, e_1.numero_embarque, e_1.numero_releve, e_1.type_periode, e_1.id_position_debut, e_1.id_position_fin, e_1.debut_time, e_1.fin_time, e_1.ndid, e_1.geom_debut, e_1.geom_fin, e_1.extended_data
  • Index Cond: ((e_1.numero_embarque = vfj_1.numembarque) AND (e_1.debut_time >= vfj_1.startaffectationentite) AND (e_1.debut_time <= COALESCE(vfj_1.endaffectationentite, 'infinity'::timestamp without time zone)) AND (e_1.debut_time < '2019-04-01 22:00:00'::timestamp without time zone) AND (e_1.debut_time > '2019-02-18 22:00:00'::timestamp without time zone))
  • Filter: ((e_1.code_exploitant = '1M9'::bpchar) AND (e_1.type_periode = ANY ('{1,2,3,5}'::smallint[])) AND ((e_1.type_periode <> 4) OR (date_part('epoch'::text, (e_1.fin_time - e_1.debut_time)) > '10'::double precision)))
  • Buffers: shared hit=763
17. 2.289 2.289 ↓ 0.0 0 763

Index Scan using idx_etape_part_1m9_03_num_debut on aggregation.etape_part_1m9_03 e_2 (cost=0.13..0.19 rows=1 width=196) (actual time=0.003..0.003 rows=0 loops=763)

  • Output: e_2.id_etape, e_2.consommation, e_2.code_exploitant, e_2.distance, e_2.etat, e_2.numero_embarque, e_2.numero_releve, e_2.type_periode, e_2.id_position_debut, e_2.id_position_fin, e_2.debut_time, e_2.fin_time, e_2.ndid, e_2.geom_debut, e_2.geom_fin, e_2.extended_data
  • Index Cond: ((e_2.numero_embarque = vfj_1.numembarque) AND (e_2.debut_time >= vfj_1.startaffectationentite) AND (e_2.debut_time <= COALESCE(vfj_1.endaffectationentite, 'infinity'::timestamp without time zone)) AND (e_2.debut_time < '2019-04-01 22:00:00'::timestamp without time zone) AND (e_2.debut_time > '2019-02-18 22:00:00'::timestamp without time zone))
  • Filter: ((e_2.code_exploitant = '1M9'::bpchar) AND (e_2.type_periode = ANY ('{1,2,3,5}'::smallint[])) AND ((e_2.type_periode <> 4) OR (date_part('epoch'::text, (e_2.fin_time - e_2.debut_time)) > '10'::double precision)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=764 read=2
18. 317.408 317.408 ↓ 5.5 22 763

Index Scan using idx_etape_part_1m9_04_num_debut on aggregation.etape_part_1m9_04 e_3 (cost=0.42..28.49 rows=4 width=196) (actual time=0.241..0.416 rows=22 loops=763)

  • Output: e_3.id_etape, e_3.consommation, e_3.code_exploitant, e_3.distance, e_3.etat, e_3.numero_embarque, e_3.numero_releve, e_3.type_periode, e_3.id_position_debut, e_3.id_position_fin, e_3.debut_time, e_3.fin_time, e_3.ndid, e_3.geom_debut, e_3.geom_fin, e_3.extended_data
  • Index Cond: ((e_3.numero_embarque = vfj_1.numembarque) AND (e_3.debut_time >= vfj_1.startaffectationentite) AND (e_3.debut_time <= COALESCE(vfj_1.endaffectationentite, 'infinity'::timestamp without time zone)) AND (e_3.debut_time < '2019-04-01 22:00:00'::timestamp without time zone) AND (e_3.debut_time > '2019-02-18 22:00:00'::timestamp without time zone))
  • Filter: ((e_3.code_exploitant = '1M9'::bpchar) AND (e_3.type_periode = ANY ('{1,2,3,5}'::smallint[])) AND ((e_3.type_periode <> 4) OR (date_part('epoch'::text, (e_3.fin_time - e_3.debut_time)) > '10'::double precision)))
  • Rows Removed by Filter: 14
  • Buffers: shared hit=16625 read=729
19. 204.910 1,331.915 ↑ 3.0 1 102,455

Append (cost=0.14..6.68 rows=3 width=475) (actual time=0.012..0.013 rows=1 loops=102,455)

  • Buffers: shared hit=614392 read=1378
20. 102.455 102.455 ↓ 0.0 0 102,455

Index Scan using position_geo_part_1m9_02_pkey on data.position_geo_part_1m9_02 pg_deb (cost=0.14..0.17 rows=1 width=1,312) (actual time=0.001..0.001 rows=0 loops=102,455)

  • Output: pg_deb.id_position_geo, pg_deb.adresse_pos, pg_deb.arrivee_temps_reel_pos, pg_deb.batterie_interne_pos, pg_deb.cap_pos, pg_deb.code_exploitant_pos, pg_deb.code_postal_pos, pg_deb.complement_adresse2_pos, pg_deb.distance_adresse_donnee_pos, pg_deb.distance_depuis_point_prec_pos, pg_deb.etat_region_pos, pg_deb.gmt_pos, pg_deb.gps_hs_pos, pg_deb.heure_stockage_geo, pg_deb.id_etat_mobile, pg_deb.id_pays, pg_deb.id_reset, pg_deb.latitude_y_pos, pg_deb.longitude_x_pos, pg_deb.numero_embarque_pos, pg_deb.numero_releve_pos, pg_deb.numeros_voie_pos, pg_deb.position_reelle_pos, pg_deb.pct_gauge, pg_deb.retour_gprs_pos, pg_deb.roaming_pos, pg_deb.tension_batterie_pos, pg_deb.vie_privee_pos, pg_deb.ville_pos, pg_deb.vitesse_instantanee_pos
  • Index Cond: (pg_deb.id_position_geo = e.id_position_debut)
  • Filter: ((pg_deb.gmt_pos >= '2019-02-18 22:00:00'::timestamp without time zone) AND (pg_deb.gmt_pos <= '2019-04-08 21:59:59.999'::timestamp without time zone))
  • Buffers: shared hit=102455
21. 102.455 102.455 ↓ 0.0 0 102,455

Index Scan using position_geo_part_1m9_03_pkey on data.position_geo_part_1m9_03 pg_deb_1 (cost=0.14..0.17 rows=1 width=1,312) (actual time=0.001..0.001 rows=0 loops=102,455)

  • Output: pg_deb_1.id_position_geo, pg_deb_1.adresse_pos, pg_deb_1.arrivee_temps_reel_pos, pg_deb_1.batterie_interne_pos, pg_deb_1.cap_pos, pg_deb_1.code_exploitant_pos, pg_deb_1.code_postal_pos, pg_deb_1.complement_adresse2_pos, pg_deb_1.distance_adresse_donnee_pos, pg_deb_1.distance_depuis_point_prec_pos, pg_deb_1.etat_region_pos, pg_deb_1.gmt_pos, pg_deb_1.gps_hs_pos, pg_deb_1.heure_stockage_geo, pg_deb_1.id_etat_mobile, pg_deb_1.id_pays, pg_deb_1.id_reset, pg_deb_1.latitude_y_pos, pg_deb_1.longitude_x_pos, pg_deb_1.numero_embarque_pos, pg_deb_1.numero_releve_pos, pg_deb_1.numeros_voie_pos, pg_deb_1.position_reelle_pos, pg_deb_1.pct_gauge, pg_deb_1.retour_gprs_pos, pg_deb_1.roaming_pos, pg_deb_1.tension_batterie_pos, pg_deb_1.vie_privee_pos, pg_deb_1.ville_pos, pg_deb_1.vitesse_instantanee_pos
  • Index Cond: (pg_deb_1.id_position_geo = e.id_position_debut)
  • Filter: ((pg_deb_1.gmt_pos >= '2019-02-18 22:00:00'::timestamp without time zone) AND (pg_deb_1.gmt_pos <= '2019-04-08 21:59:59.999'::timestamp without time zone))
  • Buffers: shared hit=102455
22. 922.095 922.095 ↑ 1.0 1 102,455

Index Scan using position_geo_part_1m9_04_pkey on data.position_geo_part_1m9_04 pg_deb_2 (cost=0.43..6.34 rows=1 width=475) (actual time=0.009..0.009 rows=1 loops=102,455)

  • Output: pg_deb_2.id_position_geo, pg_deb_2.adresse_pos, pg_deb_2.arrivee_temps_reel_pos, pg_deb_2.batterie_interne_pos, pg_deb_2.cap_pos, pg_deb_2.code_exploitant_pos, pg_deb_2.code_postal_pos, pg_deb_2.complement_adresse2_pos, pg_deb_2.distance_adresse_donnee_pos, pg_deb_2.distance_depuis_point_prec_pos, pg_deb_2.etat_region_pos, pg_deb_2.gmt_pos, pg_deb_2.gps_hs_pos, pg_deb_2.heure_stockage_geo, pg_deb_2.id_etat_mobile, pg_deb_2.id_pays, pg_deb_2.id_reset, pg_deb_2.latitude_y_pos, pg_deb_2.longitude_x_pos, pg_deb_2.numero_embarque_pos, pg_deb_2.numero_releve_pos, pg_deb_2.numeros_voie_pos, pg_deb_2.position_reelle_pos, pg_deb_2.pct_gauge, pg_deb_2.retour_gprs_pos, pg_deb_2.roaming_pos, pg_deb_2.tension_batterie_pos, pg_deb_2.vie_privee_pos, pg_deb_2.ville_pos, pg_deb_2.vitesse_instantanee_pos
  • Index Cond: (pg_deb_2.id_position_geo = e.id_position_debut)
  • Filter: ((pg_deb_2.gmt_pos >= '2019-02-18 22:00:00'::timestamp without time zone) AND (pg_deb_2.gmt_pos <= '2019-04-08 21:59:59.999'::timestamp without time zone))
  • Buffers: shared hit=409482 read=1378
23. 204.910 3,585.925 ↑ 3.0 1 102,455

Append (cost=0.14..6.68 rows=3 width=475) (actual time=0.034..0.035 rows=1 loops=102,455)

  • Buffers: shared hit=605669 read=10100
24. 0.000 0.000 ↓ 0.0 0 102,455

Index Scan using position_geo_part_1m9_02_pkey on data.position_geo_part_1m9_02 pg_fin (cost=0.14..0.17 rows=1 width=1,312) (actual time=0.000..0.000 rows=0 loops=102,455)

  • Output: pg_fin.id_position_geo, pg_fin.adresse_pos, pg_fin.arrivee_temps_reel_pos, pg_fin.batterie_interne_pos, pg_fin.cap_pos, pg_fin.code_exploitant_pos, pg_fin.code_postal_pos, pg_fin.complement_adresse2_pos, pg_fin.distance_adresse_donnee_pos, pg_fin.distance_depuis_point_prec_pos, pg_fin.etat_region_pos, pg_fin.gmt_pos, pg_fin.gps_hs_pos, pg_fin.heure_stockage_geo, pg_fin.id_etat_mobile, pg_fin.id_pays, pg_fin.id_reset, pg_fin.latitude_y_pos, pg_fin.longitude_x_pos, pg_fin.numero_embarque_pos, pg_fin.numero_releve_pos, pg_fin.numeros_voie_pos, pg_fin.position_reelle_pos, pg_fin.pct_gauge, pg_fin.retour_gprs_pos, pg_fin.roaming_pos, pg_fin.tension_batterie_pos, pg_fin.vie_privee_pos, pg_fin.ville_pos, pg_fin.vitesse_instantanee_pos
  • Index Cond: (pg_fin.id_position_geo = e.id_position_fin)
  • Filter: ((pg_fin.gmt_pos >= '2019-02-18 22:00:00'::timestamp without time zone) AND (pg_fin.gmt_pos <= '2019-04-22 23:59:59.999'::timestamp without time zone))
  • Buffers: shared hit=102455
25. 0.000 0.000 ↓ 0.0 0 102,455

Index Scan using position_geo_part_1m9_03_pkey on data.position_geo_part_1m9_03 pg_fin_1 (cost=0.14..0.17 rows=1 width=1,312) (actual time=0.000..0.000 rows=0 loops=102,455)

  • Output: pg_fin_1.id_position_geo, pg_fin_1.adresse_pos, pg_fin_1.arrivee_temps_reel_pos, pg_fin_1.batterie_interne_pos, pg_fin_1.cap_pos, pg_fin_1.code_exploitant_pos, pg_fin_1.code_postal_pos, pg_fin_1.complement_adresse2_pos, pg_fin_1.distance_adresse_donnee_pos, pg_fin_1.distance_depuis_point_prec_pos, pg_fin_1.etat_region_pos, pg_fin_1.gmt_pos, pg_fin_1.gps_hs_pos, pg_fin_1.heure_stockage_geo, pg_fin_1.id_etat_mobile, pg_fin_1.id_pays, pg_fin_1.id_reset, pg_fin_1.latitude_y_pos, pg_fin_1.longitude_x_pos, pg_fin_1.numero_embarque_pos, pg_fin_1.numero_releve_pos, pg_fin_1.numeros_voie_pos, pg_fin_1.position_reelle_pos, pg_fin_1.pct_gauge, pg_fin_1.retour_gprs_pos, pg_fin_1.roaming_pos, pg_fin_1.tension_batterie_pos, pg_fin_1.vie_privee_pos, pg_fin_1.ville_pos, pg_fin_1.vitesse_instantanee_pos
  • Index Cond: (pg_fin_1.id_position_geo = e.id_position_fin)
  • Filter: ((pg_fin_1.gmt_pos >= '2019-02-18 22:00:00'::timestamp without time zone) AND (pg_fin_1.gmt_pos <= '2019-04-22 23:59:59.999'::timestamp without time zone))
  • Buffers: shared hit=102455
26. 3,381.015 3,381.015 ↑ 1.0 1 102,455

Index Scan using position_geo_part_1m9_04_pkey on data.position_geo_part_1m9_04 pg_fin_2 (cost=0.43..6.34 rows=1 width=475) (actual time=0.033..0.033 rows=1 loops=102,455)

  • Output: pg_fin_2.id_position_geo, pg_fin_2.adresse_pos, pg_fin_2.arrivee_temps_reel_pos, pg_fin_2.batterie_interne_pos, pg_fin_2.cap_pos, pg_fin_2.code_exploitant_pos, pg_fin_2.code_postal_pos, pg_fin_2.complement_adresse2_pos, pg_fin_2.distance_adresse_donnee_pos, pg_fin_2.distance_depuis_point_prec_pos, pg_fin_2.etat_region_pos, pg_fin_2.gmt_pos, pg_fin_2.gps_hs_pos, pg_fin_2.heure_stockage_geo, pg_fin_2.id_etat_mobile, pg_fin_2.id_pays, pg_fin_2.id_reset, pg_fin_2.latitude_y_pos, pg_fin_2.longitude_x_pos, pg_fin_2.numero_embarque_pos, pg_fin_2.numero_releve_pos, pg_fin_2.numeros_voie_pos, pg_fin_2.position_reelle_pos, pg_fin_2.pct_gauge, pg_fin_2.retour_gprs_pos, pg_fin_2.roaming_pos, pg_fin_2.tension_batterie_pos, pg_fin_2.vie_privee_pos, pg_fin_2.ville_pos, pg_fin_2.vitesse_instantanee_pos
  • Index Cond: (pg_fin_2.id_position_geo = e.id_position_fin)
  • Filter: ((pg_fin_2.gmt_pos >= '2019-02-18 22:00:00'::timestamp without time zone) AND (pg_fin_2.gmt_pos <= '2019-04-22 23:59:59.999'::timestamp without time zone))
  • Buffers: shared hit=400759 read=10100