How to calculate bytes used for individual table rows?

[Josh]

Hello,

Is there a way to get the exact bytes used by a particular row from a table? Not the average, but the exact?

I think I know how to get the average bytes used per row:

Code: Select all

dbadmin=> select * from t;
   c1   |  c2   
--------+-------
 1234   | 5
 123456 | 78
 123456 | 78910
(3 rows)

dbadmin=> select sum(used_bytes), avg(row_count), sum(used_bytes) / avg(row_count) from projection_storage where anchor_table_name = 't';
 sum | avg | ?column? 
-----+-----+----------
 123 |   3 |       41
(1 row)

dbadmin=> select sum(used_bytes), avg(row_count), sum(used_bytes) / avg(row_count) avg_row_used_bytes from projection_storage where anchor_table_name = 't';
 sum | avg | avg_row_used_bytes 
-----+-----+--------------------
 123 |   3 |                 41
(1 row)

But I would like to see the actual bytes used per row

Thank you.