explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kpHq

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 5,730.134 ↑ 1.0 25 1

Limit (cost=1,914,831.13..1,914,832.82 rows=25 width=790) (actual time=5,730.113..5,730.134 rows=25 loops=1)

2. 0.012 5,730.132 ↑ 117,499.7 25 1

Unique (cost=1,914,831.13..2,113,111.84 rows=2,937,492 width=790) (actual time=5,730.112..5,730.132 rows=25 loops=1)

3. 1,753.582 5,730.120 ↑ 117,499.7 25 1

Sort (cost=1,914,831.13..1,922,174.86 rows=2,937,492 width=790) (actual time=5,730.112..5,730.120 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, omaha_apprequest.tag, omaha_apprequest.installage, omaha_request.os_id, omaha_request.hw_id, omaha_request.version, omaha_request.ismachine, omaha_request.sessionid, omaha_request.userid, omaha_request.installsource, omaha_request.originurl, omaha_request.testsource, omaha_request.updaterchannel, omaha_request.ip, omaha_os.id, omaha_os.platform, omaha_os.version, omaha_os.sp, omaha_os.arch
  • Sort Method: quicksort Memory: 1463244kB
4. 546.360 3,976.538 ↓ 1.0 2,937,904 1

Hash Left Join (cost=224,917.18..575,147.11 rows=2,937,492 width=790) (actual time=1,401.036..3,976.538 rows=2,937,904 loops=1)

  • Hash Cond: (omaha_request.os_id = omaha_os.id)
5. 1,719.685 3,430.090 ↓ 1.0 2,937,904 1

Hash Join (cost=224,904.34..534,743.75 rows=2,937,492 width=749) (actual time=1,400.922..3,430.090 rows=2,937,904 loops=1)

  • Hash Cond: (omaha_request.id = omaha_apprequest.request_id)
6. 320.505 320.505 ↑ 1.0 2,947,415 1

Seq Scan on omaha_request (cost=0.00..262,043.15 rows=2,947,415 width=674) (actual time=0.002..320.505 rows=2,947,415 loops=1)

7. 797.599 1,389.900 ↓ 1.0 2,937,904 1

Hash (cost=188,185.69..188,185.69 rows=2,937,492 width=75) (actual time=1,389.900..1,389.900 rows=2,937,904 loops=1)

  • Buckets: 4194304 Batches: 1 Memory Usage: 328313kB
8. 592.301 592.301 ↓ 1.0 2,937,904 1

Seq Scan on omaha_apprequest (cost=0.00..188,185.69 rows=2,937,492 width=75) (actual time=0.013..592.301 rows=2,937,904 loops=1)

  • Filter: ((appid)::text = '{98DA7DF2-4E3E-4744-9DE6-EC931886ABAB}'::text)
  • Rows Removed by Filter: 9511
9. 0.038 0.088 ↑ 1.0 393 1

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

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

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