Advertisement
Guest User

Untitled

a guest
Nov 24th, 2014
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.92 KB | None | 0 0
  1. pokusnik=# explain analyze select * from ukol_1.ulice u, ukol_1.katatest k where k.ogc_fid = 700 AND ST_Intersects(k.wkb_geometry,u.geom);
  2. QUERY PLAN
  3. -----------------------------------------------------------------------------------------------------------------------------------
  4. Nested Loop (cost=0.29..16.59 rows=440 width=8131) (actual time=7.120..12.139 rows=41 loops=1)
  5. -> Index Scan using katatest_pkey on katatest k (cost=0.14..8.16 rows=1 width=7665) (actual time=0.013..0.014 rows=1 loops=1)
  6. Index Cond: (ogc_fid = 700)
  7. -> Index Scan using ulice_geom_idx on ulice u (cost=0.15..8.42 rows=1 width=466) (actual time=7.082..12.076 rows=41 loops=1)
  8. Index Cond: (k.wkb_geometry && geom)
  9. Filter: _st_intersects(k.wkb_geometry, geom)
  10. Rows Removed by Filter: 61
  11. Total runtime: 12.265 ms
  12. (8 řádek)
  13.  
  14.  
  15. pokusnik=# explain analyze select * from ukol_1.ulice u, ukol_1.katatest k where k.ogc_fid = 700 AND k.wkb_geometry && u.geom;
  16. QUERY PLAN
  17. -----------------------------------------------------------------------------------------------------------------------------------
  18. Nested Loop (cost=0.29..16.34 rows=1321 width=8131) (actual time=0.076..0.285 rows=102 loops=1)
  19. -> Index Scan using katatest_pkey on katatest k (cost=0.14..8.16 rows=1 width=7665) (actual time=0.013..0.014 rows=1 loops=1)
  20. Index Cond: (ogc_fid = 700)
  21. -> Index Scan using ulice_geom_idx on ulice u (cost=0.15..8.17 rows=1 width=466) (actual time=0.037..0.188 rows=102 loops=1)
  22. Index Cond: (k.wkb_geometry && geom)
  23. Total runtime: 0.342 ms
  24. (6 řádek)
  25. pokusnik=# explain analyze SELECT * FROM (select geom, wkb_geometry from ukol_1.ulice u, ukol_1.katatest k where k.ogc_fid = 700 AND k.wkb_geometry && u.geom) a where ST_INtersects(wkb_geometry, geom);
  26. QUERY PLAN
  27. -----------------------------------------------------------------------------------------------------------------------------------
  28. Nested Loop (cost=0.29..16.59 rows=77 width=7815) (actual time=7.160..12.148 rows=41 loops=1)
  29. -> Index Scan using katatest_pkey on katatest k (cost=0.14..8.16 rows=1 width=7486) (actual time=0.012..0.013 rows=1 loops=1)
  30. Index Cond: (ogc_fid = 700)
  31. -> Index Scan using ulice_geom_idx on ulice u (cost=0.15..8.42 rows=1 width=329) (actual time=7.103..12.072 rows=41 loops=1)
  32. Index Cond: ((k.wkb_geometry && geom) AND (k.wkb_geometry && geom))
  33. Filter: _st_intersects(k.wkb_geometry, geom)
  34. Rows Removed by Filter: 61
  35. Total runtime: 12.268 ms
  36. (8 řádek)
  37. pokusnik=# explain analyze SELECT * FROM (select geom, wkb_geometry from ukol_1.ulice u, ukol_1.katatest k where k.ogc_fid = 700 AND k.wkb_geometry && u.geom) a where ST_Relate(wkb_geometry, geom, 'T********');
  38. QUERY PLAN
  39. -----------------------------------------------------------------------------------------------------------------------------------
  40. Nested Loop (cost=0.29..16.34 rows=440 width=7815) (actual time=7.876..43.236 rows=41 loops=1)
  41. -> Index Scan using katatest_pkey on katatest k (cost=0.14..8.16 rows=1 width=7486) (actual time=0.014..0.016 rows=1 loops=1)
  42. Index Cond: (ogc_fid = 700)
  43. -> Index Scan using ulice_geom_idx on ulice u (cost=0.15..8.17 rows=1 width=329) (actual time=7.839..43.174 rows=41 loops=1)
  44. Index Cond: (k.wkb_geometry && geom)
  45. Filter: st_relate(k.wkb_geometry, geom, 'T********'::text)
  46. Rows Removed by Filter: 61
  47. Total runtime: 43.292 ms
  48. (8 řádek)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement