explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XeLt

Settings
# exclusive inclusive rows x rows loops node
1. 213.324 1,896.813 ↑ 1.0 26,649 1

Hash Left Join (cost=2,015.39..3,376.17 rows=26,649 width=4,255) (actual time=498.348..1,896.813 rows=26,649 loops=1)

  • Hash Cond: (""e.PositionRef"".""PositionRangeRefId"" = ""e.PositionRef.PositionRangeRef"".""Id"")
2. 214.205 1,682.308 ↑ 1.0 26,649 1

Hash Join (cost=2,007.10..3,296.25 rows=26,649 width=4,047) (actual time=497.136..1,682.308 rows=26,649 loops=1)

  • Hash Cond: (""p.Employees"".""PositionRefId"" = ""e.PositionRef"".""Id"")
3. 214.494 1,465.726 ↑ 1.0 26,649 1

Hash Left Join (cost=1,990.96..3,209.07 rows=26,649 width=3,811) (actual time=494.656..1,465.726 rows=26,649 loops=1)

  • Hash Cond: ((l0.""LegalFormRefValue"")::text = (""e.Division.LegalEntity.LegalFormRef"".""Value"")::text)
4. 210.029 1,251.084 ↑ 1.0 26,649 1

Hash Left Join (cost=1,989.60..3,119.87 rows=26,649 width=3,085) (actual time=494.459..1,251.084 rows=26,649 loops=1)

  • Hash Cond: (l0.""LogoId"" = ""e.Division.LegalEntity.Logo"".""Id"")
5. 216.797 962.466 ↑ 1.0 26,649 1

Hash Left Join (cost=1,510.30..2,570.59 rows=26,649 width=2,924) (actual time=415.802..962.466 rows=26,649 loops=1)

  • Hash Cond: (""e.Division3"".""LegalEntityId"" = l0.""Id"")
6. 217.933 730.706 ↑ 1.0 26,649 1

Hash Left Join (cost=1,266.32..2,256.48 rows=26,649 width=1,446) (actual time=400.804..730.706 rows=26,649 loops=1)

  • Hash Cond: (""p.Employees"".""DivisionId"" = ""e.Division3"".""Id"")
7. 112.028 112.028 ↑ 1.0 26,649 1

Seq Scan on ""Employees"" ""p.Employees"" (cost=0.00..641.49 rows=26,649 width=139) (actual time=0.010..112.028 rows=26,649 loops=1)

  • Filter: (NOT ""IsDeleted"")
8. 12.867 400.745 ↑ 1.0 2,571 1

Hash (cost=1,234.18..1,234.18 rows=2,571 width=1,307) (actual time=400.742..400.745 rows=2,571 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 2559kB
9. 19.772 387.878 ↑ 1.0 2,571 1

Hash Left Join (cost=325.98..1,234.18 rows=2,571 width=1,307) (actual time=28.007..387.878 rows=2,571 loops=1)

  • Hash Cond: (""e.Division3"".""TypeOfDivisionRefId"" = ""e.Division.TypeOfDivisionRef"".""Id"")
10. 178.227 367.277 ↑ 1.0 2,571 1

Hash Right Join (cost=320.85..1,222.00 rows=2,571 width=1,131) (actual time=27.140..367.277 rows=2,571 loops=1)

  • Hash Cond: (""e.Division.Location1"".""Id"" = ""e.Division3"".""LocationId"")
11. 161.968 161.968 ↑ 1.0 43,528 1

Seq Scan on ""Locations"" ""e.Division.Location1"" (cost=0.00..713.28 rows=43,528 width=24) (actual time=0.014..161.968 rows=43,528 loops=1)

12. 13.585 27.082 ↑ 1.0 2,571 1

Hash (cost=288.71..288.71 rows=2,571 width=1,107) (actual time=27.078..27.082 rows=2,571 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 2094kB
13. 13.497 13.497 ↑ 1.0 2,571 1

Seq Scan on ""Divisions"" ""e.Division3"" (cost=0.00..288.71 rows=2,571 width=1,107) (actual time=0.013..13.497 rows=2,571 loops=1)

14. 0.433 0.829 ↑ 1.0 95 1

Hash (cost=3.95..3.95 rows=95 width=176) (actual time=0.826..0.829 rows=95 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 29kB
15. 0.396 0.396 ↑ 1.0 95 1

Seq Scan on ""TypeOfDivisionRefs"" ""e.Division.TypeOfDivisionRef"" (cost=0.00..3.95 rows=95 width=176) (actual time=0.010..0.396 rows=95 loops=1)

16. 7.625 14.963 ↑ 1.0 1,554 1

Hash (cost=224.55..224.55 rows=1,554 width=1,478) (actual time=14.960..14.963 rows=1,554 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 1632kB
17. 7.338 7.338 ↑ 1.0 1,554 1

Seq Scan on ""LegalEntities"" l0 (cost=0.00..224.55 rows=1,554 width=1,478) (actual time=0.013..7.338 rows=1,554 loops=1)

  • Filter: (NOT ""IsDeleted"")
  • Rows Removed by Filter: 1
18. 39.322 78.589 ↑ 1.0 10,058 1

Hash (cost=353.58..353.58 rows=10,058 width=161) (actual time=78.585..78.589 rows=10,058 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 2065kB
19. 39.267 39.267 ↑ 1.0 10,058 1

Seq Scan on ""Files"" ""e.Division.LegalEntity.Logo"" (cost=0.00..353.58 rows=10,058 width=161) (actual time=0.010..39.267 rows=10,058 loops=1)

20. 0.077 0.148 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=726) (actual time=0.144..0.148 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
21. 0.071 0.071 ↑ 1.0 16 1

Seq Scan on ""LegalFormRefs"" ""e.Division.LegalEntity.LegalFormRef"" (cost=0.00..1.16 rows=16 width=726) (actual time=0.010..0.071 rows=16 loops=1)

22. 1.191 2.377 ↑ 1.0 273 1

Hash (cost=12.73..12.73 rows=273 width=236) (actual time=2.374..2.377 rows=273 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 82kB
23. 1.186 1.186 ↑ 1.0 273 1

Seq Scan on ""PositionRefs"" ""e.PositionRef"" (cost=0.00..12.73 rows=273 width=236) (actual time=0.014..1.186 rows=273 loops=1)

24. 0.605 1.181 ↑ 1.0 146 1

Hash (cost=6.46..6.46 rows=146 width=208) (actual time=1.178..1.181 rows=146 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 45kB
25. 0.576 0.576 ↑ 1.0 146 1

Seq Scan on ""PositionRangeRefs"" ""e.PositionRef.PositionRangeRef"" (cost=0.00..6.46 rows=146 width=208) (actual time=0.008..0.576 rows=146 loops=1)

Planning time : 5.739 ms
Execution time : 1,994.646 ms