X-Received: by 2002:a05:622a:309:b0:2dd:53e9:ae80 with SMTP id q9-20020a05622a030900b002dd53e9ae80mr4613713qtw.557.1646929883735; Thu, 10 Mar 2022 08:31:23 -0800 (PST)
X-Received: by 2002:a81:49d5:0:b0:2dc:5709:4d91 with SMTP id w204-20020a8149d5000000b002dc57094d91mr4717724ywa.231.1646929883338; Thu, 10 Mar 2022 08:31:23 -0800 (PST)
Path: csiph.com!1.us.feeder.erje.net!3.us.feeder.erje.net!feeder.erje.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.postgresql
Date: Thu, 10 Mar 2022 08:31:23 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=2600:8801:d502:9200:246e:cc61:28bf:17b4; posting-account=MD_47woAAABULmOe11ZqdjPGw6zni88O
NNTP-Posting-Host: 2600:8801:d502:9200:246e:cc61:28bf:17b4
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <1add5218-f1fa-4e34-a5ee-a399c19c6c1bn@googlegroups.com>
Subject: Get explain plan while query running
From: Rich Ford <richford990@gmail.com>
Injection-Date: Thu, 10 Mar 2022 16:31:23 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 6
Xref: csiph.com comp.databases.postgresql:904

Is there a way to get the explain plan for a running query as opposed to having to wait for the query to complete which is the case when using EXPLAIN.

I know in Oracle there is DBMS_XPLAN and wondering if something similar in PostgreSQL. We have looked at auto_explain but this requires a cluster reboot and this is production and we have no downtime.

This is Aurora PostgreSQL 12.6.

Rich