[Qgis-developer] Wroclaw taking several minutes to load a single postgis polygon

[Tim Keitt]

The table has only a single row. Normally it loads instantly. Suddenly
its taking a very long time. Here's the output from postgres:


2011-09-12 19:50:26 CDT STATEMENT:  select
estimated_extent('public','region_boundary','the_geom')
2011-09-12 19:50:26 CDT LOG:  statement: select extent("the_geom")
from "public"."region_boundary"
2011-09-12 19:50:26 CDT LOG:  duration: 0.519 ms
2011-09-12 19:54:07 CDT LOG:  duration: 228246.691 ms
2011-09-12 19:54:07 CDT LOG:  statement: BEGIN READ ONLY
2011-09-12 19:54:07 CDT LOG:  duration: 0.145 ms
2011-09-12 19:54:07 CDT LOG:  statement: declare qgisf0 binary cursor
for select "gid",asbinary("the_geom",'NDR') from
"public"."region_boundary" where "the_geom" &&
setsrid('BOX3D(-5826044.8984273653477430 -6024214.2690353775396943,
7145528.0523074865341187 3985583.1240626471117139)'::box3d,900914)
2011-09-12 19:54:08 CDT LOG:  duration: 73.467 ms
2011-09-12 19:54:08 CDT LOG:  statement: fetch forward 200 from qgisf0
2011-09-12 19:54:08 CDT LOG:  duration: 8.667 ms
2011-09-12 19:54:08 CDT LOG:  statement: fetch forward 200 from qgisf0
2011-09-12 19:54:08 CDT LOG:  duration: 0.107 ms
2011-09-12 19:54:08 CDT LOG:  statement: CLOSE qgisf0
2011-09-12 19:54:08 CDT LOG:  duration: 0.050 ms
2011-09-12 19:54:08 CDT LOG:  statement: COMMIT
2011-09-12 19:54:08 CDT LOG:  duration: 0.057 ms

Anybody have an idea about this one?

THK


-- 
Timothy H. Keitt
http://www.keittlab.org/