count geomtypes

count_geomtypes.sql

SELECT 
	string_agg(stmt,  E' union all\n') as union_stmt
from
(
select 
 table_schema
 , table_name	  
 , column_name 
 , format($$select %1$L || '.' || %2$L || '.' || %3$L as col, ST_GeometryType(%3$I), count(*) as arv from	%1$I.%2$I group by 	ST_GeometryType(%3$I)$$ 	  , table_schema	  , table_name	  , column_name	  ) as stmt
from 
	information_schema.columns  c
where
	udt_name = 'geometry'
) as dummy
	;