explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bHBm

Settings

Optimization(s) for this plan:

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

Aggregate (cost=250,187.51..250,187.52 rows=1 width=0) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=237,106.55..249,962.09 rows=90,167 width=0) (actual rows= loops=)

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

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

4. 0.000 0.000 ↓ 0.0

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

5. 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))