How to get each row size of a particular table in postgresql..?

Question

Is it possible to get each row size of a particular table in postgres?

For example a table has 50 rows and total table size is 10gb but i want to know each row size rather than complete table size.

Answer 1

Function to calculate row size of postgress table row is something like this

SELECT sum(pg_column_size(t.*)) as filesize, count(*) as filerow FROM TABLE_NAME as t;

replace TABLE_NAME with your table name; to add condition t.COLUMN_NAME = 'YOUR_VALUE'

Answer 2

There is no function that calculates the size of a row, only a function that calculates the size of a column value. So you can do something like this:

select pg_column_size(column_1) + 
       pg_column_size(column_2) + 
       pg_column_size(column_3) as row_size
from the_table;

This could be automated using dynamic SQL and a PL/pgSQL function if you need this.