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.
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 ?
Benoit.
