Null display is "[NULL]". Expanded display is used automatically. Timing is on. postgis_full_version ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- POSTGIS="2.5.2 r17328" [EXTENSION] PGSQL="110" GEOS="3.7.1-CAPI-1.11.1 27a5e771" SFCGAL="1.2.2" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 1.11.4, released 2016/01/25" LIBXML="2.9.1" LIBJSON="0.11" TOPOLOGY RASTER (1 row) Time: 115.073 ms QUERY PLAN ----------------------------------------------------------------------------------------------------------------------------------- Result (cost=97.02..362.28 rows=1000 width=32) (actual time=2465.410..2486.867 rows=767 loops=1) -> ProjectSet (cost=97.02..102.28 rows=1000 width=32) (actual time=2465.402..2486.776 rows=767 loops=1) -> Aggregate (cost=97.02..97.03 rows=1 width=32) (actual time=2463.947..2463.947 rows=1 loops=1) -> Seq Scan on t1_intersects (cost=0.00..93.11 rows=1561 width=4143) (actual time=0.012..0.720 rows=1561 loops=1) Planning Time: 0.064 ms Execution Time: 2492.932 ms (6 rows) Time: 2499.112 ms (00:02.499) QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------- Result (cost=620.48..885.74 rows=1000 width=32) (actual time=14933.311..14990.527 rows=8438 loops=1) -> ProjectSet (cost=620.48..625.74 rows=1000 width=32) (actual time=14933.306..14989.714 rows=8438 loops=1) -> Aggregate (cost=620.48..620.49 rows=1 width=32) (actual time=14929.665..14929.666 rows=1 loops=1) -> Seq Scan on t1_not_intersects (cost=0.00..599.38 rows=8438 width=1711) (actual time=0.008..4.173 rows=8438 loops=1) Planning Time: 0.260 ms Execution Time: 15009.943 ms (6 rows) Time: 15016.025 ms (00:15.016) QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------------------- Result (cost=1117.45..1382.71 rows=1000 width=32) (actual time=24955.519..25036.965 rows=9205 loops=1) -> ProjectSet (cost=1117.45..1122.71 rows=1000 width=32) (actual time=24955.513..25036.080 rows=9205 loops=1) -> Aggregate (cost=1117.45..1117.46 rows=1 width=32) (actual time=24949.974..24949.974 rows=1 loops=1) -> HashAggregate (cost=892.47..992.46 rows=9999 width=36) (actual time=20.778..22.500 rows=9999 loops=1) Group Key: t1_intersects.gid, t1_intersects.geo -> Append (cost=0.00..842.48 rows=9999 width=36) (actual time=0.006..2.179 rows=9999 loops=1) -> Seq Scan on t1_intersects (cost=0.00..93.11 rows=1561 width=4147) (actual time=0.006..0.234 rows=1561 loops=1) -> Seq Scan on t1_not_intersects (cost=0.00..599.38 rows=8438 width=1715) (actual time=0.004..1.305 rows=8438 loops=1) Planning Time: 0.134 ms Execution Time: 25037.768 ms (10 rows) Time: 25044.059 ms (00:25.044) QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------- Result (cost=620.48..885.74 rows=1000 width=32) (actual time=21.225..78.477 rows=8438 loops=1) -> ProjectSet (cost=620.48..625.74 rows=1000 width=32) (actual time=21.222..77.709 rows=8438 loops=1) -> Aggregate (cost=620.48..620.49 rows=1 width=32) (actual time=17.020..17.021 rows=1 loops=1) -> Seq Scan on t1_not_intersects (cost=0.00..599.38 rows=8438 width=1711) (actual time=0.006..1.614 rows=8438 loops=1) Planning Time: 0.048 ms Execution Time: 78.775 ms (6 rows) Time: 84.628 ms