Re: Obtaining the size of temp tables in current sesion

From: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
To: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Obtaining the size of temp tables in current sesion
Date: 2023-06-11 14:15:06
Message-ID: 3100b415-bbe5-7786-390b-f316aa301b05@sqlexec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

du -hs $PGDATA/base/pgsql_tmp

Wells Oliver wrote on 6/8/2023 1:32 PM:
> 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..
>
> --
> Wells Oliver
> wells(dot)oliver(at)gmail(dot)com <mailto:wellsoliver(at)gmail(dot)com>

Regards,

Michael Vitale

Michaeldba(at)sqlexec(dot)com <mailto:michaelvitale(at)sqlexec(dot)com>

703-600-9343

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message M Sarwar 2023-06-11 21:44:06 How to use long list of columns with COPY command
Previous Message hubert depesz lubaczewski 2023-06-09 15:12:55 Re: How to read wal files in postgresql 15?