#	rows x	node
1.	↓ 0.0	→ Insert on ctybnda2005 (cost=263766.71..263799.24 rows=212 width=35) (actual time=.. rows= loops=)
2.	↓ 0.0	→ Subquery Scan on "SELECT" (cost=263766.71..263799.24 rows=212 width=35) (actual time=.. rows= loops=)
3.	↓ 0.0	→ GroupAggregate (cost=263766.71..263795.00 rows=212 width=182910) (actual time=.. rows= loops=)
4.	↓ 0.0	→ Sort (cost=263766.71..263775.08 rows=3347 width=182910) (actual time=.. rows= loops=) Sort Key: m.country
5.	↓ 0.0	→ Seq Scan on maptable m (cost=0.00..1970.27 rows=3347 width=182910) (actual time=.. rows= loops=) Filter: ((geom IS NOT NULL) AND (valstart <= 2005) AND ((valend IS NULL) OR (valend >= 2005)))

                                                       QUERY PLAN                                                        
--------------------------------------------------------------------------------------------------------------------------
 Insert on ctybnda2005  (cost=263766.71..263799.24 rows=212 width=35)
   ->  Subquery Scan on "*SELECT*"  (cost=263766.71..263799.24 rows=212 width=35)
         ->  GroupAggregate  (cost=263766.71..263795.00 rows=212 width=182910)
               ->  Sort  (cost=263766.71..263775.08 rows=3347 width=182910)
                     Sort Key: m.country
                     ->  Seq Scan on maptable m  (cost=0.00..1970.27 rows=3347 width=182910)
                           Filter: ((geom IS NOT NULL) AND (valstart <= 2005) AND ((valend IS NULL) OR (valend >= 2005)))

Per node type stats

node type	count	sum of times	% of query
GroupAggregate	1	0.000 ms	0.0 %
Insert	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %
Sort	1	0.000 ms	0.0 %
Subquery Scan on "SELECT"	1	0.000 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
ctybnda2005	1	0.000 ms	0.0 %
Insert	1	0.000 ms	0.0 %
maptable	1	0.000 ms	0.0 %
Seq Scan	1	0.000 ms	0.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: Hvg : ctybnda

Colorize:

Columns visibility:

Per node type stats

Per table stats