explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PEV

Settings
# exclusive inclusive rows x rows loops node
1. 2,854,954.501 2,979,342.191 ↓ 1.9 200,682 1

Nested Loop (cost=0.00..277,771.84 rows=104,443 width=1,658) (actual time=135.504..2,979,342.191 rows=200,682 loops=1)

2. 142.186 142.186 ↓ 1.0 16,992 1

Seq Scan on recorte_2012 uso (cost=0.00..18,905.60 rows=16,508 width=1,534) (actual time=0.084..142.186 rows=16,992 loops=1)

  • Filter: (gridcode = 2)
  • Rows Removed by Filter: 160896
3. 124,245.504 124,245.504 ↓ 4.0 12 16,992

Index Scan using sidx_recorte_grade_geom on recorte_grade grade (cost=0.00..14.05 rows=3 width=124) (actual time=0.126..7.312 rows=12 loops=16,992)

  • Index Cond: (the_geom && uso.geom)
  • Filter: _st_intersects(the_geom, uso.geom)
  • Rows Removed by Filter: 12