SQL to generate statistics about an osm2pgsql database for verification of output

osm2pgsql_stats.sql

\x
SELECT COUNT(*), SUM(array_length(nodes, 1)) AS nodes, SUM(array_length(tags, 1)) AS tags FROM planet_osm_ways;

SELECT COUNT(*), SUM(array_length(parts, 1)) AS parts, SUM(array_length(members, 1)) AS members, SUM(array_length(tags, 1)) AS tags FROM planet_osm_rels;


SELECT COUNT(*) AS point_count FROM planet_osm_point;
SELECT COUNT(*), SUM(ST_Length(way)) AS st_length FROM planet_osm_line;
SELECT COUNT(*), SUM(way_area) AS way_area, SUM(ST_Area(way)) AS st_area, SUM(ST_Perimeter(way)) AS st_perimeter FROM planet_osm_polygon;
SELECT COUNT(*), SUM(ST_Length(way)) AS st_length FROM planet_osm_roads;

SELECT COUNT(*), SUM(way_area) AS way_area, SUM(ST_Area(way)) AS st_area, SUM(ST_Perimeter(way)) AS st_perimeter FROM planet_osm_polygon WHERE leisure = 'playground';
SELECT COUNT(*), SUM(ST_Length(way)) AS st_length FROM planet_osm_line WHERE highway='primary';
SELECT COUNT(*), SUM(ST_Length(way)) AS st_length FROM planet_osm_roads WHERE highway='primary';
SELECT COUNT(*) AS point_count FROM planet_osm_point WHERE "natural"='tree';