explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Hvg : ctybnda

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Insert on ctybnda2005 (cost=263,766.71..263,799.24 rows=212 width=35) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

Subquery Scan on "*SELECT*" (cost=263,766.71..263,799.24 rows=212 width=35) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=263,766.71..263,795.00 rows=212 width=182,910) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=263,766.71..263,775.08 rows=3,347 width=182,910) (actual time=.. rows= loops=)

  • Sort Key: m.country
5. 0.000 0.000 ↓ 0.0

Seq Scan on maptable m (cost=0.00..1,970.27 rows=3,347 width=182,910) (actual time=.. rows= loops=)

  • Filter: ((geom IS NOT NULL) AND (valstart <= 2005) AND ((valend IS NULL) OR (valend >= 2005)))