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 ) id 1pN318-0005Vm-TT for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Feb 2023 02:38:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pN317-0003Lr-2O for pgsql-hackers@arkaria.postgresql.org; Wed, 01 Feb 2023 02:38:33 +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 ) id 1pN316-0003LS-Kx for pgsql-hackers@lists.postgresql.org; Wed, 01 Feb 2023 02:38:32 +0000 Received: from mail-io1-xd2d.google.com ([2607:f8b0:4864:20::d2d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pN30z-00064f-N7 for pgsql-hackers@postgresql.org; Wed, 01 Feb 2023 02:38:31 +0000 Received: by mail-io1-xd2d.google.com with SMTP id r6so3900235ioj.5 for ; Tue, 31 Jan 2023 18:38:25 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=VeCCRFUFZfCjSfuq1XWWdHj64TAr5JnnRWlLT8+nbBY=; b=K0DfwEh36VfJZukqlzc61q0MZ9cT7CCR2w6h/CqG6Y39zfXyhOfRHl+CF/nk26hHtw yM2Jny0TlP5sOe2/4CElJFb+/9FE3yBhxWvwyMNUHkovOLjcTCER+CojC74rcBjldqFK 0sZkDfcqj6z67zhOPjfK35yDNGWMAo18seVGO5egwBm7E0MjvrwMPXwtD58JPxL95Wtr VwUfclMcaO+j2nKBrPQh7RqiAy5ACrein7efkDO6P44vyuff24nhRHHppBFEZFY73kOr 8RaHbytxAEnV+3w0MpLXlAdKKHjl/GnIrjEmudJQtW4LlkLiOpPYwsa1YYYST0s2GiqE J6IQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=user-agent:in-reply-to:content-disposition:mime-version:references :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=VeCCRFUFZfCjSfuq1XWWdHj64TAr5JnnRWlLT8+nbBY=; b=Rensnm0qV+gdBUTSC44KBkj/e9Ln5QXnn32Y/xtfF5d928u8+BjebH0lHCndcQxItk 07RmGGUBsOhxuxIh+cWOg+7b6GkTXbyGxHYvZNQD3GEr2bmJZkqkXBlZWILvvKqNvCaF t/PjEmAbGjIqTrGE8tBbohYK311J/avtlYp3PPD97rtMdrBqrZ1spLknKk9ZvMP/ySdN UXELdchpnjYllELLyrlaImScpYSRtgOllvy9IXe+h1vdT+dZpwEH2Kg1raoMY8yNlC1z sEfwaMaxbxFtU1IaCKSZ5xnLVjyEzakMF3cU2Dl9hQTT67O2LOXpYW5f8QRl6Ojwu2lA lLiQ== X-Gm-Message-State: AO0yUKX/F+/1OZ/Ov0NGhpbOSp6KUIDp04g4BQhgYS7iLkAHDeb3V6AL jZcz0xSAyaO12NMQNMn2kqnFB/QAK+FnFjYm X-Google-Smtp-Source: AK7set8hjT9J0gUPLEOmWc5D0KrDnrVjKknQwBSOW8S3l+xDA7B/95MY8/UsCdL2Qb8koIv0otw8ew== X-Received: by 2002:a5d:890a:0:b0:719:25b3:3db0 with SMTP id b10-20020a5d890a000000b0071925b33db0mr418808ion.14.1675219103528; Tue, 31 Jan 2023 18:38:23 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id c4-20020a056602334400b006e3a51d5878sm5717388ioz.7.2023.01.31.18.38.22 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 31 Jan 2023 18:38:23 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id E9F37800983; Tue, 31 Jan 2023 20:38:21 -0600 (CST) Date: Tue, 31 Jan 2023 20:38:21 -0600 From: Justin Pryzby To: Bruce Momjian Cc: pgsql-hackers@postgresql.org Subject: Re: Generating "Subplan Removed" in EXPLAIN Message-ID: <20230201023821.GP22427@telsasoft.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jan 31, 2023 at 08:59:57PM -0500, Bruce Momjian wrote: > Does anyone know how to generate this? Thanks. The regression tests know: $ git grep -c 'Subplans Removed' ./src/test/regress/ src/test/regress/expected/partition_prune.out:29 -- Justin