Skip to main content

HUMANIZE_SIZE

Returns the readable size with a suffix(KiB, MiB, etc).

Syntax​

HUMANIZE_SIZE(x);

Arguments​

ArgumentsDescription
xThe numerical size.

Return Type​

String.

Examples​

SELECT HUMANIZE_SIZE(1024 * 1024)
+-------------------------+
| HUMANIZE_SIZE((1024 * 1024)) |
+-------------------------+
| 1 MiB                    |
+-------------------------+