Re: Query too slow

Поиск
Список
Период
Сортировка
От Ang Chin Han
Тема Re: Query too slow
Дата
Msg-id 3F4B02ED.4080704@bytecraft.com.my
обсуждение исходный текст
Ответ на Re: Query too slow  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Ответы Re: Query too slow  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-performance
Stephan Szabo wrote:

> Looking at the explain:

Veering aside a bit, since we usually pinpoint performance problems by
looking at EXPLAIN ANALYZE's differences between the planner's
estimation and actual execution's stats, what's involved in parsing the
EXPLAIN ANALYZE results, and highlighting the places where they are way
different? Bold, underline, or put some asterisks in front of those steps.

Makes looking at big EXPLAIN ANALYZE trees much easier.

--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
   2:30pm  up 243 days,  5:48,  8 users,  load average: 5.52, 5.29, 5.10

Вложения

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

Предыдущее
От: "Magnus Naeslund(f)"
Дата:
Сообщение: Re: What is the fastest way to get a resultset
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Query too slow