explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yaem

Settings
# exclusive inclusive rows x rows loops node
1. 607.025 831.699 ↑ 9.2 6,430 1

Nested Loop Left Join (cost=92,998.77..155,356.12 rows=59,400 width=2,299) (actual time=204.169..831.699 rows=6,430 loops=1)

2. 5.523 224.674 ↑ 9.2 6,430 1

Hash Left Join (cost=92,998.48..94,611.31 rows=59,400 width=2,222) (actual time=203.969..224.674 rows=6,430 loops=1)

  • Hash Cond: (kcc.regionid = pr.regionid)
3. 8.517 217.250 ↑ 9.2 6,430 1

Merge Left Join (cost=92,815.38..94,272.12 rows=59,400 width=2,183) (actual time=202.051..217.250 rows=6,430 loops=1)

  • Merge Cond: ((kcc.tn_gongonerankshangid)::text = (((kkc.id)::character varying)::text))
4. 36.112 208.733 ↑ 2.6 6,430 1

Sort (cost=70,725.83..70,766.83 rows=16,401 width=2,178) (actual time=202.044..208.733 rows=6,430 loops=1)

  • Sort Key: kcc.tn_gongonerankshangid
  • Sort Method: external sort Disk: 11616kB
5. 4.147 172.621 ↑ 2.6 6,430 1

Hash Left Join (cost=318.36..54,104.14 rows=16,401 width=2,178) (actual time=4.064..172.621 rows=6,430 loops=1)

  • Hash Cond: ((kcc.tn_managereducation)::text = ((tqc.dictionaryid)::character varying)::text)
6. 6.266 168.119 ↑ 2.6 6,430 1

Nested Loop Left Join (cost=291.11..50,730.80 rows=16,401 width=2,168) (actual time=3.698..168.119 rows=6,430 loops=1)

7. 4.554 161.853 ↑ 2.6 6,430 1

Hash Left Join (cost=290.82..30,777.40 rows=16,401 width=2,150) (actual time=3.690..161.853 rows=6,430 loops=1)

  • Hash Cond: ((kcc.tn_deliverybase)::text = ((db.dickey)::character varying)::text)
8. 4.508 156.944 ↑ 2.6 6,430 1

Hash Left Join (cost=263.57..27,404.06 rows=16,401 width=2,144) (actual time=3.320..156.944 rows=6,430 loops=1)

  • Hash Cond: ((kcc.tn_landtype)::text = ((td.dickey)::character varying)::text)
9. 4.102 152.088 ↑ 2.6 6,430 1

Hash Left Join (cost=236.32..24,030.72 rows=16,401 width=2,137) (actual time=2.961..152.088 rows=6,430 loops=1)

  • Hash Cond: (kcc.tn_channelytype = kct.dictionaryid)
10. 4.490 147.688 ↑ 2.6 6,430 1

Hash Left Join (cost=209.07..23,960.10 rows=16,401 width=2,133) (actual time=2.651..147.688 rows=6,430 loops=1)

  • Hash Cond: ((kcc.tn_distributorlevel)::text = ((dj.dickey)::character varying)::text)
11. 4.080 142.846 ↑ 2.6 6,430 1

Hash Left Join (cost=181.82..20,586.76 rows=16,401 width=2,126) (actual time=2.285..142.846 rows=6,430 loops=1)

  • Hash Cond: ((kcc.tn_servertype)::text = ((tst.dictionaryid)::character varying)::text)
12. 4.085 138.419 ↑ 1.1 6,430 1

Hash Left Join (cost=154.57..19,020.36 rows=6,833 width=2,116) (actual time=1.922..138.419 rows=6,430 loops=1)

  • Hash Cond: ((kcc.tn_noneshoprank)::text = ((tnz.dictionaryid)::character varying)::text)
13. 4.072 133.981 ↓ 2.3 6,430 1

Hash Left Join (cost=127.32..18,351.82 rows=2,847 width=2,107) (actual time=1.557..133.981 rows=6,430 loops=1)

  • Hash Cond: ((kcc.tn_nongshoptype)::text = ((tnt.dictionaryid)::character varying)::text)
14. 5.213 129.557 ↓ 5.4 6,430 1

Hash Left Join (cost=100.07..18,057.42 rows=1,186 width=2,098) (actual time=1.186..129.557 rows=6,430 loops=1)

  • Hash Cond: ((kcc.tn_managementattributes)::text = ((sx.dickey)::character varying)::text)
15. 4.292 123.984 ↓ 5.4 6,430 1

Hash Left Join (cost=72.82..17,788.21 rows=1,186 width=2,096) (actual time=0.808..123.984 rows=6,430 loops=1)

  • Hash Cond: ((kcc.tn_contacteducation)::text = ((ed.dickey)::character varying)::text)
16. 4.197 119.337 ↓ 5.4 6,430 1

Hash Left Join (cost=45.57..17,518.99 rows=1,186 width=2,087) (actual time=0.437..119.337 rows=6,430 loops=1)

  • Hash Cond: (kcc.supplymode = cs.dickey)
17. 5.433 114.811 ↓ 5.4 6,430 1

Nested Loop Left Join (cost=18.32..17,487.29 rows=1,186 width=2,076) (actual time=0.097..114.811 rows=6,430 loops=1)

18. 7.791 96.518 ↓ 5.4 6,430 1

Nested Loop Left Join (cost=18.03..17,035.82 rows=1,186 width=1,933) (actual time=0.082..96.518 rows=6,430 loops=1)

19. 52.204 82.297 ↓ 5.4 6,430 1

Hash Join (cost=17.74..16,584.36 rows=1,186 width=1,919) (actual time=0.065..82.297 rows=6,430 loops=1)

  • Hash Cond: (kcc.channeltype = ct.dickey)
20. 30.052 30.052 ↑ 1.0 66,967 1

Seq Scan on ka_kq_channelcustomers kcc (cost=0.00..16,292.73 rows=69,873 width=1,908) (actual time=0.009..30.052 rows=66,967 loops=1)

21. 0.009 0.041 ↑ 1.0 9 1

Hash (cost=17.63..17.63 rows=9 width=19) (actual time=0.041..0.041 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
22. 0.017 0.032 ↑ 1.0 9 1

Bitmap Heap Scan on pl_dictionary ct (cost=4.34..17.63 rows=9 width=19) (actual time=0.022..0.032 rows=9 loops=1)

  • Recheck Cond: (parentdictionaryid = '896257431468904448'::bigint)
  • Filter: (platstatus = 1)
  • Heap Blocks: exact=3
23. 0.015 0.015 ↑ 1.0 9 1

Bitmap Index Scan on idx_pl_dictionary_parentdictionaryid (cost=0.00..4.34 rows=9 width=0) (actual time=0.015..0.015 rows=9 loops=1)

  • Index Cond: (parentdictionaryid = '896257431468904448'::bigint)
24. 6.430 6.430 ↑ 1.0 1 6,430

Index Scan using pl_orgstruct_orgstructid on pl_orgstruct po (cost=0.29..0.38 rows=1 width=22) (actual time=0.001..0.001 rows=1 loops=6,430)

  • Index Cond: (orgstructid = kcc.createop)
  • Filter: (platstatus = 1)
25. 12.860 12.860 ↑ 1.0 1 6,430

Index Scan using pl_orgstruct_orgstructid on pl_orgstruct sid (cost=0.29..0.38 rows=1 width=151) (actual time=0.002..0.002 rows=1 loops=6,430)

  • Index Cond: (kcc.saleareaid = orgstructid)
  • Filter: (platstatus = 1)
26. 0.123 0.329 ↓ 1.0 536 1

Hash (cost=20.62..20.62 rows=530 width=19) (actual time=0.329..0.329 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
27. 0.206 0.206 ↓ 1.0 536 1

Seq Scan on pl_dictionary cs (cost=0.00..20.62 rows=530 width=19) (actual time=0.006..0.206 rows=536 loops=1)

  • Filter: (platstatus = 1)
28. 0.189 0.355 ↓ 1.0 536 1

Hash (cost=20.62..20.62 rows=530 width=19) (actual time=0.355..0.355 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
29. 0.166 0.166 ↓ 1.0 536 1

Seq Scan on pl_dictionary ed (cost=0.00..20.62 rows=530 width=19) (actual time=0.002..0.166 rows=536 loops=1)

  • Filter: (platstatus = 1)
30. 0.198 0.360 ↓ 1.0 536 1

Hash (cost=20.62..20.62 rows=530 width=19) (actual time=0.360..0.360 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
31. 0.162 0.162 ↓ 1.0 536 1

Seq Scan on pl_dictionary sx (cost=0.00..20.62 rows=530 width=19) (actual time=0.002..0.162 rows=536 loops=1)

  • Filter: (platstatus = 1)
32. 0.194 0.352 ↓ 1.0 536 1

Hash (cost=20.62..20.62 rows=530 width=19) (actual time=0.352..0.352 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
33. 0.158 0.158 ↓ 1.0 536 1

Seq Scan on pl_dictionary tnt (cost=0.00..20.62 rows=530 width=19) (actual time=0.002..0.158 rows=536 loops=1)

  • Filter: (platstatus = 1)
34. 0.191 0.353 ↓ 1.0 536 1

Hash (cost=20.62..20.62 rows=530 width=19) (actual time=0.353..0.353 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
35. 0.162 0.162 ↓ 1.0 536 1

Seq Scan on pl_dictionary tnz (cost=0.00..20.62 rows=530 width=19) (actual time=0.002..0.162 rows=536 loops=1)

  • Filter: (platstatus = 1)
36. 0.191 0.347 ↓ 1.0 536 1

Hash (cost=20.62..20.62 rows=530 width=19) (actual time=0.347..0.347 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
37. 0.156 0.156 ↓ 1.0 536 1

Seq Scan on pl_dictionary tst (cost=0.00..20.62 rows=530 width=19) (actual time=0.002..0.156 rows=536 loops=1)

  • Filter: (platstatus = 1)
38. 0.196 0.352 ↓ 1.0 536 1

Hash (cost=20.62..20.62 rows=530 width=19) (actual time=0.352..0.352 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
39. 0.156 0.156 ↓ 1.0 536 1

Seq Scan on pl_dictionary dj (cost=0.00..20.62 rows=530 width=19) (actual time=0.002..0.156 rows=536 loops=1)

  • Filter: (platstatus = 1)
40. 0.124 0.298 ↓ 1.0 536 1

Hash (cost=20.62..20.62 rows=530 width=20) (actual time=0.298..0.298 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 38kB
41. 0.174 0.174 ↓ 1.0 536 1

Seq Scan on pl_dictionary kct (cost=0.00..20.62 rows=530 width=20) (actual time=0.002..0.174 rows=536 loops=1)

  • Filter: (platstatus = 1)
42. 0.191 0.348 ↓ 1.0 536 1

Hash (cost=20.62..20.62 rows=530 width=19) (actual time=0.348..0.348 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
43. 0.157 0.157 ↓ 1.0 536 1

Seq Scan on pl_dictionary td (cost=0.00..20.62 rows=530 width=19) (actual time=0.002..0.157 rows=536 loops=1)

  • Filter: (platstatus = 1)
44. 0.194 0.355 ↓ 1.0 536 1

Hash (cost=20.62..20.62 rows=530 width=19) (actual time=0.355..0.355 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
45. 0.161 0.161 ↓ 1.0 536 1

Seq Scan on pl_dictionary db (cost=0.00..20.62 rows=530 width=19) (actual time=0.002..0.161 rows=536 loops=1)

  • Filter: (platstatus = 1)
46. 0.000 0.000 ↓ 0.0 0 6,430

Index Scan using ka_kq_channelcustomers_pkey on ka_kq_channelcustomers ss (cost=0.29..1.22 rows=1 width=26) (actual time=0.000..0.000 rows=0 loops=6,430)

  • Index Cond: (kcc.superiorcustomer = id)
  • Filter: (platstatus = 1)
47. 0.198 0.355 ↓ 1.0 536 1

Hash (cost=20.62..20.62 rows=530 width=19) (actual time=0.354..0.355 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
48. 0.157 0.157 ↓ 1.0 536 1

Seq Scan on pl_dictionary tqc (cost=0.00..20.62 rows=530 width=19) (actual time=0.002..0.157 rows=536 loops=1)

  • Filter: (platstatus = 1)
49. 0.000 0.000 ↓ 0.0 0

Sort (cost=22,089.55..22,264.23 rows=69,873 width=26) (never executed)

  • Sort Key: (((kkc.id)::character varying)::text)
50. 0.000 0.000 ↓ 0.0 0

Seq Scan on ka_kq_channelcustomers kkc (cost=0.00..16,467.41 rows=69,873 width=26) (never executed)

  • Filter: (platstatus = 1)
51. 0.640 1.901 ↑ 1.0 3,404 1

Hash (cost=140.55..140.55 rows=3,404 width=47) (actual time=1.901..1.901 rows=3,404 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 309kB
52. 1.261 1.261 ↑ 1.0 3,404 1

Seq Scan on pl_region pr (cost=0.00..140.55 rows=3,404 width=47) (actual time=0.010..1.261 rows=3,404 loops=1)

  • Filter: (platstatus = 1)
53. 0.000 0.000 ↓ 0.0 0 6,430

Materialize (cost=0.29..8.31 rows=1 width=14) (actual time=0.000..0.000 rows=0 loops=6,430)

54. 0.009 0.009 ↓ 0.0 0 1

Index Scan using ix_pl_orgstruct_userinfoid on pl_orgstruct co (cost=0.29..8.31 rows=1 width=14) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (userinfoid = '1090226767253344256'::bigint)
  • Filter: (platstatus = 1)
Planning time : 23.619 ms
Execution time : 836.742 ms