[PATCH] Make skipped sort explicit in EXPLAIN ANALYZE

Поиск
Список
Период
Сортировка
От Marti Raudsepp
Тема [PATCH] Make skipped sort explicit in EXPLAIN ANALYZE
Дата
Msg-id CABRT9RCaWa1mOj+7BjP_EMtLg86OX0oLtzJBZAHJvu5N6Ymo3Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: [PATCH] Make skipped sort explicit in EXPLAIN ANALYZE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

This is just a small clarity improvement. tuplesort_performsort()
skips sorting entirely when the result set has 0 or 1 tuples, but
EXPLAIN still says it's using "quicksort". The patch changes that to
"skipped"

For example:

db=# explain analyze select * from now() order by 1;
 Sort  (cost=0.02..0.03 rows=1 width=8) (actual time=0.126..0.126
rows=1 loops=1)
   Sort Key: now
   Sort Method: skipped  Memory: 25kB
   ->  Function Scan on now  (cost=0.00..0.01 rows=1 width=8) (actual
time=0.032..0.033 rows=1 loops=1)

Patch attached.

Regards,
Marti

Вложения

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

Предыдущее
От: Sergey Koposov
Дата:
Сообщение: Re: 9.2beta1, parallel queries, ReleasePredicateLocks, CheckForSerializableConflictIn in the oprofile
Следующее
От: Tom Lane
Дата:
Сообщение: Re: proclock table corrupted