explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Pe0

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 77,450.198 ↓ 0.0 0 1

Limit (cost=4,182.53..4,343.25 rows=1 width=1,529) (actual time=77,450.198..77,450.198 rows=0 loops=1)

2. 31.773 77,450.196 ↓ 0.0 0 1

Nested Loop Left Join (cost=4,182.53..4,343.25 rows=1 width=1,529) (actual time=77,450.196..77,450.196 rows=0 loops=1)

  • Filter: ((hashed SubPlan 1) OR ((ps1.codepath)::text ~~ '1.1139717204409978880.1139717294344245248.1153493361248833536.%'::text))
  • Rows Removed by Filter: 15,575
3. 83.768 77,324.303 ↓ 15,575.0 15,575 1

Nested Loop Left Join (cost=3,967.76..4,128.39 rows=1 width=1,036) (actual time=42,985.179..77,324.303 rows=15,575 loops=1)

  • Join Filter: (vo.verificationid = kv.id)
  • Rows Removed by Join Filter: 778,750
  • Filter: ((kv.applystatus = 1) OR (kv.applystatus IS NULL))
4. 969.073 76,773.285 ↓ 15,575.0 15,575 1

Nested Loop Left Join (cost=3,967.76..4,123.61 rows=1 width=1,040) (actual time=42,985.136..76,773.285 rows=15,575 loops=1)

  • Join Filter: (vo.orderid = o.id)
  • Rows Removed by Join Filter: 8,535,100
5. 23.284 74,246.712 ↓ 15,575.0 15,575 1

Nested Loop Left Join (cost=3,967.76..4,102.29 rows=1 width=1,032) (actual time=42,984.997..74,246.712 rows=15,575 loops=1)

6. 21.803 74,223.428 ↓ 15,575.0 15,575 1

Nested Loop Left Join (cost=3,967.48..4,101.78 rows=1 width=1,030) (actual time=42,984.993..74,223.428 rows=15,575 loops=1)

7. 2,002.183 74,186.050 ↓ 15,575.0 15,575 1

Nested Loop Left Join (cost=3,967.20..4,093.98 rows=1 width=1,020) (actual time=42,984.989..74,186.050 rows=15,575 loops=1)

  • Join Filter: (o.id = r_3.exeid)
  • Rows Removed by Join Filter: 19,605,290
8. 16.014 48,746.502 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=3,808.81..3,886.02 rows=1 width=985) (actual time=42,982.909..48,746.502 rows=15,573 loops=1)

9. 19.880 48,730.488 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=3,808.53..3,885.52 rows=1 width=983) (actual time=42,982.896..48,730.488 rows=15,573 loops=1)

10. 117.430 48,710.608 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=3,808.25..3,877.21 rows=1 width=973) (actual time=42,982.884..48,710.608 rows=15,573 loops=1)

  • Join Filter: (o.id = r_2.exeid)
  • Rows Removed by Join Filter: 1,043,379
11. 1,062.239 47,456.349 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=3,728.09..3,794.70 rows=1 width=938) (actual time=42,982.409..47,456.349 rows=15,573 loops=1)

  • Join Filter: (plc1.orgstructid = o.salesmanid)
  • Rows Removed by Join Filter: 10,893,450
12. 16.167 43,357.375 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=2,984.81..3,031.08 rows=1 width=906) (actual time=42,974.913..43,357.375 rows=15,573 loops=1)

13. 19.940 43,341.208 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=2,984.53..3,022.76 rows=1 width=894) (actual time=42,974.903..43,341.208 rows=15,573 loops=1)

14. 16.025 43,305.695 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=2,984.26..3,019.97 rows=1 width=882) (actual time=42,974.895..43,305.695 rows=15,573 loops=1)

15. 15.819 43,289.670 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=2,983.98..3,011.65 rows=1 width=878) (actual time=42,974.887..43,289.670 rows=15,573 loops=1)

16. 17.437 43,273.851 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=2,983.71..3,008.86 rows=1 width=874) (actual time=42,974.879..43,273.851 rows=15,573 loops=1)

17. 21.962 43,256.414 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=2,983.43..3,000.55 rows=1 width=873) (actual time=42,974.872..43,256.414 rows=15,573 loops=1)

18. 61.792 43,203.306 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=2,983.15..2,997.13 rows=1 width=872) (actual time=42,974.864..43,203.306 rows=15,573 loops=1)

  • Join Filter: (p.goodsid = po.id)
  • Rows Removed by Join Filter: 124,097
19. 18.540 43,110.368 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=2,983.15..2,986.26 rows=1 width=860) (actual time=42,974.851..43,110.368 rows=15,573 loops=1)

20. 10.581 43,045.109 ↓ 15,573.0 15,573 1

Nested Loop Left Join (cost=2,982.88..2,982.95 rows=1 width=856) (actual time=42,974.833..43,045.109 rows=15,573 loops=1)

21. 26.675 43,018.955 ↓ 15,573.0 15,573 1

Merge Left Join (cost=2,982.60..2,982.64 rows=1 width=852) (actual time=42,974.827..43,018.955 rows=15,573 loops=1)

  • Merge Cond: ((o.id = r.execid) AND (kp.id = r.costid))
22. 161.810 42,988.215 ↓ 15,573.0 15,573 1

Sort (cost=2,416.86..2,416.87 rows=1 width=797) (actual time=42,970.806..42,988.215 rows=15,573 loops=1)

  • Sort Key: od.orderid DESC, od.costid
  • Sort Method: external merge Disk: 9,872kB
23. 27.992 42,826.405 ↓ 15,573.0 15,573 1

Merge Join (cost=1,132.10..2,416.85 rows=1 width=797) (actual time=93.919..42,826.405 rows=15,573 loops=1)

  • Merge Cond: (od.costid = p.costid)
  • Join Filter: (od.gpruleid = p.giftid)
  • Rows Removed by Join Filter: 89
24. 29,625.099 42,793.370 ↓ 819.6 15,573 1

Nested Loop Left Join (cost=1,128.49..9,263.94 rows=19 width=774) (actual time=93.844..42,793.370 rows=15,573 loops=1)

  • Join Filter: (r_1.execid = o.id)
  • Rows Removed by Join Filter: 138,715,783
25. 25.375 1,239.353 ↓ 819.6 15,573 1

Nested Loop Left Join (cost=7.05..7,836.06 rows=19 width=719) (actual time=32.075..1,239.353 rows=15,573 loops=1)

26. 20.325 1,213.978 ↓ 819.6 15,573 1

Nested Loop Left Join (cost=6.77..7,829.44 rows=19 width=648) (actual time=32.066..1,213.978 rows=15,573 loops=1)

27. 16.305 1,100.215 ↓ 819.6 15,573 1

Nested Loop Left Join (cost=6.48..7,818.31 rows=19 width=501) (actual time=32.040..1,100.215 rows=15,573 loops=1)

28. 11.707 1,006.045 ↓ 819.6 15,573 1

Nested Loop Left Join (cost=6.20..7,812.59 rows=19 width=430) (actual time=32.022..1,006.045 rows=15,573 loops=1)

29. 32.692 932.046 ↓ 819.6 15,573 1

Nested Loop Left Join (cost=5.93..7,806.79 rows=19 width=426) (actual time=32.009..932.046 rows=15,573 loops=1)

30. 14.366 852.635 ↓ 819.6 15,573 1

Nested Loop Left Join (cost=5.65..7,800.99 rows=19 width=422) (actual time=31.994..852.635 rows=15,573 loops=1)

31. 52.956 775.977 ↓ 819.6 15,573 1

Nested Loop Left Join (cost=5.38..7,795.19 rows=19 width=418) (actual time=31.972..775.977 rows=15,573 loops=1)

32. 32.133 333.721 ↓ 819.6 15,572 1

Nested Loop (cost=4.95..7,712.80 rows=19 width=366) (actual time=31.928..333.721 rows=15,572 loops=1)

33. 13.530 104.864 ↓ 293.2 17,884 1

Merge Join (cost=4.53..7,369.94 rows=61 width=142) (actual time=0.101..104.864 rows=17,884 loops=1)

  • Merge Cond: (od.costid = kp.id)
34. 91.108 91.108 ↓ 11.0 17,884 1

Index Scan using ix_kx_order_detail_2 on kx_order_detail od (cost=0.42..42,330.85 rows=1,623 width=52) (actual time=0.025..91.108 rows=17,884 loops=1)

  • Index Cond: (isgift = 1)
  • Filter: ((gpruleid IS NOT NULL) AND (platstatus = 1))
  • Rows Removed by Filter: 2
35. 0.226 0.226 ↓ 1.1 26 1

Index Scan using kx_cost_plan_pkey on kx_cost_plan kp (cost=0.14..91.39 rows=23 width=90) (actual time=0.070..0.226 rows=26 loops=1)

  • Filter: ((platstatus = 1) AND (costmodel = '1027741035423469568'::bigint))
  • Rows Removed by Filter: 73
36. 196.724 196.724 ↑ 1.0 1 17,884

Index Scan using kx_order_pkey on kx_order o (cost=0.42..5.62 rows=1 width=224) (actual time=0.011..0.011 rows=1 loops=17,884)

  • Index Cond: (id = od.orderid)
  • Filter: ((status <> ALL ('{110,140}'::integer[])) AND (createtime >= '2020-06-01 00:00:00'::timestamp without time zone) AND (createtime <= '2020-07-01 23:59:59'::timestamp without time zone) AND (platstatus = 1))
  • Rows Removed by Filter: 0
37. 389.300 389.300 ↑ 1.0 1 15,572

Index Scan using ix_kx_kq_store_storecode on kx_kq_store ks (cost=0.42..4.33 rows=1 width=62) (actual time=0.024..0.025 rows=1 loops=15,572)

  • Index Cond: ((o.customercode)::text = (storecode)::text)
  • Filter: (platstatus = 1)
  • Rows Removed by Filter: 0
38. 62.292 62.292 ↑ 1.0 1 15,573

Index Scan using idx_pl_dictionary_dickey on pl_dictionary st (cost=0.28..0.30 rows=1 width=20) (actual time=0.003..0.004 rows=1 loops=15,573)

  • Index Cond: (ks.storetype = dickey)
  • Filter: (platstatus = 1)
39. 46.719 46.719 ↑ 1.0 1 15,573

Index Scan using idx_pl_dictionary_dickey on pl_dictionary sle (cost=0.28..0.30 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=15,573)

  • Index Cond: (ks.storelevel = dickey)
  • Filter: (platstatus = 1)
40. 62.292 62.292 ↑ 1.0 1 15,573

Index Scan using idx_pl_dictionary_dickey on pl_dictionary tnl (cost=0.28..0.30 rows=1 width=20) (actual time=0.002..0.004 rows=1 loops=15,573)

  • Index Cond: (dickey = ks.tn_storedevicion)
  • Filter: (platstatus = 1)
41. 77.865 77.865 ↑ 1.0 1 15,573

Index Scan using pl_orgstruct_pkey on pl_orgstruct sl (cost=0.28..0.30 rows=1 width=87) (actual time=0.005..0.005 rows=1 loops=15,573)

  • Index Cond: (ks.seleareaid = orgstructid)
  • Filter: (platstatus = 1)
42. 93.438 93.438 ↓ 0.0 0 15,573

Index Scan using idx_ka_kq_channelcustomers_channelcode on ka_kq_channelcustomers kc (cost=0.29..0.58 rows=1 width=147) (actual time=0.006..0.006 rows=0 loops=15,573)

  • Index Cond: ((o.customercode)::text = (channelcode)::text)
  • Filter: (platstatus = 1)
43. 0.000 0.000 ↓ 0.0 0 15,573

Index Scan using pl_orgstruct_pkey on pl_orgstruct s2 (cost=0.28..0.35 rows=1 width=87) (actual time=0.000..0.000 rows=0 loops=15,573)

  • Index Cond: (kc.saleareaid = orgstructid)
  • Filter: (platstatus = 1)
44. 11,880.888 11,928.918 ↓ 198.0 8,908 15,573

Materialize (cost=1,121.44..1,415.17 rows=45 width=63) (actual time=0.002..0.766 rows=8,908 loops=15,573)

45. 2.023 48.030 ↓ 198.0 8,908 1

Subquery Scan on r_1 (cost=1,121.44..1,414.95 rows=45 width=63) (actual time=22.603..48.030 rows=8,908 loops=1)

  • Filter: (r_1.rownumber = 1)
  • Rows Removed by Filter: 1,006
46. 10.529 46.007 ↓ 1.1 9,914 1

WindowAgg (cost=1,121.44..1,302.06 rows=9,031 width=135) (actual time=22.601..46.007 rows=9,914 loops=1)

47. 19.534 35.478 ↓ 1.1 9,914 1

Sort (cost=1,121.44..1,144.02 rows=9,031 width=63) (actual time=22.587..35.478 rows=9,914 loops=1)

  • Sort Key: kx_cost_execrecord.execid, kx_cost_execrecord.examine_time DESC
  • Sort Method: quicksort Memory: 1,805kB
48. 15.944 15.944 ↓ 1.1 9,914 1

Seq Scan on kx_cost_execrecord (cost=0.00..528.08 rows=9,031 width=63) (actual time=0.012..15.944 rows=9,914 loops=1)

  • Filter: (((type = 1) OR (type IS NULL)) AND ((area = 1) OR (area IS NULL)) AND (platstatus = 1))
  • Rows Removed by Filter: 2,159
49. 5.002 5.043 ↓ 488.8 15,640 1

Sort (cost=3.61..3.69 rows=32 width=39) (actual time=0.064..5.043 rows=15,640 loops=1)

  • Sort Key: p.costid
  • Sort Method: quicksort Memory: 27kB
50. 0.041 0.041 ↓ 1.2 37 1

Seq Scan on kx_promotion_product p (cost=0.00..2.81 rows=32 width=39) (actual time=0.016..0.041 rows=37 loops=1)

  • Filter: ((goodsid IS NOT NULL) AND (platstatus = 1))
  • Rows Removed by Filter: 38
51. 0.321 4.065 ↓ 39.0 78 1

Sort (cost=565.74..565.75 rows=2 width=79) (actual time=4.011..4.065 rows=78 loops=1)

  • Sort Key: r.execid DESC, r.costid
  • Sort Method: quicksort Memory: 111kB
52. 0.075 3.744 ↓ 261.5 523 1

Subquery Scan on r (cost=549.14..565.73 rows=2 width=79) (actual time=3.299..3.744 rows=523 loops=1)

  • Filter: (r.rownumber = 1)
  • Rows Removed by Filter: 33
53. 0.365 3.669 ↓ 1.2 556 1

WindowAgg (cost=549.14..559.81 rows=474 width=135) (actual time=3.297..3.669 rows=556 loops=1)

54. 0.349 3.304 ↓ 1.2 556 1

Sort (cost=549.14..550.33 rows=474 width=79) (actual time=3.273..3.304 rows=556 loops=1)

  • Sort Key: kx_cost_execrecord_1.costid, kx_cost_execrecord_1.execid, kx_cost_execrecord_1.examine_time DESC
  • Sort Method: quicksort Memory: 113kB
55. 2.955 2.955 ↓ 1.2 556 1

Seq Scan on kx_cost_execrecord kx_cost_execrecord_1 (cost=0.00..528.08 rows=474 width=79) (actual time=0.087..2.955 rows=556 loops=1)

  • Filter: ((area = 2) AND (type = 1) AND (platstatus = 1))
  • Rows Removed by Filter: 11,517
56. 15.573 15.573 ↓ 0.0 0 15,573

Index Scan using idx_pl_dictionary_dickey on pl_dictionary kcs (cost=0.28..0.31 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=15,573)

  • Index Cond: (kc.channelcustomersort = dickey)
  • Filter: (platstatus = 1)
57. 46.719 46.719 ↑ 1.0 1 15,573

Index Scan using pl_dictionary_pkey on pl_dictionary gp (cost=0.28..3.29 rows=1 width=20) (actual time=0.003..0.003 rows=1 loops=15,573)

  • Index Cond: (p.giftid = dictionaryid)
  • Filter: (platstatus = 1)
58. 31.146 31.146 ↑ 8.3 9 15,573

Seq Scan on kx_kq_product po (cost=0.00..9.94 rows=75 width=28) (actual time=0.001..0.002 rows=9 loops=15,573)

  • Filter: (platstatus = 1)
59. 31.146 31.146 ↑ 1.0 1 15,573

Index Scan using pl_userinfo_pkey on pl_userinfo area_men (cost=0.28..3.41 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=15,573)

  • Index Cond: (userinfoid = r_1.tn_applyid)
  • Filter: (platstatus = 1)
60. 0.000 0.000 ↓ 0.0 0 15,573

Index Scan using pl_userinfo_pkey on pl_userinfo area_men1 (cost=0.28..8.30 rows=1 width=17) (actual time=0.000..0.000 rows=0 loops=15,573)

  • Index Cond: (userinfoid = r.tn_applyid)
  • Filter: (platstatus = 1)
61. 0.000 0.000 ↓ 0.0 0 15,573

Index Scan using pl_dictionary_pkey on pl_dictionary ts (cost=0.28..2.78 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=15,573)

  • Index Cond: (dictionaryid = r_1.state_class)
  • Filter: (platstatus = 1)
62. 0.000 0.000 ↓ 0.0 0 15,573

Index Scan using pl_dictionary_pkey on pl_dictionary ts1 (cost=0.28..8.29 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=15,573)

  • Index Cond: (dictionaryid = r.state_class)
  • Filter: (platstatus = 1)
63. 15.573 15.573 ↑ 1.0 1 15,573

Index Scan using pl_dictionary_pkey on pl_dictionary tcs (cost=0.28..2.78 rows=1 width=20) (actual time=0.001..0.001 rows=1 loops=15,573)

  • Index Cond: (dictionaryid = r_1.checktype)
  • Filter: (platstatus = 1)
64. 0.000 0.000 ↓ 0.0 0 15,573

Index Scan using pl_dictionary_pkey on pl_dictionary tcs1 (cost=0.28..8.29 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=15,573)

  • Index Cond: (dictionaryid = r.checktype)
  • Filter: (platstatus = 1)
65. 3,030.738 3,036.735 ↓ 1.2 701 15,573

HashAggregate (cost=743.28..750.54 rows=581 width=40) (actual time=0.001..0.195 rows=701 loops=15,573)

  • Group Key: plc1.orgstructid
66. 0.499 5.997 ↓ 2.7 1,554 1

Hash Join (cost=568.76..740.38 rows=581 width=18) (actual time=4.772..5.997 rows=1,554 loops=1)

  • Hash Cond: (plc1.parentorgstructid = plc2.orgstructid)
67. 0.768 0.768 ↓ 1.0 2,726 1

Seq Scan on pl_orgstruct plc1 (cost=0.00..155.71 rows=2,693 width=16) (actual time=0.011..0.768 rows=2,726 loops=1)

  • Filter: (platstatus = 1)
  • Rows Removed by Filter: 82
68. 0.143 4.730 ↓ 1.3 809 1

Hash (cost=561.26..561.26 rows=600 width=18) (actual time=4.730..4.730 rows=809 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 48kB
69. 0.312 4.587 ↓ 1.3 809 1

Hash Join (cost=388.10..561.26 rows=600 width=18) (actual time=3.577..4.587 rows=809 loops=1)

  • Hash Cond: (plc2.parentpositionid = plc3.orgstructid)
70. 0.737 0.737 ↓ 1.0 2,726 1

Seq Scan on pl_orgstruct plc2 (cost=0.00..155.71 rows=2,693 width=16) (actual time=0.003..0.737 rows=2,726 loops=1)

  • Filter: (platstatus = 1)
  • Rows Removed by Filter: 82
71. 0.480 3.538 ↓ 1.0 2,474 1

Hash (cost=358.47..358.47 rows=2,371 width=26) (actual time=3.538..3.538 rows=2,474 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 184kB
72. 0.527 3.058 ↓ 1.0 2,474 1

Hash Join (cost=189.38..358.47 rows=2,371 width=26) (actual time=1.621..3.058 rows=2,474 loops=1)

  • Hash Cond: (plc4.parentorgstructid = plc3.orgstructid)
73. 0.952 0.952 ↓ 1.0 2,477 1

Seq Scan on pl_orgstruct plc4 (cost=0.00..162.66 rows=2,448 width=18) (actual time=0.003..0.952 rows=2,477 loops=1)

  • Filter: ((platstatus = 1) AND (status = 1))
  • Rows Removed by Filter: 331
74. 0.397 1.579 ↓ 1.0 2,726 1

Hash (cost=155.71..155.71 rows=2,693 width=8) (actual time=1.579..1.579 rows=2,726 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 139kB
75. 1.182 1.182 ↓ 1.0 2,726 1

Seq Scan on pl_orgstruct plc3 (cost=0.00..155.71 rows=2,693 width=8) (actual time=0.003..1.182 rows=2,726 loops=1)

  • Filter: (platstatus = 1)
  • Rows Removed by Filter: 82
76. 171.303 1,136.829 ↓ 67.0 67 15,573

Subquery Scan on r_2 (cost=80.16..82.50 rows=1 width=43) (actual time=0.002..0.073 rows=67 loops=15,573)

  • Filter: (r_2.rownumber = '1'::bigint)
  • Rows Removed by Filter: 4
77. 887.661 965.526 ↑ 1.0 71 15,573

WindowAgg (cost=80.16..81.60 rows=72 width=537) (actual time=0.002..0.062 rows=71 loops=15,573)

78. 77.497 77.865 ↑ 1.0 71 15,573

Sort (cost=80.16..80.34 rows=72 width=51) (actual time=0.000..0.005 rows=71 loops=15,573)

  • Sort Key: t.exeid, t.platupdatetime DESC
  • Sort Method: quicksort Memory: 33kB
79. 0.368 0.368 ↑ 1.0 71 1

Seq Scan on kx_cost_active_check t (cost=0.00..77.94 rows=72 width=51) (actual time=0.011..0.368 rows=71 loops=1)

  • Filter: (((area = 2) OR (area IS NULL)) AND (platstatus = 1))
  • Rows Removed by Filter: 1,523
80. 0.000 0.000 ↓ 0.0 0 15,573

Index Scan using ix_pl_orgstruct_orgstructid on pl_orgstruct newm (cost=0.28..8.30 rows=1 width=26) (actual time=0.000..0.000 rows=0 loops=15,573)

  • Index Cond: (orgstructid = r_2.userid)
  • Filter: (platstatus = 1)
81. 0.000 0.000 ↓ 0.0 0 15,573

Index Scan using pl_orgstruct_pkey on pl_orgstruct post (cost=0.28..0.50 rows=1 width=18) (actual time=0.000..0.000 rows=0 loops=15,573)

  • Index Cond: (orgstructid = newm.parentorgstructid)
  • Filter: (platstatus = 1)
82. 2,927.724 23,437.365 ↓ 157.4 1,259 15,573

Subquery Scan on r_3 (cost=158.39..207.86 rows=8 width=43) (actual time=0.001..1.505 rows=1,259 loops=15,573)

  • Filter: (r_3.rownumber = '1'::bigint)
  • Rows Removed by Filter: 262
83. 18,469.578 20,509.641 ↑ 1.0 1,521 15,573

WindowAgg (cost=158.39..188.83 rows=1,522 width=537) (actual time=0.001..1.317 rows=1,521 loops=15,573)

84. 2,039.695 2,040.063 ↑ 1.0 1,521 15,573

Sort (cost=158.39..162.20 rows=1,522 width=51) (actual time=0.000..0.131 rows=1,521 loops=15,573)

  • Sort Key: t_1.exeid, t_1.platupdatetime DESC
  • Sort Method: quicksort Memory: 214kB
85. 0.368 0.368 ↑ 1.0 1,521 1

Seq Scan on kx_cost_active_check t_1 (cost=0.00..77.94 rows=1,522 width=51) (actual time=0.006..0.368 rows=1,521 loops=1)

  • Filter: ((area = 1) AND (platstatus = 1))
  • Rows Removed by Filter: 73
86. 15.575 15.575 ↓ 0.0 0 15,575

Index Scan using ix_pl_orgstruct_orgstructid on pl_orgstruct area_newm (cost=0.28..7.80 rows=1 width=26) (actual time=0.001..0.001 rows=0 loops=15,575)

  • Index Cond: (orgstructid = r_3.userid)
  • Filter: (platstatus = 1)
87. 0.000 0.000 ↓ 0.0 0 15,575

Index Scan using pl_orgstruct_pkey on pl_orgstruct area_post (cost=0.28..0.50 rows=1 width=18) (actual time=0.000..0.000 rows=0 loops=15,575)

  • Index Cond: (orgstructid = area_newm.parentorgstructid)
  • Filter: (platstatus = 1)
88. 1,557.500 1,557.500 ↓ 1.0 548 15,575

Seq Scan on kx_cost_verification_order vo (cost=0.00..14.66 rows=533 width=16) (actual time=0.005..0.100 rows=548 loops=15,575)

  • Filter: (platstatus = 1)
  • Rows Removed by Filter: 5
89. 467.250 467.250 ↑ 1.0 50 15,575

Seq Scan on kx_cost_verification kv (cost=0.00..4.03 rows=50 width=12) (actual time=0.002..0.030 rows=50 loops=15,575)

  • Filter: ((applystatus IS NOT NULL) AND (platstatus = 1))
  • Rows Removed by Filter: 32
90. 93.450 93.450 ↑ 1.0 1 15,575

Index Scan using pl_orgstruct_pkey on pl_orgstruct ps1 (cost=0.28..0.31 rows=1 width=113) (actual time=0.006..0.006 rows=1 loops=15,575)

  • Index Cond: (o.salesmanid = orgstructid)
  • Filter: ((platstatus = 1) AND (status = 1))
91.          

SubPlan (for Nested Loop Left Join)

92. 0.004 0.670 ↑ 1.0 3 1

Nested Loop (cost=4.30..214.48 rows=3 width=8) (actual time=0.075..0.670 rows=3 loops=1)

93. 0.643 0.643 ↑ 3.0 1 1

Seq Scan on pl_orgstruct u2 (cost=0.00..169.60 rows=3 width=8) (actual time=0.052..0.643 rows=1 loops=1)

  • Filter: ((parentpositionid = '1174611375889190912'::bigint) OR ((orgstructid = '1174611375889190912'::bigint) AND (platstatus = 1)))
  • Rows Removed by Filter: 2,807
94. 0.009 0.023 ↑ 1.0 3 1

Bitmap Heap Scan on pl_orgstruct u1 (cost=4.30..14.93 rows=3 width=16) (actual time=0.020..0.023 rows=3 loops=1)

  • Recheck Cond: (parentorgstructid = u2.orgstructid)
  • Filter: (platstatus = 1)
  • Heap Blocks: exact=4
95. 0.014 0.014 ↓ 1.3 4 1

Bitmap Index Scan on ix_pl_orgstruct_parentorgstructid (cost=0.00..4.30 rows=3 width=0) (actual time=0.014..0.014 rows=4 loops=1)

  • Index Cond: (parentorgstructid = u2.orgstructid)
Planning time : 295.236 ms
Execution time : 77,592.391 ms