The SE_OutOfRowSize() function

The SE_OutOfRowSize() function returns the size of the out-of-row portion of a geometry. Geometries which are larger than 930 bytes (for example, polygons with many vertices) have an in-row component and an out-of-row component; the out-of-row component is stored in an sbspace.

If a geometry has no out-of-row component, SE_OutOfRowSize() returns 0.

You can use this function to obtain an estimate of the amount of diskspace consumed by one or more geometries. However, this function does not account for dbspace and sbspace overhead, so cannot be used to obtain an exact total.

Syntax

SE_OutOfRowSize(ST_Geometry)

Return type

INTEGER

See also

The SE_InRowSize() function

The SE_TotalSize() function