Variation between query runtimes

Поиск
Список
Период
Сортировка
От John Top-k apad
Тема Variation between query runtimes
Дата
Msg-id 5809b390606102335j41f734d8j@mail.gmail.com
обсуждение исходный текст
Список pgsql-performance
Hi,

I have the following quering plans:

"Seq Scan on ind_uni_100 (cost=0.00..27242.00 rows=1000000 width=104) (actual time=0.272..2444.667 rows=1000000 loops=1)"
"Total runtime: 4229.449 ms"

and

"Bitmap Heap Scan on ind_uni_100  (cost=314.00..18181.00 rows=50000 width=104) (actual time=74.106..585.368 rows=49758 loops=1)"
"  Recheck Cond: (b = 1)"
"  ->  Bitmap Index Scan on index_b_ind_uni_100  (cost= 0.00..314.00 rows=50000 width=0) (actual time=61.814..61.814 rows=49758 loops=1)"
"        Index Cond: (b = 1)"
"Total runtime: 638.787 ms"

from pg_stast_get_blocks_fetched i can see that both queries need almost the same number of disk fetches which is quite reasonable ( the index is unclustered).

But as you can see there is a great variation between query runtimes.Can someone explain this differnce?

Thanks!

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

Предыдущее
От: "Jim Nasby"
Дата:
Сообщение: FW: pg_xlog on data partition with BBU RAID
Следующее
От: "Craig A. James"
Дата:
Сообщение: function not called if part of aggregate