Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
- QUERY PLAN
- -----------------------------------------------------------------------------------------------------------------------------------
- Nested Loop (cost=0.29..16.59 rows=440 width=8131) (actual time=7.120..12.139 rows=41 loops=1)
- -> 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)
- Index Cond: (ogc_fid = 700)
- -> 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)
- Index Cond: (k.wkb_geometry && geom)
- Filter: _st_intersects(k.wkb_geometry, geom)
- Rows Removed by Filter: 61
- Total runtime: 12.265 ms
- (8 řádek)
- pokusnik=# explain analyze select * from ukol_1.ulice u, ukol_1.katatest k where k.ogc_fid = 700 AND k.wkb_geometry && u.geom;
- QUERY PLAN
- -----------------------------------------------------------------------------------------------------------------------------------
- Nested Loop (cost=0.29..16.34 rows=1321 width=8131) (actual time=0.076..0.285 rows=102 loops=1)
- -> 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)
- Index Cond: (ogc_fid = 700)
- -> 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)
- Index Cond: (k.wkb_geometry && geom)
- Total runtime: 0.342 ms
- (6 řádek)
- 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);
- QUERY PLAN
- -----------------------------------------------------------------------------------------------------------------------------------
- Nested Loop (cost=0.29..16.59 rows=77 width=7815) (actual time=7.160..12.148 rows=41 loops=1)
- -> 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)
- Index Cond: (ogc_fid = 700)
- -> 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)
- Index Cond: ((k.wkb_geometry && geom) AND (k.wkb_geometry && geom))
- Filter: _st_intersects(k.wkb_geometry, geom)
- Rows Removed by Filter: 61
- Total runtime: 12.268 ms
- (8 řádek)
- 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********');
- QUERY PLAN
- -----------------------------------------------------------------------------------------------------------------------------------
- Nested Loop (cost=0.29..16.34 rows=440 width=7815) (actual time=7.876..43.236 rows=41 loops=1)
- -> 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)
- Index Cond: (ogc_fid = 700)
- -> 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)
- Index Cond: (k.wkb_geometry && geom)
- Filter: st_relate(k.wkb_geometry, geom, 'T********'::text)
- Rows Removed by Filter: 61
- Total runtime: 43.292 ms
- (8 řádek)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement