Re: How Avg_row_length is calculated?

[Benjamin Dunlap]

This is confusing me as well. I have table with four INT columns (16 bytes), 2 SMALLINT columns (4 bytes), and one FLOAT column (4 bytes). Maximum row size should be 24 bytes, shouldn't it?

But when I put data in the table I see various avg_row_length values, including 70.

As far as I can tell avg_row_length is something close to 'data_length' / 'rows'. But the value of 'rows' is confusing too, because it doesn't seem to necessarily match the number of rows in the table.

Thanks!