ST_GeoSize

Note:

PostgreSQL only

Definition

ST_GeoSize takes an ST_Geometry object and returns its size in bytes.

Syntax

st_geosize (st_geometry)

Return type

Integer

Example

You can discover the size of the features created in the ST_GeomFromWKB example by querying the geometry column of the sample_geometries table.

SELECT st_geosize (geometry) 
FROM sample_geometries;

st_geosize
	512
	592
	616