Database/TableInfoDump
< Database
Jump to navigation
Jump to 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 |