explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3jit

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 5,846.130 ↑ 1.0 25 1

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

2. 0.017 5,846.127 ↑ 117,499.7 25 1

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

3. 1,809.672 5,846.110 ↑ 117,499.7 25 1

Sort (cost=1,914,831.13..1,922,174.86 rows=2,937,492 width=790) (actual time=5,846.109..5,846.110 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. 561.411 4,036.438 ↓ 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,447.324..4,036.438 rows=2,937,904 loops=1)

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

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

  • Hash Cond: (omaha_request.id = omaha_apprequest.request_id)
6. 317.512 317.512 ↑ 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.007..317.512 rows=2,947,415 loops=1)

7. 797.065 1,413.502 ↓ 1.0 2,937,904 1

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

  • Buckets: 4194304 Batches: 1 Memory Usage: 328313kB
8. 616.437 616.437 ↓ 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.015..616.437 rows=2,937,904 loops=1)

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

Hash (cost=7.93..7.93 rows=393 width=41) (actual time=0.063..0.063 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.003..0.031 rows=393 loops=1)