Created
January 20, 2020 18:23
-
-
Save Komzpa/2cd396ec9b65e2c93341e9934d974826 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
21:22:14 [gis] > explain select | |
node_from | |
from | |
osm_road_segments | |
where | |
seg_geom && ST_Buffer('POINT(0 0)'::geography, 10000)::geometry and ST_Intersects(seg_geom, ST_Buffer('POINT(0 0)'::geography, 10000)::geometry) | |
order by 'POINT(0 0)' <-> seg_geom | |
limit 1; | |
QUERY PLAN | |
────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── | |
Limit (cost=2681821710.55..2681821710.56 rows=1 width=16) | |
-> Sort (cost=2681821710.55..2681821710.56 rows=1 width=16) | |
Sort Key: (('010100000000000000000000000000000000000000'::geometry <-> seg_geom)) | |
-> Gather (cost=100.00..2681821710.54 rows=1 width=16) | |
Workers Planned: 16 | |
-> Parallel Seq Scan on osm_road_segments (cost=0.00..2681821610.54 rows=1 width=16) | |
Filter: ((seg_geom && '0103000020E610000001000000210000008713DA6BABF9B63F0000000000000000163A323AA488B63FB464E0BEF00C92BF14F5D71DE739B53FCA8A342F21B4A1BFB35EE5AD521AB33FC8CB015E95B3A9BF5FC84DCFCC3EB03F598E1890115BB0BF0AE23E99E986A93F7F07F34B693BB3BFB7DEC9941C95A13FD08E9743865EB5BF2C42212CBFEC913F633C427763AFB6BF2ECB4C51821BCFBEBC40FD1A1121B7BFDE1F45018BEE91BF79B4188733AFB6BFE309278DCC95A1BF019899AF2D5EB5BF97CC32D54887A9BFC1FE5990F53AB3BF6C7045CFCC3EB0BFE7BA6E4B945AB0BFDD9CDF0F231AB3BF262BE0E6ADB2A9BF985EA9218F39B5BF68DD4F0770B3A1BF700EF5443188B6BFF0265BFE300C92BFE17CE1FD2EF9B6BF6B0C8BDE9508B5BC700EF5443188B6BF4B265BFE300C923FB55EA9218F39B5BF1ADD4F0770B3A13FDD9CDF0F231AB3BFE12AE0E6ADB2A93FA67045CFCC3EB0BFCBBA6E4B945AB03FD0CC32D54887A9BFA8FE5990F53AB33F560A278DCC95A1BFF19799AF2D5EB53F502045018BEE91BF72B4188733AFB63FF8C37751821BCFBEBC40FD1A1121B73F2C42212CBFEC913F683C427763AFB63FB7DEC9941C95A13FDB8E9743865EB53FD1E13E99E986A93F8E07F34B693BB33F5FC84DCFCC3EB03F6A8E1890115BB03FB35EE5AD521AB33FEDCB015E95B3A93FF7F4D71DE739B53FED8A342F21B4A13F163A323AA488B63FF364E0BEF00C923F8713DA6BABF9B63F0000000000000000'::geometry) AND st_intersects(seg_geom, '0103000020E610000001000000210000008713DA6BABF9B63F0000000000000000163A323AA488B63FB464E0BEF00C92BF14F5D71DE739B53FCA8A342F21B4A1BFB35EE5AD521AB33FC8CB015E95B3A9BF5FC84DCFCC3EB03F598E1890115BB0BF0AE23E99E986A93F7F07F34B693BB3BFB7DEC9941C95A13FD08E9743865EB5BF2C42212CBFEC913F633C427763AFB6BF2ECB4C51821BCFBEBC40FD1A1121B7BFDE1F45018BEE91BF79B4188733AFB6BFE309278DCC95A1BF019899AF2D5EB5BF97CC32D54887A9BFC1FE5990F53AB3BF6C7045CFCC3EB0BFE7BA6E4B945AB0BFDD9CDF0F231AB3BF262BE0E6ADB2A9BF985EA9218F39B5BF68DD4F0770B3A1BF700EF5443188B6BFF0265BFE300C92BFE17CE1FD2EF9B6BF6B0C8BDE9508B5BC700EF5443188B6BF4B265BFE300C923FB55EA9218F39B5BF1ADD4F0770B3A13FDD9CDF0F231AB3BFE12AE0E6ADB2A93FA67045CFCC3EB0BFCBBA6E4B945AB03FD0CC32D54887A9BFA8FE5990F53AB33F560A278DCC95A1BFF19799AF2D5EB53F502045018BEE91BF72B4188733AFB63FF8C37751821BCFBEBC40FD1A1121B73F2C42212CBFEC913F683C427763AFB63FB7DEC9941C95A13FDB8E9743865EB53FD1E13E99E986A93F8E07F34B693BB33F5FC84DCFCC3EB03F6A8E1890115BB03FB35EE5AD521AB33FEDCB015E95B3A93FF7F4D71DE739B53FED8A342F21B4A13F163A323AA488B63FF364E0BEF00C923F8713DA6BABF9B63F0000000000000000'::geometry)) | |
JIT: | |
Functions: 5 | |
Options: Inlining true, Optimization true, Expressions true, Deforming true | |
(10 rows) | |
Time: 191,643 ms | |
21:22:40 [gis] > set enable_seqscan to off; | |
SET | |
Time: 0,976 ms | |
21:22:51 [gis] > explain select | |
node_from | |
from | |
osm_road_segments | |
where | |
seg_geom && ST_Buffer('POINT(0 0)'::geography, 10000)::geometry and ST_Intersects(seg_geom, ST_Buffer('POINT(0 0)'::geography, 10000)::geometry) | |
order by 'POINT(0 0)' <-> seg_geom | |
limit 1; | |
QUERY PLAN | |
───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── | |
Limit (cost=2681828775.60..2681828775.61 rows=1 width=16) | |
-> Sort (cost=2681828775.60..2681828775.61 rows=1 width=16) | |
Sort Key: (('010100000000000000000000000000000000000000'::geometry <-> seg_geom)) | |
-> Gather (cost=7165.05..2681828775.59 rows=1 width=16) | |
Workers Planned: 16 | |
-> Parallel Bitmap Heap Scan on osm_road_segments (cost=7065.05..2681828675.59 rows=1 width=16) | |
Recheck Cond: (seg_geom && '0103000020E610000001000000210000008713DA6BABF9B63F0000000000000000163A323AA488B63FB464E0BEF00C92BF14F5D71DE739B53FCA8A342F21B4A1BFB35EE5AD521AB33FC8CB015E95B3A9BF5FC84DCFCC3EB03F598E1890115BB0BF0AE23E99E986A93F7F07F34B693BB3BFB7DEC9941C95A13FD08E9743865EB5BF2C42212CBFEC913F633C427763AFB6BF2ECB4C51821BCFBEBC40FD1A1121B7BFDE1F45018BEE91BF79B4188733AFB6BFE309278DCC95A1BF019899AF2D5EB5BF97CC32D54887A9BFC1FE5990F53AB3BF6C7045CFCC3EB0BFE7BA6E4B945AB0BFDD9CDF0F231AB3BF262BE0E6ADB2A9BF985EA9218F39B5BF68DD4F0770B3A1BF700EF5443188B6BFF0265BFE300C92BFE17CE1FD2EF9B6BF6B0C8BDE9508B5BC700EF5443188B6BF4B265BFE300C923FB55EA9218F39B5BF1ADD4F0770B3A13FDD9CDF0F231AB3BFE12AE0E6ADB2A93FA67045CFCC3EB0BFCBBA6E4B945AB03FD0CC32D54887A9BFA8FE5990F53AB33F560A278DCC95A1BFF19799AF2D5EB53F502045018BEE91BF72B4188733AFB63FF8C37751821BCFBEBC40FD1A1121B73F2C42212CBFEC913F683C427763AFB63FB7DEC9941C95A13FDB8E9743865EB53FD1E13E99E986A93F8E07F34B693BB33F5FC84DCFCC3EB03F6A8E1890115BB03FB35EE5AD521AB33FEDCB015E95B3A93FF7F4D71DE739B53FED8A342F21B4A13F163A323AA488B63FF364E0BEF00C923F8713DA6BABF9B63F0000000000000000'::geometry) | |
Filter: st_intersects(seg_geom, '0103000020E610000001000000210000008713DA6BABF9B63F0000000000000000163A323AA488B63FB464E0BEF00C92BF14F5D71DE739B53FCA8A342F21B4A1BFB35EE5AD521AB33FC8CB015E95B3A9BF5FC84DCFCC3EB03F598E1890115BB0BF0AE23E99E986A93F7F07F34B693BB3BFB7DEC9941C95A13FD08E9743865EB5BF2C42212CBFEC913F633C427763AFB6BF2ECB4C51821BCFBEBC40FD1A1121B7BFDE1F45018BEE91BF79B4188733AFB6BFE309278DCC95A1BF019899AF2D5EB5BF97CC32D54887A9BFC1FE5990F53AB3BF6C7045CFCC3EB0BFE7BA6E4B945AB0BFDD9CDF0F231AB3BF262BE0E6ADB2A9BF985EA9218F39B5BF68DD4F0770B3A1BF700EF5443188B6BFF0265BFE300C92BFE17CE1FD2EF9B6BF6B0C8BDE9508B5BC700EF5443188B6BF4B265BFE300C923FB55EA9218F39B5BF1ADD4F0770B3A13FDD9CDF0F231AB3BFE12AE0E6ADB2A93FA67045CFCC3EB0BFCBBA6E4B945AB03FD0CC32D54887A9BFA8FE5990F53AB33F560A278DCC95A1BFF19799AF2D5EB53F502045018BEE91BF72B4188733AFB63FF8C37751821BCFBEBC40FD1A1121B73F2C42212CBFEC913F683C427763AFB63FB7DEC9941C95A13FDB8E9743865EB53FD1E13E99E986A93F8E07F34B693BB33F5FC84DCFCC3EB03F6A8E1890115BB03FB35EE5AD521AB33FEDCB015E95B3A93FF7F4D71DE739B53FED8A342F21B4A13F163A323AA488B63FF364E0BEF00C923F8713DA6BABF9B63F0000000000000000'::geometry) | |
-> Bitmap Index Scan on osm_road_segments_seg_geom_idx (cost=0.00..7065.05 rows=1683425664 width=0) | |
Index Cond: ((seg_geom && '0103000020E610000001000000210000008713DA6BABF9B63F0000000000000000163A323AA488B63FB464E0BEF00C92BF14F5D71DE739B53FCA8A342F21B4A1BFB35EE5AD521AB33FC8CB015E95B3A9BF5FC84DCFCC3EB03F598E1890115BB0BF0AE23E99E986A93F7F07F34B693BB3BFB7DEC9941C95A13FD08E9743865EB5BF2C42212CBFEC913F633C427763AFB6BF2ECB4C51821BCFBEBC40FD1A1121B7BFDE1F45018BEE91BF79B4188733AFB6BFE309278DCC95A1BF019899AF2D5EB5BF97CC32D54887A9BFC1FE5990F53AB3BF6C7045CFCC3EB0BFE7BA6E4B945AB0BFDD9CDF0F231AB3BF262BE0E6ADB2A9BF985EA9218F39B5BF68DD4F0770B3A1BF700EF5443188B6BFF0265BFE300C92BFE17CE1FD2EF9B6BF6B0C8BDE9508B5BC700EF5443188B6BF4B265BFE300C923FB55EA9218F39B5BF1ADD4F0770B3A13FDD9CDF0F231AB3BFE12AE0E6ADB2A93FA67045CFCC3EB0BFCBBA6E4B945AB03FD0CC32D54887A9BFA8FE5990F53AB33F560A278DCC95A1BFF19799AF2D5EB53F502045018BEE91BF72B4188733AFB63FF8C37751821BCFBEBC40FD1A1121B73F2C42212CBFEC913F683C427763AFB63FB7DEC9941C95A13FDB8E9743865EB53FD1E13E99E986A93F8E07F34B693BB33F5FC84DCFCC3EB03F6A8E1890115BB03FB35EE5AD521AB33FEDCB015E95B3A93FF7F4D71DE739B53FED8A342F21B4A13F163A323AA488B63FF364E0BEF00C923F8713DA6BABF9B63F0000000000000000'::geometry) AND (seg_geom && '0103000020E610000001000000210000008713DA6BABF9B63F0000000000000000163A323AA488B63FB464E0BEF00C92BF14F5D71DE739B53FCA8A342F21B4A1BFB35EE5AD521AB33FC8CB015E95B3A9BF5FC84DCFCC3EB03F598E1890115BB0BF0AE23E99E986A93F7F07F34B693BB3BFB7DEC9941C95A13FD08E9743865EB5BF2C42212CBFEC913F633C427763AFB6BF2ECB4C51821BCFBEBC40FD1A1121B7BFDE1F45018BEE91BF79B4188733AFB6BFE309278DCC95A1BF019899AF2D5EB5BF97CC32D54887A9BFC1FE5990F53AB3BF6C7045CFCC3EB0BFE7BA6E4B945AB0BFDD9CDF0F231AB3BF262BE0E6ADB2A9BF985EA9218F39B5BF68DD4F0770B3A1BF700EF5443188B6BFF0265BFE300C92BFE17CE1FD2EF9B6BF6B0C8BDE9508B5BC700EF5443188B6BF4B265BFE300C923FB55EA9218F39B5BF1ADD4F0770B3A13FDD9CDF0F231AB3BFE12AE0E6ADB2A93FA67045CFCC3EB0BFCBBA6E4B945AB03FD0CC32D54887A9BFA8FE5990F53AB33F560A278DCC95A1BFF19799AF2D5EB53F502045018BEE91BF72B4188733AFB63FF8C37751821BCFBEBC40FD1A1121B73F2C42212CBFEC913F683C427763AFB63FB7DEC9941C95A13FDB8E9743865EB53FD1E13E99E986A93F8E07F34B693BB33F5FC84DCFCC3EB03F6A8E1890115BB03FB35EE5AD521AB33FEDCB015E95B3A93FF7F4D71DE739B53FED8A342F21B4A13F163A323AA488B63FF364E0BEF00C923F8713DA6BABF9B63F0000000000000000'::geometry)) | |
JIT: | |
Functions: 7 | |
Options: Inlining true, Optimization true, Expressions true, Deforming true | |
(13 rows) | |
Time: 8,050 ms |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment