Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT

From: Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com>
To: Gunnlaugur Thor Briem <gunnlaugur(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
Date: 2015-03-05 16:25:08
Message-ID: CAB=Je-Hetut=v94TORmJnzZGCSxwsfaxiSmDudFejxbZD0jjOQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>What could cause this? Note that there is no ANALYZE.

Can you capture pstack and/or perf report while explain hangs?
I think it should shed light on the activity of PostgreSQL.

Vladimir

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Marc Mamin 2015-03-05 21:13:47 Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
Previous Message Gunnlaugur Thor Briem 2015-03-05 15:01:58 Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT