Re: Looking find the each row size of table
| От | John Scalia |
|---|---|
| Тема | Re: Looking find the each row size of table |
| Дата | |
| Msg-id | FC63CF67-F60D-4424-992A-AFB5408A9650@gmail.com обсуждение исходный текст |
| Ответ на | Looking find the each row size of table (dbatoCloud Solution <dbatocloud17@gmail.com>) |
| Список | pgsql-admin |
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
В списке pgsql-admin по дате отправления: