explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kWjA

Settings
# exclusive inclusive rows x rows loops node
1. 3,779.910 271,416.993 ↓ 3.7 392,927 1

Sort (cost=1,040,443.23..1,040,707.93 rows=105,879 width=143) (actual time=271,339.743..271,416.993 rows=392,927 loops=1)

  • Sort Key: "SO"."NUMBER001
  • Sort Method: external sort Disk: 71896kB
2. 468.050 267,637.083 ↓ 3.7 392,927 1

Nested Loop Left Join (cost=2.54..1,031,606.54 rows=105,879 width=143) (actual time=1.865..267,637.083 rows=392,927 loops=1)

3. 227.122 262,846.836 ↓ 3.7 392,927 1

Nested Loop Left Join (cost=2.11..974,528.99 rows=105,879 width=146) (actual time=1.589..262,846.836 rows=392,927 loops=1)

4. 558.749 257,515.784 ↓ 3.7 392,610 1

Nested Loop Left Join (cost=1.68..903,773.03 rows=105,879 width=146) (actual time=1.507..257,515.784 rows=392,610 loops=1)

5. 304.210 253,816.155 ↓ 3.7 392,610 1

Nested Loop (cost=1.25..855,886.24 rows=105,879 width=146) (actual time=1.399..253,816.155 rows=392,610 loops=1)

6. 914.518 2,442.623 ↓ 3.4 396,634 1

Nested Loop (cost=0.56..288,591.72 rows=115,463 width=130) (actual time=0.210..2,442.623 rows=396,634 loops=1)

7. 0.123 0.123 ↑ 1.0 2 1

Seq Scan on "SALESORDERTYPE" "SOT" (cost=0.00..7.89 rows=2 width=16) (actual time=0.100..0.123 rows=2 loops=1)

  • Filter: (("CODE")::text ~~ '_68'::text)
  • Rows Removed by Filter: 69
8. 1,527.982 1,527.982 ↓ 1.2 198,317 2

Index Scan using "I008SPOAUD600CIS" on "SALESORDER" "SO" (cost=0.56..142,652.33 rows=163,958 width=130) (actual time=0.063..763.991 rows=198,317 loops=2)

  • Index Cond: ("TYPE001" = "SOT"."GUID")
9. 251,069.322 251,069.322 ↑ 3.0 1 396,634

Index Scan using "I10OK45CAP600CIS00" on "ORDERREFERENCE" "OREF" (cost=0.70..4.88 rows=3 width=32) (actual time=0.495..0.633 rows=1 loops=396,634)

  • Index Cond: (("SOURCEHEADER" = "SO"."GUID") AND ("TARGETDETAIL" = '00000000-0000-0000-0000-000000000000'::uuid))
  • Filter: (("SOURCETYPE" = 40) AND ("TARGETTYPE" = 90))
  • Rows Removed by Filter: 3
10. 3,140.880 3,140.880 ↑ 1.0 1 392,610

Index Only Scan using "SHIPPINGORDER_pkey" on "SHIPPINGORDER" "SHO" (cost=0.43..0.45 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=392,610)

  • Index Cond: ("GUID" = "OREF"."TARGETHEADER")
  • Heap Fetches: 11045
11. 5,103.930 5,103.930 ↑ 1.0 1 392,610

Index Scan using "UNITLOAD_IDX03" on "UNITLOAD" "UL" (cost=0.43..0.66 rows=1 width=32) (actual time=0.012..0.013 rows=1 loops=392,610)

  • Index Cond: ("KIKDV_SHIPPINGORDER" = "SHO"."GUID")
12. 4,322.197 4,322.197 ↑ 1.0 1 392,927

Index Scan using "UNITLOAD_pkey" on "UNITLOAD" "UL_UVP" (cost=0.43..0.54 rows=1 width=29) (actual time=0.011..0.011 rows=1 loops=392,927)

  • Index Cond: ("GUID" = "UL"."PARENTGUID")
Planning time : 10.568 ms
Execution time : 271,441.359 ms