explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s7w4

Settings
# exclusive inclusive rows x rows loops node
1. 368.411 23,320.668 ↓ 3.8 497,015 1

Merge Append (cost=372,119.86..375,363.21 rows=129,734 width=954) (actual time=21,261.451..23,320.668 rows=497,015 loops=1)

  • Sort Key: wf_hz.matter_number, imw_matter.end_date
2. 936.609 2,775.343 ↓ 1.1 69,839 1

Sort (cost=94,572.27..94,734.44 rows=64,867 width=1,315) (actual time=2,580.643..2,775.343 rows=69,839 loops=1)

  • Sort Key: wf_hz.matter_number, imw_matter.end_date
  • Sort Method: external merge Disk: 14000kB
3.          

CTE imw_matter

4. 4.932 492.348 ↓ 4.2 6,566 1

Hash Right Join (cost=1,000.90..10,003.67 rows=1,576 width=771) (actual time=13.599..492.348 rows=6,566 loops=1)

  • Hash Cond: ((cpl_user.system_matter_id)::text = (umttr.system_matter_id)::text)
5. 2.425 486.187 ↓ 4.2 6,566 1

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

6. 4.098 24.472 ↓ 1,248.5 4,994 1

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

  • Hash Cond: ((cpl_user.system_matter_id)::text = (ct.system_matter_id)::text)
7. 5.070 14.130 ↓ 1,248.5 4,994 1

Hash Join (cost=456.97..840.87 rows=4 width=108) (actual time=6.080..14.130 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))
8. 3.029 3.029 ↑ 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.012..3.029 rows=7,843 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
9. 2.374 6.031 ↑ 1.0 4,994 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 648kB
10. 3.657 3.657 ↑ 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.009..3.657 rows=4,994 loops=1)

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

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

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 115kB
12. 2.709 5.715 ↓ 1.6 1,572 1

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

  • Group Key: ct.system_matter_id
13. 3.006 3.006 ↑ 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..3.006 rows=4,994 loops=1)

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

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

15. 2.630 458.297 ↑ 1.0 1,572 1

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

  • Hash Cond: (((exex_user_numbering.system_matter_id)::text = (task_2.system_matter_id)::text) AND ((exex_user_numbering.node_id)::text = (task_2.node_id)::text))
16. 2.852 454.396 ↓ 21.2 1,526 1

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

  • Merge Cond: ((exex_user_numbering.system_matter_id)::text = (exex_user_count.system_matter_id)::text)
17. 7.117 386.575 ↓ 21.2 1,526 1

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

  • Filter: (exex_user_numbering.row_num = 1)
  • Rows Removed by Filter: 29833
18. 21.124 379.458 ↓ 2.2 31,359 1

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

19. 309.608 358.334 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=343.989..358.334 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
20. 20.487 48.726 ↓ 2.2 31,359 1

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

  • Merge Cond: ((us.user_cd)::text = (imw_t_actv_executable_user.auth_user_code)::text)
21. 3.210 3.210 ↓ 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.051..3.210 rows=3,564 loops=1)

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 107
22. 25.029 25.029 ↑ 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.012..25.029 rows=31,598 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
23. 7.042 64.969 ↑ 1.0 1,526 1

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

  • Sort Key: exex_user_count.system_matter_id
  • Sort Method: quicksort Memory: 168kB
24. 0.576 57.927 ↑ 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.923..57.927 rows=1,526 loops=1)

25. 13.476 57.351 ↑ 1.0 1,526 1

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

  • Group Key: imw_t_actv_executable_user_1.system_matter_id
26. 18.220 43.875 ↓ 2.2 31,359 1

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

  • Merge Cond: ((us_1.user_cd)::text = (imw_t_actv_executable_user_1.auth_user_code)::text)
27. 3.116 3.116 ↓ 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.058..3.116 rows=3,564 loops=1)

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 107
28. 22.539 22.539 ↑ 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.018..22.539 rows=31,598 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
29. 0.717 1.271 ↑ 1.0 1,572 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 166kB
30. 0.554 0.554 ↑ 1.0 1,572 1

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

31. 0.593 1.229 ↑ 1.0 1,572 1

Hash (cost=84.72..84.72 rows=1,572 width=67) (actual time=1.229..1.229 rows=1,572 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 176kB
32. 0.636 0.636 ↑ 1.0 1,572 1

Seq Scan on imw_t_actv_matter umttr (cost=0.00..84.72 rows=1,572 width=67) (actual time=0.013..0.636 rows=1,572 loops=1)

33. 110.266 1,838.734 ↓ 1.1 69,839 1

Hash Left Join (cost=37,021.11..42,133.55 rows=64,867 width=1,315) (actual time=1,184.586..1,838.734 rows=69,839 loops=1)

  • Hash Cond: ((wf_hz.system_matter_id)::text = (pos.system_matter_id)::text)
34. 55.889 1,204.100 ↓ 1.1 69,839 1

Hash Right Join (cost=32,712.04..34,500.01 rows=64,867 width=1,263) (actual time=660.169..1,204.100 rows=69,839 loops=1)

  • Hash Cond: ((imw_matter.system_matter_id)::text = (wf_hz.system_matter_id)::text)
35. 501.864 501.864 ↓ 4.2 6,566 1

CTE Scan on imw_matter (cost=0.00..31.52 rows=1,576 width=1,192) (actual time=13.605..501.864 rows=6,566 loops=1)

36. 55.001 646.347 ↑ 1.0 64,863 1

Hash (cost=30,634.20..30,634.20 rows=64,867 width=129) (actual time=646.347..646.347 rows=64,863 loops=1)

  • Buckets: 32768 Batches: 4 Memory Usage: 2879kB
37. 97.691 591.346 ↑ 1.0 64,863 1

Hash Join (cost=14,491.54..30,634.20 rows=64,867 width=129) (actual time=240.676..591.346 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))
38. 81.513 427.656 ↑ 1.0 64,863 1

Hash Join (cost=10,581.39..22,850.88 rows=64,867 width=96) (actual time=174.273..427.656 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))
39. 71.777 276.158 ↑ 1.0 65,806 1

Hash Join (cost=6,394.30..14,766.57 rows=65,806 width=99) (actual time=104.011..276.158 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))
40. 64.440 149.978 ↑ 1.0 65,806 1

Hash Join (cost=3,102.15..8,329.82 rows=65,806 width=58) (actual time=49.341..149.978 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))
41. 36.480 36.480 ↑ 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..36.480 rows=65,806 loops=1)

42. 30.404 49.058 ↑ 1.0 65,806 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 2636kB
43. 18.654 18.654 ↑ 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.004..18.654 rows=65,806 loops=1)

44. 31.366 54.403 ↑ 1.0 65,806 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 2896kB
45. 23.037 23.037 ↑ 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.006..23.037 rows=65,806 loops=1)

46. 35.754 69.985 ↑ 1.0 64,863 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 3496kB
47. 34.231 34.231 ↑ 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.231 rows=64,863 loops=1)

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

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

  • Buckets: 65536 Batches: 4 Memory Usage: 2311kB
49. 23.194 23.194 ↑ 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.194 rows=65,806 loops=1)

50. 0.806 524.368 ↓ 418.7 1,256 1

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

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 139kB
51. 100.468 523.562 ↓ 418.7 1,256 1

Hash Join (cost=81.72..4,309.04 rows=3 width=71) (actual time=2.084..523.562 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))
52. 199.974 421.941 ↓ 372.4 347,081 1

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

53. 2.727 2.727 ↓ 315.0 1,260 1

Seq Scan on imm_department imd (cost=0.00..190.98 rows=4 width=51) (actual time=0.019..2.727 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
54. 219.240 219.240 ↑ 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.174 rows=275 loops=1,260)

  • Index Cond: (((ks_cd)::text = (imd.company_cd)::text) AND ((approve_auth_dept_code)::text = (imd.department_cd)::text))
55. 0.654 1.153 ↑ 1.0 1,572 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 123kB
56. 0.499 0.499 ↑ 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.499 rows=1,572 loops=1)

57. 7,269.546 20,176.914 ↓ 6.6 427,176 1

Sort (cost=277,547.58..277,709.75 rows=64,867 width=1,315) (actual time=18,680.803..20,176.914 rows=427,176 loops=1)

  • Sort Key: wf_hz_1.matter_number, imw_matter_1.end_date
  • Sort Method: external merge Disk: 127440kB
58.          

CTE imw_matter

59. 505.374 9,469.175 ↓ 6.7 425,609 1

Hash Right Join (cost=90,785.73..172,580.73 rows=63,296 width=772) (actual time=6,835.966..9,469.175 rows=425,609 loops=1)

  • Hash Cond: ((his.system_matter_id)::text = (umttr_1.system_matter_id)::text)
60. 186.140 8,907.429 ↓ 270.5 427,181 1

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

61. 161.245 8,721.289 ↓ 270.5 427,181 1

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

62. 460.702 8,099.791 ↓ 60,801.3 425,609 1

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

  • Merge Cond: ((ct_1.system_matter_id)::text = (cpl_user_1.system_matter_id)::text)
63. 214.333 674.230 ↓ 1.4 63,296 1

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

  • Group Key: ct_1.system_matter_id
64. 459.897 459.897 ↑ 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.032..459.897 rows=425,609 loops=1)

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

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

  • Sort Key: cpl_user_1.system_matter_id
  • Sort Method: external sort Disk: 54288kB
66. 1,428.075 2,218.999 ↓ 60,801.3 425,609 1

Hash Join (cost=39,706.92..85,741.05 rows=7 width=109) (actual time=565.697..2,218.999 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))
67. 225.689 225.689 ↑ 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.009..225.689 rows=568,653 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
68. 290.633 565.235 ↑ 1.0 425,609 1

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

  • Buckets: 32768 Batches: 16 Memory Usage: 3423kB
69. 274.602 274.602 ↑ 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.008..274.602 rows=425,609 loops=1)

  • Filter: ((status)::text = ANY ('{apply,reapply,discontinue,pullback,sendbacktopullback,approve,sendback}'::text[]))
  • Rows Removed by Filter: 143044
70. 0.888 460.253 ↑ 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=411.264..460.253 rows=1,572 loops=1)

71. 2.479 459.365 ↑ 1.0 1,572 1

Hash Right Join (cost=8,066.80..8,565.12 rows=1,572 width=97) (actual time=411.262..459.365 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))
72. 2.793 455.660 ↓ 21.2 1,526 1

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

  • Merge Cond: ((exex_user_numbering_1.system_matter_id)::text = (exex_user_count_1.system_matter_id)::text)
73. 6.938 387.933 ↓ 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=345.455..387.933 rows=1,526 loops=1)

  • Filter: (exex_user_numbering_1.row_num = 1)
  • Rows Removed by Filter: 29833
74. 20.929 380.995 ↓ 2.2 31,359 1

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

75. 314.449 360.066 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=345.433..360.066 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
76. 19.008 45.617 ↓ 2.2 31,359 1

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

  • Merge Cond: ((us_2.user_cd)::text = (imw_t_actv_executable_user_2.auth_user_code)::text)
77. 3.142 3.142 ↓ 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.054..3.142 rows=3,564 loops=1)

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 107
78. 23.467 23.467 ↑ 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.013..23.467 rows=31,598 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
79. 6.981 64.934 ↑ 1.0 1,526 1

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

  • Sort Key: exex_user_count_1.system_matter_id
  • Sort Method: quicksort Memory: 168kB
80. 0.594 57.953 ↑ 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=56.923..57.953 rows=1,526 loops=1)

81. 13.535 57.359 ↑ 1.0 1,526 1

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

  • Group Key: imw_t_actv_executable_user_3.system_matter_id
82. 18.082 43.824 ↓ 2.2 31,359 1

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

  • Merge Cond: ((us_3.user_cd)::text = (imw_t_actv_executable_user_3.auth_user_code)::text)
83. 3.166 3.166 ↓ 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.060..3.166 rows=3,564 loops=1)

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 107
84. 22.576 22.576 ↑ 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.015..22.576 rows=31,598 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
85. 0.671 1.226 ↑ 1.0 1,572 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 166kB
86. 0.555 0.555 ↑ 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.007..0.555 rows=1,572 loops=1)

87. 30.608 56.372 ↑ 1.0 63,296 1

Hash (cost=3,510.96..3,510.96 rows=63,296 width=68) (actual time=56.372..56.372 rows=63,296 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 3716kB
88. 25.764 25.764 ↑ 1.0 63,296 1

Seq Scan on imw_t_cpl_matter umttr_1 (cost=0.00..3,510.96 rows=63,296 width=68) (actual time=0.012..25.764 rows=63,296 loops=1)

89. 819.718 12,907.368 ↓ 6.6 427,176 1

Hash Left Join (cost=37,021.11..62,531.79 rows=64,867 width=1,315) (actual time=8,037.319..12,907.368 rows=427,176 loops=1)

  • Hash Cond: ((wf_hz_1.system_matter_id)::text = (pos_1.system_matter_id)::text)
90. 691.179 11,565.887 ↓ 6.6 427,176 1

Hash Right Join (cost=32,712.04..54,898.25 rows=64,867 width=1,263) (actual time=7,515.505..11,565.887 rows=427,176 loops=1)

  • Hash Cond: ((imw_matter_1.system_matter_id)::text = (wf_hz_1.system_matter_id)::text)
91. 10,195.309 10,195.309 ↓ 6.7 425,609 1

CTE Scan on imw_matter imw_matter_1 (cost=0.00..1,265.92 rows=63,296 width=1,192) (actual time=6,835.972..10,195.309 rows=425,609 loops=1)

92. 55.018 679.399 ↑ 1.0 64,863 1

Hash (cost=30,634.20..30,634.20 rows=64,867 width=129) (actual time=679.399..679.399 rows=64,863 loops=1)

  • Buckets: 32768 Batches: 4 Memory Usage: 2879kB
93. 101.578 624.381 ↑ 1.0 64,863 1

Hash Join (cost=14,491.54..30,634.20 rows=64,867 width=129) (actual time=242.263..624.381 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))
94. 87.525 456.004 ↑ 1.0 64,863 1

Hash Join (cost=10,581.39..22,850.88 rows=64,867 width=96) (actual time=175.054..456.004 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))
95. 76.137 298.127 ↑ 1.0 65,806 1

Hash Join (cost=6,394.30..14,766.57 rows=65,806 width=99) (actual time=104.428..298.127 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))
96. 76.507 167.471 ↑ 1.0 65,806 1

Hash Join (cost=3,102.15..8,329.82 rows=65,806 width=58) (actual time=49.629..167.471 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))
97. 41.620 41.620 ↑ 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.007..41.620 rows=65,806 loops=1)

98. 30.619 49.344 ↑ 1.0 65,806 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 2636kB
99. 18.725 18.725 ↑ 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.725 rows=65,806 loops=1)

100. 31.561 54.519 ↑ 1.0 65,806 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 2896kB
101. 22.958 22.958 ↑ 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.004..22.958 rows=65,806 loops=1)

102. 36.475 70.352 ↑ 1.0 64,863 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 3496kB
103. 33.877 33.877 ↑ 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.014..33.877 rows=64,863 loops=1)

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

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

  • Buckets: 65536 Batches: 4 Memory Usage: 2311kB
105. 23.192 23.192 ↑ 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.013..23.192 rows=65,806 loops=1)

106. 0.774 521.763 ↓ 418.7 1,256 1

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

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 139kB
107. 98.527 520.989 ↓ 418.7 1,256 1

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

  • Hash Cond: (((pos_1.system_matter_id)::text = (task_1.system_matter_id)::text) AND ((pos_1.node_name)::text = (task_1.node_name)::text))
108. 198.120 421.342 ↓ 372.4 347,081 1

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

109. 2.722 2.722 ↓ 315.0 1,260 1

Seq Scan on imm_department imd_1 (cost=0.00..190.98 rows=4 width=51) (actual time=0.017..2.722 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
110. 220.500 220.500 ↑ 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.010..0.175 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))
111. 0.585 1.120 ↑ 1.0 1,572 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 123kB
112. 0.535 0.535 ↑ 1.0 1,572 1

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

Planning time : 23.541 ms
Execution time : 23,468.132 ms