unexpected external sort Disk
От | Manuel Kniep |
---|---|
Тема | unexpected external sort Disk |
Дата | |
Msg-id | BB5FFDDA-4AF3-428D-A5CE-29F869DCB1A9@adeven.com обсуждение исходный текст |
Ответы |
Re: unexpected external sort Disk
|
Список | pgsql-general |
Hello, I have table with 37 million entries the whole table has a size of 2.3 GB Although I have set the work_mem to 10 GB I see the an unexpected external sort Disk in Explain Analyze for around 650MB of data EXPLAIN ANALYZE SELECT application_id, price_tier FROM application_prices order by application_id, created_at; QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------- Sort (cost=5284625.89..5378196.50 rows=37428244 width=8) (actual time=36972.658..40618.161 rows=37428244 loops=1) Sort Key: application_id, created_at Sort Method: external sort Disk: 658568kB -> Seq Scan on application_prices (cost=0.00..576597.44 rows=37428244 width=8) (actual time=0.012..6259.923 rows=37428244loops=1) Total runtime: 42999.882 ms (5 rows) Has anyone an idea what I'm missing ? Thanks Manuel
В списке pgsql-general по дате отправления: