explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MG8J

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

Hash Left Join (cost=613.36..3,943.48 rows=4,159 width=197) (actual rows= loops=)

  • Hash Cond: (obj.evenement_geo_fin_id = fin.evenement_geo_id)
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=306.82..1,253.79 rows=4,159 width=109) (actual rows= loops=)

  • Hash Cond: (obj.evenement_geo_debut_id = debut.evenement_geo_id)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..924.64 rows=4,159 width=101) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on type_geo type (cost=0.00..1.25 rows=1 width=47) (actual rows= loops=)

  • Filter: ((type_geo_code)::text = 'EPCI'::text)
5. 0.000 0.000 ↓ 0.0

Index Scan using objet_geo_type_geo_id_idx on objet_geo obj (cost=0.29..879.61 rows=4,378 width=62) (actual rows= loops=)

  • Index Cond: (type_geo_id = type.type_geo_id)
6. 0.000 0.000 ↓ 0.0

Hash (cost=169.57..169.57 rows=10,957 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on evenement_geo debut (cost=0.00..169.57 rows=10,957 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=169.57..169.57 rows=10,957 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on evenement_geo fin (cost=0.00..169.57 rows=10,957 width=16) (actual rows= loops=)