explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c8GO0

Settings
# exclusive inclusive rows x rows loops node
1. 0.138 79.463 ↑ 195.0 4 1

Sort (cost=619.47..621.42 rows=780 width=3,133) (actual time=79.416..79.463 rows=4 loops=1)

  • Sort Key: l."Id
  • Sort Method: quicksort Memory: 33kB
2. 0.144 79.325 ↑ 195.0 4 1

Hash Left Join (cost=248.49..582.00 rows=780 width=3,133) (actual time=75.414..79.325 rows=4 loops=1)

  • Hash Cond: ((l."LegalEntityTypeRefValue")::text = ("l.LegalEntityTypeRef"."Value")::text)
3. 0.137 78.778 ↑ 195.0 4 1

Hash Left Join (cost=236.14..566.65 rows=780 width=2,462) (actual time=74.955..78.778 rows=4 loops=1)

  • Hash Cond: (l."LogoId" = "l.Logo"."Id")
4. 0.123 70.016 ↑ 195.0 4 1

Hash Left Join (cost=192.13..520.58 rows=780 width=2,286) (actual time=66.280..70.016 rows=4 loops=1)

  • Hash Cond: (l."LicenseId" = "l.License"."Id")
5. 0.145 31.225 ↑ 195.0 4 1

Hash Left Join (cost=78.73..405.14 rows=780 width=2,157) (actual time=27.575..31.225 rows=4 loops=1)

  • Hash Cond: ("l.Accreditation"."AccreditationCategoryRefId" = "l.Accreditation.AccreditationCategoryRef"."Id")
6. 0.126 30.921 ↑ 195.0 4 1

Hash Left Join (cost=66.49..389.32 rows=780 width=1,487) (actual time=27.356..30.921 rows=4 loops=1)

  • Hash Cond: (l."AccreditationId" = "l.Accreditation"."Id")
7. 0.129 4.893 ↑ 195.0 4 1

Hash Left Join (cost=12.85..333.63 rows=780 width=1,450) (actual time=1.413..4.893 rows=4 loops=1)

  • Hash Cond: ((l."LegalFormRefValue")::text = ("l.LegalFormRef"."Value")::text)
8. 4.137 4.137 ↑ 195.0 4 1

Index Scan using "IX_LegalEntities_LegalEntityTypeRefValue" on "LegalEntities" l (cost=0.28..318.67 rows=780 width=724) (actual time=0.749..4.137 rows=4 loops=1)

  • Filter: (immutable_array_to_string(avals("NameTranslations"), ','::text) ~~* '%a%'::text)
  • Rows Removed by Filter: 776
9. 0.303 0.627 ↑ 1.0 16 1

Hash (cost=12.38..12.38 rows=16 width=726) (actual time=0.618..0.627 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
10. 0.324 0.324 ↑ 1.0 16 1

Index Scan using "IX_LegalFormRefs_Value" on "LegalFormRefs" "l.LegalFormRef" (cost=0.14..12.38 rows=16 width=726) (actual time=0.020..0.324 rows=16 loops=1)

11. 12.181 25.902 ↑ 1.0 882 1

Hash (cost=42.61..42.61 rows=882 width=37) (actual time=25.892..25.902 rows=882 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 51kB
12. 13.721 13.721 ↑ 1.0 882 1

Index Scan using "PK_dbo.Accreditations" on "Accreditations" "l.Accreditation" (cost=0.28..42.61 rows=882 width=37) (actual time=0.030..13.721 rows=882 loops=1)

13. 0.063 0.159 ↑ 1.0 4 1

Hash (cost=12.19..12.19 rows=4 width=670) (actual time=0.150..0.159 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
14. 0.096 0.096 ↑ 1.0 4 1

Index Scan using "PK_dbo.AccreditationCategoryRefs" on "AccreditationCategoryRefs" "l.Accreditation.AccreditationCategoryRef" (cost=0.13..12.19 rows=4 width=670) (actual time=0.036..0.096 rows=4 loops=1)

15. 17.402 38.668 ↑ 1.0 1,179 1

Hash (cost=98.66..98.66 rows=1,179 width=129) (actual time=38.659..38.668 rows=1,179 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 138kB
16. 21.266 21.266 ↑ 1.0 1,179 1

Index Scan using "PK_dbo.Licenses" on "Licenses" "l.License" (cost=0.28..98.66 rows=1,179 width=129) (actual time=0.029..21.266 rows=1,179 loops=1)

17. 3.981 8.625 ↑ 1.0 296 1

Hash (cost=40.31..40.31 rows=296 width=176) (actual time=8.616..8.625 rows=296 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 70kB
18. 4.644 4.644 ↑ 1.0 296 1

Index Scan using "PK_dbo.Files" on "Files" "l.Logo" (cost=0.15..40.31 rows=296 width=176) (actual time=0.044..4.644 rows=296 loops=1)

19. 0.130 0.403 ↑ 1.0 8 1

Hash (cost=12.25..12.25 rows=8 width=671) (actual time=0.393..0.403 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
20. 0.273 0.273 ↑ 1.0 8 1

Index Scan using "IX_TypeOfLegalEntityRefs_Value" on "LegalEntityTypeRefs" "l.LegalEntityTypeRef" (cost=0.13..12.25 rows=8 width=671) (actual time=0.164..0.273 rows=8 loops=1)

Planning time : 3.428 ms
Execution time : 80.129 ms