Re: pg_stats.avg_width

2023-05-18 Thread Maciek Sakrejda
Thanks, that makes sense. It was going to be my third guess, but it seemed pretty wide for a TOAST pointer. Reviewing what goes in there, though, it's reasonable. I assume that this means for unTOASTed but compressed data, this counts the compressed size. Would a doc patch clarifying this (and po

Re: pg_stats.avg_width

2023-05-17 Thread Tom Lane
Maciek Sakrejda writes: > The pg_stats.avg_width field is documented [1] as "Average width in > bytes of column's entries" but it's not defined exactly what "entries" > means here with respect to STORAGE (the underlying pg_statistic > documentati

pg_stats.avg_width

2023-05-17 Thread Maciek Sakrejda
Hello, The pg_stats.avg_width field is documented [1] as "Average width in bytes of column's entries" but it's not defined exactly what "entries" means here with respect to STORAGE (the underlying pg_statistic documentation doesn't clarify this either). I thou