Re: slow query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: slow query
Дата
Msg-id 2050.1045880439@sss.pgh.pa.us
обсуждение
Ответ на slow query  (Oleg Lebedev <oleg.lebedev@waterford.org>)
Список pgsql-performance
Oleg Lebedev <oleg.lebedev@waterford.org> writes:
> Interestingly the planner statistics for this query are the same on the
> master and replica databases.
> However, query execution on the master database is about 4min. and on
> the replica database is 6 sec.!

What does EXPLAIN ANALYZE show in each case?

            regards, tom lane

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