explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1v8X

Settings
# exclusive inclusive rows x rows loops node
1. 7,050.995 19,492.708 ↓ 6.7 432,152 1

Sort (cost=265,839.98..266,002.15 rows=64,867 width=840) (actual time=18,245.226..19,492.708 rows=432,152 loops=1)

  • Sort Key: wf_hz.matter_number, "*SELECT* 1".end_date
  • Sort Method: external merge Disk: 130432kB
2. 814.600 12,441.713 ↓ 6.7 432,152 1

Hash Left Join (cost=38,022.01..236,708.43 rows=64,867 width=840) (actual time=1,186.107..12,441.713 rows=432,152 loops=1)

  • Hash Cond: ((wf_hz.system_matter_id)::text = (pos.system_matter_id)::text)
3. 849.906 11,102.034 ↓ 6.7 432,152 1

Hash Right Join (cost=33,712.93..229,074.89 rows=64,867 width=788) (actual time=660.980..11,102.034 rows=432,152 loops=1)

  • Hash Cond: (("*SELECT* 1".system_matter_id)::text = (wf_hz.system_matter_id)::text)
4. 164.892 9,604.736 ↓ 6.7 432,175 1

Append (cost=1,000.90..183,063.12 rows=64,872 width=678) (actual time=13.380..9,604.736 rows=432,175 loops=1)

5. 2.894 490.737 ↓ 4.2 6,566 1

Subquery Scan on *SELECT* 1 (cost=1,000.90..10,019.43 rows=1,576 width=677) (actual time=13.379..490.737 rows=6,566 loops=1)

6. 4.863 487.843 ↓ 4.2 6,566 1

Hash Right Join (cost=1,000.90..10,003.67 rows=1,576 width=645) (actual time=13.377..487.843 rows=6,566 loops=1)

  • Hash Cond: ((cpl_user.system_matter_id)::text = (umttr.system_matter_id)::text)
7. 2.448 481.821 ↓ 4.2 6,566 1

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

8. 3.924 24.120 ↓ 1,248.5 4,994 1

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

  • Hash Cond: ((cpl_user.system_matter_id)::text = (ct.system_matter_id)::text)
9. 5.054 13.995 ↓ 1,248.5 4,994 1

Hash Join (cost=456.97..840.87 rows=4 width=108) (actual time=5.962..13.995 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))
10. 3.028 3.028 ↑ 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.028 rows=7,843 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
11. 2.336 5.913 ↑ 1.0 4,994 1

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

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

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

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

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 115kB
14. 2.630 5.664 ↓ 1.6 1,572 1

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

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

  • Filter: ((status)::text = ANY ('{apply,reapply,discontinue,pullback,sendbacktopullback,approve,sendback}'::text[]))
  • Rows Removed by Filter: 2849
16. 0.916 455.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=405.609..455.253 rows=1,572 loops=1)

17. 2.671 454.337 ↑ 1.0 1,572 1

Hash Right Join (cost=8,066.80..8,565.12 rows=1,572 width=97) (actual time=405.606..454.337 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))
18. 2.856 450.392 ↓ 21.2 1,526 1

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

  • Merge Cond: ((exex_user_numbering.system_matter_id)::text = (exex_user_count.system_matter_id)::text)
19. 7.042 382.406 ↓ 21.2 1,526 1

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

  • Filter: (exex_user_numbering.row_num = 1)
  • Rows Removed by Filter: 29833
20. 21.338 375.364 ↓ 2.2 31,359 1

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

21. 307.766 354.026 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=339.527..354.026 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
22. 19.583 46.260 ↓ 2.2 31,359 1

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

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

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

  • Filter: ((locale_id)::text = 'ja'::text)
25. 7.052 65.130 ↑ 1.0 1,526 1

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

  • Sort Key: exex_user_count.system_matter_id
  • Sort Method: quicksort Memory: 168kB
26. 0.557 58.078 ↑ 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=57.072..58.078 rows=1,526 loops=1)

27. 13.617 57.521 ↑ 1.0 1,526 1

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

  • Group Key: imw_t_actv_executable_user_1.system_matter_id
28. 18.351 43.904 ↓ 2.2 31,359 1

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

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

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

  • Filter: ((locale_id)::text = 'ja'::text)
31. 0.727 1.274 ↑ 1.0 1,572 1

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

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

33. 0.576 1.159 ↑ 1.0 1,572 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 158kB
34. 0.583 0.583 ↑ 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.013..0.583 rows=1,572 loops=1)

35. 187.398 8,949.107 ↓ 6.7 425,609 1

Subquery Scan on *SELECT* 2 (cost=90,723.73..173,043.69 rows=63,296 width=678) (actual time=6,059.569..8,949.107 rows=425,609 loops=1)

36. 578.832 8,761.709 ↓ 6.7 425,609 1

Hash Right Join (cost=90,723.73..172,410.73 rows=63,296 width=646) (actual time=6,059.567..8,761.709 rows=425,609 loops=1)

  • Hash Cond: ((his.system_matter_id)::text = (umttr_1.system_matter_id)::text)
37. 177.595 8,115.396 ↓ 270.5 427,181 1

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

38. 156.462 7,937.801 ↓ 270.5 427,181 1

Append (cost=85,741.57..166,451.07 rows=1,579 width=97) (actual time=5,991.681..7,937.801 rows=427,181 loops=1)

39. 438.509 7,255.614 ↓ 60,801.3 425,609 1

Merge Right Join (cost=85,741.57..157,870.16 rows=7 width=136) (actual time=5,991.681..7,255.614 rows=425,609 loops=1)

  • Merge Cond: ((ct_1.system_matter_id)::text = (cpl_user_1.system_matter_id)::text)
40. 207.804 646.440 ↓ 1.4 63,296 1

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

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

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

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

  • Sort Key: cpl_user_1.system_matter_id
  • Sort Method: external sort Disk: 54288kB
43. 712.438 1,503.298 ↓ 60,801.3 425,609 1

Hash Join (cost=39,706.92..85,741.05 rows=7 width=109) (actual time=567.781..1,503.298 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))
44. 223.547 223.547 ↑ 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.012..223.547 rows=568,653 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
45. 290.578 567.313 ↑ 1.0 425,609 1

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

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

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

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

48. 2.836 524.797 ↑ 1.0 1,572 1

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

  • Hash Cond: (((exex_user_numbering_1.system_matter_id)::text = (task_2.system_matter_id)::text) AND ((exex_user_numbering_1.node_id)::text = (task_2.node_id)::text))
49. 3.086 520.703 ↓ 21.2 1,526 1

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

  • Merge Cond: ((exex_user_numbering_1.system_matter_id)::text = (exex_user_count_1.system_matter_id)::text)
50. 7.681 444.672 ↓ 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=397.170..444.672 rows=1,526 loops=1)

  • Filter: (exex_user_numbering_1.row_num = 1)
  • Rows Removed by Filter: 29833
51. 23.095 436.991 ↓ 2.2 31,359 1

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

52. 362.267 413.896 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=397.130..413.896 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
53. 21.409 51.629 ↓ 2.2 31,359 1

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

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

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

  • Filter: ((locale_id)::text = 'ja'::text)
56. 7.686 72.945 ↑ 1.0 1,526 1

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

  • Sort Key: exex_user_count_1.system_matter_id
  • Sort Method: quicksort Memory: 168kB
57. 0.620 65.259 ↑ 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=64.035..65.259 rows=1,526 loops=1)

58. 15.572 64.639 ↑ 1.0 1,526 1

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

  • Group Key: imw_t_actv_executable_user_3.system_matter_id
59. 20.335 49.067 ↓ 2.2 31,359 1

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

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

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

  • Filter: ((locale_id)::text = 'ja'::text)
62. 0.694 1.258 ↑ 1.0 1,572 1

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

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

64. 37.593 67.481 ↑ 1.0 63,296 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 3352kB
65. 29.888 29.888 ↑ 1.0 63,296 1

Seq Scan on imw_t_cpl_matter umttr_1 (cost=0.00..3,510.96 rows=63,296 width=60) (actual time=0.007..29.888 rows=63,296 loops=1)

66. 54.160 647.392 ↑ 1.0 64,863 1

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

  • Buckets: 32768 Batches: 4 Memory Usage: 2879kB
67. 97.460 593.232 ↑ 1.0 64,863 1

Hash Join (cost=14,491.54..30,634.20 rows=64,867 width=129) (actual time=241.319..593.232 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))
68. 81.436 430.321 ↑ 1.0 64,863 1

Hash Join (cost=10,581.39..22,850.88 rows=64,867 width=96) (actual time=175.433..430.321 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))
69. 72.297 279.068 ↑ 1.0 65,806 1

Hash Join (cost=6,394.30..14,766.57 rows=65,806 width=99) (actual time=105.341..279.068 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))
70. 65.624 151.628 ↑ 1.0 65,806 1

Hash Join (cost=3,102.15..8,329.82 rows=65,806 width=58) (actual time=49.921..151.628 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))
71. 36.369 36.369 ↑ 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.005..36.369 rows=65,806 loops=1)

72. 30.705 49.635 ↑ 1.0 65,806 1

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

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

74. 32.199 55.143 ↑ 1.0 65,806 1

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

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

76. 35.722 69.817 ↑ 1.0 64,863 1

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

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

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

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

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

80. 0.820 525.079 ↓ 418.7 1,256 1

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

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 139kB
81. 99.763 524.259 ↓ 418.7 1,256 1

Hash Join (cost=81.72..4,309.04 rows=3 width=71) (actual time=2.014..524.259 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))
82. 200.141 423.376 ↓ 372.4 347,081 1

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

83. 2.735 2.735 ↓ 315.0 1,260 1

Seq Scan on imm_department imd (cost=0.00..190.98 rows=4 width=51) (actual time=0.020..2.735 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
84. 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 (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.company_cd)::text) AND ((approve_auth_dept_code)::text = (imd.department_cd)::text))
85. 0.613 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
86. 0.507 0.507 ↑ 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.005..0.507 rows=1,572 loops=1)

Planning time : 13.802 ms
Execution time : 19,614.400 ms