NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

Hello is it finished processing? its been 9 hours since last line

2022-01-23 13:15:37  osm2pgsql version 1.5.1
2022-01-23 13:15:37  Database version: 13.5 (Debian 13.5-1.pgdg110+1)
2022-01-23 13:15:37  PostGIS version: 3.2
2022-01-23 13:15:38  Setting up table 'planet_osm_point'
2022-01-23 13:15:38  Setting up table 'planet_osm_line'
2022-01-23 13:15:38  Setting up table 'planet_osm_polygon'
2022-01-23 13:15:38  Setting up table 'planet_osm_roads'
Processing: Node(3891800k 2915.2k/s) Way(0k 0.00k/s) Relation(0 0.0/s)sudo apt-get install iotop

Processing: Node(3980900k 2946.6k/s) Way(0k 0.00k/s) Relation(0 0.0/s)
Processing: Node(7445971k 3129.9k/s) Way(12531k 3.62k/s) Relation(0 0.0/s)
Processing: Node(7445971k 3129.9k/s) Way(68887k 3.65k/s) Relation(0 0.0/s)
Processing: Node(7445971k 3129.9k/s) Way(72953k 3.71k/s) Relation(0 0.0/s)
Processing: Node(7445971k 3129.9k/s) Way(100938k 4.09k/s) Relation(0 0.0/s)
Processing: Node(7445971k 3129.9k/s) Way(105326k 4.15k/s) Relation(0 0.0/s)
Processing: Node(7445971k 3129.9k/s) Way(507298k 7.02k/s) Relation(0 0.0/s)
Processing: Node(7445971k 3129.9k/s) Way(648443k 7.55k/s) Relation(0 0.0/s)
Processing: Node(7445971k 3129.9k/s) Way(830127k 8.22k/s) Relation(238020 36.3/s)
Processing: Node(7445971k 3129.9k/s) Way(830127k 8.22k/s) Relation(587060 55.0/s)
Processing: Node(7445971k 3129.9k/s) Way(830127k 8.22k/s) Relation(1640510 86.9/s)
2022-01-25 07:18:42  Reading input files done in 151384s (42h 3m 4s).
2022-01-25 07:18:42    Processed 7445971967 nodes in 2379s (39m 39s) - 3130k/s
2022-01-25 07:18:42    Processed 830127741 ways in 100934s (28h 2m 14s) - 8k/s
2022-01-25 07:18:42    Processed 9578611 relations in 48071s (13h 21m 11s) - 199/s
2022-01-25 07:18:43  Dropping table 'planet_osm_nodes'
2022-01-25 07:18:43  Done postprocessing on table 'planet_osm_nodes' in 0s
2022-01-25 07:18:43  Dropping table 'planet_osm_ways'
2022-01-25 07:18:45  Done postprocessing on table 'planet_osm_ways' in 2s
2022-01-25 07:18:45  Dropping table 'planet_osm_rels'
2022-01-25 07:18:45  Done postprocessing on table 'planet_osm_rels' in 0s
2022-01-25 07:18:45  Done postprocessing on table 'planet_osm_nodes' in 0s
2022-01-25 07:18:45  Done postprocessing on table 'planet_osm_ways' in 0s
2022-01-25 07:18:45  Done postprocessing on table 'planet_osm_rels' in 0s
2022-01-25 07:18:45  Clustering table 'planet_osm_point' by geometry...
2022-01-25 07:18:45  Clustering table 'planet_osm_roads' by geometry...
2022-01-25 07:18:45  Clustering table 'planet_osm_polygon' by geometry...
2022-01-25 07:18:45  Clustering table 'planet_osm_line' by geometry...
2022-01-25 09:04:10  Creating geometry index on table 'planet_osm_point'...
2022-01-25 09:29:14  Creating geometry index on table 'planet_osm_roads'...
2022-01-25 09:59:54  Analyzing table 'planet_osm_roads'...
2022-01-25 11:20:04  Analyzing table 'planet_osm_point'...
2022-01-25 11:27:19  All postprocessing on table 'planet_osm_point' done in 14914s (4h 8m 34s).
2022-01-25 21:07:07  Creating geometry index on table 'planet_osm_polygon'...
2022-01-25 21:27:05  Analyzing table 'planet_osm_line'...
2022-01-25 21:27:16  All postprocessing on table 'planet_osm_line' done in 50911s (14h 8m 31s).
2022-01-26 03:17:08  Analyzing table 'planet_osm_polygon'...
2022-01-26 03:17:47  All postprocessing on table 'planet_osm_polygon' done in 71942s (19h 59m 2s).
2022-01-26 03:17:47  All postprocessing on table 'planet_osm_roads' done in 10092s (2h 48m 12s).
2022-01-26 03:17:48  osm2pgsql took 223331s (62h 2m 11s) overall.

asked 26 Jan '22, 09:37

do-d's gravatar image

do-d
11223
accept rate: 0%


Yes, it is finished. The "osm2pgsql took X (...) overall" message is the last one. You should now see the created tables fine in your database.

permanent link

answered 26 Jan '22, 12:18

mboeringa's gravatar image

mboeringa
1.5k21527
accept rate: 9%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×263

question asked: 26 Jan '22, 09:37

question was seen: 1,099 times

last updated: 26 Jan '22, 12:18

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum