[postgis-users] Very long query time

Manchon Pierre pierre.manchon at irstea.fr
Thu Dec 6 07:44:02 PST 2018


Hello there,

I'm new on the list and for a premiere I would like to know if some of you
have a very long runtime for some of their queries (even with a LIMIT 5),
whereas those queries were working well before (nothing changed from
that).  I'm using Postgre10, pgAdmin4 and postgis 2.4.4 on windows .

 

The infinite query I'm trying to execute: (only ~500 rows are stored on
each of the two tables)

 


SELECT code_tile, code_zi FROM data.tile, data.zi

WHERE ST_Intersects(zi.geom, tile.geom) = 'true'

GROUP BY code_zi, code_tile, zi.geom, tile.geom

LIMIT 5

 

Thank you for your time

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181206/6a1eab1d/attachment.html>


More information about the postgis-users mailing list