Assuming I have a table in PostgreSQL, how can I find the exact byte size used by the system in order to save a specific row of my table? For example, assume I have a table with a <code>VARCHAR(1000000)</code> field and some rows contain really big strings for this field while others really small. How can I check the byte size of a row in this case? (including the byte size even in the case TOAST is being used).

Use <code>pg_column_size</code> and <code>octet_length</code>. See: <ul> <li>How can pg_column_size be smaller than octet_length?</li> <li>How can I find out how big a large TEXT field is in Postgres?</li> <li>How can pg_column_size be smaller than octet_length?</li> </ul>

Find the byte size of a row in PostgreSQL

Tags:

sql

database

postgresql

varchar

byte

Assuming I have a table in PostgreSQL, how can I find the exact byte size used by the system in order to save a specific row of my table?

For example, assume I have a table with a VARCHAR(1000000) field and some rows contain really big strings for this field while others really small. How can I check the byte size of a row in this case? (including the byte size even in the case TOAST is being used).