On Wed, 15 May 2024 at 15:40, jian he <jian.universal...@gmail.com> wrote: > I am looking for an example where this information under json key > "Serialization" is not zero. > So far I have tried:
Something that requires detoasting. > create table s(a text); > insert into s select repeat('a', 1024) from generate_series(1,1024); > explain (format json, analyze, wal, buffers, memory, serialize, timing > off) select * from s; Something bigger than 1024 bytes or use SET STORAGE EXTERNAL or EXTENDED. create table s(a text); insert into s select repeat('a', 1024*1024) from generate_series(1,10); explain (format text, analyze, buffers, serialize, timing off) select * from s; Serialization: output=10241kB format=text Buffers: shared hit=36 David