explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r5Ud

Settings
# exclusive inclusive rows x rows loops node
1. 9.158 380.558 ↑ 1.0 25 1

Unique (cost=2,058.57..2,060.47 rows=25 width=2) (actual time=362.762..380.558 rows=25 loops=1)

2. 18.934 371.400 ↓ 6.5 2,465 1

Sort (cost=2,058.57..2,059.52 rows=381 width=2) (actual time=362.754..371.400 rows=2,465 loops=1)

  • Sort Key: x.""RegionId"
  • Sort Method: quicksort Memory: 212kB
3. 30.933 352.466 ↓ 6.5 2,465 1

Nested Loop (cost=1,123.21..2,042.23 rows=381 width=2) (actual time=196.614..352.466 rows=2,465 loops=1)

4. 19.687 304.278 ↓ 6.5 2,465 1

Hash Join (cost=1,122.79..1,397.11 rows=381 width=14) (actual time=196.582..304.278 rows=2,465 loops=1)

  • Hash Cond: (x.""Id"" = a0.""Address_Id"")
5. 48.658 205.284 ↓ 1.4 2,555 1

Hash Join (cost=685.86..949.32 rows=1,880 width=10) (actual time=117.263..205.284 rows=2,555 loops=1)

  • Hash Cond: (x.""Id"" = a.""Address_Id"")
6. 39.396 39.396 ↓ 1.0 9,728 1

Seq Scan on ""AddressH24"" x (cost=0.00..208.50 rows=9,642 width=6) (actual time=0.018..39.396 rows=9,728 loops=1)

  • Filter: (""RegionId"" IS NOT NULL)
  • Rows Removed by Filter: 3,622
7. 10.532 117.230 ↓ 1.1 2,800 1

Hash (cost=653.32..653.32 rows=2,603 width=4) (actual time=117.226..117.230 rows=2,800 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 131kB
8. 23.489 106.698 ↓ 1.1 2,800 1

HashAggregate (cost=627.29..653.32 rows=2,603 width=4) (actual time=95.410..106.698 rows=2,800 loops=1)

  • Group Key: a.""Address_Id"
9. 20.994 83.209 ↓ 1.1 2,800 1

Hash Join (cost=563.06..620.78 rows=2,603 width=4) (actual time=30.615..83.209 rows=2,800 loops=1)

  • Hash Cond: (""a.Division"".""LegalEntityId"" = l.""Id"")
10. 21.619 50.903 ↑ 1.0 2,865 1

Hash Join (cost=320.85..371.03 rows=2,865 width=8) (actual time=19.278..50.903 rows=2,865 loops=1)

  • Hash Cond: (a.""Division_Id"" = ""a.Division"".""Id"")
11. 10.034 10.034 ↑ 1.0 2,865 1

Seq Scan on ""DivisionAddresses"" a (cost=0.00..42.65 rows=2,865 width=8) (actual time=0.011..10.034 rows=2,865 loops=1)

12. 9.329 19.250 ↑ 1.0 2,571 1

Hash (cost=288.71..288.71 rows=2,571 width=8) (actual time=19.247..19.250 rows=2,571 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 133kB
13. 9.921 9.921 ↑ 1.0 2,571 1

Seq Scan on ""Divisions"" ""a.Division"" (cost=0.00..288.71 rows=2,571 width=8) (actual time=0.007..9.921 rows=2,571 loops=1)

14. 5.141 11.312 ↑ 1.0 1,413 1

Hash (cost=224.55..224.55 rows=1,413 width=4) (actual time=11.309..11.312 rows=1,413 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 66kB
15. 6.171 6.171 ↑ 1.0 1,413 1

Seq Scan on ""LegalEntities"" l (cost=0.00..224.55 rows=1,413 width=4) (actual time=0.009..6.171 rows=1,413 loops=1)

  • Filter: ((NOT ""IsDeleted"") AND ""IsOnPortal"")
  • Rows Removed by Filter: 142
16. 9.769 79.307 ↓ 1.0 2,714 1

Hash (cost=403.09..403.09 rows=2,707 width=4) (actual time=79.304..79.307 rows=2,714 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 128kB
17. 20.437 69.538 ↓ 1.0 2,714 1

HashAggregate (cost=376.02..403.09 rows=2,707 width=4) (actual time=59.539..69.538 rows=2,714 loops=1)

  • Group Key: a0.""Address_Id"
18. 20.589 49.101 ↓ 1.0 2,714 1

Hash Join (cost=319.07..369.25 rows=2,707 width=4) (actual time=18.519..49.101 rows=2,714 loops=1)

  • Hash Cond: (a0.""Division_Id"" = ""a.Division0"".""Id"")
19. 10.028 10.028 ↑ 1.0 2,865 1

Seq Scan on ""DivisionAddresses"" a0 (cost=0.00..42.65 rows=2,865 width=8) (actual time=0.009..10.028 rows=2,865 loops=1)

20. 8.947 18.484 ↑ 1.0 2,420 1

Hash (cost=288.71..288.71 rows=2,429 width=4) (actual time=18.481..18.484 rows=2,420 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 118kB
21. 9.537 9.537 ↑ 1.0 2,420 1

Seq Scan on ""Divisions"" ""a.Division0"" (cost=0.00..288.71 rows=2,429 width=4) (actual time=0.008..9.537 rows=2,420 loops=1)

  • Filter: ""IsOnPortal"
  • Rows Removed by Filter: 151
22. 17.255 17.255 ↑ 1.0 1 2,465

Index Only Scan using ""PK_dbo.Addresses"" on ""Addresses"" ""x.Address"" (cost=0.42..1.69 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=2,465)

  • Index Cond: (""Id"" = x.""Id"")
  • Heap Fetches: 2,465
Planning time : 1.037 ms
Execution time : 380.871 ms