Thursday, July 14, 2011

Size of geometry in your postgis table

Here's how to find the size of geometry column in a table:

SELECT pg_size_pretty(CAST(SUM(ST_Mem_Size(geometry_column)) As bigint) ) as totgeomsum
FROM yourtable;


No comments:

Post a Comment