Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tw0pb-009uDb-Ul for pgsql-general@arkaria.postgresql.org; Sat, 22 Mar 2025 15:32:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tw0pa-00FDYn-6A for pgsql-general@arkaria.postgresql.org; Sat, 22 Mar 2025 15:32:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tw0pZ-00FDYe-P4 for pgsql-general@lists.postgresql.org; Sat, 22 Mar 2025 15:32:13 +0000 Received: from mail-ot1-x329.google.com ([2607:f8b0:4864:20::329]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tw0pX-000WRp-0e for pgsql-general@lists.postgresql.org; Sat, 22 Mar 2025 15:32:13 +0000 Received: by mail-ot1-x329.google.com with SMTP id 46e09a7af769-72c13802133so341887a34.3 for ; Sat, 22 Mar 2025 08:32:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742657529; x=1743262329; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=niN+gh5XOIF6NVgRULry31DC+PsaPsc25PyJnlblzsM=; b=X5XxI6i6r3CieIXFdvBm8DsDn7n5qaF6IXgth+XH6w3Z7MY79IK1Lev5irG3eKUOx9 tOUOH2pUKWKgXIADSOxjasH+Epbhz35pWh93YiNpsgbXbDpqgfZfCs5MdzBP7cLOAI6K 3nYx3HXutXheOPcMrwaioCnSgulr6m/lYpFNBzP/wVmiR4jnle6xB3jjQ0eXLq1GiCwd QvJ1ZnyLXgNpqPKyktcWY5QzkmsNpRm/5iSXde7cloUHz188jVcOa/N5bmDAuNmb7WqG rMPIXeY99SvtHY688pLFPLeep2F1Rnd3qaEEj1ti7lkxxMwY0C4+1bSYsYV0CQrQq7pd 88Aw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742657529; x=1743262329; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=niN+gh5XOIF6NVgRULry31DC+PsaPsc25PyJnlblzsM=; b=ENnU3OPDhpsfZlxU2hu3yPcLKhvy1fLJca1q/M8/cRIvdkbOjFb16dda6fsr0DbIDj LnLdgE5x/GI2r0/vBRBFi7kUomO1L0OvgmYC6s0+HcUqzR/iHajJukNL1/FeAjykjgnY CYcDNiZDVPVMkS6yVzNvqnsRP58kif4w1zHjWjfh6Z+NSQpn+Uu7Dl0lQEZW0BtzNU1B DfPKHuCgUsr7RGHODS/sg2e4JlfwyNliI/hV6fVMMkPO+yIb39cModl0KGVWjwGgJ9i7 VWZuXQbZebRFYSh70PrluVvjrub1K2CBN+dORuLD6dryYbTZENB6Kvyf7nqLD3nJnJ4q 5dKA== X-Gm-Message-State: AOJu0YwmPPX/9t9bYykUBr6W0afkUJPBIJc6T57DpT6PJ8ZUr+6cfZuV 0ZeWlubOt9G60Ob345P4PCduc+aps5Tf31vnfhDTeiUybgotAehHcVbtvFO1vF288hp7eLJl6hB 2SMQgx3Ael00jyQPGhTUSzFbWm70D7THB X-Gm-Gg: ASbGncsbGke2HPLuKkDvyzeRNFmMfrycoade5bNz7KwthfZGFWEgD5sXHr4or5b735D Uxg6faraVlnsZLNGnj5cUCsIhbpumm3fvrJM4gOUdGRkIJbpMS+/1ZB+WV1B8nWKugnMw4ar13c O4mW7KNVDiP6RrqZuJw3WS/43dBA== X-Google-Smtp-Source: AGHT+IHdJsZQTpHH+0Tna1F+aj7xk//zA+X3VQ1speXFAf20E9rTiHF08Vlk6JJa66b872OCEaWJ716VmaiiTsRR9Iw= X-Received: by 2002:a05:6830:3903:b0:727:4356:9f07 with SMTP id 46e09a7af769-72c0ae78b8cmr5181693a34.14.1742657528408; Sat, 22 Mar 2025 08:32:08 -0700 (PDT) MIME-Version: 1.0 From: Senthilnathan M Date: Sat, 22 Mar 2025 21:01:57 +0530 X-Gm-Features: AQ5f1JqC4EDHWOpiban1-8K0ovEQRGgTd0hJY0PWUazdCaE3om46c3J_iSYHT-w Message-ID: Subject: Getting all the plans. To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000f22f7f0630f01201" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f22f7f0630f01201 Content-Type: text/plain; charset="UTF-8" Hi all, I came across this extension which shows all the plans considered by the optimizer: https://github.com/misachi/pg_all_plans Is there a way we can get this information directly instead of using an extension? If not, does it make sense to add native support? Please feel free to redirect me if this is not the right mailing list for this topic. Thanks, Senthil --000000000000f22f7f0630f01201 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi all,
=C2=A0 I came across this extension which show= s all the plans considered by the optimizer:=C2=A0https://github.com/misachi/pg_all_plans
<= br>
=C2=A0 Is there a way we can get this information directly in= stead of using an extension?=C2=A0 If not, does it make sense to add native= support?

=C2=A0 Please feel free to redirect me i= f this is not the right mailing list for this topic.

Thanks,
Senthil
--000000000000f22f7f0630f01201--