ST_Memsize

更新时间: 2026-03-28 07:46:46

Returns the memory size occupied by an object.

Syntax

int4 ST_Memsize(meshgeom geom);
int4 ST_Memsize(sfmesh sfmeshObject);
int4 ST_Memsize(material material);
int4 ST_Memsize(texture texture);

Parameters

ParameterTypeDescription
geommeshgeomA meshgeom object.
sfmeshObjectsfmeshAn sfmesh object.
materialmaterialA material object.
texturetextureA texture object.

Description

ST_Memsize returns the amount of memory the input object occupies. The return type is int4.

The function accepts four object types: meshgeom, sfmesh, material, and texture.

Examples

Get the memory size of a single object

SELECT ST_Memsize(
  'MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0,0 10,10 10,10 0), INDEX((0,1,2),(1,2,3)))))'::meshgeom
);

Result:

 st_memsize
------------
        144
上一篇: Attribute functions 下一篇: ST_Dimension
阿里云首页 云原生数据库 PolarDB 相关技术圈