Skip to content

Instantly share code, notes, and snippets.

@nyurik
Last active August 29, 2015 14:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nyurik/125fd7e325a49fd3ce57 to your computer and use it in GitHub Desktop.
Save nyurik/125fd7e325a49fd3ce57 to your computer and use it in GitHub Desktop.
DB Imports stats
Generating 1 tiles
DONE: 3min Z=0 0/s {"checked":1,"nosave":0,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":1,"started":1,"tilegen":1,"tilegenempty":0,"tilegenerr":0,"tilegenok":1,"tilenodata":0,"tilenonsolid":0,"tiletoobig":1,"totalsize":917352,"avgsize":917352}
Generating 4 tiles
DONE: 11min Z=1 0/s {"checked":4,"nosave":0,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":4,"started":4,"tilegen":4,"tilegenempty":0,"tilegenerr":0,"tilegenok":4,"tilenodata":0,"tilenonsolid":0,"tiletoobig":4,"totalsize":1455039,"avgsize":363759.75}
Generating 16 tiles
DONE: 19min Z=2 0/s {"checked":16,"nosave":0,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":16,"started":16,"tilegen":16,"tilegenempty":0,"tilegenerr":0,"tilegenok":16,"tilenodata":0,"tilenonsolid":0,"tiletoobig":16,"totalsize":2453543,"avgsize":153346.44}
Generating 64 tiles
DONE: 33min Z=3 0/s {"checked":64,"nosave":0,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":64,"started":64,"tilegen":64,"tilegenempty":0,"tilegenerr":0,"tilegenok":64,"tilenodata":0,"tilenonsolid":15,"tiletoobig":49,"totalsize":5041335,"avgsize":78770.86}
Generating 256 tiles
DONE: 45min Z=4 0.1/s {"checked":256,"nosave":14,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":242,"started":256,"tilegen":256,"tilegenempty":11,"tilegenerr":0,"tilegenok":245,"tilenodata":11,"tilenonsolid":101,"tiletoobig":141,"totalsize":6546314,"solid_water":3,"avgsize":27050.88}
Generating 1024 tiles
DONE: 69min Z=5 0.2/s {"checked":1024,"nosave":155,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":869,"started":1024,"tilegen":1024,"tilegenempty":101,"tilegenerr":0,"tilegenok":923,"tilenodata":101,"tilenonsolid":477,"tiletoobig":392,"totalsize":22779770,"solid_water":54,"avgsize":26213.77}
Generating 4096 tiles
DONE: 95min Z=6 0.7/s {"checked":4096,"nosave":1135,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":2961,"started":4096,"tilegen":4096,"tilegenempty":561,"tilegenerr":0,"tilegenok":3535,"tilenodata":561,"tilenonsolid":1830,"tiletoobig":1131,"totalsize":29903683,"solid_water":574,"avgsize":10099.18}
Generating 16384 tiles
DONE: 129min Z=7 2.1/s {"checked":16384,"nosave":6947,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":9437,"started":16384,"tilegen":16384,"tilegenempty":2716,"tilegenerr":0,"tilegenok":13668,"tilenodata":2716,"tilenonsolid":6231,"tiletoobig":3206,"totalsize":171912698,"solid_water":4227,"solid_landuse-water":4,"avgsize":18216.88}
Generating 65536 tiles
DONE: 168min Z=8 6.5/s {"checked":65536,"nosave":35905,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":29631,"started":65536,"tilegen":65536,"tilegenempty":11886,"tilegenerr":0,"tilegenok":53650,"tilenodata":11886,"tilenonsolid":19899,"tiletoobig":9732,"totalsize":270533648,"solid_water":23970,"solid_landuse":1,"solid_landuse-water":47,"solid_-water":1,"avgsize":9130.09}
Generating 262144 tiles
DONE: 235min Z=9 18.6/s {"checked":262144,"nosave":171870,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":90274,"started":262144,"tilegen":262144,"tilegenempty":52537,"tilegenerr":0,"tilegenok":209607,"tilenodata":52537,"tilenonsolid":64816,"tiletoobig":25458,"totalsize":456139928,"solid_water":118872,"solid_landuse":23,"solid_-water":15,"solid_landuse-water":423,"avgsize":5052.84}
DONE: 404min Z=10 43.2/s {"checked":1048576,"nosave":779382,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":269194,"started":1048576,"tilegen":1048576,"tilegenempty":232774,"tilegenerr":0,"tilegenok":815802,"tilenodata":232774,"tilenonsolid":211682,"tiletoobig":57512,"totalsize":720772766,"solid_water":542932,"solid_-water":206,"solid_landuse":430,"solid_landuse-water":3022,"solid_-water-water":7,"solid_landuse-water-water":1,"solid_landuse-water-water-water":9,"solid_-water-water-water":1,"avgsize":2677.52}
Second run with updated SQL:
Generating 256 tiles
DONE: 13min Z=4 0.3/s {"checked":256,"nosave":14,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":242,"started":256,"tilegen":256,"tilegenempty":11,"tilegenerr":0,"tilegenok":245,"tilenodata":11,"tilenonsolid":105,"tiletoobig":137,"totalsize":6131676,"solid_water":3,"avgsize":25337.5}
Generating 1024 tiles
DONE: 38min Z=5 0.4/s {"checked":1024,"nosave":155,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":869,"started":1024,"tilegen":1024,"tilegenempty":101,"tilegenerr":0,"tilegenok":923,"tilenodata":101,"tilenonsolid":479,"tiletoobig":390,"totalsize":22337282,"solid_water":54,"avgsize":25704.58}
Generating 4096 tiles
DONE: 64min Z=6 1.1/s {"checked":4096,"nosave":1137,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":2959,"started":4096,"tilegen":4096,"tilegenempty":561,"tilegenerr":0,"tilegenok":3535,"tilenodata":561,"tilenonsolid":1830,"tiletoobig":1129,"totalsize":29425583,"solid_water":576,"avgsize":9944.43}
Generating 16384 tiles
DONE: 99min Z=7 2.7/s {"checked":16384,"nosave":6957,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":9427,"started":16384,"tilegen":16384,"tilegenempty":2722,"tilegenerr":0,"tilegenok":13662,"tilenodata":2722,"tilenonsolid":6263,"tiletoobig":3164,"totalsize":167101427,"solid_water":4231,"solid_landuse-water":4,"avgsize":17725.83}
Generating 65536 tiles
DONE: 142min Z=8 7.7/s {"checked":65536,"nosave":35916,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":29620,"started":65536,"tilegen":65536,"tilegenempty":11897,"tilegenerr":0,"tilegenok":53639,"tilenodata":11897,"tilenonsolid":19992,"tiletoobig":9628,"totalsize":265328746,"solid_water":23970,"solid_landuse":1,"solid_landuse-water":47,"solid_-water":1,"avgsize":8957.76}
DONE: 212min Z=9 20.6/s {"checked":262144,"nosave":171870,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":90274,"started":262144,"tilegen":262144,"tilegenempty":52537,"tilegenerr":0,"tilegenok":209607,"tilenodata":52537,"tilenonsolid":64836,"tiletoobig":25438,"totalsize":454509733,"solid_water":118872,"solid_landuse":23,"solid_-water":15,"solid_landuse-water":423,"avgsize":5034.78}
Generating 1048576 tiles
DONE: 384min Z=10 45.4/s {"checked":1048576,"nosave":779382,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":269194,"started":1048576,"tilegen":1048576,"tilegenempty":232774,"tilegenerr":0,"tilegenok":815802,"tilenodata":232774,"tilenonsolid":211710,"tiletoobig":57484,"totalsize":720049984,"solid_water":542932,"solid_-water":206,"solid_landuse":430,"solid_landuse-water":3022,"solid_-water-water":7,"solid_landuse-water-water":1,"solid_landuse-water-water-water":9,"solid_-water-water-water":1,"avgsize":2674.84}
DONE: 1691min Z=12 163.7/s {"checked":16613603,"nosave":14292968,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":2320635,"started":16777216,"tilegen":16613603,"tilegenempty":4266099,"tilegenerr":0,"tilegenok":12347504,"tilenodata":4266099,"tilenonsolid":2315913,"tiletoobig":4722,"solid_water":9889939,"solid_-water":16319,"solid_-water-water":1131,"solid_landuse-water":80171,"solid_landuse":37986,"solid_landuse-water-water":472,"solid_landuse-water-water-water":735,"solid_-water-water-water":99,"solid_-road_label":15,"solid_water-road_label":1,"solid_-water-water-water-water":1}
DONE: 6579min Z=13 170/s {"checked":67108864,"nosave":59593809,"ozload":0,"ozloadempty":0,"ozloaderror":0,"ozloadok":0,"save":7515055,"started":67108864,"tilegen":67108864,"tilegenempty":18066892,"tilegenerr":0,"tilegenok":49041972,"tilenodata":18066892,"tilenonsolid":7292579,"tiletoobig":222476,"solid_water":40785944,"solid_-water-water":9676,"solid_-water":121263,"solid_landuse-water":370312,"solid_-water-water-water":942,"solid_landuse":229981,"solid_landuse-water-water":4293,"solid_water-road_label":5,"solid_landuse-water-water-water":4388,"solid_-road_label":65,"solid_-road_label-road_label":3,"solid_-water-water-water-water":24,"solid_-admin-admin":1,"solid_-water-road_label":2,"solid_landuse-water-water-water-water":16,"solid_landuse-road_label":1,"solid_landuse-aeroway":1}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment