OWL/Benchmarks
< OWL
- Reason for being historic
- OpenStreetMap Watch List has been unmaintained since about 2015.
- Captured time
- 2013
Database size
2013-10-01 @ zark (full history, running constantly since February)
owl=# select count(distinct changeset_id) from changes;
count
---------
4,644,962
owl=# select count(*) from changeset_tiles;
count
-----------
526,004,935
owl=# \d+
List of relations
Schema | Name | Type | Owner | Size | Description
----------+-------------------+----------+----------+------------+-------------
public | changes | table | ppawel | 21 GB |
public | changes_id_seq | sequence | ppawel | 8192 bytes |
public | changeset_tiles | table | ppawel | 272 GB |
public | changesets | table | ppawel | 3013 MB |
public | geography_columns | view | ppawel | 0 bytes |
public | geometry_columns | view | ppawel | 0 bytes |
public | nodes | table | ppawel | 366 GB |
public | raster_columns | view | postgres | 0 bytes |
public | raster_overviews | view | postgres | 0 bytes |
public | relation_members | table | ppawel | 31 GB |
public | relations | table | ppawel | 1979 MB |
public | schema_migrations | table | ppawel | 0 bytes |
public | spatial_ref_sys | table | ppawel | 3224 kB |
public | users | table | ppawel | 14 MB |
public | way_revisions | table | ppawel | 68 GB |
public | way_tiles | table | ppawel | 96 GB |
public | ways | table | ppawel | 114 GB |
topology | layer | table | postgres | 8192 bytes |
topology | topology | table | postgres | 8192 bytes |
topology | topology_id_seq | sequence | postgres | 8192 bytes |
owl=# \di+
List of relations
Schema | Name | Type | Owner | Table | Size | Description
----------+-------------------------------------------------+-------+----------+-------------------+------------+-------------
public | idx_changes_changeset_id | index | ppawel | changes | 2999 MB |
public | idx_changeset_tiles_xcyz | index | ppawel | changeset_tiles | 30 GB |
public | idx_changeset_tiles_xyz | index | ppawel | changeset_tiles | 20 GB |
public | idx_nodes_changeset_id | index | ppawel | nodes | 71 GB |
public | idx_nodes_geom | index | ppawel | nodes | 99 GB |
public | idx_relations_changeset_id | index | ppawel | relations | 218 MB |
public | idx_way_revisions_changeset_id | index | ppawel | way_revisions | 5275 MB |
public | idx_way_revisions_way_id | index | ppawel | way_revisions | 5068 MB |
public | idx_ways_changeset_id | index | ppawel | ways | 9006 MB |
public | idx_ways_nodes_id | index | ppawel | ways | 155 GB |
public | pk_changes | index | ppawel | changes | 2009 MB |
public | pk_changeset_tiles | index | ppawel | changeset_tiles | 27 GB |
public | pk_changesets | index | ppawel | changesets | 393 MB |
public | pk_nodes | index | ppawel | nodes | 101 GB |
public | pk_relation_members | index | ppawel | relation_members | 21 GB |
public | pk_relations | index | ppawel | relations | 356 MB |
public | pk_users | index | ppawel | users | 7472 kB |
public | pk_way_revisions | index | ppawel | way_revisions | 7103 MB |
public | pk_way_tiles | index | ppawel | way_tiles | 31 GB |
public | pk_ways | index | ppawel | ways | 13 GB |
public | spatial_ref_sys_pkey | index | ppawel | spatial_ref_sys | 144 kB |
public | unique_schema_migrations | index | ppawel | schema_migrations | 8192 bytes |
topology | layer_pkey | index | postgres | layer | 8192 bytes |
topology | layer_schema_name_table_name_feature_column_key | index | postgres | layer | 8192 bytes |
topology | topology_name_key | index | postgres | topology | 8192 bytes |
topology | topology_pkey | index | postgres | topology | 8192 bytes |
2013-02-15 @ zark (full history, no tiles yet)
owl=> \d+
List of relations
Schema | Name | Type | Owner | Size | Description
--------+----------------------+----------+----------+------------+-------------
public | changes | table | ppawel | 8192 bytes |
public | changes_id_seq | sequence | ppawel | 8192 bytes |
public | changeset_tiles | table | ppawel | 8192 bytes |
public | changesets | table | ppawel | 8192 bytes |
public | geography_columns | view | ppawel | 0 bytes |
public | geometry_columns | view | ppawel | 0 bytes |
public | nodes | table | ppawel | 325 GB |
public | raster_columns | view | postgres | 0 bytes |
public | raster_overviews | view | postgres | 0 bytes |
public | relation_members | table | ppawel | 30 GB |
public | relations | table | ppawel | 1509 MB |
public | schema_migrations | table | ppawel | 0 bytes |
public | spatial_ref_sys | table | ppawel | 3224 kB |
public | users | table | ppawel | 12 MB |
public | way_revisions | table | ppawel | 0 bytes |
public | way_revisions_id_seq | sequence | ppawel | 8192 bytes |
public | way_tiles | table | ppawel | 8192 bytes |
public | ways | table | ppawel | 96 GB |
owl=> \di+
List of relations
Schema | Name | Type | Owner | Table | Size | Description
--------+--------------------------------+-------+--------+-------------------+------------+-------------
public | idx_changes_changeset_id | index | ppawel | changes | 8192 bytes |
public | idx_changeset_tiles_xcyz | index | ppawel | changeset_tiles | 8192 bytes |
public | idx_changeset_tiles_xyz | index | ppawel | changeset_tiles | 8192 bytes |
public | idx_nodes_changeset_id | index | ppawel | nodes | 57 GB |
public | idx_relations_changeset_id | index | ppawel | relations | 156 MB |
public | idx_way_revisions_changeset_id | index | ppawel | way_revisions | 8192 bytes |
public | idx_way_revisions_way_id | index | ppawel | way_revisions | 8192 bytes |
public | idx_ways_changeset_id | index | ppawel | ways | 6848 MB |
public | idx_ways_nodes_id | index | ppawel | ways | 119 GB |
public | pk_changes | index | ppawel | changes | 8192 bytes |
public | pk_changeset_tiles | index | ppawel | changeset_tiles | 8192 bytes |
public | pk_changesets | index | ppawel | changesets | 8192 bytes |
public | pk_nodes | index | ppawel | nodes | 80 GB |
public | pk_relation_members | index | ppawel | relation_members | 19 GB |
public | pk_relations | index | ppawel | relations | 220 MB |
public | pk_users | index | ppawel | users | 5824 kB |
public | pk_way_tiles | index | ppawel | way_tiles | 8192 bytes |
public | pk_ways | index | ppawel | ways | 9616 MB |
public | spatial_ref_sys_pkey | index | ppawel | spatial_ref_sys | 144 kB |
public | unique_schema_migrations | index | ppawel | schema_migrations | 8192 bytes |
2013-01-17 @ zark
owl=> select count(distinct changeset_id) from changes;
count
---------
4228351
owl=> \d+
List of relations
Schema | Name | Type | Owner | Size | Description
--------+-------------------+----------+----------+------------+-------------
public | changes | table | ppawel | 79 GB |
public | changes_id_seq | sequence | ppawel | 8192 bytes |
public | changesets | table | ppawel | 2373 MB |
public | geography_columns | view | ppawel | 0 bytes |
public | geometry_columns | view | ppawel | 0 bytes |
public | nodes | table | ppawel | 252 GB |
public | raster_columns | view | postgres | 0 bytes |
public | raster_overviews | view | postgres | 0 bytes |
public | relation_members | table | ppawel | 2295 MB |
public | relations | table | ppawel | 602 MB |
public | schema_migrations | table | ppawel | 0 bytes |
public | spatial_ref_sys | table | ppawel | 3224 kB |
public | tiles | table | ppawel | 253 GB |
public | users | table | ppawel | 10 MB |
public | ways | table | ppawel | 66 GB |
owl=> \di+
List of relations
Schema | Name | Type | Owner | Table | Size | Description
--------+----------------------------+-------+--------+-------------------+------------+-------------
public | idx_changes_changeset_id | index | ppawel | changes | 5785 MB |
public | idx_nodes_changeset_id | index | ppawel | nodes | 45 GB |
public | idx_nodes_node_id | index | ppawel | nodes | 45 GB |
public | idx_nodes_tstamp | index | ppawel | nodes | 45 GB |
public | idx_relations_changeset_id | index | ppawel | relations | 67 MB |
public | idx_tiles_changeset_id | index | ppawel | tiles | 8660 MB |
public | idx_tiles_tstamp | index | ppawel | tiles | 7698 MB |
public | idx_tiles_xcyz | index | ppawel | tiles | 16 GB |
public | idx_tiles_xyz | index | ppawel | tiles | 10 GB |
public | idx_ways_changeset_id | index | ppawel | ways | 5095 MB |
public | idx_ways_nodes_id | index | ppawel | ways | 94 GB |
public | idx_ways_tstamp | index | ppawel | ways | 4926 MB |
public | pk_changes | index | ppawel | changes | 3971 MB |
public | pk_changesets | index | ppawel | changesets | 321 MB |
public | pk_nodes | index | ppawel | nodes | 63 GB |
public | pk_relation_members | index | ppawel | relation_members | 2253 MB |
public | pk_relations | index | ppawel | relations | 119 MB |
public | pk_tiles | index | ppawel | tiles | 16 GB |
public | pk_users | index | ppawel | users | 5312 kB |
public | pk_ways | index | ppawel | ways | 7349 MB |
public | spatial_ref_sys_pkey | index | ppawel | spatial_ref_sys | 144 kB |
public | unique_schema_migrations | index | ppawel | schema_migrations | 8192 bytes |