explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fH4H : Optimization for: Optimization for: plan #bHBm; plan #i8Oq

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=260,503.93..260,503.94 rows=1 width=0) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=244,161.05..260,278.51 rows=90,167 width=0) (actual rows= loops=)

  • Hash Cond: (t_association.id_lot = t_lot.id_lot)
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=237,106.55..250,480.09 rows=90,167 width=8) (actual rows= loops=)

  • Hash Cond: (t_association.id_troncon_mission = t_troncon_mission.id_troncon_mission)
4. 0.000 0.000 ↓ 0.0

Seq Scan on t_association (cost=0.00..6,788.21 rows=265,021 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=232,462.58..232,462.58 rows=283,038 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on t_troncon_mission (cost=0.00..232,462.58 rows=283,038 width=8) (actual rows= loops=)

  • Filter: ((date_debut_theorique >= '2019-01-10 00:00:00'::timestamp without time zone) AND (date_debut_theorique <= '2019-04-10 00:00:00'::timestamp without time zone))
7. 0.000 0.000 ↓ 0.0

Hash (cost=5,123.11..5,123.11 rows=117,711 width=8) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on t_lot (cost=0.00..5,123.11 rows=117,711 width=8) (actual rows= loops=)