Skip to content

Instantly share code, notes, and snippets.

@zhm
Created November 7, 2012 20:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zhm/4034326 to your computer and use it in GitHub Desktop.
Save zhm/4034326 to your computer and use it in GitHub Desktop.
select
(select count(1) from acls) as acls,
(select count(1) from changeset_tags) as changeset_tags,
(select count(1) from changesets) as changesets,
(select count(1) from client_applications) as client_applications,
(select count(1) from countries) as countries,
(select count(1) from current_node_tags) as current_node_tags,
(select count(1) from current_nodes) as current_nodes,
(select count(1) from current_relation_members) as current_relation_members,
(select count(1) from current_relation_tags) as current_relation_tags,
(select count(1) from current_relations) as current_relations,
(select count(1) from current_way_nodes) as current_way_nodes,
(select count(1) from current_way_tags) as current_way_tags,
(select count(1) from current_ways) as current_ways,
(select count(1) from diary_comments) as diary_comments,
(select count(1) from diary_entries) as diary_entries,
(select count(1) from friends) as friends,
(select count(1) from gps_points) as gps_points,
(select count(1) from gpx_file_tags) as gpx_file_tags,
(select count(1) from gpx_files) as gpx_files,
(select count(1) from languages) as languages,
(select count(1) from messages) as messages,
(select count(1) from node_tags) as node_tags,
(select count(1) from nodes) as nodes,
(select count(1) from oauth_nonces) as oauth_nonces,
(select count(1) from oauth_tokens) as oauth_tokens,
(select count(1) from relation_members) as relation_members,
(select count(1) from relation_tags) as relation_tags,
(select count(1) from relations) as relations,
(select count(1) from schema_migrations) as schema_migrations,
(select count(1) from sessions) as sessions,
(select count(1) from spatial_ref_sys) as spatial_ref_sys,
(select count(1) from user_blocks) as user_blocks,
(select count(1) from user_preferences) as user_preferences,
(select count(1) from user_roles) as user_roles,
(select count(1) from user_tokens) as user_tokens,
(select count(1) from users) as users,
(select count(1) from way_nodes) as way_nodes,
(select count(1) from way_tags) as way_tags,
(select count(1) from ways) as ways
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment