Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1njPIa-0000nr-92
	for pgsql-admin@arkaria.postgresql.org; Tue, 26 Apr 2022 17:48:28 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1njPIZ-0005pS-0A
	for pgsql-admin@arkaria.postgresql.org; Tue, 26 Apr 2022 17:48:27 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1njPIY-0005pI-MK
	for pgsql-admin@lists.postgresql.org; Tue, 26 Apr 2022 17:48:26 +0000
Received: from momjian.us ([72.94.173.45])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1njPIV-0005iR-Sz
	for pgsql-admin@postgresql.org; Tue, 26 Apr 2022 17:48:26 +0000
Received: from bruce by momjian.us with local (Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1njPIT-00ERY3-Gc; Tue, 26 Apr 2022 13:48:21 -0400
Date: Tue, 26 Apr 2022 13:48:21 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Wells Oliver <wells.oliver@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: CTEs and temp_buffers?
Message-ID: <YmgwZfuUCZwctrsC@momjian.us>
References: 
 <CAOC+FBXvpUcTwH5ec0KK7A+MOmRkXDC3xy069ykzEC1asDKi3A@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAOC+FBXvpUcTwH5ec0KK7A+MOmRkXDC3xy069ykzEC1asDKi3A@mail.gmail.com>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/YmgwZfuUCZwctrsC%40momjian.us>
Precedence: bulk

On Tue, Apr 26, 2022 at 10:08:31AM -0700, Wells Oliver wrote:
> Out of curiosity, does the value of temp_buffers apply to how CTEs are
> generated under the hood?

To see temp file usage, you can enable log_temp_files, and check the
server logs or enable client_min_messages.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson