Thanks for the clarification. Also, I was wrong about the temp_* columns in
the pg_stat_database view in that they report the overall temp file usage since
the last stats reset and not the “current” usage.
Regards,
Kiriakos Georgiou
> On Jul 27, 2023, at 11:31 AM, Kyotaro Horiguchi
> wrote
Hello,
Is there a known issue with temp file reporting? I have a production db that
is reporting 231TB of temp space usage, which can’t be true. temp_blks_written
in pg_stat_statements sort of confirms this, as the reported queries show just
a few MB of temp space usage. I suspect a reboot w
