Query plan for currently executing query?

From: François Beausoleil <francois(at)teksol(dot)info>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Query plan for currently executing query?
Date: 2013-09-18 12:05:06
Message-ID: 6EAD594C-0FF9-49F3-9C5F-5960213940EA@teksol.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

Is it possible to get the plan of a query that's currently running? I have queries which normally take about 15 minutes, but are now at 2+ hours. I forgot to add the code to dump the plan to STDOUT, so I really don't know.

It might be data volume, but I want to confirm that the plan isn't bogus.

I'm doing batch imports of data on "PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit".

Thanks,
François Beausoleil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gabriel E. Sánchez Martínez 2013-09-18 12:45:05 nested partitioning
Previous Message Agustin Larreinegabe 2013-09-18 11:21:41 Re: remove everything before the period