Toad World® Forums

Postgres Average row length


#1

Is there a way to find out average record length for a table in Postgres ?

In Toad for Oracle, Schema browser table viewer had a statistics option that showed this if the table was populated with few rows of data. But TDP does not have such an option.

So wondering if it is buried somewhere that I cannot find or if there is any internal table/view of Postgres that I can query to get this.


#2

TDP does not provide this information.

You could use the following link to see who to get it

https://www.dbrnd.com/2016/03/postgresql-how-to-measure-the-size-of-a-table-row-and-data-page/

https://stackoverflow.com/questions/34222996/how-to-get-each-row-size-of-a-particular-table-in-postgresql

Regards

Aleksey