Starfish Storage has released explain-running-query.py which is a script
that prints the execution plan of a running query in PostgreSQL.
It comes in handy when PostgreSQL gets stuck running a query. Without the
script, the best one can do is run EXPLAIN with the same query text. Still,
the plan doesn't have to be the same as the original, because PostgreSQL
relies heavily on table statistics when planning a query and those might
have changed since the original query started.
The script is available at
https://github.com/StarfishStorage/explain-running-query
--
Marcin Barczyński
Starfish Storage: http://starfishstorage.com/