explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OnmC

Settings
# exclusive inclusive rows x rows loops node
1. 8,019.490 9,775.865 ↓ 61.3 4,967 1

Hash Join (cost=4,968.60..16,950.34 rows=81 width=177) (actual time=1,406.140..9,775.865 rows=4,967 loops=1)

  • Hash Cond: ((u.clicodfac)::text = (l.id)::text)
2. 385.828 385.828 ↓ 1.0 225,872 1

Seq Scan on suministrosunidogis2distribucion u (cost=0.00..11,089.68 rows=215,905 width=12) (actual time=0.074..385.828 rows=225,872 loops=1)

  • Filter: ((ec = '1'::text) AND ((eca = 1) OR (eca = 3) OR (eca = 8)))
  • Rows Removed by Filter: 37129
3. 20.604 1,370.547 ↓ 44.7 5,361 1

Hash (cost=4,967.10..4,967.10 rows=120 width=189) (actual time=1,370.547..1,370.547 rows=5,361 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1255kB
4. 10.750 1,349.943 ↓ 45.4 5,449 1

Nested Loop (cost=0.28..4,967.10 rows=120 width=189) (actual time=2.363..1,349.943 rows=5,449 loops=1)

5. 1.327 1.327 ↑ 1.6 722 1

Seq Scan on taba v (cost=0.00..16.60 rows=1,160 width=40) (actual time=0.019..1.327 rows=722 loops=1)

6. 1,337.866 1,337.866 ↓ 8.0 8 722

Index Scan using idx_cat_lote_the_geom on cat_lote l (cost=0.28..4.26 rows=1 width=149) (actual time=0.788..1.853 rows=8 loops=722)

  • Index Cond: ((v.the_geom && the_geom) AND (v.the_geom && the_geom))
  • Filter: _st_intersects(v.the_geom, the_geom)
  • Rows Removed by Filter: 12
Planning time : 6.258 ms
Execution time : 9,785.187 ms