explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vwuj

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 99.063 ↑ 1.0 3 1

Nested Loop Left Join (cost=1.27..165.40 rows=3 width=257) (actual time=98.774..99.063 rows=3 loops=1)

2. 0.007 99.030 ↑ 1.0 3 1

Nested Loop Left Join (cost=1.13..161.88 rows=3 width=205) (actual time=98.748..99.030 rows=3 loops=1)

3. 0.011 98.999 ↑ 1.0 3 1

Nested Loop Left Join (cost=0.85..154.97 rows=3 width=186) (actual time=98.725..98.999 rows=3 loops=1)

4. 0.044 98.949 ↑ 1.0 3 1

Nested Loop Left Join (cost=0.70..149.46 rows=3 width=182) (actual time=98.686..98.949 rows=3 loops=1)

5. 0.027 91.594 ↑ 1.0 3 1

Nested Loop Left Join (cost=0.43..142.55 rows=3 width=178) (actual time=91.358..91.594 rows=3 loops=1)

6. 14.383 14.383 ↑ 1.0 3 1

Index Scan using idx_kk_shipping_booking_4 on kk_shipping_booking a (cost=0.29..6.35 rows=3 width=38) (actual time=14.355..14.383 rows=3 loops=1)

  • Index Cond: (upper((shipping_ref_num)::text) = ANY ('{GK-59083688,GK-59671803,GK-59501002}'::text[]))
7. 0.114 77.184 ↓ 0.0 0 3

Append (cost=0.14..45.15 rows=25 width=148) (actual time=25.728..25.728 rows=0 loops=3)

8. 0.036 0.036 ↓ 0.0 0 3

Index Scan using idx_ws_order_logistic on ws_order_logistic b (cost=0.14..2.16 rows=1 width=113) (actual time=0.012..0.012 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
9. 0.036 0.036 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2017_09_order_id_payment_date_idx on ws_order_logistic_p2017_09 b_1 (cost=0.42..2.44 rows=1 width=149) (actual time=0.012..0.012 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
10. 0.036 0.036 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2017_10_order_id_payment_date_idx on ws_order_logistic_p2017_10 b_2 (cost=0.43..2.45 rows=1 width=148) (actual time=0.012..0.012 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
11. 0.030 0.030 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2017_11_order_id_payment_date_idx on ws_order_logistic_p2017_11 b_3 (cost=0.42..2.44 rows=1 width=149) (actual time=0.010..0.010 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
12. 0.018 0.018 ↓ 0.0 0 3

Seq Scan on ws_order_logistic_p2017_12 b_4 (cost=0.00..1.01 rows=1 width=120) (actual time=0.006..0.006 rows=0 loops=3)

  • Filter: (order_id = a.order_id)
  • Rows Removed by Filter: 1
13. 4.989 4.989 ↓ 0.0 0 3

Seq Scan on ws_order_logistic_p2018_01 b_5 (cost=0.00..1.02 rows=1 width=118) (actual time=1.663..1.663 rows=0 loops=3)

  • Filter: (order_id = a.order_id)
  • Rows Removed by Filter: 2
14. 0.033 0.033 ↓ 0.0 0 3

Seq Scan on ws_order_logistic_p2018_02 b_6 (cost=0.00..1.04 rows=1 width=119) (actual time=0.011..0.011 rows=0 loops=3)

  • Filter: (order_id = a.order_id)
  • Rows Removed by Filter: 3
15. 0.018 0.018 ↓ 0.0 0 3

Seq Scan on ws_order_logistic_p2018_03 b_7 (cost=0.00..1.11 rows=1 width=120) (actual time=0.006..0.006 rows=0 loops=3)

  • Filter: (order_id = a.order_id)
  • Rows Removed by Filter: 9
16. 9.636 9.636 ↓ 0.0 0 3

Seq Scan on ws_order_logistic_p2018_04 b_8 (cost=0.00..1.01 rows=1 width=120) (actual time=3.212..3.212 rows=0 loops=3)

  • Filter: (order_id = a.order_id)
  • Rows Removed by Filter: 1
17. 9.465 9.465 ↓ 0.0 0 3

Seq Scan on ws_order_logistic_p2018_05 b_9 (cost=0.00..1.06 rows=1 width=115) (actual time=3.155..3.155 rows=0 loops=3)

  • Filter: (order_id = a.order_id)
  • Rows Removed by Filter: 5
18. 17.940 17.940 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2018_06_order_id_payment_date_idx on ws_order_logistic_p2018_06 b_10 (cost=0.14..1.82 rows=1 width=236) (actual time=5.980..5.980 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
19. 8.088 8.088 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2018_07_pkey on ws_order_logistic_p2018_07 b_11 (cost=0.13..1.48 rows=1 width=116) (actual time=2.696..2.696 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
20. 10.638 10.638 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2018_08_pkey on ws_order_logistic_p2018_08 b_12 (cost=0.14..1.82 rows=1 width=118) (actual time=3.546..3.546 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
21. 10.788 10.788 ↓ 0.0 0 3

Seq Scan on ws_order_logistic_p2018_09 b_13 (cost=0.00..1.09 rows=1 width=116) (actual time=3.596..3.596 rows=0 loops=3)

  • Filter: (order_id = a.order_id)
  • Rows Removed by Filter: 7
22. 0.075 0.075 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2018_10_order_id_payment_date_idx on ws_order_logistic_p2018_10 b_14 (cost=0.28..2.30 rows=1 width=115) (actual time=0.025..0.025 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
23. 0.042 0.042 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2018_11_order_id_payment_date_idx on ws_order_logistic_p2018_11 b_15 (cost=0.28..2.30 rows=1 width=120) (actual time=0.014..0.014 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
24. 0.066 0.066 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2018_12_order_id_payment_date_idx on ws_order_logistic_p2018_12 b_16 (cost=0.28..2.30 rows=1 width=119) (actual time=0.022..0.022 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
25. 0.090 0.090 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2019_01_order_id_payment_date_idx on ws_order_logistic_p2019_01 b_17 (cost=0.29..2.30 rows=1 width=116) (actual time=0.030..0.030 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
26. 4.842 4.842 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2019_02_order_id_payment_date_idx on ws_order_logistic_p2019_02 b_18 (cost=0.27..2.29 rows=1 width=111) (actual time=1.614..1.614 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
27. 0.081 0.081 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2019_03_order_id_payment_date_idx on ws_order_logistic_p2019_03 b_19 (cost=0.28..2.29 rows=1 width=114) (actual time=0.027..0.027 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
28. 0.042 0.042 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2019_04_order_id_payment_date_idx on ws_order_logistic_p2019_04 b_20 (cost=0.28..2.30 rows=1 width=118) (actual time=0.014..0.014 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
29. 0.027 0.027 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2019_05_order_id_payment_date_idx on ws_order_logistic_p2019_05 b_21 (cost=0.28..2.30 rows=1 width=117) (actual time=0.009..0.009 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
30. 0.021 0.021 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2019_06_order_id_payment_date_idx on ws_order_logistic_p2019_06 b_22 (cost=0.14..1.83 rows=1 width=115) (actual time=0.007..0.007 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
31. 0.018 0.018 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2019_07_order_id_payment_date_idx on ws_order_logistic_p2019_07 b_23 (cost=0.14..1.49 rows=1 width=236) (actual time=0.006..0.006 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
32. 0.015 0.015 ↓ 0.0 0 3

Index Scan using ws_order_logistic_p2019_08_order_id_payment_date_idx on ws_order_logistic_p2019_08 b_24 (cost=0.14..1.49 rows=1 width=236) (actual time=0.005..0.005 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
33. 7.311 7.311 ↓ 0.0 0 3

Index Scan using logistic_submission_uniq_awb_ship_id on logistic_submissions c (cost=0.28..2.29 rows=1 width=17) (actual time=2.437..2.437 rows=0 loops=3)

  • Index Cond: (lower((shipping_ref_num)::text) = lower((a.shipping_ref_num)::text))
34. 0.039 0.039 ↑ 1.0 1 3

Index Scan using kk_shipping_booking_detail_pkey on kk_shipping_booking_detail d (cost=0.14..1.83 rows=1 width=20) (actual time=0.013..0.013 rows=1 loops=3)

  • Index Cond: (sb_id = a.sb_id)
35. 0.024 0.024 ↓ 0.0 0 3

Index Scan using ws_order_shipping_autoresi_pkey on ws_order_shipping_autoresi e (cost=0.29..2.30 rows=1 width=27) (actual time=0.008..0.008 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
36. 0.024 0.024 ↓ 0.0 0 3

Index Scan using krr_order_time_pkey on krr_order_time g (cost=0.14..1.16 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=3)

  • Index Cond: (order_id = a.order_id)
Planning time : 757.521 ms
Execution time : 100.166 ms