Обсуждение: Looking find the each row size of table
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@gmail.com
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@gmail.com> 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@gmail.com