Whether you are trying to estimate memory or the storage for the temp tables, I have not seen any estimates or views.
I have just learned or estimated based on the actual usage as it moves forward.
Theoretically in some database flavors, there are estimates but in actuality practical usage is realistic number.
Good luck,
Sarwar
-------- Original message --------
From: Wells Oliver <wells.oliver@gmail.com>
Date: 6/8/23 1:33 PM (GMT-05:00)
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Obtaining the size of temp tables in current sesion
Is this possible? I am tweaking some scripts and adjusting temp buffers and trying to pin down how much is being written to temporary tables..
--