Calculating the row size of a table

Asked Jun 19 '13 at 17:05

Active Jun 05 '15 at 21:28

Viewed 77 times

Is there a way to calculate the row size (in bytes) of a particular table in postgresql / pgadmin3?

edited Jun 05 '15 at 21:28

Hannah Vernon

asked Jun 19 '13 at 17:05

Nick Ginanto

1

What would that measure? Especially in case of variable-width columns? – Jun 19 '13 at 17:44
The question this one was linked to primarily deals with the size of a whole table. To get the (varying) size of individual rows: SELECT pg_column_size(t) FROM tbl AS t LIMIT 10 More info in this question on SO. – Erwin Brandstetter Jun 20 '13 at 22:07

0 Answers0