explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Aeu5

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

Limit (cost=0.00..13.14 rows=1 width=132) (actual rows= loops=)

  • Output: m."Idx", m."Nb_Item", m.geom
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..196,511,345.28 rows=14,960,725 width=132) (actual rows= loops=)

  • Output: m."Idx", m."Nb_Item", m.geom
  • Join Filter: (box(a.geom) ?# box(m.geom))
3. 0.000 0.000 ↓ 0.0

Seq Scan on recette_fg."Maillage_Idx_FE-FunctionSetPetitCarreResultat100m" m (cost=0.00..2,021,903.12 rows=66,492,112 width=132) (actual rows= loops=)

  • Output: m."Idx", m."Nb_Item", m.geom
4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..14.67 rows=45 width=14,737) (actual rows= loops=)

  • Output: a.geom
5. 0.000 0.000 ↓ 0.0

Seq Scan on public."ARRONDISSEMENT_MUNICIPAL_FE" a (cost=0.00..14.45 rows=45 width=14,737) (actual rows= loops=)

  • Output: a.geom