From: | Manuel Kniep <rapimo(at)adeven(dot)com> |
---|---|
To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | unexpected external sort Disk |
Date: | 2013-06-20 13:12:46 |
Message-ID: | BB5FFDDA-4AF3-428D-A5CE-29F869DCB1A9@adeven.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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=37428244 loops=1)
Total runtime: 42999.882 ms
(5 rows)
Has anyone an idea what I'm missing ?
Thanks
Manuel
From | Date | Subject | |
---|---|---|---|
Next Message | Antonio Goméz Soto | 2013-06-20 13:47:08 | Do not understand high estimates of index scan vs seq scan |
Previous Message | David Johnston | 2013-06-20 13:06:30 | Re: Exporting Data |