OWL/Benchmarks

From OpenStreetMap Wiki
< OWL
Jump to: navigation, search

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 |