explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4y3L

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 2.262 ↑ 1.5 26 1

Sort (cost=355.24..355.34 rows=38 width=2,350) (actual time=2.259..2.262 rows=26 loops=1)

  • Sort Key: "*SELECT* 1".createtime DESC
  • Sort Method: quicksort Memory: 38kB
2. 0.019 2.218 ↑ 1.5 26 1

Hash Left Join (cost=301.04..354.24 rows=38 width=2,350) (actual time=1.885..2.218 rows=26 loops=1)

  • Hash Cond: ("*SELECT* 1".id = kt.costid)
3. 0.024 2.197 ↑ 1.0 26 1

Nested Loop Left Join (cost=260.30..312.11 rows=26 width=2,230) (actual time=1.877..2.197 rows=26 loops=1)

4. 0.016 2.147 ↑ 1.0 26 1

Hash Left Join (cost=260.02..287.90 rows=26 width=2,225) (actual time=1.870..2.147 rows=26 loops=1)

  • Hash Cond: ("*SELECT* 1".id = kr.costid)
5. 0.017 2.107 ↑ 1.0 26 1

Hash Left Join (cost=232.73..260.34 rows=26 width=1,767) (actual time=1.842..2.107 rows=26 loops=1)

  • Hash Cond: ("*SELECT* 1".saleareaid = ps.orgstructid)
6. 0.017 2.067 ↑ 1.0 26 1

Hash Left Join (cost=228.94..256.47 rows=26 width=1,633) (actual time=1.814..2.067 rows=26 loops=1)

  • Hash Cond: ("*SELECT* 1".id = kvd.costid)
7. 0.016 2.048 ↑ 1.0 26 1

Hash Left Join (cost=217.14..244.31 rows=26 width=797) (actual time=1.806..2.048 rows=26 loops=1)

  • Hash Cond: (kccc.salebranchorgid = ksbo.salebranchorgid)
8. 0.018 2.017 ↑ 1.0 26 1

Hash Left Join (cost=215.98..243.08 rows=26 width=769) (actual time=1.786..2.017 rows=26 loops=1)

  • Hash Cond: ("*SELECT* 1".id = kc.costid)
9. 0.016 1.676 ↑ 1.0 26 1

Hash Left Join (cost=177.37..204.17 rows=26 width=722) (actual time=1.459..1.676 rows=26 loops=1)

  • Hash Cond: ("*SELECT* 1".contractid = kccc.contractid)
10. 0.016 1.643 ↑ 1.0 26 1

Hash Left Join (cost=166.70..193.42 rows=26 width=722) (actual time=1.437..1.643 rows=26 loops=1)

  • Hash Cond: ("*SELECT* 1".createop = m.orgstructid)
11. 0.016 1.581 ↑ 1.0 26 1

Hash Left Join (cost=162.91..189.55 rows=26 width=713) (actual time=1.386..1.581 rows=26 loops=1)

  • Hash Cond: ("*SELECT* 1".costsubject = ksub3.id)
12. 0.016 1.546 ↑ 1.0 26 1

Hash Left Join (cost=157.94..184.50 rows=26 width=710) (actual time=1.363..1.546 rows=26 loops=1)

  • Hash Cond: ("*SELECT* 1".activitymode = ksub2.id)
13. 0.017 1.505 ↑ 1.0 26 1

Hash Left Join (cost=152.98..179.45 rows=26 width=707) (actual time=1.332..1.505 rows=26 loops=1)

  • Hash Cond: ("*SELECT* 1".costmodel = ksub1.id)
14. 0.129 1.418 ↑ 1.0 26 1

Hash Right Join (cost=148.01..174.41 rows=26 width=704) (actual time=1.256..1.418 rows=26 loops=1)

  • Hash Cond: (tpm.dickey = "*SELECT* 1".paytype)
15. 0.083 0.083 ↑ 1.0 581 1

Seq Scan on pl_dictionary tpm (cost=0.00..23.92 rows=592 width=21) (actual time=0.002..0.083 rows=581 loops=1)

16. 0.020 1.206 ↑ 1.0 26 1

Hash (cost=147.68..147.68 rows=26 width=699) (actual time=1.206..1.206 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
17. 0.115 1.186 ↑ 1.0 26 1

Hash Right Join (cost=121.28..147.68 rows=26 width=699) (actual time=1.135..1.186 rows=26 loops=1)

  • Hash Cond: (tc.dickey = "*SELECT* 1".category)
18. 0.079 0.079 ↑ 1.0 581 1

Seq Scan on pl_dictionary tc (cost=0.00..23.92 rows=592 width=21) (actual time=0.001..0.079 rows=581 loops=1)

19. 0.018 0.992 ↑ 1.0 26 1

Hash (cost=120.96..120.96 rows=26 width=694) (actual time=0.992..0.992 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
20. 0.005 0.974 ↑ 1.0 26 1

Append (cost=50.50..120.96 rows=26 width=694) (actual time=0.710..0.974 rows=26 loops=1)

21. 0.004 0.726 ↑ 1.0 10 1

Subquery Scan on *SELECT* 1 (cost=50.50..78.32 rows=10 width=694) (actual time=0.710..0.726 rows=10 loops=1)

22. 0.096 0.722 ↑ 1.0 10 1

Hash Right Join (cost=50.50..78.22 rows=10 width=2,462) (actual time=0.708..0.722 rows=10 loops=1)

  • Hash Cond: (kcp.dickey = kkc.channeltype)
23. 0.078 0.078 ↑ 1.0 581 1

Seq Scan on pl_dictionary kcp (cost=0.00..23.92 rows=592 width=8) (actual time=0.002..0.078 rows=581 loops=1)

24. 0.007 0.548 ↑ 1.0 10 1

Hash (cost=50.37..50.37 rows=10 width=702) (actual time=0.548..0.548 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
25. 0.010 0.541 ↑ 1.0 10 1

Hash Left Join (cost=24.09..50.37 rows=10 width=702) (actual time=0.362..0.541 rows=10 loops=1)

  • Hash Cond: (ks.distributor = kkc.id)
26. 0.096 0.450 ↑ 1.0 10 1

Hash Right Join (cost=15.71..41.95 rows=10 width=702) (actual time=0.276..0.450 rows=10 loops=1)

  • Hash Cond: (kst.dickey = ks.storetype)
27. 0.218 0.218 ↑ 1.0 581 1

Seq Scan on pl_dictionary kst (cost=0.00..23.92 rows=592 width=8) (actual time=0.010..0.218 rows=581 loops=1)

28. 0.011 0.136 ↑ 1.0 10 1

Hash (cost=15.59..15.59 rows=10 width=710) (actual time=0.136..0.136 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
29. 0.011 0.125 ↑ 1.0 10 1

Hash Join (cost=10.22..15.59 rows=10 width=710) (actual time=0.075..0.125 rows=10 loops=1)

  • Hash Cond: (kp.customerid = ks.id)
30. 0.072 0.072 ↑ 1.0 10 1

Seq Scan on kx_cost_plan kp (cost=0.00..5.33 rows=10 width=686) (actual time=0.027..0.072 rows=10 loops=1)

  • Filter: (customertype = '905324680615956480'::bigint)
  • Rows Removed by Filter: 16
31. 0.003 0.042 ↑ 5.0 2 1

Hash (cost=10.10..10.10 rows=10 width=32) (actual time=0.042..0.042 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
32. 0.039 0.039 ↑ 5.0 2 1

Seq Scan on kx_kq_store ks (cost=0.00..10.10 rows=10 width=32) (actual time=0.013..0.039 rows=2 loops=1)

33. 0.005 0.081 ↑ 1.1 15 1

Hash (cost=8.17..8.17 rows=17 width=16) (actual time=0.081..0.081 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
34. 0.076 0.076 ↑ 1.1 15 1

Seq Scan on ka_kq_channelcustomers kkc (cost=0.00..8.17 rows=17 width=16) (actual time=0.013..0.076 rows=15 loops=1)

35. 0.005 0.243 ↑ 1.0 16 1

Subquery Scan on *SELECT* 2 (cost=13.96..42.64 rows=16 width=694) (actual time=0.223..0.243 rows=16 loops=1)

36. 0.098 0.238 ↑ 1.0 16 1

Hash Right Join (cost=13.96..42.48 rows=16 width=1,690) (actual time=0.222..0.238 rows=16 loops=1)

  • Hash Cond: (kcp_1.dickey = kkc_1.channeltype)
37. 0.085 0.085 ↑ 1.0 581 1

Seq Scan on pl_dictionary kcp_1 (cost=0.00..23.92 rows=592 width=8) (actual time=0.001..0.085 rows=581 loops=1)

38. 0.011 0.055 ↑ 1.0 16 1

Hash (cost=13.76..13.76 rows=16 width=702) (actual time=0.055..0.055 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
39. 0.012 0.044 ↑ 1.0 16 1

Hash Join (cost=8.38..13.76 rows=16 width=702) (actual time=0.021..0.044 rows=16 loops=1)

  • Hash Cond: (kp_1.customerid = kkc_1.id)
40. 0.018 0.018 ↑ 1.0 16 1

Seq Scan on kx_cost_plan kp_1 (cost=0.00..5.33 rows=16 width=686) (actual time=0.003..0.018 rows=16 loops=1)

  • Filter: (customertype = '905324761813487616'::bigint)
  • Rows Removed by Filter: 10
41. 0.004 0.014 ↑ 1.1 15 1

Hash (cost=8.17..8.17 rows=17 width=24) (actual time=0.014..0.014 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
42. 0.010 0.010 ↑ 1.1 15 1

Seq Scan on ka_kq_channelcustomers kkc_1 (cost=0.00..8.17 rows=17 width=24) (actual time=0.002..0.010 rows=15 loops=1)

43. 0.012 0.070 ↑ 1.0 43 1

Hash (cost=4.43..4.43 rows=43 width=19) (actual time=0.070..0.070 rows=43 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
44. 0.058 0.058 ↑ 1.0 43 1

Seq Scan on kx_budget_subject ksub1 (cost=0.00..4.43 rows=43 width=19) (actual time=0.015..0.058 rows=43 loops=1)

45. 0.011 0.025 ↑ 1.0 43 1

Hash (cost=4.43..4.43 rows=43 width=19) (actual time=0.025..0.025 rows=43 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
46. 0.014 0.014 ↑ 1.0 43 1

Seq Scan on kx_budget_subject ksub2 (cost=0.00..4.43 rows=43 width=19) (actual time=0.001..0.014 rows=43 loops=1)

47. 0.009 0.019 ↑ 1.0 43 1

Hash (cost=4.43..4.43 rows=43 width=19) (actual time=0.019..0.019 rows=43 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
48. 0.010 0.010 ↑ 1.0 43 1

Seq Scan on kx_budget_subject ksub3 (cost=0.00..4.43 rows=43 width=19) (actual time=0.001..0.010 rows=43 loops=1)

49. 0.009 0.046 ↓ 1.0 36 1

Hash (cost=3.35..3.35 rows=35 width=25) (actual time=0.046..0.046 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
50. 0.037 0.037 ↓ 1.0 36 1

Seq Scan on pl_orgstruct m (cost=0.00..3.35 rows=35 width=25) (actual time=0.011..0.037 rows=36 loops=1)

51. 0.004 0.017 ↑ 2.1 14 1

Hash (cost=10.30..10.30 rows=30 width=16) (actual time=0.017..0.017 rows=14 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
52. 0.013 0.013 ↑ 2.1 14 1

Seq Scan on kx_channelorg_contract kccc (cost=0.00..10.30 rows=30 width=16) (actual time=0.010..0.013 rows=14 loops=1)

53. 0.006 0.323 ↓ 1.1 19 1

Hash (cost=38.40..38.40 rows=17 width=55) (actual time=0.323..0.323 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
54. 0.009 0.317 ↓ 1.1 19 1

Hash Left Join (cost=36.67..38.40 rows=17 width=55) (actual time=0.291..0.317 rows=19 loops=1)

  • Hash Cond: (kc.createop = m2.orgstructid)
55. 0.010 0.291 ↓ 1.1 19 1

Hash Left Join (cost=32.88..34.56 rows=17 width=46) (actual time=0.270..0.291 rows=19 loops=1)

  • Hash Cond: (kc.type = trt.dickey)
56. 0.017 0.045 ↓ 1.1 19 1

Hash Anti Join (cost=1.56..3.11 rows=17 width=41) (actual time=0.030..0.045 rows=19 loops=1)

  • Hash Cond: (kc.costid = tt.costid)
  • Join Filter: (tt.id > kc.id)
  • Rows Removed by Join Filter: 29
57. 0.014 0.014 ↓ 1.2 29 1

Seq Scan on kx_cost_report kc (cost=0.00..1.25 rows=25 width=49) (actual time=0.010..0.014 rows=29 loops=1)

58. 0.006 0.014 ↓ 1.2 29 1

Hash (cost=1.25..1.25 rows=25 width=16) (actual time=0.014..0.014 rows=29 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
59. 0.008 0.008 ↓ 1.2 29 1

Seq Scan on kx_cost_report tt (cost=0.00..1.25 rows=25 width=16) (actual time=0.003..0.008 rows=29 loops=1)

60. 0.122 0.236 ↑ 1.0 581 1

Hash (cost=23.92..23.92 rows=592 width=21) (actual time=0.236..0.236 rows=581 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
61. 0.114 0.114 ↑ 1.0 581 1

Seq Scan on pl_dictionary trt (cost=0.00..23.92 rows=592 width=21) (actual time=0.002..0.114 rows=581 loops=1)

62. 0.008 0.017 ↓ 1.0 36 1

Hash (cost=3.35..3.35 rows=35 width=25) (actual time=0.016..0.017 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
63. 0.009 0.009 ↓ 1.0 36 1

Seq Scan on pl_orgstruct m2 (cost=0.00..3.35 rows=35 width=25) (actual time=0.002..0.009 rows=36 loops=1)

64. 0.002 0.015 ↑ 1.2 6 1

Hash (cost=1.07..1.07 rows=7 width=44) (actual time=0.015..0.015 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
65. 0.013 0.013 ↑ 1.2 6 1

Seq Scan on kx_salebranchorg ksbo (cost=0.00..1.07 rows=7 width=44) (actual time=0.012..0.013 rows=6 loops=1)

66. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=10.80..10.80 rows=80 width=844) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
67. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on kx_cost_verification_detail kvd (cost=0.00..10.80 rows=80 width=844) (actual time=0.001..0.002 rows=0 loops=1)

68. 0.010 0.023 ↓ 1.0 36 1

Hash (cost=3.35..3.35 rows=35 width=150) (actual time=0.023..0.023 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
69. 0.013 0.013 ↓ 1.0 36 1

Seq Scan on pl_orgstruct ps (cost=0.00..3.35 rows=35 width=150) (actual time=0.002..0.013 rows=36 loops=1)

70. 0.003 0.024 ↑ 31.0 3 1

Hash (cost=26.13..26.13 rows=93 width=466) (actual time=0.024..0.024 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
71. 0.007 0.021 ↑ 31.0 3 1

Hash Anti Join (cost=13.15..26.13 rows=93 width=466) (actual time=0.019..0.021 rows=3 loops=1)

  • Hash Cond: (kr.costid = tt_2.costid)
  • Join Filter: (tt_2.id > kr.id)
  • Rows Removed by Join Filter: 6
72. 0.010 0.010 ↑ 23.3 6 1

Seq Scan on kx_cost_review kr (cost=0.00..11.40 rows=140 width=474) (actual time=0.009..0.010 rows=6 loops=1)

73. 0.002 0.004 ↑ 23.3 6 1

Hash (cost=11.40..11.40 rows=140 width=16) (actual time=0.004..0.004 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
74. 0.002 0.002 ↑ 23.3 6 1

Seq Scan on kx_cost_review tt_2 (cost=0.00..11.40 rows=140 width=16) (actual time=0.001..0.002 rows=6 loops=1)

75. 0.026 0.026 ↓ 0.0 0 26

Index Scan using idx_pl_dictionary_dickey on pl_dictionary ttr (cost=0.28..0.92 rows=1 width=21) (actual time=0.001..0.001 rows=0 loops=26)

  • Index Cond: (dickey = kr.execstatus)
76. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=37.10..37.10 rows=292 width=128) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
77. 0.001 0.002 ↓ 0.0 0 1

Hash Anti Join (cost=17.88..37.10 rows=292 width=128) (actual time=0.002..0.002 rows=0 loops=1)

  • Hash Cond: (kt.costid = tt_1.costid)
  • Join Filter: (tt_1.id > kt.id)
78. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on kx_cost_take kt (cost=0.00..13.50 rows=350 width=144) (actual time=0.001..0.001 rows=0 loops=1)

79. 0.000 0.000 ↓ 0.0 0

Hash (cost=13.50..13.50 rows=350 width=16) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Seq Scan on kx_cost_take tt_1 (cost=0.00..13.50 rows=350 width=16) (never executed)

Planning time : 6.604 ms
Execution time : 2.659 ms