explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YF2z

Settings
# exclusive inclusive rows x rows loops node
1. 0.789 89.213 ↑ 195.0 4 1

Sort (cost=378.89..380.84 rows=780 width=3,133) (actual time=89.173..89.213 rows=4 loops=1)

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

Hash Left Join (cost=85.66..341.42 rows=780 width=3,133) (actual time=81.653..88.424 rows=4 loops=1)

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

Hash Left Join (cost=84.48..337.25 rows=780 width=2,462) (actual time=81.264..87.938 rows=4 loops=1)

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

Hash Left Join (cost=69.82..320.53 rows=780 width=2,286) (actual time=66.728..73.283 rows=4 loops=1)

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

Hash Left Join (cost=28.29..276.96 rows=780 width=2,157) (actual time=27.656..33.954 rows=4 loops=1)

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

Hash Left Join (cost=27.20..272.29 rows=780 width=1,487) (actual time=26.735..32.948 rows=4 loops=1)

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

Hash Left Join (cost=1.36..244.39 rows=780 width=1,450) (actual time=2.317..8.422 rows=4 loops=1)

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

Seq Scan on "LegalEntities" l (cost=0.00..240.65 rows=780 width=724) (actual time=0.884..6.889 rows=4 loops=1)

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

Hash (cost=1.16..1.16 rows=16 width=726) (actual time=1.048..1.056 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
10. 0.817 0.817 ↑ 1.0 16 1

Seq Scan on "LegalFormRefs" "l.LegalFormRef" (cost=0.00..1.16 rows=16 width=726) (actual time=0.670..0.817 rows=16 loops=1)

11. 9.512 24.162 ↑ 1.0 882 1

Hash (cost=14.82..14.82 rows=882 width=37) (actual time=24.154..24.162 rows=882 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 51kB
12. 14.650 14.650 ↑ 1.0 882 1

Seq Scan on "Accreditations" "l.Accreditation" (cost=0.00..14.82 rows=882 width=37) (actual time=0.239..14.650 rows=882 loops=1)

13. 0.069 0.888 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=670) (actual time=0.880..0.888 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 0.819 0.819 ↑ 1.0 4 1

Seq Scan on "AccreditationCategoryRefs" "l.Accreditation.AccreditationCategoryRef" (cost=0.00..1.04 rows=4 width=670) (actual time=0.642..0.819 rows=4 loops=1)

15. 13.258 39.031 ↑ 1.0 1,179 1

Hash (cost=26.79..26.79 rows=1,179 width=129) (actual time=39.023..39.031 rows=1,179 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 138kB
16. 25.773 25.773 ↑ 1.0 1,179 1

Seq Scan on "Licenses" "l.License" (cost=0.00..26.79 rows=1,179 width=129) (actual time=0.707..25.773 rows=1,179 loops=1)

17. 4.294 13.848 ↑ 1.0 296 1

Hash (cost=10.96..10.96 rows=296 width=176) (actual time=13.840..13.848 rows=296 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 70kB
18. 9.554 9.554 ↑ 1.0 296 1

Seq Scan on "Files" "l.Logo" (cost=0.00..10.96 rows=296 width=176) (actual time=0.496..9.554 rows=296 loops=1)

19. 0.146 0.292 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=671) (actual time=0.284..0.292 rows=8 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
20. 0.146 0.146 ↑ 1.0 8 1

Seq Scan on "LegalEntityTypeRefs" "l.LegalEntityTypeRef" (cost=0.00..1.08 rows=8 width=671) (actual time=0.056..0.146 rows=8 loops=1)

Planning time : 32.889 ms
Execution time : 90.169 ms