explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kxJW

Settings
# exclusive inclusive rows x rows loops node
1. 10.454 114.707 ↓ 39.0 974 1

Nested Loop Left Join (cost=1,159.17..1,221.38 rows=25 width=28) (actual time=59.516..114.707 rows=974 loops=1)

2. 11.258 98.409 ↓ 39.0 974 1

Nested Loop (cost=1,158.88..1,197.26 rows=25 width=12) (actual time=59.496..98.409 rows=974 loops=1)

3. 11.674 81.259 ↓ 36.4 982 1

Nested Loop (cost=1,158.60..1,179.70 rows=27 width=16) (actual time=59.470..81.259 rows=982 loops=1)

4. 10.342 63.315 ↓ 36.0 1,045 1

HashAggregate (cost=1,158.32..1,158.61 rows=29 width=4) (actual time=59.446..63.315 rows=1,045 loops=1)

  • Group Key: x.""Division_Id"
5. 11.641 52.973 ↓ 36.1 1,047 1

Nested Loop (cost=133.75..1,158.25 rows=29 width=4) (actual time=9.784..52.973 rows=1,047 loops=1)

6. 14.387 34.003 ↓ 3.8 1,047 1

Hash Join (cost=133.34..183.51 rows=276 width=12) (actual time=9.745..34.003 rows=1,047 loops=1)

  • Hash Cond: (x.""Address_Id"" = ""x.Address.AddressH24"".""Id"")
7. 9.915 9.915 ↑ 1.0 2,865 1

Seq Scan on ""DivisionAddresses"" x (cost=0.00..42.65 rows=2,865 width=8) (actual time=0.008..9.915 rows=2,865 loops=1)

8. 4.700 9.701 ↑ 1.0 1,262 1

Hash (cost=117.29..117.29 rows=1,284 width=4) (actual time=9.697..9.701 rows=1,262 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 61kB
9. 4.955 5.001 ↑ 1.0 1,262 1

Bitmap Heap Scan on ""AddressH24"" ""x.Address.AddressH24"" (cost=26.24..117.29 rows=1,284 width=4) (actual time=0.065..5.001 rows=1,262 loops=1)

  • Recheck Cond: (""SettlementId"" = 29219)
  • Filter: (""Id"" IS NOT NULL)
  • Heap Blocks: exact=46
10. 0.046 0.046 ↑ 1.0 1,262 1

Bitmap Index Scan on ""AddressH24_IX_SettlementId"" (cost=0.00..25.91 rows=1,284 width=0) (actual time=0.043..0.046 rows=1,262 loops=1)

  • Index Cond: (""SettlementId"" = 29219)
11. 7.329 7.329 ↑ 1.0 1 1,047

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

  • Index Cond: (""Id"" = x.""Address_Id"")
  • Heap Fetches: 1047
12. 6.270 6.270 ↑ 1.0 1 1,045

Index Scan using ""PK_dbo.Divisions"" on ""Divisions"" d (cost=0.28..0.73 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=1,045)

  • Index Cond: (""Id"" = x.""Division_Id"")
  • Filter: ""IsOnPortal"
  • Rows Removed by Filter: 0
13. 5.892 5.892 ↑ 1.0 1 982

Index Scan using ""PK_dbo.LegalEntities"" on ""LegalEntities"" l (cost=0.28..0.65 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=982)

  • Index Cond: (""Id"" = d.""LegalEntityId"")
  • Filter: ((NOT ""IsDeleted"") AND ""IsOnPortal"")
  • Rows Removed by Filter: 0
14. 5.844 5.844 ↑ 1.0 1 974

Index Scan using ""PK_dbo.Locations"" on ""Locations"" ""d.Location"" (cost=0.29..0.96 rows=1 width=24) (actual time=0.006..0.006 rows=1 loops=974)

  • Index Cond: (d.""LocationId"" = ""Id"")
Planning time : 1.149 ms
Execution time : 118.166 ms