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

Поиск
Список
Период
Сортировка
От Vladimir Sitnikov
Тема Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT
Дата
Msg-id CAB=Je-Hetut=v94TORmJnzZGCSxwsfaxiSmDudFejxbZD0jjOQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: EXPLAIN (no ANALYZE) taking an hour for INSERT FROM SELECT  (Gunnlaugur Thor Briem <gunnlaugur@gmail.com>)
Список 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

В списке pgsql-performance по дате отправления: