explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pe7v

Settings
# exclusive inclusive rows x rows loops node
1. 343.439 27,231.775 ↓ 3.8 497,015 1

Merge Append (cost=328,134.52..331,377.87 rows=129,734 width=478) (actual time=25,403.329..27,231.775 rows=497,015 loops=1)

  • Sort Key: wf_hz.matter_number, cplt.end_date
2. 926.198 2,724.136 ↓ 1.1 69,839 1

Sort (cost=77,681.46..77,843.62 rows=64,867 width=839) (actual time=2,539.845..2,724.136 rows=69,839 loops=1)

  • Sort Key: wf_hz.matter_number, cplt.end_date
  • Sort Method: external merge Disk: 14008kB
3. 112.556 1,797.938 ↓ 1.1 69,839 1

Hash Left Join (cost=28,823.99..48,549.90 rows=64,867 width=839) (actual time=1,263.232..1,797.938 rows=69,839 loops=1)

  • Hash Cond: ((wf_hz.system_matter_id)::text = (pos.system_matter_id)::text)
4. 43.942 1,155.962 ↓ 1.1 69,839 1

Hash Left Join (cost=24,514.91..40,916.36 rows=64,867 width=787) (actual time=733.768..1,155.962 rows=69,839 loops=1)

  • Hash Cond: ((wf_hz.system_matter_id)::text = (umttr.system_matter_id)::text)
5. 114.570 620.195 ↑ 1.0 64,863 1

Hash Join (cost=14,491.54..30,634.20 rows=64,867 width=129) (actual time=241.930..620.195 rows=64,863 loops=1)

  • Hash Cond: (((hz.ks_cd)::text = (kh.ks_cd)::text) AND ((hz.data_kr_no)::text = (kh.data_kr_no)::text))
6. 87.455 439.288 ↑ 1.0 64,863 1

Hash Join (cost=10,581.39..22,850.88 rows=64,867 width=96) (actual time=175.168..439.288 rows=64,863 loops=1)

  • Hash Cond: (((hz.ks_cd)::text = (wf_hz.ks_cd)::text) AND ((ss_kh.data_no)::text = (wf_hz.data_no)::text))
7. 72.742 280.996 ↑ 1.0 65,806 1

Hash Join (cost=6,394.30..14,766.57 rows=65,806 width=99) (actual time=104.049..280.996 rows=65,806 loops=1)

  • Hash Cond: (((hz.ks_cd)::text = (ss_kh.ks_cd)::text) AND ((hz.data_no)::text = (ss_kh.data_no)::text))
8. 67.731 154.039 ↑ 1.0 65,806 1

Hash Join (cost=3,102.15..8,329.82 rows=65,806 width=58) (actual time=49.563..154.039 rows=65,806 loops=1)

  • Hash Cond: (((ks_sk.ks_cd)::text = (hz.ks_cd)::text) AND ((ks_sk.data_no)::text = (hz.data_no)::text))
9. 37.033 37.033 ↑ 1.0 65,806 1

Seq Scan on nwa8_t_ks_sk_kth_ss ks_sk (cost=0.00..2,789.06 rows=65,806 width=24) (actual time=0.004..37.033 rows=65,806 loops=1)

10. 30.672 49.275 ↑ 1.0 65,806 1

Hash (cost=1,600.06..1,600.06 rows=65,806 width=34) (actual time=49.275..49.275 rows=65,806 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2636kB
11. 18.603 18.603 ↑ 1.0 65,806 1

Seq Scan on nwbb_t_kth_ss_hz hz (cost=0.00..1,600.06 rows=65,806 width=34) (actual time=0.006..18.603 rows=65,806 loops=1)

12. 31.315 54.215 ↑ 1.0 65,806 1

Hash (cost=1,726.06..1,726.06 rows=65,806 width=41) (actual time=54.215..54.215 rows=65,806 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2896kB
13. 22.900 22.900 ↑ 1.0 65,806 1

Seq Scan on nwbc_t_kth_ss_kh ss_kh (cost=0.00..1,726.06 rows=65,806 width=41) (actual time=0.005..22.900 rows=65,806 loops=1)

14. 36.587 70.837 ↑ 1.0 64,863 1

Hash (cost=2,517.09..2,517.09 rows=64,867 width=61) (actual time=70.837..70.837 rows=64,863 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 3496kB
15. 34.250 34.250 ↑ 1.0 64,863 1

Seq Scan on nwa7_wf_hz_kth_ss wf_hz (cost=0.00..2,517.09 rows=64,867 width=61) (actual time=0.015..34.250 rows=64,863 loops=1)

  • Filter: ((ki_wf_st)::text = ANY ('{05,10,90,91}'::text[]))
  • Rows Removed by Filter: 943
16. 43.237 66.337 ↑ 1.0 65,806 1

Hash (cost=2,087.06..2,087.06 rows=65,806 width=78) (actual time=66.337..66.337 rows=65,806 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2311kB
17. 23.100 23.100 ↑ 1.0 65,806 1

Seq Scan on nwba_t_kth_kh kh (cost=0.00..2,087.06 rows=65,806 width=78) (actual time=0.007..23.100 rows=65,806 loops=1)

18. 4.786 491.825 ↓ 4.2 6,566 1

Hash (cost=10,003.67..10,003.67 rows=1,576 width=677) (actual time=491.825..491.825 rows=6,566 loops=1)

  • Buckets: 8192 (originally 2048) Batches: 1 (originally 1) Memory Usage: 1115kB
19. 4.655 487.039 ↓ 4.2 6,566 1

Hash Right Join (cost=1,000.90..10,003.67 rows=1,576 width=677) (actual time=13.478..487.039 rows=6,566 loops=1)

  • Hash Cond: ((cpl_user.system_matter_id)::text = (umttr.system_matter_id)::text)
20. 2.411 481.221 ↓ 4.2 6,566 1

Append (cost=896.53..9,861.87 rows=1,576 width=97) (actual time=12.302..481.221 rows=6,566 loops=1)

21. 3.723 23.435 ↓ 1,248.5 4,994 1

Hash Left Join (cost=896.53..1,280.99 rows=4 width=135) (actual time=12.301..23.435 rows=4,994 loops=1)

  • Hash Cond: ((cpl_user.system_matter_id)::text = (ct.system_matter_id)::text)
22. 4.629 13.528 ↓ 1,248.5 4,994 1

Hash Join (cost=456.97..840.87 rows=4 width=108) (actual time=6.097..13.528 rows=4,994 loops=1)

  • Hash Cond: (((cpl_user.system_matter_id)::text = (cplt.system_matter_id)::text) AND ((cpl_user.task_id)::text = (cplt.task_id)::text))
23. 2.864 2.864 ↑ 1.0 7,843 1

Seq Scan on imw_t_cpl_user cpl_user (cost=0.00..325.04 rows=7,843 width=61) (actual time=0.010..2.864 rows=7,843 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
24. 2.561 6.035 ↑ 1.0 4,994 1

Hash (cost=382.06..382.06 rows=4,994 width=85) (actual time=6.035..6.035 rows=4,994 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 648kB
25. 3.474 3.474 ↑ 1.0 4,994 1

Seq Scan on imw_t_cpl_task cplt (cost=0.00..382.06 rows=4,994 width=85) (actual time=0.011..3.474 rows=4,994 loops=1)

  • Filter: ((status)::text = ANY ('{apply,reapply,discontinue,pullback,sendbacktopullback,approve,sendback}'::text[]))
  • Rows Removed by Filter: 2849
26. 0.518 6.184 ↓ 1.6 1,572 1

Hash (cost=427.05..427.05 rows=1,001 width=27) (actual time=6.184..6.184 rows=1,572 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 115kB
27. 2.683 5.666 ↓ 1.6 1,572 1

HashAggregate (cost=407.03..417.04 rows=1,001 width=27) (actual time=5.238..5.666 rows=1,572 loops=1)

  • Group Key: ct.system_matter_id
28. 2.983 2.983 ↑ 1.0 4,994 1

Seq Scan on imw_t_cpl_task ct (cost=0.00..382.06 rows=4,994 width=27) (actual time=0.006..2.983 rows=4,994 loops=1)

  • Filter: ((status)::text = ANY ('{apply,reapply,discontinue,pullback,sendbacktopullback,approve,sendback}'::text[]))
  • Rows Removed by Filter: 2849
29. 0.889 455.375 ↑ 1.0 1,572 1

Subquery Scan on *SELECT* 2 (cost=8,066.80..8,580.84 rows=1,572 width=97) (actual time=406.911..455.375 rows=1,572 loops=1)

30. 2.426 454.486 ↑ 1.0 1,572 1

Hash Right Join (cost=8,066.80..8,565.12 rows=1,572 width=97) (actual time=406.909..454.486 rows=1,572 loops=1)

  • Hash Cond: (((exex_user_numbering.system_matter_id)::text = (task_1.system_matter_id)::text) AND ((exex_user_numbering.node_id)::text = (task_1.node_id)::text))
31. 2.720 450.764 ↓ 21.2 1,526 1

Merge Join (cost=7,985.50..8,459.69 rows=72 width=67) (actual time=405.577..450.764 rows=1,526 loops=1)

  • Merge Cond: ((exex_user_numbering.system_matter_id)::text = (exex_user_count.system_matter_id)::text)
32. 7.084 383.060 ↓ 21.2 1,526 1

Subquery Scan on exex_user_numbering (cost=4,394.69..4,860.22 rows=72 width=59) (actual time=340.993..383.060 rows=1,526 loops=1)

  • Filter: (exex_user_numbering.row_num = 1)
  • Rows Removed by Filter: 29833
33. 20.840 375.976 ↓ 2.2 31,359 1

WindowAgg (cost=4,394.69..4,681.17 rows=14,324 width=59) (actual time=340.982..375.976 rows=31,359 loops=1)

34. 308.829 355.136 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=340.972..355.136 rows=31,359 loops=1)

  • Sort Key: imw_t_actv_executable_user.system_matter_id, imw_t_actv_executable_user.auth_user_code
  • Sort Method: external merge Disk: 2136kB
35. 19.555 46.307 ↓ 2.2 31,359 1

Merge Join (cost=0.76..3,405.89 rows=14,324 width=59) (actual time=0.086..46.307 rows=31,359 loops=1)

  • Merge Cond: ((us.user_cd)::text = (imw_t_actv_executable_user.auth_user_code)::text)
36. 3.213 3.213 ↓ 1.3 3,564 1

Index Only Scan using imm_user_idx_ref_del on imm_user us (cost=0.29..491.44 rows=2,680 width=7) (actual time=0.060..3.213 rows=3,564 loops=1)

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 107
37. 23.539 23.539 ↑ 1.0 31,598 1

Index Scan using idx_imw_t_actv_exe_user on imw_t_actv_executable_user (cost=0.29..2,784.72 rows=31,598 width=59) (actual time=0.015..23.539 rows=31,598 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
38. 7.020 64.984 ↑ 1.0 1,526 1

Sort (cost=3,590.81..3,594.69 rows=1,552 width=27) (actual time=64.579..64.984 rows=1,526 loops=1)

  • Sort Key: exex_user_count.system_matter_id
  • Sort Method: quicksort Memory: 168kB
39. 0.567 57.964 ↑ 1.0 1,526 1

Subquery Scan on exex_user_count (cost=3,477.51..3,508.55 rows=1,552 width=27) (actual time=56.976..57.964 rows=1,526 loops=1)

40. 13.501 57.397 ↑ 1.0 1,526 1

HashAggregate (cost=3,477.51..3,493.03 rows=1,552 width=26) (actual time=56.976..57.397 rows=1,526 loops=1)

  • Group Key: imw_t_actv_executable_user_1.system_matter_id
41. 18.314 43.896 ↓ 2.2 31,359 1

Merge Join (cost=0.76..3,405.89 rows=14,324 width=26) (actual time=0.078..43.896 rows=31,359 loops=1)

  • Merge Cond: ((us_1.user_cd)::text = (imw_t_actv_executable_user_1.auth_user_code)::text)
42. 3.145 3.145 ↓ 1.3 3,564 1

Index Only Scan using imm_user_idx_ref_del on imm_user us_1 (cost=0.29..491.44 rows=2,680 width=7) (actual time=0.055..3.145 rows=3,564 loops=1)

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 107
43. 22.437 22.437 ↑ 1.0 31,598 1

Index Scan using idx_imw_t_actv_exe_user on imw_t_actv_executable_user imw_t_actv_executable_user_1 (cost=0.29..2,784.72 rows=31,598 width=26) (actual time=0.015..22.437 rows=31,598 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
44. 0.729 1.296 ↑ 1.0 1,572 1

Hash (cost=57.72..57.72 rows=1,572 width=65) (actual time=1.296..1.296 rows=1,572 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 166kB
45. 0.567 0.567 ↑ 1.0 1,572 1

Seq Scan on imw_t_actv_task task_1 (cost=0.00..57.72 rows=1,572 width=65) (actual time=0.005..0.567 rows=1,572 loops=1)

46. 0.602 1.163 ↑ 1.0 1,572 1

Hash (cost=84.72..84.72 rows=1,572 width=59) (actual time=1.163..1.163 rows=1,572 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 158kB
47. 0.561 0.561 ↑ 1.0 1,572 1

Seq Scan on imw_t_actv_matter umttr (cost=0.00..84.72 rows=1,572 width=59) (actual time=0.005..0.561 rows=1,572 loops=1)

48. 0.834 529.420 ↓ 418.7 1,256 1

Hash (cost=4,309.04..4,309.04 rows=3 width=71) (actual time=529.420..529.420 rows=1,256 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 139kB
49. 100.330 528.586 ↓ 418.7 1,256 1

Hash Join (cost=81.72..4,309.04 rows=3 width=71) (actual time=1.997..528.586 rows=1,256 loops=1)

  • Hash Cond: (((pos.system_matter_id)::text = (task.system_matter_id)::text) AND ((pos.node_name)::text = (task.node_name)::text))
50. 202.667 427.146 ↓ 372.4 347,081 1

Nested Loop (cost=0.42..4,220.72 rows=932 width=92) (actual time=0.089..427.146 rows=347,081 loops=1)

51. 2.719 2.719 ↓ 315.0 1,260 1

Seq Scan on imm_department imd (cost=0.00..190.98 rows=4 width=51) (actual time=0.022..2.719 rows=1,260 loops=1)

  • Filter: (((company_cd)::text = (department_set_cd)::text) AND ((locale_id)::text = 'ja'::text) AND ((delete_flag)::text = '0'::text) AND (start_date <= now()) AND (end_date > now()))
  • Rows Removed by Filter: 2121
52. 221.760 221.760 ↑ 2.2 275 1,260

Index Scan using idx_nwur_t_akb_sn_tts_pos_02 on nwur_t_akb_sn_tts_pos pos (cost=0.42..1,001.28 rows=615 width=71) (actual time=0.010..0.176 rows=275 loops=1,260)

  • Index Cond: (((ks_cd)::text = (imd.company_cd)::text) AND ((approve_auth_dept_code)::text = (imd.department_cd)::text))
53. 0.597 1.110 ↑ 1.0 1,572 1

Hash (cost=57.72..57.72 rows=1,572 width=37) (actual time=1.110..1.110 rows=1,572 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 123kB
54. 0.513 0.513 ↑ 1.0 1,572 1

Seq Scan on imw_t_actv_task task (cost=0.00..57.72 rows=1,572 width=37) (actual time=0.004..0.513 rows=1,572 loops=1)

55. 6,941.601 24,164.200 ↓ 6.6 427,176 1

Sort (cost=250,453.06..250,615.22 rows=64,867 width=840) (actual time=22,863.479..24,164.200 rows=427,176 loops=1)

  • Sort Key: wf_hz_1.matter_number, his.end_date
  • Sort Method: external merge Disk: 127392kB
56. 932.613 17,222.599 ↓ 6.6 427,176 1

Merge Left Join (cost=211,113.48..221,321.50 rows=64,867 width=840) (actual time=14,775.778..17,222.599 rows=427,176 loops=1)

  • Merge Cond: ((wf_hz_1.system_matter_id)::text = (pos_1.system_matter_id)::text)
57. 336.413 15,746.412 ↓ 6.6 427,176 1

Merge Left Join (cost=206,804.42..213,769.04 rows=64,867 width=788) (actual time=14,232.591..15,746.412 rows=427,176 loops=1)

  • Merge Cond: ((wf_hz_1.system_matter_id)::text = (umttr_1.system_matter_id)::text)
58. 647.015 1,274.872 ↑ 1.0 64,863 1

Sort (cost=40,253.26..40,415.43 rows=64,867 width=129) (actual time=1,156.614..1,274.872 rows=64,863 loops=1)

  • Sort Key: wf_hz_1.system_matter_id
  • Sort Method: external merge Disk: 9104kB
59. 101.693 627.857 ↑ 1.0 64,863 1

Hash Join (cost=14,491.54..30,634.20 rows=64,867 width=129) (actual time=241.379..627.857 rows=64,863 loops=1)

  • Hash Cond: (((hz_1.ks_cd)::text = (kh_1.ks_cd)::text) AND ((hz_1.data_kr_no)::text = (kh_1.data_kr_no)::text))
60. 84.771 460.164 ↑ 1.0 64,863 1

Hash Join (cost=10,581.39..22,850.88 rows=64,867 width=96) (actual time=175.163..460.164 rows=64,863 loops=1)

  • Hash Cond: (((hz_1.ks_cd)::text = (wf_hz_1.ks_cd)::text) AND ((ss_kh_1.data_no)::text = (wf_hz_1.data_no)::text))
61. 88.885 305.159 ↑ 1.0 65,806 1

Hash Join (cost=6,394.30..14,766.57 rows=65,806 width=99) (actual time=104.647..305.159 rows=65,806 loops=1)

  • Hash Cond: (((hz_1.ks_cd)::text = (ss_kh_1.ks_cd)::text) AND ((hz_1.data_no)::text = (ss_kh_1.data_no)::text))
62. 76.131 161.662 ↑ 1.0 65,806 1

Hash Join (cost=3,102.15..8,329.82 rows=65,806 width=58) (actual time=49.756..161.662 rows=65,806 loops=1)

  • Hash Cond: (((ks_sk_1.ks_cd)::text = (hz_1.ks_cd)::text) AND ((ks_sk_1.data_no)::text = (hz_1.data_no)::text))
63. 36.064 36.064 ↑ 1.0 65,806 1

Seq Scan on nwa8_t_ks_sk_kth_ss ks_sk_1 (cost=0.00..2,789.06 rows=65,806 width=24) (actual time=0.005..36.064 rows=65,806 loops=1)

64. 30.566 49.467 ↑ 1.0 65,806 1

Hash (cost=1,600.06..1,600.06 rows=65,806 width=34) (actual time=49.467..49.467 rows=65,806 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2636kB
65. 18.901 18.901 ↑ 1.0 65,806 1

Seq Scan on nwbb_t_kth_ss_hz hz_1 (cost=0.00..1,600.06 rows=65,806 width=34) (actual time=0.005..18.901 rows=65,806 loops=1)

66. 31.647 54.612 ↑ 1.0 65,806 1

Hash (cost=1,726.06..1,726.06 rows=65,806 width=41) (actual time=54.612..54.612 rows=65,806 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 2896kB
67. 22.965 22.965 ↑ 1.0 65,806 1

Seq Scan on nwbc_t_kth_ss_kh ss_kh_1 (cost=0.00..1,726.06 rows=65,806 width=41) (actual time=0.005..22.965 rows=65,806 loops=1)

68. 35.764 70.234 ↑ 1.0 64,863 1

Hash (cost=2,517.09..2,517.09 rows=64,867 width=61) (actual time=70.234..70.234 rows=64,863 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 3496kB
69. 34.470 34.470 ↑ 1.0 64,863 1

Seq Scan on nwa7_wf_hz_kth_ss wf_hz_1 (cost=0.00..2,517.09 rows=64,867 width=61) (actual time=0.015..34.470 rows=64,863 loops=1)

  • Filter: ((ki_wf_st)::text = ANY ('{05,10,90,91}'::text[]))
  • Rows Removed by Filter: 943
70. 43.033 66.000 ↑ 1.0 65,806 1

Hash (cost=2,087.06..2,087.06 rows=65,806 width=78) (actual time=66.000..66.000 rows=65,806 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2311kB
71. 22.967 22.967 ↑ 1.0 65,806 1

Seq Scan on nwba_t_kth_kh kh_1 (cost=0.00..2,087.06 rows=65,806 width=78) (actual time=0.014..22.967 rows=65,806 loops=1)

72. 342.863 14,135.127 ↓ 6.7 425,609 1

Materialize (cost=166,551.16..172,409.27 rows=63,296 width=678) (actual time=13,075.970..14,135.127 rows=425,609 loops=1)

73. 394.598 13,792.264 ↓ 6.7 425,609 1

Merge Left Join (cost=166,551.16..172,251.03 rows=63,296 width=678) (actual time=13,075.963..13,792.264 rows=425,609 loops=1)

  • Merge Cond: ((umttr_1.system_matter_id)::text = (his.system_matter_id)::text)
74. 110.301 110.301 ↑ 1.0 63,296 1

Index Scan using imw_t_cpl_matter_pkey on imw_t_cpl_matter umttr_1 (cost=0.41..5,518.37 rows=63,296 width=60) (actual time=0.022..110.301 rows=63,296 loops=1)

75. 4,932.259 13,287.365 ↓ 270.0 426,305 1

Sort (cost=166,550.74..166,554.69 rows=1,579 width=644) (actual time=13,075.933..13,287.365 rows=426,305 loops=1)

  • Sort Key: his.system_matter_id
  • Sort Method: external sort Disk: 41608kB
76. 184.306 8,355.106 ↓ 270.5 427,181 1

Subquery Scan on his (cost=85,741.57..166,466.86 rows=1,579 width=644) (actual time=6,292.844..8,355.106 rows=427,181 loops=1)

77. 159.321 8,170.800 ↓ 270.5 427,181 1

Append (cost=85,741.57..166,451.07 rows=1,579 width=97) (actual time=6,292.842..8,170.800 rows=427,181 loops=1)

78. 431.890 7,551.303 ↓ 60,801.3 425,609 1

Merge Right Join (cost=85,741.57..157,870.16 rows=7 width=136) (actual time=6,292.842..7,551.303 rows=425,609 loops=1)

  • Merge Cond: ((ct_1.system_matter_id)::text = (cpl_user_1.system_matter_id)::text)
79. 206.527 645.955 ↓ 1.4 63,296 1

GroupAggregate (cost=0.42..71,561.09 rows=45,424 width=27) (actual time=0.037..645.955 rows=63,296 loops=1)

  • Group Key: ct_1.system_matter_id
80. 439.428 439.428 ↑ 1.0 425,609 1

Index Scan using imw_t_cpl_matter_task_pkey on imw_t_cpl_matter_task ct_1 (cost=0.42..68,977.63 rows=425,845 width=27) (actual time=0.021..439.428 rows=425,609 loops=1)

  • Filter: ((status)::text = ANY ('{apply,reapply,discontinue,pullback,sendbacktopullback,approve,sendback}'::text[]))
  • Rows Removed by Filter: 143044
81. 4,677.834 6,473.458 ↓ 60,801.3 425,609 1

Sort (cost=85,741.15..85,741.16 rows=7 width=109) (actual time=6,292.774..6,473.458 rows=425,609 loops=1)

  • Sort Key: cpl_user_1.system_matter_id
  • Sort Method: external sort Disk: 54288kB
82. 1,002.746 1,795.624 ↓ 60,801.3 425,609 1

Hash Join (cost=39,706.92..85,741.05 rows=7 width=109) (actual time=567.703..1,795.624 rows=425,609 loops=1)

  • Hash Cond: (((cpl_user_1.system_matter_id)::text = (cplt_1.system_matter_id)::text) AND ((cpl_user_1.task_id)::text = (cplt_1.task_id)::text))
83. 225.639 225.639 ↑ 1.0 568,653 1

Seq Scan on imw_t_cpl_matter_user cpl_user_1 (cost=0.00..23,728.16 rows=568,653 width=61) (actual time=0.010..225.639 rows=568,653 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
84. 293.141 567.239 ↑ 1.0 425,609 1

Hash (cost=27,496.24..27,496.24 rows=425,845 width=86) (actual time=567.239..567.239 rows=425,609 loops=1)

  • Buckets: 32768 Batches: 16 Memory Usage: 3423kB
85. 274.098 274.098 ↑ 1.0 425,609 1

Seq Scan on imw_t_cpl_matter_task cplt_1 (cost=0.00..27,496.24 rows=425,845 width=86) (actual time=0.010..274.098 rows=425,609 loops=1)

  • Filter: ((status)::text = ANY ('{apply,reapply,discontinue,pullback,sendbacktopullback,approve,sendback}'::text[]))
  • Rows Removed by Filter: 143044
86. 0.932 460.176 ↑ 1.0 1,572 1

Subquery Scan on *SELECT* 2_1 (cost=8,066.80..8,580.84 rows=1,572 width=97) (actual time=409.317..460.176 rows=1,572 loops=1)

87. 2.736 459.244 ↑ 1.0 1,572 1

Hash Right Join (cost=8,066.80..8,565.12 rows=1,572 width=97) (actual time=409.315..459.244 rows=1,572 loops=1)

  • Hash Cond: (((exex_user_numbering_1.system_matter_id)::text = (task_3.system_matter_id)::text) AND ((exex_user_numbering_1.node_id)::text = (task_3.node_id)::text))
88. 2.745 455.277 ↓ 21.2 1,526 1

Merge Join (cost=7,985.50..8,459.69 rows=72 width=67) (actual time=408.026..455.277 rows=1,526 loops=1)

  • Merge Cond: ((exex_user_numbering_1.system_matter_id)::text = (exex_user_count_1.system_matter_id)::text)
89. 7.096 387.164 ↓ 21.2 1,526 1

Subquery Scan on exex_user_numbering_1 (cost=4,394.69..4,860.22 rows=72 width=59) (actual time=343.204..387.164 rows=1,526 loops=1)

  • Filter: (exex_user_numbering_1.row_num = 1)
  • Rows Removed by Filter: 29833
90. 21.034 380.068 ↓ 2.2 31,359 1

WindowAgg (cost=4,394.69..4,681.17 rows=14,324 width=59) (actual time=343.186..380.068 rows=31,359 loops=1)

91. 312.403 359.034 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=343.177..359.034 rows=31,359 loops=1)

  • Sort Key: imw_t_actv_executable_user_2.system_matter_id, imw_t_actv_executable_user_2.auth_user_code
  • Sort Method: external merge Disk: 2136kB
92. 19.634 46.631 ↓ 2.2 31,359 1

Merge Join (cost=0.76..3,405.89 rows=14,324 width=59) (actual time=0.084..46.631 rows=31,359 loops=1)

  • Merge Cond: ((us_2.user_cd)::text = (imw_t_actv_executable_user_2.auth_user_code)::text)
93. 3.191 3.191 ↓ 1.3 3,564 1

Index Only Scan using imm_user_idx_ref_del on imm_user us_2 (cost=0.29..491.44 rows=2,680 width=7) (actual time=0.057..3.191 rows=3,564 loops=1)

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 107
94. 23.806 23.806 ↑ 1.0 31,598 1

Index Scan using idx_imw_t_actv_exe_user on imw_t_actv_executable_user imw_t_actv_executable_user_2 (cost=0.29..2,784.72 rows=31,598 width=59) (actual time=0.019..23.806 rows=31,598 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
95. 7.115 65.368 ↑ 1.0 1,526 1

Sort (cost=3,590.81..3,594.69 rows=1,552 width=27) (actual time=64.815..65.368 rows=1,526 loops=1)

  • Sort Key: exex_user_count_1.system_matter_id
  • Sort Method: quicksort Memory: 168kB
96. 0.556 58.253 ↑ 1.0 1,526 1

Subquery Scan on exex_user_count_1 (cost=3,477.51..3,508.55 rows=1,552 width=27) (actual time=57.199..58.253 rows=1,526 loops=1)

97. 13.726 57.697 ↑ 1.0 1,526 1

HashAggregate (cost=3,477.51..3,493.03 rows=1,552 width=26) (actual time=57.198..57.697 rows=1,526 loops=1)

  • Group Key: imw_t_actv_executable_user_3.system_matter_id
98. 18.282 43.971 ↓ 2.2 31,359 1

Merge Join (cost=0.76..3,405.89 rows=14,324 width=26) (actual time=0.093..43.971 rows=31,359 loops=1)

  • Merge Cond: ((us_3.user_cd)::text = (imw_t_actv_executable_user_3.auth_user_code)::text)
99. 3.199 3.199 ↓ 1.3 3,564 1

Index Only Scan using imm_user_idx_ref_del on imm_user us_3 (cost=0.29..491.44 rows=2,680 width=7) (actual time=0.063..3.199 rows=3,564 loops=1)

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 107
100. 22.490 22.490 ↑ 1.0 31,598 1

Index Scan using idx_imw_t_actv_exe_user on imw_t_actv_executable_user imw_t_actv_executable_user_3 (cost=0.29..2,784.72 rows=31,598 width=26) (actual time=0.020..22.490 rows=31,598 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
101. 0.674 1.231 ↑ 1.0 1,572 1

Hash (cost=57.72..57.72 rows=1,572 width=65) (actual time=1.231..1.231 rows=1,572 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 166kB
102. 0.557 0.557 ↑ 1.0 1,572 1

Seq Scan on imw_t_actv_task task_3 (cost=0.00..57.72 rows=1,572 width=65) (actual time=0.005..0.557 rows=1,572 loops=1)

103. 6.245 543.574 ↓ 418.7 1,256 1

Sort (cost=4,309.06..4,309.07 rows=3 width=71) (actual time=543.146..543.574 rows=1,256 loops=1)

  • Sort Key: pos_1.system_matter_id
  • Sort Method: quicksort Memory: 225kB
104. 101.993 537.329 ↓ 418.7 1,256 1

Hash Join (cost=81.72..4,309.04 rows=3 width=71) (actual time=2.176..537.329 rows=1,256 loops=1)

  • Hash Cond: (((pos_1.system_matter_id)::text = (task_2.system_matter_id)::text) AND ((pos_1.node_name)::text = (task_2.node_name)::text))
105. 202.998 434.115 ↓ 372.4 347,081 1

Nested Loop (cost=0.42..4,220.72 rows=932 width=92) (actual time=0.101..434.115 rows=347,081 loops=1)

106. 3.057 3.057 ↓ 315.0 1,260 1

Seq Scan on imm_department imd_1 (cost=0.00..190.98 rows=4 width=51) (actual time=0.030..3.057 rows=1,260 loops=1)

  • Filter: (((company_cd)::text = (department_set_cd)::text) AND ((locale_id)::text = 'ja'::text) AND ((delete_flag)::text = '0'::text) AND (start_date <= now()) AND (end_date > now()))
  • Rows Removed by Filter: 2121
107. 228.060 228.060 ↑ 2.2 275 1,260

Index Scan using idx_nwur_t_akb_sn_tts_pos_02 on nwur_t_akb_sn_tts_pos pos_1 (cost=0.42..1,001.28 rows=615 width=71) (actual time=0.011..0.181 rows=275 loops=1,260)

  • Index Cond: (((ks_cd)::text = (imd_1.company_cd)::text) AND ((approve_auth_dept_code)::text = (imd_1.department_cd)::text))
108. 0.636 1.221 ↑ 1.0 1,572 1

Hash (cost=57.72..57.72 rows=1,572 width=37) (actual time=1.221..1.221 rows=1,572 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 123kB
109. 0.585 0.585 ↑ 1.0 1,572 1

Seq Scan on imw_t_actv_task task_2 (cost=0.00..57.72 rows=1,572 width=37) (actual time=0.004..0.585 rows=1,572 loops=1)

Planning time : 24.485 ms
Execution time : 27,500.203 ms