Re: Looking find the each row size of table

[John Scalia <jayknowsunix@xxxxxxxxx>]

pg_column_size returns the number of bytes with no formatting at all. Do something like select pg_size_pretty(pg_column_size(my_column) / 1024)  would give you the value in Kbytes, further calculation in the same manner could convert this into Mbytes, Gbytes, or whatever you need.

—

Jay

Sent from my iPad

On Feb 19, 2021, at 7:28 AM, dbatoCloud Solution <dbatocloud17@xxxxxxxxx> wrote:



Dear All,

 I want to find out each row size of a table in PostgreSQL? 

I got pg_column_size() function. Could you please someone help me? Will this function return size in KB or MB?

 

 

Thanks & Best Wishes,

Ashok

 

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UAE | BLR , INDIA

M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@xxxxxxxxx