explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uQkr

Settings
# exclusive inclusive rows x rows loops node
1. 0.447 59.053 ↑ 647.9 79 1

Merge Left Join (cost=492,973.77..493,244.24 rows=51,181 width=1,133) (actual time=58.991..59.053 rows=79 loops=1)

  • Merge Cond: (networkobj1_.id = natinfo7_.netobj_id)
2. 0.120 54.559 ↑ 647.9 79 1

Sort (cost=492,689.08..492,817.04 rows=51,181 width=748) (actual time=54.549..54.559 rows=79 loops=1)

  • Sort Key: members0_.member_id
  • Sort Method: quicksort Memory: 46kB
3. 0.079 54.439 ↑ 647.9 79 1

Hash Left Join (cost=1,792.75..488,685.88 rows=51,181 width=748) (actual time=46.295..54.439 rows=79 loops=1)

  • Hash Cond: (networkobj1_.reference_id = reference9_.id)
4. 0.048 54.359 ↑ 647.9 79 1

Hash Left Join (cost=1,772.40..488,473.59 rows=51,181 width=604) (actual time=46.269..54.359 rows=79 loops=1)

  • Hash Cond: (policyzone4_.admin_domain_id = admindomai6_.id)
5. 0.070 54.310 ↑ 647.9 79 1

Hash Left Join (cost=1,745.07..488,254.33 rows=51,181 width=528) (actual time=46.258..54.310 rows=79 loops=1)

  • Hash Cond: (policyzone4_.address_book_id = addressboo5_.id)
6. 0.094 54.238 ↑ 647.9 79 1

Hash Left Join (cost=1,710.32..488,027.64 rows=51,181 width=484) (actual time=46.229..54.238 rows=79 loops=1)

  • Hash Cond: (networkobj1_.zone_id = policyzone4_.id)
7. 0.055 12.098 ↑ 647.9 79 1

Hash Left Join (cost=50.91..485,856.41 rows=51,181 width=404) (actual time=4.153..12.098 rows=79 loops=1)

  • Hash Cond: (networkobj1_.customer_id = domain3_.id)
8. 0.065 11.780 ↑ 647.9 79 1

Hash Left Join (cost=35.92..485,556.60 rows=51,181 width=365) (actual time=3.879..11.780 rows=79 loops=1)

  • Hash Cond: (networkobj1_.address_book_id = addressboo2_.id)
9. 4.208 11.713 ↑ 647.9 79 1

Nested Loop (cost=1.18..485,329.91 rows=51,181 width=321) (actual time=3.860..11.713 rows=79 loops=1)

  • -> Index Only Scan using unique_group_member on nst_netobj_groups members0_ (cost=0.60..49473.31 rows=51181 width=16) (actual time=3.799..4.062 rows=79 lo
  • Index Cond: (group_id = ANY ('{10531416702,10531417063,10531417071,10531417081,10531417281,10531417283,10531417285,10531417469,10531417471,10531417473
  • Heap Fetches: 79
10. 7.505 7.505 ↑ 1.0 1 79

Index Scan using nst_netobjs_pkey on nst_netobjs networkobj1_ (cost=0.57..8.51 rows=1 width=305) (actual time=0.095..0.095 rows=1 loops=79)

  • Index Cond: (id = members0_.member_id)
11. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=21.00..21.00 rows=1,100 width=44) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
12. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on nst_address_books addressboo2_ (cost=0.00..21.00 rows=1,100 width=44) (actual time=0.001..0.001 rows=0 loops=1)

13. 0.128 0.263 ↓ 1.0 461 1

Hash (cost=9.44..9.44 rows=444 width=39) (actual time=0.263..0.263 rows=461 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 32kB
14. 0.135 0.135 ↓ 1.0 461 1

Seq Scan on customers domain3_ (cost=0.00..9.44 rows=444 width=39) (actual time=0.008..0.135 rows=461 loops=1)

15. 13.452 42.046 ↓ 1.0 49,591 1

Hash (cost=1,058.07..1,058.07 rows=48,107 width=80) (actual time=42.046..42.046 rows=49,591 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 3599kB
16. 28.594 28.594 ↓ 1.0 49,591 1

Seq Scan on nst_zones policyzone4_ (cost=0.00..1,058.07 rows=48,107 width=80) (actual time=0.007..28.594 rows=49,591 loops=1)

17. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=21.00..21.00 rows=1,100 width=44) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
18. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on nst_address_books addressboo5_ (cost=0.00..21.00 rows=1,100 width=44) (actual time=0.001..0.001 rows=0 loops=1)

19. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=17.70..17.70 rows=770 width=76) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
20. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on nst_admin_domains admindomai6_ (cost=0.00..17.70 rows=770 width=76) (actual time=0.001..0.001 rows=0 loops=1)

21. 0.001 0.001 ↓ 0.0 0 1

Hash (cost=14.60..14.60 rows=460 width=144) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
22. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on nst_references reference9_ (cost=0.00..14.60 rows=460 width=144) (actual time=0.000..0.000 rows=0 loops=1)

23. 1.596 4.047 ↓ 1.0 3,049 1

Sort (cost=284.48..291.86 rows=2,953 width=385) (actual time=3.759..4.047 rows=3,049 loops=1)

  • Sort Key: natinfo7_.netobj_id
  • Sort Method: quicksort Memory: 541kB
24. 0.875 2.451 ↓ 1.1 3,163 1

Hash Right Join (cost=97.44..114.27 rows=2,953 width=385) (actual time=1.589..2.451 rows=3,163 loops=1)

  • Hash Cond: (fortigatev8_.nat_info_id = natinfo7_.id)
25. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on nst_nat_info_fortigate_vip fortigatev8_ (cost=0.00..12.60 rows=260 width=276) (actual time=0.001..0.001 rows=0 loops=1)

26. 0.783 1.575 ↓ 1.1 3,163 1

Hash (cost=60.53..60.53 rows=2,953 width=109) (actual time=1.575..1.575 rows=3,163 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 241kB
27. 0.792 0.792 ↓ 1.1 3,163 1

Seq Scan on nst_nat_info natinfo7_ (cost=0.00..60.53 rows=2,953 width=109) (actual time=0.011..0.792 rows=3,163 loops=1)