explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2OXx

Settings
# exclusive inclusive rows x rows loops node
1. 489.990 48,350.212 ↑ 6.5 943,044 1

Nested Loop (cost=0.28..103,286.82 rows=6,133,199 width=146) (actual time=2.511..48,350.212 rows=943,044 loops=1)

2. 3.217 3.217 ↑ 1.1 1,093 1

Seq Scan on mag_zonas m (cost=0.00..137.66 rows=1,166 width=570) (actual time=0.029..3.217 rows=1,093 loops=1)

3. 47,857.005 47,857.005 ↓ 33.2 863 1,093

Index Scan using idx_cat_lote_the_geom on cat_lote l (cost=0.28..88.20 rows=26 width=146) (actual time=1.059..43.785 rows=863 loops=1,093)

  • Index Cond: (m.the_geom && the_geom)
  • Filter: ((id IS NOT NULL) AND ((NOT (m.the_geom ~ the_geom)) OR (NOT _st_contains(m.the_geom, the_geom))))
  • Rows Removed by Filter: 987
Planning time : 10.053 ms
Execution time : 48,532.072 ms