SIZE - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

SIZE

Returns the binary in-memory size of a SUPER type constant or expression as an INTEGER.

Syntax

SIZE(super_expression)

Arguments

super_expression

A SUPER type constant or expression.

Return type

INTEGER

Examples

To use SIZE to get the in-memory size of several SUPER type expressions, use the following example.

CREATE TABLE test_super_size(a SUPER); INSERT INTO test_super_size VALUES (null), (TRUE), (JSON_PARSE('[0,1,2,3]')), (JSON_PARSE('{"a":0,"b":1,"c":2,"d":3}')) ; SELECT a, SIZE(a) FROM test_super_size ORDER BY 2, 1; +---------------------------+------+ | a | size | +---------------------------+------+ | true | 4 | | NULL | 4 | | [0,1,2,3] | 23 | | {"a":0,"b":1,"c":2,"d":3} | 52 | +---------------------------+------+