Groups > comp.databases.postgresql > #904

Get explain plan while query running

Newsgroups	comp.databases.postgresql
Date	2022-03-10 08:31 -0800
Message-ID	<1add5218-f1fa-4e34-a5ee-a399c19c6c1bn@googlegroups.com> (permalink)
Subject	Get explain plan while query running
From	Rich Ford <richford990@gmail.com>

Show all headers | View raw

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

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar

Thread

Get explain plan while query running Rich Ford <richford990@gmail.com> - 2022-03-10 08:31 -0800
  Re: Get explain plan while query running George Neuner <gneuner2@comcast.net> - 2022-03-11 10:04 -0500

csiph-web