explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PdfIK

Settings
# exclusive inclusive rows x rows loops node
1. 1.380 2.910 ↓ 0.0 0 1

Sort (cost=39.82..39.83 rows=1 width=3,133) (actual time=2.902..2.910 rows=0 loops=1)

  • Sort Key: l."Id
  • Sort Method: quicksort Memory: 25kB
2. 0.018 1.530 ↓ 0.0 0 1

Nested Loop Left Join (cost=8.83..39.81 rows=1 width=3,133) (actual time=1.521..1.530 rows=0 loops=1)

  • Join Filter: ((l."LegalEntityTypeRefValue")::text = ("l.LegalEntityTypeRef"."Value")::text)
3. 0.018 1.512 ↓ 0.0 0 1

Nested Loop Left Join (cost=8.83..38.63 rows=1 width=2,462) (actual time=1.503..1.512 rows=0 loops=1)

4. 0.016 1.494 ↓ 0.0 0 1

Nested Loop Left Join (cost=8.68..30.41 rows=1 width=2,286) (actual time=1.487..1.494 rows=0 loops=1)

5. 0.016 1.478 ↓ 0.0 0 1

Nested Loop Left Join (cost=8.41..22.10 rows=1 width=2,157) (actual time=1.470..1.478 rows=0 loops=1)

  • Join Filter: ((l."LegalFormRefValue")::text = ("l.LegalFormRef"."Value")::text)
6. 0.017 1.462 ↓ 0.0 0 1

Nested Loop Left Join (cost=8.41..20.74 rows=1 width=1,431) (actual time=1.454..1.462 rows=0 loops=1)

7. 0.021 1.445 ↓ 0.0 0 1

Bitmap Heap Scan on "LegalEntities" l (cost=8.00..12.27 rows=1 width=724) (actual time=1.437..1.445 rows=0 loops=1)

  • Recheck Cond: (immutable_array_to_string(avals("NameTranslations"), ','::text) ~~* '%ааа%'::text)
8. 1.424 1.424 ↓ 0.0 0 1

Bitmap Index Scan on "IX_LegalEntities_NameTranslations_Filter" (cost=0.00..8.00 rows=1 width=0) (actual time=1.416..1.424 rows=0 loops=1)

  • Index Cond: (immutable_array_to_string(avals("NameTranslations"), ','::text) ~~* '%ааа%'::text)
9. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.41..8.47 rows=1 width=707) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_dbo.Accreditations" on "Accreditations" "l.Accreditation" (cost=0.28..8.29 rows=1 width=37) (never executed)

  • Index Cond: (l."AccreditationId" = "Id")
11. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_dbo.AccreditationCategoryRefs" on "AccreditationCategoryRefs" "l.Accreditation.AccreditationCategoryRef" (cost=0.13..0.16 rows=1 width=670) (never executed)

  • Index Cond: ("l.Accreditation"."AccreditationCategoryRefId" = "Id")
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on "LegalFormRefs" "l.LegalFormRef" (cost=0.00..1.16 rows=16 width=726) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_dbo.Licenses" on "Licenses" "l.License" (cost=0.28..8.29 rows=1 width=129) (never executed)

  • Index Cond: (l."LicenseId" = "Id")
14. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_dbo.Files" on "Files" "l.Logo" (cost=0.15..8.17 rows=1 width=176) (never executed)

  • Index Cond: (l."LogoId" = "Id")
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on "LegalEntityTypeRefs" "l.LegalEntityTypeRef" (cost=0.00..1.08 rows=8 width=671) (never executed)

Planning time : 65.816 ms
Execution time : 25.321 ms