I'll second pg_badger. Very useful tool for this.
On Tue, Sep 14, 2021 at 10:20 AM Campbell, Lance <lance@xxxxxxxxxxxx> wrote:
Thanks Tom for responding. I think this will help me out.
Lance
On 9/14/21, 8:58 AM, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote:
"Campbell, Lance" <lance@xxxxxxxxxxxx> writes:
> Is there a way to see, track or log the queries that result in temporary file creation?
The log_temp_files setting might be of use.
regards, tom lane
Jayson Hreczuck | Principal Database Administrator
C: +1 617.571.9861
130 Turner St, Ste 530, Waltham, MA 02453