Re: Obtaining the size of temp tables in current sesion

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Wells Oliver <wells.oliver@xxxxxxxxx>
Subject: Re: Obtaining the size of temp tables in current sesion
From: MichaelDBA <MichaelDBA@xxxxxxxxxxx>
Date: Sun, 11 Jun 2023 10:15:06 -0400
Cc: pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <CAOC+FBVRL9=sp5tMNu6u7K4uSJ7mMLo3HmAoCk6+_U4kctAv2Q@mail.gmail.com>
References: <CAOC+FBVRL9=sp5tMNu6u7K4uSJ7mMLo3HmAoCk6+_U4kctAv2Q@mail.gmail.com>
Ui-outboundreport: notjunk:1;M01:P0:malHIt6Nhzg=;5CX0Y0KXMHFXsD35MXUuKX/aX8Y Gm65+zqd4RaBgmyqKKHEyMggKPYbFdYdQtSvSmTw4gDEd/WCAaj0CJ5z/rTh+YdB20dghORaH folHa0jEgOX+PmmBawzVo75P5luPin0Po9LASFVOdbiSsv6jOBYrEh367sw9qfvia4Nf6Q7Mp PxwGIBs6Ah8KWJ3zYcp0Zwa6rEmnMtXNclaVXOeTcqXnVf7T8A1hBjCK68n7KMUp0B2wdzkRH XDEKPhrmnjGerYe9HuRHA2Ety32ary2WHPy+HPnXGkW3S5vrsEmwGGx/zVeHfsHj4X84/oJtS hSIi1/p8Nv9PLjmWFQ62GtHsd0G2m8KOcP8PD1KGgLl3M5fO1k85Gsr/F1IPPXNJHyMcDzwev QsjfPxZ6vdbyy4WfLv96Q2TD6VMZbNKe7/NbmasG0EUjXXBX0Ek1LueF7GtRoEB2VRvFbe9sl rPsYPs9kOFOmiQs5QZO9GYzIgUC+n3IB7WA6PIXKYzn5xmIv3IQwTWzE/e9qlPWT9rtU1/cF8 Jem7uZHeHsIFsQaJZyyYUHrzSL/oMj/5q8I0qAEBB1sUE3ubsrQ5KnU3liIYkWhu5BtjX/u6i nTq7JKjdPOAgYBe2192uYMs2Ikm8DYSQbTZBZsf5TgzQkpzujMbIL1VsnoyRcP/VgaZmhLQPp BSNCDHDHw8WLHBdjKgP8WXYT6aEqccQCAkVF5/nKDw==
User-agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 PostboxApp/7.0.60

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.oliver@xxxxxxxxx

Regards,

Michael Vitale

Michaeldba@xxxxxxxxxxx

703-600-9343

References:
- Obtaining the size of temp tables in current sesion
  - From: Wells Oliver

Prev by Date: Re: How to read wal files in postgresql 15?
Next by Date: How to use long list of columns with COPY command
Previous by thread: RE: Obtaining the size of temp tables in current sesion
Next by thread: How to read wal files in postgresql 15?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]