Database/TableInfoDump

From OpenStreetMap Wiki
Jump to: navigation, search

This table info was dumped by TomH on 2016/10/31.

Link: https://gist.github.com/tomhughes/975fdc9bcf50415c4a12c22f09e653d7

I case links will break content is included below.

Tables

Schema |           Name            | Type  |     Owner     |  Size   | Description 
public | acls                      | table | openstreetmap | 280 kB  | 
public | changeset_comments        | table | openstreetmap | 27 MB   | 
public | changeset_tags            | table | openstreetmap | 8108 MB | 
public | changesets                | table | openstreetmap | 5131 MB | 
public | changesets_subscribers    | table | openstreetmap | 4007 MB | 
public | client_applications       | table | openstreetmap | 536 kB  | 
public | current_node_tags         | table | openstreetmap | 32 GB   | 
public | current_nodes             | table | openstreetmap | 332 GB  | 
public | current_relation_members  | table | openstreetmap | 3572 MB | 
public | current_relation_tags     | table | openstreetmap | 1270 MB | 
public | current_relations         | table | openstreetmap | 406 MB  | 
public | current_way_nodes         | table | openstreetmap | 235 GB  | 
public | current_way_tags          | table | openstreetmap | 67 GB   | 
public | current_ways              | table | openstreetmap | 28 GB   | 
public | diary_comments            | table | openstreetmap | 14 MB   | 
public | diary_entries             | table | openstreetmap | 38 MB   | 
public | diary_entry_subscriptions | table | openstreetmap | 1752 kB | 
public | friends                   | table | openstreetmap | 4376 kB | 
public | gps_points                | table | openstreetmap | 389 GB  | 
public | gpx_file_tags             | table | openstreetmap | 130 MB  | 
public | gpx_files                 | table | openstreetmap | 260 MB  | 
public | languages                 | table | openstreetmap | 56 kB   | 
public | messages                  | table | openstreetmap | 661 MB  | 
public | node_tags                 | table | openstreetmap | 129 GB  | 
public | nodes                     | table | openstreetmap | 465 GB  | 
public | note_comments             | table | openstreetmap | 239 MB  | 
public | notes                     | table | openstreetmap | 73 MB   | 
public | oauth_nonces              | table | openstreetmap | 8627 MB | 
public | oauth_tokens              | table | openstreetmap | 2534 MB | 
public | redactions                | table | openstreetmap | 48 kB   | 
public | relation_members          | table | openstreetmap | 109 GB  | 
public | relation_tags             | table | openstreetmap | 6979 MB | 
public | relations                 | table | openstreetmap | 1275 MB | 
public | schema_migrations         | table | openstreetmap | 40 kB   | 
public | user_blocks               | table | openstreetmap | 1104 kB | 
public | user_preferences          | table | openstreetmap | 31 MB   | 
public | user_roles                | table | openstreetmap | 40 kB   | 
public | user_tokens               | table | openstreetmap | 8816 kB | 
public | users                     | table | openstreetmap | 2141 MB | 
public | way_nodes                 | table | openstreetmap | 641 GB  | 
public | way_tags                  | table | openstreetmap | 143 GB  | 
public | ways                      | table | openstreetmap | 47 GB   | 

Indexes

Schema |                              Name                              | Type  |     Owner     |           Table           |  Size   | Description 
public | acls_k_idx                                                     | index | openstreetmap | acls                      | 72 kB   | 
public | acls_pkey                                                      | index | openstreetmap | acls                      | 48 kB   | 
public | changeset_comments_pkey                                        | index | openstreetmap | changeset_comments        | 1880 kB | 
public | changeset_tags_id_idx                                          | index | openstreetmap | changeset_tags            | 2614 MB | 
public | changesets_bbox_idx                                            | index | openstreetmap | changesets                | 129 GB  | 
public | changesets_closed_at_idx                                       | index | openstreetmap | changesets                | 40 GB   | 
public | changesets_created_at_idx                                      | index | openstreetmap | changesets                | 27 GB   | 
public | changesets_pkey                                                | index | openstreetmap | changesets                | 31 GB   | 
public | changesets_user_id_created_at_idx                              | index | openstreetmap | changesets                | 37 GB   | 
public | changesets_user_id_id_idx                                      | index | openstreetmap | changesets                | 36 GB   | 
public | client_applications_pkey                                       | index | openstreetmap | client_applications       | 72 kB   | 
public | current_node_tags_pkey                                         | index | openstreetmap | current_node_tags         | 27 GB   | 
public | current_nodes_pkey1                                            | index | openstreetmap | current_nodes             | 122 GB  | 
public | current_nodes_tile_idx                                         | index | openstreetmap | current_nodes             | 123 GB  | 
public | current_nodes_timestamp_idx                                    | index | openstreetmap | current_nodes             | 106 GB  | 
public | current_relation_members_member_idx                            | index | openstreetmap | current_relation_members  | 5181 MB | 
public | current_relation_members_pkey                                  | index | openstreetmap | current_relation_members  | 10 GB   | 
public | current_relation_tags_pkey                                     | index | openstreetmap | current_relation_tags     | 1079 MB | 
public | current_relations_pkey                                         | index | openstreetmap | current_relations         | 199 MB  | 
public | current_relations_timestamp_idx                                | index | openstreetmap | current_relations         | 261 MB  | 
public | current_way_nodes_node_idx                                     | index | openstreetmap | current_way_nodes         | 111 GB  | 
public | current_way_nodes_pkey                                         | index | openstreetmap | current_way_nodes         | 205 GB  | 
public | current_way_tags_pkey                                          | index | openstreetmap | current_way_tags          | 51 GB   | 
public | current_ways_pkey                                              | index | openstreetmap | current_ways              | 13 GB   | 
public | current_ways_timestamp_idx                                     | index | openstreetmap | current_ways              | 12 GB   | 
public | diary_comment_user_id_created_at_index                         | index | openstreetmap | diary_comments            | 1448 kB | 
public | diary_comments_entry_id_idx                                    | index | openstreetmap | diary_comments            | 1152 kB | 
public | diary_comments_entry_id_idx_old                                | index | openstreetmap | diary_comments            | 1176 kB | 
public | diary_comments_pkey                                            | index | openstreetmap | diary_comments            | 816 kB  | 
public | diary_entries_pkey                                             | index | openstreetmap | diary_entries             | 888 kB  | 
public | diary_entry_created_at_index                                   | index | openstreetmap | diary_entries             | 888 kB  | 
public | diary_entry_language_code_created_at_index                     | index | openstreetmap | diary_entries             | 1760 kB | 
public | diary_entry_subscriptions_pkey                                 | index | openstreetmap | diary_entry_subscriptions | 1568 kB | 
public | diary_entry_user_id_created_at_index                           | index | openstreetmap | diary_entries             | 1480 kB | 
public | friends_pkey                                                   | index | openstreetmap | friends                   | 1904 kB | 
public | friends_user_id_idx                                            | index | openstreetmap | friends                   | 2568 kB | 
public | gpx_file_tags_gpxid_idx                                        | index | openstreetmap | gpx_file_tags             | 53 MB   | 
public | gpx_file_tags_pkey                                             | index | openstreetmap | gpx_file_tags             | 53 MB   | 
public | gpx_file_tags_tag_idx                                          | index | openstreetmap | gpx_file_tags             | 82 MB   | 
public | gpx_files_pkey                                                 | index | openstreetmap | gpx_files                 | 45 MB   | 
public | gpx_files_timestamp_idx                                        | index | openstreetmap | gpx_files                 | 42 MB   | 
public | gpx_files_user_id_idx                                          | index | openstreetmap | gpx_files                 | 50 MB   | 
public | gpx_files_visible_visibility_idx                               | index | openstreetmap | gpx_files                 | 50 MB   | 
public | index_changeset_comments_on_created_at                         | index | openstreetmap | changeset_comments        | 1880 kB | 
public | index_changesets_subscribers_on_changeset_id                   | index | openstreetmap | changesets_subscribers    | 1449 MB | 
public | index_changesets_subscribers_on_subscriber_id_and_changeset_id | index | openstreetmap | changesets_subscribers    | 2237 MB | 
public | index_client_applications_on_key                               | index | openstreetmap | client_applications       | 232 kB  | 
public | index_diary_entry_subscriptions_on_diary_entry_id              | index | openstreetmap | diary_entry_subscriptions | 888 kB  | 
public | index_note_comments_on_body                                    | index | openstreetmap | note_comments             | 213 MB  | 
public | index_note_comments_on_created_at                              | index | openstreetmap | note_comments             | 33 MB   | 
public | index_oauth_nonces_on_nonce_and_timestamp                      | index | openstreetmap | oauth_nonces              | 3889 MB | 
public | index_oauth_tokens_on_token                                    | index | openstreetmap | oauth_tokens              | 843 MB  | 
public | index_user_blocks_on_user_id                                   | index | openstreetmap | user_blocks               | 48 kB   | 
public | languages_pkey                                                 | index | openstreetmap | languages                 | 16 kB   | 
public | messages_from_user_id_idx                                      | index | openstreetmap | messages                  | 17 MB   | 
public | messages_pkey                                                  | index | openstreetmap | messages                  | 16 MB   | 
public | messages_to_user_id_idx                                        | index | openstreetmap | messages                  | 17 MB   | 
public | node_tags_pkey                                                 | index | openstreetmap | node_tags                 | 89 GB   | 
public | nodes_changeset_id_idx                                         | index | openstreetmap | nodes                     | 141 GB  | 
public | nodes_pkey                                                     | index | openstreetmap | nodes                     | 214 GB  | 
public | nodes_tile_idx                                                 | index | openstreetmap | nodes                     | 155 GB  | 
public | nodes_timestamp_idx                                            | index | openstreetmap | nodes                     | 123 GB  | 
public | nodes_xmin_idx                                                 | index | openstreetmap | nodes                     | 138 GB  | 
public | note_comments_note_id_idx                                      | index | openstreetmap | note_comments             | 41 MB   | 
public | note_comments_pkey                                             | index | openstreetmap | note_comments             | 33 MB   | 
public | notes_created_at_idx                                           | index | openstreetmap | notes                     | 74 MB   | 
public | notes_pkey                                                     | index | openstreetmap | notes                     | 41 MB   | 
public | notes_tile_status_idx                                          | index | openstreetmap | notes                     | 39 MB   | 
public | notes_updated_at_idx                                           | index | openstreetmap | notes                     | 63 MB   | 
public | oauth_nonces_pkey                                              | index | openstreetmap | oauth_nonces              | 2436 MB | 
public | oauth_tokens_pkey                                              | index | openstreetmap | oauth_tokens              | 236 MB  | 
public | points_gpxid_idx                                               | index | openstreetmap | gps_points                | 132 GB  | 
public | points_tile_idx                                                | index | openstreetmap | gps_points                | 144 GB  | 
public | redactions_pkey                                                | index | openstreetmap | redactions                | 16 kB   | 
public | relation_members_member_idx                                    | index | openstreetmap | relation_members          | 63 GB   | 
public | relation_members_pkey                                          | index | openstreetmap | relation_members          | 131 GB  | 
public | relation_tags_pkey                                             | index | openstreetmap | relation_tags             | 6017 MB | 
public | relations_changeset_id_idx                                     | index | openstreetmap | relations                 | 458 MB  | 
public | relations_pkey                                                 | index | openstreetmap | relations                 | 804 MB  | 
public | relations_timestamp_idx                                        | index | openstreetmap | relations                 | 438 MB  | 
public | relations_xmin_idx                                             | index | openstreetmap | relations                 | 440 MB  | 
public | unique_schema_migrations                                       | index | openstreetmap | schema_migrations         | 16 kB   | 
public | user_blocks_pkey                                               | index | openstreetmap | user_blocks               | 40 kB   | 
public | user_id_idx                                                    | index | openstreetmap | friends                   | 2640 kB | 
public | user_preferences_pkey                                          | index | openstreetmap | user_preferences          | 15 MB   | 
public | user_roles_id_role_unique                                      | index | openstreetmap | user_roles                | 16 kB   | 
public | user_roles_pkey                                                | index | openstreetmap | user_roles                | 16 kB   | 
public | user_tokens_pkey                                               | index | openstreetmap | user_tokens               | 3656 kB | 
public | user_tokens_token_idx                                          | index | openstreetmap | user_tokens               | 6904 kB | 
public | user_tokens_user_id_idx                                        | index | openstreetmap | user_tokens               | 6416 kB | 
public | users_auth_idx                                                 | index | openstreetmap | users                     | 214 MB  | 
public | users_display_name_idx                                         | index | openstreetmap | users                     | 218 MB  | 
public | users_display_name_lower_idx                                   | index | openstreetmap | users                     | 229 MB  | 
public | users_email_idx                                                | index | openstreetmap | users                     | 319 MB  | 
public | users_email_lower_idx                                          | index | openstreetmap | users                     | 335 MB  | 
public | users_pkey                                                     | index | openstreetmap | users                     | 182 MB  | 
public | way_nodes_node_idx                                             | index | openstreetmap | way_nodes                 | 326 GB  | 
public | way_nodes_pkey                                                 | index | openstreetmap | way_nodes                 | 600 GB  | 
public | way_tags_pkey                                                  | index | openstreetmap | way_tags                  | 123 GB  | 
public | ways_changeset_id_idx                                          | index | openstreetmap | ways                      | 18 GB   | 
public | ways_pkey                                                      | index | openstreetmap | ways                      | 29 GB   | 
public | ways_timestamp_idx                                             | index | openstreetmap | ways                      | 16 GB   | 
public | ways_xmin_idx                                                  | index | openstreetmap | ways                      | 17 GB   |