explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FJXs

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

Update on "ITEMPLANNINGDATA" "IPD" (cost=62,720.85..66,615.06 rows=1 width=700) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=62,720.85..66,615.06 rows=1 width=700) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=62,720.42..62,720.43 rows=1 width=72) (actual rows= loops=)

  • Group Key: "I"."GUID
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.71..62,720.42 rows=1 width=72) (actual rows= loops=)

  • Join Filter: ("I"."GUID" = "IPDA"."GUID")
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.29..58,826.40 rows=1 width=50) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..58,825.88 rows=1 width=28) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using "I10816RDNB600CIS00" on "PARTNER001" "P" (cost=0.43..2.66 rows=1 width=22) (actual rows= loops=)

  • Index Cond: ((("NUMBER001")::text = '9000000'::text) AND ("VALIDFROM" <= now()))
  • Filter: ("VALIDUNTIL" > now())
8. 0.000 0.000 ↓ 0.0

Index Scan using "SALESITEM_pkey" on "SALESITEM" "SI" (cost=0.43..54,684.62 rows=413,860 width=38) (actual rows= loops=)

  • Index Cond: (("ORGANIZATIONALUNIT" = "P"."GUID") AND ("VALIDFROM" <= now()))
  • Filter: ((("KIKDV_CATALOGITEM")::text = ' '::text) AND ("VALIDUNTIL" > now()))
9. 0.000 0.000 ↓ 0.0

Index Scan using "ITEM001_pkey" on "ITEM001" "I" (cost=0.42..0.51 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (("GUID" = "SI"."GUID") AND ("VALIDFROM" <= now()))
  • Filter: ("KIKDV_PREPACK" AND ("VALIDUNTIL" > now()))
10. 0.000 0.000 ↓ 0.0

Index Scan using "I00G2V4F66600CIS" on "ITEMPLANNINGDATA" "IPDA" (cost=0.42..3,894.01 rows=1 width=22) (actual rows= loops=)

  • Index Cond: ("GUID" = "SI"."GUID")
  • Filter: (("VALIDFROM" <= now()) AND ("VALIDUNTIL" > now()))
11. 0.000 0.000 ↓ 0.0

Index Scan using "I00G2V4F66600CIS" on "ITEMPLANNINGDATA" "IPD" (cost=0.42..3,894.61 rows=1 width=636) (actual rows= loops=)

  • Index Cond: ("GUID" = "I"."GUID")