Hi,
In this video (PostgreSQL at 10 TB and beyond: https://youtu.be/8mKpfutwD0U
at 6mn05), the speaker says that on very big databases explain analyse can
give unrealistic results because it doesn't read toasted data.
I suppose it's because of this: "The big values of TOASTed attributes will
only be pulled out (if selected at all) at the time the result set is sent
to the client." But I dont know if explain analyse does something to
simulate this (if it's possible).
Could you give me a hand to verify/understand this information please ?
Thanks in advance.
Benoit.