explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tssc

Settings
# exclusive inclusive rows x rows loops node
1. 4,353.459 5,149,809.469 ↓ 0.0 0 1

Update on "ITEMPLANNINGDATA" "IPD" (cost=60,266.22..64,179.32 rows=1 width=700) (actual time=5,149,809.469..5,149,809.469 rows=0 loops=1)

2. 366.724 5,145,456.010 ↓ 85,949.0 85,949 1

Nested Loop (cost=60,266.22..64,179.32 rows=1 width=700) (actual time=2,319,870.718..5,145,456.010 rows=85,949 loops=1)

3. 845.377 2,320,289.452 ↓ 85,949.0 85,949 1

HashAggregate (cost=60,265.80..60,265.81 rows=1 width=72) (actual time=2,319,837.885..2,320,289.452 rows=85,949 loops=1)

  • Group Key: "I"."GUID
4. 306.668 2,319,444.075 ↓ 85,949.0 85,949 1

Nested Loop (cost=1.71..60,265.80 rows=1 width=72) (actual time=0.816..2,319,444.075 rows=85,949 loops=1)

  • Join Filter: ("I"."GUID" = "IPDA"."GUID")
5. 416.443 4,187.041 ↓ 85,949.0 85,949 1

Nested Loop (cost=1.29..56,352.84 rows=1 width=50) (actual time=0.336..4,187.041 rows=85,949 loops=1)

6. 90.030 1,363.208 ↓ 481,478.0 481,478 1

Nested Loop (cost=0.86..56,352.32 rows=1 width=28) (actual time=0.152..1,363.208 rows=481,478 loops=1)

7. 0.233 0.233 ↑ 1.0 1 1

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

  • Index Cond: ((("NUMBER001")::text = '9000000'::text) AND ("VALIDFROM" <= now()))
  • Filter: ("VALIDUNTIL" > now())
8. 1,272.945 1,272.945 ↓ 1.2 481,478 1

Index Scan using "SALESITEM_pkey" on "SALESITEM" "SI" (cost=0.43..52,201.15 rows=414,869 width=38) (actual time=0.063..1,272.945 rows=481,478 loops=1)

  • Index Cond: (("ORGANIZATIONALUNIT" = "P"."GUID") AND ("VALIDFROM" <= now()))
  • Filter: ((("KIKDV_CATALOGITEM")::text = ' '::text) AND ("VALIDUNTIL" > now()))
  • Rows Removed by Filter: 36753
9. 2,407.390 2,407.390 ↓ 0.0 0 481,478

Index Scan using "ITEM001_pkey" on "ITEM001" "I" (cost=0.43..0.51 rows=1 width=22) (actual time=0.005..0.005 rows=0 loops=481,478)

  • Index Cond: (("GUID" = "SI"."GUID") AND ("VALIDFROM" <= now()))
  • Filter: ("KIKDV_PREPACK" AND ("VALIDUNTIL" > now()))
  • Rows Removed by Filter: 1
10. 2,314,950.366 2,314,950.366 ↑ 1.0 1 85,949

Index Scan using "I00G2V4F66600CIS" on "ITEMPLANNINGDATA" "IPDA" (cost=0.42..3,912.94 rows=1 width=22) (actual time=18.285..26.934 rows=1 loops=85,949)

  • Index Cond: ("GUID" = "SI"."GUID")
  • Filter: (("VALIDFROM" <= now()) AND ("VALIDUNTIL" > now()))
11. 2,824,799.834 2,824,799.834 ↑ 1.0 1 85,949

Index Scan using "I00G2V4F66600CIS" on "ITEMPLANNINGDATA" "IPD" (cost=0.42..3,913.50 rows=1 width=636) (actual time=21.572..32.866 rows=1 loops=85,949)

  • Index Cond: ("GUID" = "I"."GUID")
Planning time : 6.108 ms
Execution time : 5,149,811.185 ms