explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 34R

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 8,655.029 ↑ 1.0 25 1

Limit (cost=106,132.32..106,134.01 rows=25 width=1,244) (actual time=8,655.010..8,655.029 rows=25 loops=1)

2. 0.015 8,655.026 ↑ 589.5 25 1

Unique (cost=106,132.32..107,127.07 rows=14,737 width=1,244) (actual time=8,655.008..8,655.026 rows=25 loops=1)

3. 1,826.845 8,655.011 ↑ 589.5 25 1

Sort (cost=106,132.32..106,169.17 rows=14,737 width=1,244) (actual time=8,655.006..8,655.011 rows=25 loops=1)

  • Sort Key: omaha_request.created DESC, omaha_apprequest.id, omaha_apprequest.request_id, omaha_apprequest.version, omaha_apprequest.nextversion, omaha_apprequest.lang COLLATE "C", omaha_apprequest.tag COLLATE "C", omaha_apprequest.installage, omaha_request.os_id, omaha_request.hw_id, omaha_request.version, omaha_request.ismachine, omaha_request.sessionid COLLATE "C", omaha_request.userid COLLATE "C", omaha_request.installsource COLLATE "C", omaha_request.originurl COLLATE "C", omaha_request.testsource COLLATE "C", omaha_request.updaterchannel COLLATE "C", omaha_request.ip, omaha_os.id, omaha_os.platform, omaha_os.version, omaha_os.sp, omaha_os.arch
  • Sort Method: quicksort Memory: 1463244kB
4. 611.127 6,828.166 ↓ 199.4 2,937,904 1

Hash Left Join (cost=556.16..105,112.00 rows=14,737 width=1,244) (actual time=242.271..6,828.166 rows=2,937,904 loops=1)

  • Hash Cond: (omaha_request.os_id = omaha_os.id)
5. 0.000 6,216.979 ↓ 199.4 2,937,904 1

Nested Loop (cost=543.32..104,896.52 rows=14,737 width=1,203) (actual time=242.199..6,216.979 rows=2,937,904 loops=1)

6. 528.900 735.405 ↓ 199.4 2,937,904 1

Bitmap Heap Scan on omaha_apprequest (cost=542.77..44,092.22 rows=14,737 width=316) (actual time=242.164..735.405 rows=2,937,904 loops=1)

  • Recheck Cond: ((appid)::text = '{98DA7DF2-4E3E-4744-9DE6-EC931886ABAB}'::text)
  • Heap Blocks: exact=151300
7. 206.505 206.505 ↓ 199.4 2,937,904 1

Bitmap Index Scan on omaha_apprequest_7aa64062 (cost=0.00..539.08 rows=14,737 width=0) (actual time=206.505..206.505 rows=2,937,904 loops=1)

  • Index Cond: ((appid)::text = '{98DA7DF2-4E3E-4744-9DE6-EC931886ABAB}'::text)
8. 5,875.808 5,875.808 ↑ 1.0 1 2,937,904

Index Only Scan using omaha_request_version_4 on omaha_request (cost=0.56..4.12 rows=1 width=887) (actual time=0.001..0.002 rows=1 loops=2,937,904)

  • Index Cond: (id = omaha_apprequest.request_id)
  • Heap Fetches: 0
9. 0.029 0.060 ↑ 1.0 393 1

Hash (cost=7.93..7.93 rows=393 width=41) (actual time=0.060..0.060 rows=393 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
10. 0.031 0.031 ↑ 1.0 393 1

Seq Scan on omaha_os (cost=0.00..7.93 rows=393 width=41) (actual time=0.005..0.031 rows=393 loops=1)