explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kAcR

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=367.15..5,748.40 rows=1 width=299) (actual rows= loops=)

  • Filter: ("BalSheet"."Guid" IS NULL)
2. 0.000 0.000 ↓ 0.0

Seq Scan on "BalSheetTemp" (cost=0.00..13.13 rows=1 width=279) (actual rows= loops=)

  • Filter: ((NOT "Deleted") AND ("OrganizationID" = 1727765173))
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on "BalSheet" (cost=367.15..5,735.26 rows=1 width=124) (actual rows= loops=)

  • Recheck Cond: ("Period" = "BalSheetTemp"."Period")
  • Filter: ((NOT "Deleted") AND ("OrganizationID" = 1) AND (("Key2" = "BalSheetTemp"."Key2") OR (("Key2" IS NULL) AND ("BalSheetTemp"."Key2" IS NULL))) AND (("Key3" = "BalSheetTemp"."Key3") OR (("Key3" IS NULL) AND ("BalSheetTemp"."Key3" IS NULL))) AND (("Key4" = "BalSheetTemp"."Key4") OR (("Key4" IS NULL) AND ("BalSheetTemp"."Key4" IS NULL))) AND (("Key5" = "BalSheetTemp"."Key5") OR (("Key5" IS NULL) AND ("BalSheetTemp"."Key5" IS NULL))) AND (("Key6" = "BalSheetTemp"."Key6") OR (("Key6" IS NULL) AND ("BalSheetTemp"."Key6" IS NULL))) AND (("Key1" = "BalSheetTemp"."Key1") OR (("Key1" IS NULL) AND ("BalSheetTemp"."Key1" IS NULL))) AND ("RegisterKind" = "BalSheetTemp"."RegisterKind"))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "BalSheet_IX_Period" (cost=0.00..367.15 rows=4,097 width=0) (actual rows= loops=)