explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7ckK

Settings
# exclusive inclusive rows x rows loops node
1. 519.398 49,211.849 ↑ 6.5 943,044 1

Nested Loop (cost=0.28..103,286.82 rows=6,133,199 width=146) (actual time=0.788..49,211.849 rows=943,044 loops=1)

2. 2.580 2.580 ↑ 1.1 1,093 1

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

3. 48,689.871 48,689.871 ↓ 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.031..44.547 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 : 0.720 ms
Execution time : 49,424.837 ms