explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eiH2

Settings
# exclusive inclusive rows x rows loops node
1. 4.735 55.735 ↓ 2.0 104 1

Sort (cost=154.17..154.29 rows=51 width=873) (actual time=53.777..55.735 rows=104 loops=1)

  • Sort Key: "l.Divisions"."LegalEntityId", "l.Divisions"."Id
  • Sort Method: quicksort Memory: 117kB
2. 7.566 51.000 ↓ 2.0 104 1

Nested Loop Left Join (cost=9.09..152.72 rows=51 width=873) (actual time=10.884..51.000 rows=104 loops=1)

3. 4.086 34.074 ↓ 2.0 104 1

Hash Left Join (cost=8.81..56.23 rows=51 width=849) (actual time=10.792..34.074 rows=104 loops=1)

  • Hash Cond: ("l.Divisions"."TypeOfDivisionRefId" = "d.TypeOfDivisionRef"."Id")
4. 14.512 25.948 ↓ 2.0 104 1

Hash Join (cost=2.67..49.95 rows=51 width=598) (actual time=6.595..25.948 rows=104 loops=1)

  • Hash Cond: ("l.Divisions"."LegalEntityId" = l0."Id")
5. 10.576 10.576 ↑ 1.0 731 1

Seq Scan on "Divisions" "l.Divisions" (cost=0.00..45.31 rows=731 width=594) (actual time=0.017..10.576 rows=731 loops=1)

6. 0.110 0.860 ↑ 1.0 10 1

Hash (cost=2.54..2.54 rows=10 width=4) (actual time=0.848..0.860 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.244 0.750 ↑ 1.0 10 1

Unique (cost=0.28..2.44 rows=10 width=4) (actual time=0.072..0.750 rows=10 loops=1)

8. 0.171 0.506 ↑ 1.0 10 1

Limit (cost=0.28..2.32 rows=10 width=4) (actual time=0.054..0.506 rows=10 loops=1)

9. 0.335 0.335 ↑ 78.0 10 1

Index Scan using "PK_dbo.LegalEntities" on "LegalEntities" l0 (cost=0.28..159.63 rows=780 width=4) (actual time=0.037..0.335 rows=10 loops=1)

10. 1.870 4.040 ↑ 1.0 95 1

Hash (cost=4.95..4.95 rows=95 width=251) (actual time=4.026..4.040 rows=95 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
11. 2.170 2.170 ↑ 1.0 95 1

Seq Scan on "TypeOfDivisionRefs" "d.TypeOfDivisionRef" (cost=0.00..4.95 rows=95 width=251) (actual time=0.076..2.170 rows=95 loops=1)

12. 9.360 9.360 ↑ 1.0 1 104

Index Scan using "PK_dbo.Locations" on "Locations" "d.Location" (cost=0.29..1.89 rows=1 width=24) (actual time=0.090..0.090 rows=1 loops=104)

  • Index Cond: ("l.Divisions"."LocationId" = "Id")
Planning time : 6.988 ms
Execution time : 58.216 ms