Guest User

Untitled

a guest
Oct 20th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. CREATE INDEX filter_polygon_ix2
  2. ON filter_polygon.filter_polygon USING gist
  3. (geom)
  4. TABLESPACE pg_default;
  5.  
  6. select * from
  7. filter_polygon.filter_polygon AS Filter,
  8. myGeometries AS myGeoms
  9. where
  10. Filter.id = '0101'
  11. AND
  12. ST_Intersects(myGeoms.geometri, Filter.geom);
  13.  
  14. 'Nested Loop (cost=261.66..25164.63 rows=1934865 width=251228)'
  15. ' -> Seq Scan on filter_polygon filter (cost=0.00..5.24 rows=1 width=248951)'
  16. ' Filter: ((origin_id_fieldvalue)::text = '0101'::text)'
  17. ' -> Bitmap Heap Scan on myGeometries (cost=261.66..25139.51 rows=1989 width=2277)'
  18. ' Recheck Cond: (geometri && filter.geom)'
  19. ' Filter: (st_intersects(geometri, filter.geom))'
  20. ' -> Bitmap Index Scan on myGeometries_idx1 (cost=0.00..261.17 rows=5966 width=0)'
  21. ' Index Cond: (geometri && filter.geom)'
  22.  
  23. 'POSTGIS="2.1.8 r13780" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1" LIBJSON="UNKNOWN" RASTER'
  24.  
  25. 'PostgreSQL 9.4.18 on x86_64-unknown-linux-gnu (Ubuntu 9.4.18-2.pgdg14.04+1), compiled by gcc (Ubuntu 4.8.4-2ubuntu1~14.04.4) 4.8.4, 64-bit'
Add Comment
Please, Sign In to add comment