explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fxGm

Settings
# exclusive inclusive rows x rows loops node
1. 0.109 56.865 ↑ 195.0 4 1

Sort (cost=376.94..378.89 rows=780 width=3,133) (actual time=56.825..56.865 rows=4 loops=1)

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

Hash Left Join (cost=85.66..339.47 rows=780 width=3,133) (actual time=53.804..56.756 rows=4 loops=1)

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

Hash Left Join (cost=84.48..335.30 rows=780 width=2,462) (actual time=53.585..56.382 rows=4 loops=1)

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

Hash Left Join (cost=69.82..318.58 rows=780 width=2,286) (actual time=47.551..50.362 rows=4 loops=1)

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

Hash Left Join (cost=28.29..275.01 rows=780 width=2,157) (actual time=21.450..24.108 rows=4 loops=1)

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

Hash Left Join (cost=27.20..270.34 rows=780 width=1,487) (actual time=20.832..23.421 rows=4 loops=1)

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

Hash Left Join (cost=1.36..242.44 rows=780 width=1,450) (actual time=0.727..3.243 rows=4 loops=1)

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

Seq Scan on "LegalEntities" l (cost=0.00..238.70 rows=780 width=724) (actual time=0.324..2.765 rows=4 loops=1)

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

Hash (cost=1.16..1.16 rows=16 width=726) (actual time=0.362..0.370 rows=16 loops=1)

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

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

11. 10.065 19.878 ↑ 1.0 882 1

Hash (cost=14.82..14.82 rows=882 width=37) (actual time=19.870..19.878 rows=882 loops=1)

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

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

13. 0.072 0.160 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=670) (actual time=0.152..0.160 rows=4 loops=1)

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

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

15. 13.209 26.061 ↑ 1.0 1,179 1

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

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

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

17. 2.994 5.995 ↑ 1.0 296 1

Hash (cost=10.96..10.96 rows=296 width=176) (actual time=5.987..5.995 rows=296 loops=1)

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

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

19. 0.091 0.185 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=671) (actual time=0.177..0.185 rows=8 loops=1)

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

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

Planning time : 17.038 ms
Execution time : 57.564 ms