unexpected external sort Disk

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

Responses

Browse pgsql-general by date

  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