educative.io

222 bytes per row for the Users table

Can someone explain how 222bytes was derived?

Hi R_P,

If we calculate the sum of all attribute sizes of user fields, we’ll get a total sum of 222 bytes, which is the per-row storage size of a user record.

Size of DATE: 4 bytes

Size of INT: 4 bytes

The total sum of all VARCHARs will be: 210 bytes

The sum of all DATEs: 8 bytes
Size of INT: 4 bytes

If we sum all these, then we’ll get a total of 222 bytes.

Thank you.