explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2nzf

Settings
# exclusive inclusive rows x rows loops node
1. 149.468 646.823 ↑ 1.0 716 1

GroupAggregate (cost=773.61..69,550.91 rows=716 width=62) (actual time=7.206..646.823 rows=716 loops=1)

  • Group Key: asset_location.id
2. 40.238 497.355 ↑ 2.6 296,387 1

Nested Loop Left Join (cost=773.61..59,980.80 rows=765,036 width=89) (actual time=7.176..497.355 rows=296,387 loops=1)

3. 1.699 10.241 ↓ 1.0 4,754 1

Merge Left Join (cost=773.18..842.69 rows=4,658 width=89) (actual time=7.172..10.241 rows=4,754 loops=1)

  • Merge Cond: (asset_location.id = asset_asset.location_id)
4. 0.416 1.013 ↑ 1.0 716 1

Sort (cost=84.49..86.28 rows=716 width=43) (actual time=0.806..1.013 rows=716 loops=1)

  • Sort Key: asset_location.id
  • Sort Method: quicksort Memory: 64kB
5. 0.119 0.597 ↑ 1.0 716 1

Hash Right Join (cost=26.11..50.54 rows=716 width=43) (actual time=0.371..0.597 rows=716 loops=1)

  • Hash Cond: (person_person.location_id = asset_location.id)
6. 0.162 0.162 ↑ 1.0 685 1

Seq Scan on person_person (cost=0.00..21.85 rows=685 width=9) (actual time=0.008..0.162 rows=685 loops=1)

7. 0.154 0.316 ↑ 1.0 716 1

Hash (cost=17.16..17.16 rows=716 width=38) (actual time=0.316..0.316 rows=716 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 43kB
8. 0.162 0.162 ↑ 1.0 716 1

Seq Scan on asset_location (cost=0.00..17.16 rows=716 width=38) (actual time=0.005..0.162 rows=716 loops=1)

9. 2.424 7.529 ↑ 1.1 4,396 1

Sort (cost=688.69..700.34 rows=4,658 width=50) (actual time=6.363..7.529 rows=4,396 loops=1)

  • Sort Key: asset_asset.location_id
  • Sort Method: quicksort Memory: 467kB
10. 1.039 5.105 ↑ 1.0 4,658 1

Hash Left Join (cost=97.07..404.89 rows=4,658 width=50) (actual time=1.042..5.105 rows=4,658 loops=1)

  • Hash Cond: (asset_asset.id = operating_system_osinfo.asset_id)
11. 1.037 3.083 ↑ 1.0 4,658 1

Hash Left Join (cost=12.93..284.55 rows=4,658 width=46) (actual time=0.045..3.083 rows=4,658 loops=1)

  • Hash Cond: (asset_asset.status_id = asset_assetstatus.id)
12. 2.035 2.035 ↑ 1.0 4,658 1

Seq Scan on asset_asset (cost=0.00..207.58 rows=4,658 width=12) (actual time=0.022..2.035 rows=4,658 loops=1)

13. 0.003 0.011 ↑ 21.7 6 1

Hash (cost=11.30..11.30 rows=130 width=42) (actual time=0.011..0.011 rows=6 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 0.008 0.008 ↑ 21.7 6 1

Seq Scan on asset_assetstatus (cost=0.00..11.30 rows=130 width=42) (actual time=0.007..0.008 rows=6 loops=1)

15. 0.281 0.983 ↑ 1.0 1,873 1

Hash (cost=60.73..60.73 rows=1,873 width=8) (actual time=0.983..0.983 rows=1,873 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 90kB
16. 0.702 0.702 ↑ 1.0 1,873 1

Seq Scan on operating_system_osinfo (cost=0.00..60.73 rows=1,873 width=8) (actual time=0.005..0.702 rows=1,873 loops=1)

17. 446.876 446.876 ↑ 2.7 62 4,754

Index Scan using operating_system_installedprogram_os_info_id_049227e4 on operating_system_installedprogram (cost=0.42..11.01 rows=169 width=8) (actual time=0.023..0.094 rows=62 loops=4,754)

  • Index Cond: (operating_system_osinfo.id = os_info_id)
Planning time : 3.106 ms
Execution time : 647.066 ms