Created
July 11, 2020 06:09
-
-
Save smellman/3b87ae65a140a22adb168152b9784160 to your computer and use it in GitHub Desktop.
openmaptiles logs 20200708
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
| ====> : Start SQL postprocessing: ./build/sql/* -> PostgreSQL | |
| : Source code: https://github.com/openmaptiles/openmaptiles-tools/blob/master/bin/import-sql | |
| Starting postgres docker compose target using default image (no recreate if exists) | |
| Starting openmaptiles_postgres_1 ... done | |
| docker-compose run --rm -u 1000:1000 openmaptiles-tools sh -c 'pgwait && import-sql' | \ | |
| awk -v s=": WARNING:" '$0~s{print; print "\n*** WARNING detected, aborting"; exit(1)} 1' | |
| Importing /usr/src/app/sql/CleanNumeric.sql (md5 d8300fc8b346b6288993391fb4f3c31d - 18 lines) into Postgres... | |
| Timing is on. | |
| CREATE FUNCTION | |
| Time: 11.222 ms | |
| Importing /usr/src/app/sql/LabelGrid.sql (md5 fc70f3ec686bb28e68a48d0cf836d4b8 - 58 lines) into Postgres... | |
| Timing is on. | |
| CREATE FUNCTION | |
| Time: 8.680 ms | |
| Importing /usr/src/app/sql/LineLabel.sql (md5 71fcd9c99a394f7b126e107c4d7c49d7 - 34 lines) into Postgres... | |
| Timing is on. | |
| CREATE FUNCTION | |
| Time: 10.144 ms | |
| Importing /usr/src/app/sql/TileBBox.sql (md5 a15bd1f4570f77f765d352bf237a1411 - 42 lines) into Postgres... | |
| Timing is on. | |
| CREATE FUNCTION | |
| Time: 6.898 ms | |
| Importing /usr/src/app/sql/ToPoint.sql (md5 84f649a97153d0932cbde91ac8efa0f2 - 47 lines) into Postgres... | |
| Timing is on. | |
| CREATE FUNCTION | |
| Time: 36.939 ms | |
| Importing /usr/src/app/sql/Z.sql (md5 86ff3018c262e31b8dd9f8337d45e98c - 39 lines) into Postgres... | |
| Timing is on. | |
| CREATE FUNCTION | |
| Time: 5.932 ms | |
| Importing /usr/src/app/sql/ZRes.sql (md5 d69b542be73069bf033e012aa56bb69f - 41 lines) into Postgres... | |
| Timing is on. | |
| CREATE FUNCTION | |
| Time: 4.667 ms | |
| CREATE FUNCTION | |
| Time: 3.101 ms | |
| Importing /usr/src/app/sql/zzz_language.sql (md5 3a64b14cb2f1a39e7bb98581cd693267 - 164 lines) into Postgres... | |
| Timing is on. | |
| CREATE FUNCTION | |
| Time: 8.286 ms | |
| CREATE FUNCTION | |
| Time: 3.764 ms | |
| CREATE FUNCTION | |
| Time: 7.283 ms | |
| CREATE FUNCTION | |
| Time: 7.231 ms | |
| CREATE FUNCTION | |
| Time: 7.498 ms | |
| CREATE FUNCTION | |
| Time: 7.786 ms | |
| psql:/usr/src/app/sql/zzz_language.sql:125: NOTICE: relation "wd_names" already exists, skipping | |
| CREATE TABLE | |
| Time: 0.934 ms | |
| CREATE FUNCTION | |
| Time: 6.912 ms | |
| CREATE FUNCTION | |
| Time: 7.200 ms | |
| Importing /usr/src/app/sql/zzz_omt_as_numeric.sql (md5 ae5e2fb975b2212d31aa56c8d0d02ed0 - 10 lines) into Postgres... | |
| Timing is on. | |
| CREATE FUNCTION | |
| Time: 5.448 ms | |
| Importing /sql/run_first.sql (md5 123b660794ba7d420bd85f8b6ab77a37 - 6 lines) into Postgres... | |
| Timing is on. | |
| CREATE FUNCTION | |
| Time: 5.686 ms | |
| Importing 14 sql files from /sql/parallel/, up to 5 files at the same time | |
| Importing /sql/parallel/building.sql (md5 46d71248779b990be89fbf01ac27b833 - 254 lines) into Postgres... | |
| Importing /sql/parallel/water_name.sql (md5 b83707de5706f980534fe6e6912bd9ea - 355 lines) into Postgres... | |
| Importing /sql/parallel/housenumber.sql (md5 457719c03942056248008e36368f15ee - 93 lines) into Postgres... | |
| Importing /sql/parallel/aeroway.sql (md5 c83922c6cbcd8828166db561264ab4b8 - 67 lines) into Postgres... | |
| Importing /sql/parallel/poi.sql (md5 36804089c15c26704e9be223f7968d4d - 413 lines) into Postgres... | |
| Timing is on. | |
| psql:/sql/parallel/housenumber.sql:1: NOTICE: Processing layer housenumber | |
| DO | |
| Time: 1.821 ms | |
| psql:/sql/parallel/housenumber.sql:5: NOTICE: trigger "trigger_flag" for relation "osm_housenumber_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 1.723 ms | |
| Timing is on. | |
| Timing is on. | |
| psql:/sql/parallel/housenumber.sql:6: NOTICE: schema "housenumber" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 2.030 ms | |
| psql:/sql/parallel/building.sql:1: NOTICE: Processing layer building | |
| psql:/sql/parallel/water_name.sql:1: DO | |
| NOTICE: Processing layer water_name | |
| Time: 1.423 ms | |
| DO | |
| Time: 3.240 ms | |
| psql:/sql/parallel/building.sql:5: NOTICE: schema "buildings" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.246 ms | |
| psql:/sql/parallel/building.sql:6: NOTICE: trigger "trigger_flag" for relation "osm_building_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.671 ms | |
| psql:/sql/parallel/water_name.sql:5: NOTICE: trigger "trigger_flag" for relation "osm_marine_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 2.214 ms | |
| psql:/sql/parallel/water_name.sql:6: NOTICE: schema "water_name_marine" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.455 ms | |
| CREATE FUNCTION | |
| Time: 4.655 ms | |
| CREATE FUNCTION | |
| Time: 4.736 ms | |
| psql:/sql/parallel/building.sql:78: NOTICE: materialized view "osm_building_block_gen1" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| psql:/sql/parallel/water_name.sql:8: NOTICE: extension "unaccent" already exists, skipping | |
| Time: 0.621 ms | |
| CREATE EXTENSION | |
| Time: 3.837 ms | |
| CREATE FUNCTION | |
| Time: 3.973 ms | |
| Timing is on. | |
| psql:/sql/parallel/aeroway.sql:1: NOTICE: Processing layer aeroway | |
| DO | |
| Time: 5.443 ms | |
| CREATE FUNCTION | |
| Time: 14.370 ms | |
| psql:/sql/parallel/aeroway.sql:67: NOTICE: Finished layer aeroway | |
| DO | |
| Time: 0.379 ms | |
| Timing is on. | |
| psql:/sql/parallel/poi.sql:1: NOTICE: Processing layer poi | |
| DO | |
| Time: 2.161 ms | |
| Importing /sql/parallel/mountain_peak.sql (md5 4b5628e9db5a07ca87be6238ca6efe0f - 104 lines) into Postgres... | |
| DO | |
| Time: 7.702 ms | |
| CREATE FUNCTION | |
| Time: 5.063 ms | |
| CREATE FUNCTION | |
| Time: 9.045 ms | |
| psql:/sql/parallel/poi.sql:99: NOTICE: materialized view "osm_poi_stop_centroid" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.887 ms | |
| update_osm_marine_point | |
| ------------------------- | |
| (1 row) | |
| Time: 70.157 ms | |
| CREATE INDEX | |
| Time: 20.844 ms | |
| CREATE SCHEMA | |
| Time: 6.112 ms | |
| CREATE TABLE | |
| Time: 31.714 ms | |
| Timing is on. | |
| psql:/sql/parallel/mountain_peak.sql:1: NOTICE: Processing layer mountain_peak | |
| DO | |
| Time: 1.316 ms | |
| psql:/sql/parallel/mountain_peak.sql:5: NOTICE: trigger "trigger_update_point" for relation "osm_peak_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.515 ms | |
| CREATE FUNCTION | |
| Time: 11.396 ms | |
| CREATE FUNCTION | |
| Time: 12.878 ms | |
| CREATE FUNCTION | |
| Time: 8.184 ms | |
| CREATE TRIGGER | |
| Time: 4.563 ms | |
| CREATE TRIGGER | |
| Time: 3.774 ms | |
| psql:/sql/parallel/water_name.sql:87: NOTICE: trigger "trigger_delete_line" for relation "osm_water_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.725 ms | |
| psql:/sql/parallel/water_name.sql:88: NOTICE: trigger "trigger_update_line" for relation "osm_water_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.362 ms | |
| psql:/sql/parallel/water_name.sql:89: NOTICE: trigger "trigger_insert_line" for relation "osm_water_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 1.146 ms | |
| CREATE VIEW | |
| Time: 9.381 ms | |
| SELECT 0 | |
| Time: 444.786 ms | |
| psql:/sql/parallel/poi.sql:112: NOTICE: materialized view "osm_poi_stop_rank" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 1.517 ms | |
| SELECT 0 | |
| Time: 21.885 ms | |
| psql:/sql/parallel/poi.sql:133: NOTICE: trigger "trigger_flag" for relation "osm_poi_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 1.115 ms | |
| psql:/sql/parallel/poi.sql:134: NOTICE: schema "poi_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.870 ms | |
| CREATE FUNCTION | |
| Time: 6.378 ms | |
| convert_housenumber_point | |
| --------------------------- | |
| (1 row) | |
| Time: 5901.461 ms (00:05.901) | |
| CREATE SCHEMA | |
| Time: 30.532 ms | |
| CREATE TABLE | |
| Time: 265.498 ms | |
| CREATE FUNCTION | |
| Time: 167.357 ms | |
| CREATE FUNCTION | |
| Time: 82.946 ms | |
| CREATE TRIGGER | |
| Time: 122.648 ms | |
| CREATE TRIGGER | |
| Time: 85.226 ms | |
| CREATE FUNCTION | |
| Time: 28.030 ms | |
| psql:/sql/parallel/housenumber.sql:93: NOTICE: Finished layer housenumber | |
| DO | |
| Time: 0.230 ms | |
| Importing /sql/parallel/transportation__transportation_name.sql (md5 aa41c281aa6ca6310036506078962d78 - 1481 lines) into Postgres... | |
| Timing is on. | |
| psql:/sql/parallel/transportation__transportation_name.sql:1: NOTICE: Processing layer transportation | |
| DO | |
| Time: 3.474 ms | |
| CREATE FUNCTION | |
| Time: 22.104 ms | |
| CREATE FUNCTION | |
| Time: 30.860 ms | |
| CREATE FUNCTION | |
| Time: 50.934 ms | |
| CREATE FUNCTION | |
| Time: 66.706 ms | |
| CREATE FUNCTION | |
| Time: 119.559 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:107: NOTICE: materialized view "osm_transportation_merge_linestring" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.563 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:108: NOTICE: materialized view "osm_transportation_merge_linestring_gen3" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.453 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:109: NOTICE: materialized view "osm_transportation_merge_linestring_gen4" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.664 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:110: NOTICE: materialized view "osm_transportation_merge_linestring_gen5" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.490 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:111: NOTICE: materialized view "osm_transportation_merge_linestring_gen6" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 1.037 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:112: NOTICE: materialized view "osm_transportation_merge_linestring_gen7" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 1.337 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:115: NOTICE: trigger "trigger_flag_transportation" for relation "osm_highway_linestring" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 1.605 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:116: NOTICE: schema "transportation" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 1.199 ms | |
| SELECT 13 | |
| Time: 7740.993 ms (00:07.741) | |
| DO | |
| Time: 60.712 ms | |
| CREATE INDEX | |
| Time: 23.744 ms | |
| CREATE SCHEMA | |
| Time: 28.014 ms | |
| CREATE FUNCTION | |
| Time: 35.543 ms | |
| CREATE FUNCTION | |
| Time: 30.941 ms | |
| CREATE FUNCTION | |
| Time: 22.938 ms | |
| CREATE TRIGGER | |
| Time: 68.133 ms | |
| CREATE TRIGGER | |
| Time: 26.304 ms | |
| CREATE TRIGGER | |
| Time: 34.587 ms | |
| psql:/sql/parallel/water_name.sql:181: NOTICE: trigger "trigger_delete_point" for relation "osm_water_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 1.015 ms | |
| psql:/sql/parallel/water_name.sql:182: NOTICE: trigger "trigger_update_point" for relation "osm_water_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 1.038 ms | |
| psql:/sql/parallel/water_name.sql:183: NOTICE: trigger "trigger_insert_point" for relation "osm_water_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 1.436 ms | |
| CREATE VIEW | |
| Time: 39.173 ms | |
| CREATE INDEX | |
| Time: 64441.199 ms (01:04.441) | |
| CREATE INDEX | |
| Time: 15401.783 ms (00:15.402) | |
| SELECT 23207 | |
| Time: 16524.983 ms (00:16.525) | |
| CREATE INDEX | |
| Time: 624.549 ms | |
| CREATE INDEX | |
| Time: 118.856 ms | |
| SELECT 23207 | |
| Time: 613.347 ms | |
| CREATE INDEX | |
| Time: 389.466 ms | |
| CREATE INDEX | |
| Time: 85.269 ms | |
| SELECT 22040 | |
| Time: 151.415 ms | |
| CREATE INDEX | |
| Time: 417.991 ms | |
| CREATE INDEX | |
| Time: 120.162 ms | |
| SELECT 10344 | |
| Time: 124.490 ms | |
| CREATE INDEX | |
| Time: 104.644 ms | |
| CREATE INDEX | |
| Time: 81.238 ms | |
| SELECT 8756 | |
| Time: 84.365 ms | |
| CREATE INDEX | |
| Time: 224.686 ms | |
| CREATE INDEX | |
| Time: 70.723 ms | |
| SELECT 1885 | |
| Time: 48.001 ms | |
| CREATE INDEX | |
| Time: 19.979 ms | |
| CREATE SCHEMA | |
| Time: 3.368 ms | |
| CREATE TABLE | |
| Time: 47.095 ms | |
| CREATE FUNCTION | |
| Time: 5.521 ms | |
| CREATE FUNCTION | |
| Time: 3.461 ms | |
| CREATE TRIGGER | |
| Time: 8.714 ms | |
| CREATE TRIGGER | |
| Time: 12.566 ms | |
| CREATE FUNCTION | |
| Time: 6.478 ms | |
| CREATE FUNCTION | |
| Time: 27.116 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:981: NOTICE: Finished layer transportation | |
| DO | |
| Time: 0.416 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:983: NOTICE: Processing layer transportation_name | |
| DO | |
| Time: 0.303 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:987: NOTICE: materialized view "osm_transportation_name_network" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.355 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:988: NOTICE: materialized view "osm_transportation_name_linestring" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.312 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:989: NOTICE: materialized view "osm_transportation_name_linestring_gen1" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.311 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:990: NOTICE: materialized view "osm_transportation_name_linestring_gen2" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.307 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:991: NOTICE: materialized view "osm_transportation_name_linestring_gen3" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.309 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:992: NOTICE: materialized view "osm_transportation_name_linestring_gen4" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.316 ms | |
| DO | |
| Time: 13.125 ms | |
| DO | |
| Time: 3.689 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:1021: NOTICE: trigger "trigger_flag_transportation_name" for relation "osm_route_member" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.463 ms | |
| CREATE FUNCTION | |
| Time: 3.591 ms | |
| CREATE FUNCTION | |
| Time: 3.287 ms | |
| CREATE INDEX | |
| Time: 964.517 ms | |
| CREATE INDEX | |
| Time: 430.224 ms | |
| CREATE INDEX | |
| Time: 2745.628 ms (00:02.746) | |
| CREATE INDEX | |
| Time: 971.574 ms | |
| update_osm_route_member | |
| ------------------------- | |
| (1 row) | |
| Time: 44098.492 ms (00:44.098) | |
| CREATE INDEX | |
| Time: 1293.952 ms (00:01.294) | |
| psql:/sql/parallel/transportation__transportation_name.sql:1094: NOTICE: trigger "trigger_flag_transportation_name" for relation "osm_highway_linestring" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.686 ms | |
| psql:/sql/parallel/transportation__transportation_name.sql:1095: NOTICE: schema "transportation_name" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.520 ms | |
| SELECT 8247797 | |
| Time: 259389.965 ms (04:19.390) | |
| CREATE INDEX | |
| Time: 440713.795 ms (07:20.714) | |
| SELECT 7395 | |
| Time: 3468088.595 ms (57:48.089) | |
| DO | |
| Time: 28.793 ms | |
| CREATE INDEX | |
| Time: 143.103 ms | |
| CREATE SCHEMA | |
| Time: 1.874 ms | |
| CREATE FUNCTION | |
| Time: 2.736 ms | |
| CREATE FUNCTION | |
| Time: 1.668 ms | |
| CREATE FUNCTION | |
| Time: 1.302 ms | |
| CREATE TRIGGER | |
| Time: 2.813 ms | |
| CREATE TRIGGER | |
| Time: 1.795 ms | |
| CREATE TRIGGER | |
| Time: 1.229 ms | |
| CREATE FUNCTION | |
| Time: 12.858 ms | |
| psql:/sql/parallel/water_name.sql:355: NOTICE: Finished layer water_name | |
| DO | |
| Time: 1.219 ms | |
| Importing /sql/parallel/landcover.sql (md5 c97e31a7aa4f4661f425ffc1facab55d - 203 lines) into Postgres... | |
| Timing is on. | |
| psql:/sql/parallel/landcover.sql:1: NOTICE: Processing layer landcover | |
| DO | |
| Time: 3.000 ms | |
| CREATE FUNCTION | |
| Time: 8.935 ms | |
| CREATE VIEW | |
| Time: 8.897 ms | |
| CREATE VIEW | |
| Time: 4.524 ms | |
| CREATE VIEW | |
| Time: 4.424 ms | |
| CREATE VIEW | |
| Time: 3.653 ms | |
| CREATE VIEW | |
| Time: 2.715 ms | |
| CREATE VIEW | |
| Time: 2.876 ms | |
| CREATE VIEW | |
| Time: 2.541 ms | |
| CREATE VIEW | |
| Time: 2.187 ms | |
| CREATE VIEW | |
| Time: 3.313 ms | |
| CREATE VIEW | |
| Time: 2.823 ms | |
| CREATE VIEW | |
| Time: 2.716 ms | |
| CREATE FUNCTION | |
| Time: 4.465 ms | |
| psql:/sql/parallel/landcover.sql:203: NOTICE: Finished layer landcover | |
| DO | |
| Time: 0.264 ms | |
| Importing /sql/parallel/landuse.sql (md5 2cf933c5c89b3c66327819350aba4313 - 225 lines) into Postgres... | |
| Timing is on. | |
| psql:/sql/parallel/landuse.sql:1: NOTICE: Processing layer landuse | |
| DO | |
| Time: 1.977 ms | |
| CREATE VIEW | |
| Time: 8.219 ms | |
| CREATE VIEW | |
| Time: 2.380 ms | |
| CREATE VIEW | |
| Time: 3.638 ms | |
| CREATE VIEW | |
| Time: 3.072 ms | |
| CREATE VIEW | |
| Time: 2.546 ms | |
| CREATE VIEW | |
| Time: 7.444 ms | |
| CREATE VIEW | |
| Time: 2.766 ms | |
| CREATE VIEW | |
| Time: 3.122 ms | |
| CREATE VIEW | |
| Time: 2.815 ms | |
| CREATE VIEW | |
| Time: 3.843 ms | |
| CREATE FUNCTION | |
| Time: 7.770 ms | |
| psql:/sql/parallel/landuse.sql:225: NOTICE: Finished layer landuse | |
| DO | |
| Time: 0.283 ms | |
| Importing /sql/parallel/park.sql (md5 941d7ddc94358f2d7bc30123696684b9 - 506 lines) into Postgres... | |
| Timing is on. | |
| psql:/sql/parallel/park.sql:1: NOTICE: Processing layer park | |
| DO | |
| Time: 1.841 ms | |
| ALTER TABLE | |
| Time: 7.352 ms | |
| ALTER TABLE | |
| Time: 2.223 ms | |
| ALTER TABLE | |
| Time: 2.739 ms | |
| ALTER TABLE | |
| Time: 1.306 ms | |
| ALTER TABLE | |
| Time: 1.977 ms | |
| ALTER TABLE | |
| Time: 1.913 ms | |
| ALTER TABLE | |
| Time: 1.352 ms | |
| ALTER TABLE | |
| Time: 1.631 ms | |
| ALTER TABLE | |
| Time: 1.379 ms | |
| psql:/sql/parallel/park.sql:24: NOTICE: trigger "update_row" for relation "osm_park_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.383 ms | |
| psql:/sql/parallel/park.sql:25: NOTICE: trigger "update_row" for relation "osm_park_polygon_gen1" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.290 ms | |
| psql:/sql/parallel/park.sql:26: NOTICE: trigger "update_row" for relation "osm_park_polygon_gen2" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.274 ms | |
| psql:/sql/parallel/park.sql:27: NOTICE: trigger "update_row" for relation "osm_park_polygon_gen3" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.240 ms | |
| psql:/sql/parallel/park.sql:28: NOTICE: trigger "update_row" for relation "osm_park_polygon_gen4" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.251 ms | |
| psql:/sql/parallel/park.sql:29: NOTICE: trigger "update_row" for relation "osm_park_polygon_gen5" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.251 ms | |
| psql:/sql/parallel/park.sql:30: NOTICE: trigger "update_row" for relation "osm_park_polygon_gen6" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.257 ms | |
| psql:/sql/parallel/park.sql:31: NOTICE: trigger "update_row" for relation "osm_park_polygon_gen7" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.246 ms | |
| psql:/sql/parallel/park.sql:32: NOTICE: trigger "update_row" for relation "osm_park_polygon_gen8" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.261 ms | |
| CREATE FUNCTION | |
| Time: 1.833 ms | |
| update_osm_park_polygon | |
| ------------------------- | |
| (1 row) | |
| Time: 306527.594 ms (05:06.528) | |
| CREATE INDEX | |
| Time: 3.607 ms | |
| CREATE INDEX | |
| Time: 13.461 ms | |
| CREATE INDEX | |
| Time: 2.999 ms | |
| CREATE INDEX | |
| Time: 2.472 ms | |
| CREATE INDEX | |
| Time: 2.159 ms | |
| CREATE INDEX | |
| Time: 2.221 ms | |
| CREATE INDEX | |
| Time: 1.994 ms | |
| CREATE INDEX | |
| Time: 1.828 ms | |
| CREATE INDEX | |
| Time: 2.559 ms | |
| CREATE FUNCTION | |
| Time: 1.513 ms | |
| CREATE TRIGGER | |
| Time: 1.993 ms | |
| CREATE TRIGGER | |
| Time: 1.357 ms | |
| CREATE TRIGGER | |
| Time: 1.231 ms | |
| CREATE TRIGGER | |
| Time: 1.395 ms | |
| CREATE TRIGGER | |
| Time: 1.276 ms | |
| CREATE TRIGGER | |
| Time: 1.224 ms | |
| CREATE TRIGGER | |
| Time: 1.254 ms | |
| CREATE TRIGGER | |
| Time: 1.367 ms | |
| CREATE TRIGGER | |
| Time: 1.173 ms | |
| CREATE FUNCTION | |
| Time: 17.354 ms | |
| psql:/sql/parallel/park.sql:506: NOTICE: Finished layer park | |
| DO | |
| Time: 0.337 ms | |
| Importing /sql/parallel/aerodrome_label.sql (md5 f107c84b93e2cb3b5d39b4c430e3cfef - 128 lines) into Postgres... | |
| Timing is on. | |
| psql:/sql/parallel/aerodrome_label.sql:1: NOTICE: Processing layer aerodrome_label | |
| DO | |
| Time: 1.860 ms | |
| psql:/sql/parallel/aerodrome_label.sql:5: NOTICE: trigger "trigger_flag" for relation "osm_aerodrome_label_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 4.803 ms | |
| psql:/sql/parallel/aerodrome_label.sql:6: NOTICE: schema "aerodrome_label" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.219 ms | |
| CREATE FUNCTION | |
| Time: 2.140 ms | |
| update_aerodrome_label_point | |
| ------------------------------ | |
| (1 row) | |
| Time: 11279.764 ms (00:11.280) | |
| CREATE SCHEMA | |
| Time: 1.917 ms | |
| CREATE TABLE | |
| Time: 15.807 ms | |
| CREATE FUNCTION | |
| Time: 1.379 ms | |
| CREATE FUNCTION | |
| Time: 1.348 ms | |
| CREATE TRIGGER | |
| Time: 1.696 ms | |
| CREATE TRIGGER | |
| Time: 1.422 ms | |
| CREATE FUNCTION | |
| Time: 3.614 ms | |
| psql:/sql/parallel/aerodrome_label.sql:128: NOTICE: Finished layer aerodrome_label | |
| DO | |
| Time: 0.327 ms | |
| Importing /sql/parallel/boundary.sql (md5 8f5ea3b932ce7bd201eda5b734382599 - 639 lines) into Postgres... | |
| Timing is on. | |
| psql:/sql/parallel/boundary.sql:1: NOTICE: Processing layer boundary | |
| DO | |
| Time: 1.869 ms | |
| psql:/sql/parallel/boundary.sql:13: NOTICE: table "osm_border_linestring_gen1" does not exist, skipping | |
| DO | |
| Time: 0.960 ms | |
| psql:/sql/parallel/boundary.sql:16: NOTICE: materialized view "osm_border_linestring_gen1" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.187 ms | |
| SELECT 32619 | |
| Time: 1414.380 ms (00:01.414) | |
| CREATE INDEX | |
| Time: 762.661 ms | |
| psql:/sql/parallel/boundary.sql:33: NOTICE: table "osm_border_linestring_gen2" does not exist, skipping | |
| DO | |
| Time: 0.450 ms | |
| psql:/sql/parallel/boundary.sql:36: NOTICE: materialized view "osm_border_linestring_gen2" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.237 ms | |
| SELECT 32619 | |
| Time: 749.288 ms | |
| CREATE INDEX | |
| Time: 803.208 ms | |
| psql:/sql/parallel/boundary.sql:53: NOTICE: table "osm_border_linestring_gen3" does not exist, skipping | |
| DO | |
| Time: 0.850 ms | |
| psql:/sql/parallel/boundary.sql:56: NOTICE: materialized view "osm_border_linestring_gen3" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.667 ms | |
| SELECT 10811 | |
| Time: 381.732 ms | |
| CREATE INDEX | |
| Time: 117.444 ms | |
| psql:/sql/parallel/boundary.sql:73: NOTICE: table "osm_border_linestring_gen4" does not exist, skipping | |
| DO | |
| Time: 1.076 ms | |
| psql:/sql/parallel/boundary.sql:76: NOTICE: materialized view "osm_border_linestring_gen4" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.654 ms | |
| SELECT 5238 | |
| Time: 202.281 ms | |
| CREATE INDEX | |
| Time: 87.582 ms | |
| psql:/sql/parallel/boundary.sql:93: NOTICE: table "osm_border_linestring_gen5" does not exist, skipping | |
| DO | |
| Time: 0.405 ms | |
| psql:/sql/parallel/boundary.sql:96: NOTICE: materialized view "osm_border_linestring_gen5" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.188 ms | |
| SELECT 5238 | |
| Time: 204.889 ms | |
| CREATE INDEX | |
| Time: 94.285 ms | |
| psql:/sql/parallel/boundary.sql:113: NOTICE: table "osm_border_linestring_gen6" does not exist, skipping | |
| DO | |
| Time: 0.422 ms | |
| psql:/sql/parallel/boundary.sql:116: NOTICE: materialized view "osm_border_linestring_gen6" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.203 ms | |
| SELECT 1701 | |
| Time: 61.436 ms | |
| CREATE INDEX | |
| Time: 26.516 ms | |
| psql:/sql/parallel/boundary.sql:133: NOTICE: table "osm_border_linestring_gen7" does not exist, skipping | |
| DO | |
| Time: 0.467 ms | |
| psql:/sql/parallel/boundary.sql:136: NOTICE: materialized view "osm_border_linestring_gen7" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.254 ms | |
| SELECT 1701 | |
| Time: 76.227 ms | |
| CREATE INDEX | |
| Time: 26.453 ms | |
| psql:/sql/parallel/boundary.sql:153: NOTICE: table "osm_border_linestring_gen8" does not exist, skipping | |
| DO | |
| Time: 0.416 ms | |
| psql:/sql/parallel/boundary.sql:156: NOTICE: materialized view "osm_border_linestring_gen8" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.195 ms | |
| SELECT 1701 | |
| Time: 49.796 ms | |
| CREATE INDEX | |
| Time: 26.757 ms | |
| psql:/sql/parallel/boundary.sql:173: NOTICE: table "osm_border_linestring_gen9" does not exist, skipping | |
| DO | |
| Time: 0.464 ms | |
| psql:/sql/parallel/boundary.sql:176: NOTICE: materialized view "osm_border_linestring_gen9" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.245 ms | |
| SELECT 1701 | |
| Time: 60.312 ms | |
| CREATE INDEX | |
| Time: 36.854 ms | |
| psql:/sql/parallel/boundary.sql:193: NOTICE: table "osm_border_linestring_gen10" does not exist, skipping | |
| DO | |
| Time: 0.422 ms | |
| psql:/sql/parallel/boundary.sql:196: NOTICE: materialized view "osm_border_linestring_gen10" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.193 ms | |
| SELECT 308 | |
| Time: 33.014 ms | |
| CREATE INDEX | |
| Time: 3.569 ms | |
| CREATE FUNCTION | |
| Time: 3.297 ms | |
| CREATE VIEW | |
| Time: 3.571 ms | |
| CREATE VIEW | |
| Time: 11.265 ms | |
| CREATE VIEW | |
| Time: 3.016 ms | |
| CREATE VIEW | |
| Time: 6.326 ms | |
| CREATE VIEW | |
| Time: 14.261 ms | |
| CREATE VIEW | |
| Time: 3.498 ms | |
| CREATE VIEW | |
| Time: 3.337 ms | |
| CREATE VIEW | |
| Time: 3.280 ms | |
| CREATE VIEW | |
| Time: 13.412 ms | |
| CREATE VIEW | |
| Time: 3.231 ms | |
| CREATE VIEW | |
| Time: 3.413 ms | |
| CREATE VIEW | |
| Time: 3.210 ms | |
| CREATE VIEW | |
| Time: 13.724 ms | |
| CREATE FUNCTION | |
| Time: 6.483 ms | |
| psql:/sql/parallel/boundary.sql:639: NOTICE: Finished layer boundary | |
| DO | |
| Time: 0.339 ms | |
| Importing /sql/parallel/water__waterway.sql (md5 1796cdaa8d3831f8d5bc798588e13b67 - 987 lines) into Postgres... | |
| Timing is on. | |
| psql:/sql/parallel/water__waterway.sql:1: NOTICE: Processing layer water | |
| DO | |
| Time: 3.427 ms | |
| psql:/sql/parallel/water__waterway.sql:13: NOTICE: table "osm_ocean_polygon_gen1" does not exist, skipping | |
| DO | |
| Time: 2.011 ms | |
| psql:/sql/parallel/water__waterway.sql:16: NOTICE: materialized view "osm_ocean_polygon_gen1" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 1.551 ms | |
| SELECT 14516 | |
| Time: 29043.145 ms (00:29.043) | |
| CREATE INDEX | |
| Time: 659.917 ms | |
| psql:/sql/parallel/water__waterway.sql:33: NOTICE: table "osm_ocean_polygon_gen2" does not exist, skipping | |
| DO | |
| Time: 1.520 ms | |
| psql:/sql/parallel/water__waterway.sql:36: NOTICE: materialized view "osm_ocean_polygon_gen2" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 1.281 ms | |
| SELECT 14516 | |
| Time: 16390.176 ms (00:16.390) | |
| CREATE INDEX | |
| Time: 550.230 ms | |
| psql:/sql/parallel/water__waterway.sql:53: NOTICE: table "osm_ocean_polygon_gen3" does not exist, skipping | |
| DO | |
| Time: 0.936 ms | |
| psql:/sql/parallel/water__waterway.sql:56: NOTICE: materialized view "osm_ocean_polygon_gen3" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.640 ms | |
| SELECT 14516 | |
| Time: 11564.334 ms (00:11.564) | |
| CREATE INDEX | |
| Time: 358.544 ms | |
| psql:/sql/parallel/water__waterway.sql:73: NOTICE: table "osm_ocean_polygon_gen4" does not exist, skipping | |
| DO | |
| Time: 0.453 ms | |
| psql:/sql/parallel/water__waterway.sql:76: NOTICE: materialized view "osm_ocean_polygon_gen4" does not exist, skipping | |
| DROP MATERIALIZED VIEW | |
| Time: 0.232 ms | |
| SELECT 14516 | |
| Time: 9013.048 ms (00:09.013) | |
| CREATE INDEX | |
| Time: 408.875 ms | |
| CREATE FUNCTION | |
| Time: 2.473 ms | |
| CREATE FUNCTION | |
| Time: 1.368 ms | |
| CREATE VIEW | |
| Time: 2.899 ms | |
| CREATE VIEW | |
| Time: 2.464 ms | |
| CREATE VIEW | |
| Time: 2.633 ms | |
| CREATE VIEW | |
| Time: 3.070 ms | |
| CREATE VIEW | |
| Time: 2.756 ms | |
| CREATE VIEW | |
| Time: 11.135 ms | |
| CREATE VIEW | |
| Time: 2.937 ms | |
| CREATE VIEW | |
| Time: 2.677 ms | |
| CREATE VIEW | |
| Time: 2.840 ms | |
| CREATE VIEW | |
| Time: 2.761 ms | |
| CREATE VIEW | |
| Time: 7.766 ms | |
| CREATE VIEW | |
| Time: 2.875 ms | |
| CREATE VIEW | |
| Time: 2.734 ms | |
| CREATE VIEW | |
| Time: 2.661 ms | |
| CREATE FUNCTION | |
| Time: 15.535 ms | |
| psql:/sql/parallel/water__waterway.sql:478: NOTICE: Finished layer water | |
| DO | |
| Time: 0.278 ms | |
| psql:/sql/parallel/water__waterway.sql:480: NOTICE: Processing layer waterway | |
| DO | |
| Time: 0.210 ms | |
| psql:/sql/parallel/water__waterway.sql:484: NOTICE: trigger "trigger_flag" for relation "osm_waterway_linestring" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.360 ms | |
| psql:/sql/parallel/water__waterway.sql:485: NOTICE: trigger "trigger_refresh" for relation "osm_waterway_linestring" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.240 ms | |
| update_osm_peak_point | |
| ----------------------- | |
| (1 row) | |
| Time: 6215871.744 ms (01:43:35.872) | |
| CREATE SCHEMA | |
| Time: 3.429 ms | |
| CREATE FUNCTION | |
| Time: 5.662 ms | |
| CREATE TRIGGER | |
| Time: 3.070 ms | |
| CREATE FUNCTION | |
| Time: 7.676 ms | |
| psql:/sql/parallel/mountain_peak.sql:104: NOTICE: Finished layer mountain_peak | |
| DO | |
| Time: 1.294 ms | |
| Importing /sql/parallel/place.sql (md5 f93b20f3733b8c2d2307930983452988 - 794 lines) into Postgres... | |
| Timing is on. | |
| psql:/sql/parallel/place.sql:1: NOTICE: Processing layer place | |
| DO | |
| Time: 1.956 ms | |
| DO | |
| Time: 4.937 ms | |
| ALTER TABLE | |
| Time: 1108.480 ms (00:01.108) | |
| CREATE FUNCTION | |
| Time: 10.196 ms | |
| CREATE FUNCTION | |
| Time: 6.203 ms | |
| CREATE FUNCTION | |
| Time: 2.624 ms | |
| psql:/sql/parallel/place.sql:129: NOTICE: trigger "trigger_flag" for relation "osm_continent_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.431 ms | |
| psql:/sql/parallel/place.sql:130: NOTICE: schema "place_continent_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.233 ms | |
| CREATE FUNCTION | |
| Time: 1.386 ms | |
| update_osm_continent_point | |
| ---------------------------- | |
| (1 row) | |
| Time: 1.483 ms | |
| CREATE SCHEMA | |
| Time: 1.102 ms | |
| CREATE TABLE | |
| Time: 21.240 ms | |
| CREATE FUNCTION | |
| Time: 1.423 ms | |
| CREATE FUNCTION | |
| Time: 1.275 ms | |
| CREATE TRIGGER | |
| Time: 1.398 ms | |
| CREATE TRIGGER | |
| Time: 1.363 ms | |
| psql:/sql/parallel/place.sql:189: NOTICE: trigger "trigger_flag" for relation "osm_country_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.384 ms | |
| psql:/sql/parallel/place.sql:190: NOTICE: schema "place_country" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.239 ms | |
| psql:/sql/parallel/place.sql:193: NOTICE: constraint "osm_country_point_rank_constraint" of relation "osm_country_point" does not exist, skipping | |
| ALTER TABLE | |
| Time: 0.313 ms | |
| CREATE FUNCTION | |
| Time: 2.165 ms | |
| update_osm_country_point | |
| -------------------------- | |
| (1 row) | |
| Time: 31.168 ms | |
| CREATE INDEX | |
| Time: 3.891 ms | |
| CREATE SCHEMA | |
| Time: 1.065 ms | |
| CREATE TABLE | |
| Time: 11.177 ms | |
| CREATE FUNCTION | |
| Time: 1.332 ms | |
| CREATE FUNCTION | |
| Time: 1.257 ms | |
| CREATE TRIGGER | |
| Time: 1.277 ms | |
| CREATE TRIGGER | |
| Time: 1.348 ms | |
| psql:/sql/parallel/place.sql:324: NOTICE: trigger "trigger_flag" for relation "osm_island_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.391 ms | |
| psql:/sql/parallel/place.sql:325: NOTICE: schema "place_island_polygon" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.257 ms | |
| CREATE FUNCTION | |
| Time: 1.333 ms | |
| update_osm_island_polygon | |
| --------------------------- | |
| (1 row) | |
| Time: 185458.721 ms (03:05.459) | |
| CREATE SCHEMA | |
| Time: 1.328 ms | |
| CREATE TABLE | |
| Time: 11.793 ms | |
| CREATE FUNCTION | |
| Time: 1.477 ms | |
| CREATE FUNCTION | |
| Time: 1.282 ms | |
| CREATE TRIGGER | |
| Time: 1.554 ms | |
| CREATE TRIGGER | |
| Time: 1.338 ms | |
| psql:/sql/parallel/place.sql:387: NOTICE: trigger "trigger_flag" for relation "osm_island_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.435 ms | |
| psql:/sql/parallel/place.sql:388: NOTICE: schema "place_island_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.272 ms | |
| CREATE FUNCTION | |
| Time: 1.325 ms | |
| update_osm_island_point | |
| ------------------------- | |
| (1 row) | |
| Time: 121842.221 ms (02:01.842) | |
| CREATE SCHEMA | |
| Time: 1.078 ms | |
| CREATE TABLE | |
| Time: 19.682 ms | |
| CREATE FUNCTION | |
| Time: 1.430 ms | |
| CREATE FUNCTION | |
| Time: 1.578 ms | |
| CREATE TRIGGER | |
| Time: 1.401 ms | |
| CREATE TRIGGER | |
| Time: 1.407 ms | |
| psql:/sql/parallel/place.sql:447: NOTICE: trigger "trigger_flag" for relation "osm_state_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.480 ms | |
| psql:/sql/parallel/place.sql:448: NOTICE: schema "place_state" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.267 ms | |
| psql:/sql/parallel/place.sql:451: NOTICE: constraint "osm_state_point_rank_constraint" of relation "osm_state_point" does not exist, skipping | |
| ALTER TABLE | |
| Time: 0.383 ms | |
| CREATE FUNCTION | |
| Time: 1.821 ms | |
| update_osm_state_point | |
| ------------------------ | |
| (1 row) | |
| Time: 5.103 ms | |
| CREATE INDEX | |
| Time: 3.985 ms | |
| CREATE SCHEMA | |
| Time: 1.114 ms | |
| CREATE TABLE | |
| Time: 10.869 ms | |
| CREATE FUNCTION | |
| Time: 1.363 ms | |
| CREATE FUNCTION | |
| Time: 1.262 ms | |
| CREATE TRIGGER | |
| Time: 1.311 ms | |
| CREATE TRIGGER | |
| Time: 1.323 ms | |
| psql:/sql/parallel/place.sql:547: NOTICE: trigger "trigger_flag" for relation "osm_city_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.317 ms | |
| psql:/sql/parallel/place.sql:548: NOTICE: schema "place_city" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.269 ms | |
| psql:/sql/parallel/place.sql:550: NOTICE: extension "unaccent" already exists, skipping | |
| CREATE EXTENSION | |
| Time: 1.603 ms | |
| CREATE FUNCTION | |
| Time: 1.696 ms | |
| update_osm_city_point | |
| ----------------------- | |
| (1 row) | |
| Time: 13976793.805 ms (03:52:56.794) | |
| CREATE INDEX | |
| Time: 168.280 ms | |
| CREATE SCHEMA | |
| Time: 1.184 ms | |
| CREATE TABLE | |
| Time: 11.973 ms | |
| CREATE FUNCTION | |
| Time: 1.588 ms | |
| CREATE FUNCTION | |
| Time: 1.285 ms | |
| CREATE TRIGGER | |
| Time: 1.739 ms | |
| CREATE TRIGGER | |
| Time: 1.477 ms | |
| CREATE FUNCTION | |
| Time: 3.857 ms | |
| psql:/sql/parallel/place.sql:794: NOTICE: Finished layer place | |
| DO | |
| Time: 0.328 ms | |
| SELECT 590189 | |
| Time: 24070996.488 ms (06:41:10.996) | |
| CREATE INDEX | |
| Time: 13980.396 ms (00:13.980) | |
| CREATE INDEX | |
| Time: 777.969 ms | |
| CREATE SCHEMA | |
| Time: 1.601 ms | |
| CREATE TABLE | |
| Time: 12.582 ms | |
| CREATE FUNCTION | |
| Time: 2.825 ms | |
| CREATE FUNCTION | |
| Time: 1.371 ms | |
| CREATE TRIGGER | |
| Time: 1.938 ms | |
| CREATE TRIGGER | |
| Time: 1.491 ms | |
| CREATE INDEX | |
| Time: 16.569 ms | |
| CREATE INDEX | |
| Time: 8.958 ms | |
| CREATE VIEW | |
| Time: 5.824 ms | |
| CREATE FUNCTION | |
| Time: 4.976 ms | |
| psql:/sql/parallel/building.sql:254: NOTICE: Finished layer building | |
| DO | |
| Time: 1.270 ms | |
| update_poi_polygon | |
| -------------------- | |
| (1 row) | |
| Time: 72102496.460 ms (20:01:42.496) | |
| CREATE SCHEMA | |
| Time: 1.690 ms | |
| CREATE TABLE | |
| Time: 12.300 ms | |
| CREATE FUNCTION | |
| Time: 1.850 ms | |
| CREATE FUNCTION | |
| Time: 1.831 ms | |
| CREATE TRIGGER | |
| Time: 1.720 ms | |
| CREATE TRIGGER | |
| Time: 1.464 ms | |
| psql:/sql/parallel/poi.sql:214: NOTICE: trigger "trigger_flag" for relation "osm_poi_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 1.142 ms | |
| psql:/sql/parallel/poi.sql:215: NOTICE: schema "poi_point" does not exist, skipping | |
| DROP TRIGGER | |
| Time: 0.645 ms | |
| CREATE FUNCTION | |
| Time: 1.330 ms | |
| update_osm_poi_point | |
| ---------------------- | |
| (1 row) | |
| Time: 165829809.176 ms (1 d 22:03:49.809) | |
| CREATE FUNCTION | |
| Time: 1.791 ms | |
| ALTER TABLE | |
| Time: 2.018 ms | |
| update_osm_poi_point_agg | |
| -------------------------- | |
| (1 row) | |
| Time: 44637.449 ms (00:44.637) | |
| CREATE SCHEMA | |
| Time: 6.329 ms | |
| CREATE TABLE | |
| Time: 36.373 ms | |
| CREATE FUNCTION | |
| Time: 3.345 ms | |
| CREATE FUNCTION | |
| Time: 3.032 ms | |
| CREATE TRIGGER | |
| Time: 3.107 ms | |
| CREATE TRIGGER | |
| Time: 2.949 ms | |
| CREATE FUNCTION | |
| Time: 5.980 ms | |
| psql:/sql/parallel/poi.sql:413: NOTICE: Finished layer poi | |
| DO | |
| Time: 0.905 ms | |
| SELECT 134830 | |
| Time: 245426860.754 ms (2 d 20:10:26.861) | |
| CREATE INDEX | |
| Time: 2043.269 ms (00:02.043) | |
| CREATE INDEX | |
| Time: 186.656 ms | |
| SELECT 3317 | |
| Time: 195.945 ms | |
| CREATE INDEX | |
| Time: 18.635 ms | |
| CREATE INDEX | |
| Time: 12.071 ms | |
| SELECT 1749 | |
| Time: 29.382 ms | |
| CREATE INDEX | |
| Time: 9.213 ms | |
| CREATE INDEX | |
| Time: 8.034 ms | |
| SELECT 272 | |
| Time: 12.279 ms | |
| CREATE INDEX | |
| Time: 2.750 ms | |
| CREATE INDEX | |
| Time: 4.434 ms | |
| SELECT 271 | |
| Time: 9.809 ms | |
| CREATE INDEX | |
| Time: 2.748 ms | |
| CREATE | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment