explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gh2h

Settings
# exclusive inclusive rows x rows loops node
1. 17.601 187.911 ↑ 1.0 1,553 1

Sort (cost=3,830.75..3,834.64 rows=1,555 width=3,906) (actual time=181.286..187.911 rows=1,553 loops=1)

  • Sort Key: l.""Id"
  • Sort Method: external merge Disk: 2,936kB
2. 12.589 170.310 ↑ 1.0 1,553 1

Hash Left Join (cost=703.87..1,130.32 rows=1,555 width=3,906) (actual time=35.650..170.310 rows=1,553 loops=1)

  • Hash Cond: ((l.""LegalEntityTypeRefValue"")::text = (""l.LegalEntityTypeRef"".""Value"")::text)
3. 12.427 157.504 ↑ 1.0 1,553 1

Hash Left Join (cost=702.69..1,123.42 rows=1,555 width=3,235) (actual time=35.414..157.504 rows=1,553 loops=1)

  • Hash Cond: (l.""LicenseId"" = ""l.License"".""Id"")
4. 12.679 133.602 ↑ 1.0 1,553 1

Hash Left Join (cost=656.44..1,073.07 rows=1,555 width=3,071) (actual time=23.925..133.602 rows=1,553 loops=1)

  • Hash Cond: ((l.""LegalFormRefValue"")::text = (""l.LegalFormRef"".""Value"")::text)
5. 12.024 120.660 ↑ 1.0 1,553 1

Hash Left Join (cost=655.08..1,066.59 rows=1,555 width=2,345) (actual time=23.625..120.660 rows=1,553 loops=1)

  • Hash Cond: (l.""AccreditationId"" = ""l.Accreditation"".""Id"")
6. 45.630 104.427 ↑ 1.0 1,553 1

Hash Right Join (cost=644.40..1,047.38 rows=1,555 width=1,639) (actual time=19.402..104.427 rows=1,553 loops=1)

  • Hash Cond: (""l.Logo"".""Id"" = l.""LogoId"")
7. 39.517 39.517 ↑ 1.0 10,058 1

Seq Scan on ""Files"" ""l.Logo"" (cost=0.00..353.58 rows=10,058 width=161) (actual time=0.008..39.517 rows=10,058 loops=1)

8. 7.428 19.280 ↑ 1.0 1,553 1

Hash (cost=624.96..624.96 rows=1,555 width=1,478) (actual time=19.276..19.280 rows=1,553 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 1,632kB
9. 11.852 11.852 ↑ 1.0 1,553 1

Seq Scan on ""LegalEntities"" l (cost=0.00..624.96 rows=1,555 width=1,478) (actual time=0.170..11.852 rows=1,553 loops=1)

  • Filter: (((""_Name"")::text ~~* '%%'::text) OR (immutable_array_to_string(avals(""NameTranslations""), ','::text) ~~* '%%'::text))
  • Rows Removed by Filter: 2
10. 1.089 4.209 ↑ 1.0 275 1

Hash (cost=7.24..7.24 rows=275 width=706) (actual time=4.205..4.209 rows=275 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 61kB
11. 2.078 3.120 ↑ 1.0 275 1

Hash Left Join (cost=1.09..7.24 rows=275 width=706) (actual time=0.085..3.120 rows=275 loops=1)

  • Hash Cond: (""l.Accreditation"".""AccreditationCategoryRefId"" = ""l.Accreditation.AccreditationCategoryRef"".""Id"")
12. 0.994 0.994 ↑ 1.0 275 1

Seq Scan on ""Accreditations"" ""l.Accreditation"" (cost=0.00..4.75 rows=275 width=36) (actual time=0.008..0.994 rows=275 loops=1)

13. 0.022 0.048 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=670) (actual time=0.044..0.048 rows=4 loops=1)

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

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

15. 0.071 0.263 ↑ 1.0 16 1

Hash (cost=1.16..1.16 rows=16 width=726) (actual time=0.260..0.263 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
16. 0.192 0.192 ↑ 1.0 16 1

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

17. 5.494 11.475 ↑ 1.0 1,389 1

Hash (cost=28.89..28.89 rows=1,389 width=164) (actual time=11.472..11.475 rows=1,389 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 134kB
18. 5.981 5.981 ↑ 1.0 1,389 1

Seq Scan on ""Licenses"" ""l.License"" (cost=0.00..28.89 rows=1,389 width=164) (actual time=0.009..5.981 rows=1,389 loops=1)

19. 0.006 0.217 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=671) (actual time=0.213..0.217 rows=8 loops=1)

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

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

Planning time : 12.655 ms
Execution time : 194.696 ms