Timeline for Measure the size of a PostgreSQL table row
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 4, 2023 at 15:28 | comment | added | Daniel Vérité |
The question says the size of the row is very large and it's taking a while to transport so it refers to the size of what goes through the network when an SQL client issues a select * from table query, which is the uncompressed size.
|
|
| Jan 4, 2023 at 13:35 | comment | added | Milad | I don't think this considers the compression. So the real size is less than this. | |
| Jul 2, 2020 at 9:56 | comment | added | dankal444 | @AkmalSalikhov yes, just checked it in documentation. I have also a question - am I correct - octet_length gives uncompressed size, not actual size on disk it takes? I found this answer that suggests it to me. | |
| Oct 21, 2019 at 15:18 | comment | added | Akmal Salikhov | result are bytes? | |
| Mar 27, 2019 at 16:06 | comment | added | fgblomqvist | Excellent way to quickly get some estimates when working with big data (e.g. the majority of the row size lies in variable-length toast-stored columns), good idea! | |
| Sep 7, 2012 at 14:23 | history | answered | Daniel Vérité | CC BY-SA 3.0 |