Postgres Pro
Downloads
Home   >   mailing lists

Query plan for currently executing query? - Mailing list pgsql-general

From François Beausoleil
Subject Query plan for currently executing query?
Date
Msg-id 6EAD594C-0FF9-49F3-9C5F-5960213940EA@teksol.info
Whole thread Raw
Responses Re: Query plan for currently executing query?  (Rowan Collins <rowan.collins@gmail.com>)
List pgsql-general
Tree view 
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
Attachment

pgsql-general by date:

Previous
From: Agustin Larreinegabe
Date:
Subject: Re: remove everything before the period
Next
From: "Gabriel E. Sánchez Martínez"
Date:
Subject: nested partitioning