explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CFa3

Settings
# exclusive inclusive rows x rows loops node
1. 7,114.182 21,550.099 ↓ 6.7 432,152 1

Sort (cost=288,720.92..288,883.09 rows=64,867 width=1,315) (actual time=20,305.827..21,550.099 rows=432,152 loops=1)

  • Sort Key: wf_hz.matter_number, imw_matter.end_date
  • Sort Method: external merge Disk: 130432kB
2.          

CTE imw_matter

3. 165.439 10,966.848 ↓ 6.7 432,175 1

Append (cost=1,000.90..183,233.12 rows=64,872 width=804) (actual time=13.673..10,966.848 rows=432,175 loops=1)

4. 5.148 493.954 ↓ 4.2 6,566 1

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

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

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

6. 4.119 24.648 ↓ 1,248.5 4,994 1

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

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

Hash Join (cost=456.97..840.87 rows=4 width=108) (actual time=6.137..14.279 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.045 3.045 ↑ 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.016..3.045 rows=7,843 loops=1)

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

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

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

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

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

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

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

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

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

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

15. 2.721 459.631 ↑ 1.0 1,572 1

Hash Right Join (cost=8,066.80..8,565.12 rows=1,572 width=97) (actual time=410.460..459.631 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))
16. 2.855 455.585 ↓ 21.2 1,526 1

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

  • Merge Cond: ((exex_user_numbering.system_matter_id)::text = (exex_user_count.system_matter_id)::text)
17. 7.214 387.533 ↓ 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.385..387.533 rows=1,526 loops=1)

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

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

19. 313.049 359.030 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=344.355..359.030 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. 19.461 45.981 ↓ 2.2 31,359 1

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

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

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

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

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

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

25. 13.464 57.579 ↑ 1.0 1,526 1

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

  • Group Key: imw_t_actv_executable_user_1.system_matter_id
26. 18.553 44.115 ↓ 2.2 31,359 1

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

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

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

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

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

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

31. 0.606 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.623 0.623 ↑ 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.012..0.623 rows=1,572 loops=1)

33. 869.654 10,307.455 ↓ 6.7 425,609 1

Hash Right Join (cost=90,785.73..172,580.73 rows=63,296 width=772) (actual time=7,235.071..10,307.455 rows=425,609 loops=1)

  • Hash Cond: ((his.system_matter_id)::text = (umttr_1.system_matter_id)::text)
34. 187.701 9,380.410 ↓ 270.5 427,181 1

Subquery Scan on his (cost=85,741.57..166,466.86 rows=1,579 width=762) (actual time=7,177.285..9,380.410 rows=427,181 loops=1)

35. 167.224 9,192.709 ↓ 270.5 427,181 1

Append (cost=85,741.57..166,451.07 rows=1,579 width=97) (actual time=7,177.283..9,192.709 rows=427,181 loops=1)

36. 468.541 8,529.192 ↓ 60,801.3 425,609 1

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

  • Merge Cond: ((ct_1.system_matter_id)::text = (cpl_user_1.system_matter_id)::text)
37. 228.877 696.203 ↓ 1.4 63,296 1

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

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

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

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

  • Sort Key: cpl_user_1.system_matter_id
  • Sort Method: external sort Disk: 54288kB
40. 1,887.277 2,706.311 ↓ 60,801.3 425,609 1

Hash Join (cost=39,706.92..85,741.05 rows=7 width=109) (actual time=579.334..2,706.311 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))
41. 240.184 240.184 ↑ 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.008..240.184 rows=568,653 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
42. 297.269 578.850 ↑ 1.0 425,609 1

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

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

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

45. 2.965 495.357 ↑ 1.0 1,572 1

Hash Right Join (cost=8,066.80..8,565.12 rows=1,572 width=97) (actual time=440.181..495.357 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))
46. 3.438 491.178 ↓ 21.2 1,526 1

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

  • Merge Cond: ((exex_user_numbering_1.system_matter_id)::text = (exex_user_count_1.system_matter_id)::text)
47. 8.239 407.466 ↓ 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=359.094..407.466 rows=1,526 loops=1)

  • Filter: (exex_user_numbering_1.row_num = 1)
  • Rows Removed by Filter: 29833
48. 23.170 399.227 ↓ 2.2 31,359 1

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

49. 328.414 376.057 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=359.058..376.057 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
50. 20.163 47.643 ↓ 2.2 31,359 1

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

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

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

  • Filter: ((locale_id)::text = 'ja'::text)
53. 8.054 80.274 ↑ 1.0 1,526 1

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

  • Sort Key: exex_user_count_1.system_matter_id
  • Sort Method: quicksort Memory: 168kB
54. 0.714 72.220 ↑ 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=70.966..72.220 rows=1,526 loops=1)

55. 16.417 71.506 ↑ 1.0 1,526 1

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

  • Group Key: imw_t_actv_executable_user_3.system_matter_id
56. 23.385 55.089 ↓ 2.2 31,359 1

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

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

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

  • Filter: ((locale_id)::text = 'ja'::text)
59. 0.649 1.214 ↑ 1.0 1,572 1

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

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

61. 31.362 57.391 ↑ 1.0 63,296 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 3716kB
62. 26.029 26.029 ↑ 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.008..26.029 rows=63,296 loops=1)

63. 830.754 14,435.917 ↓ 6.7 432,152 1

Hash Left Join (cost=37,021.11..63,052.75 rows=64,867 width=1,315) (actual time=1,192.667..14,435.917 rows=432,152 loops=1)

  • Hash Cond: ((wf_hz.system_matter_id)::text = (pos.system_matter_id)::text)
64. 708.772 13,080.729 ↓ 6.7 432,152 1

Hash Right Join (cost=32,712.04..55,419.21 rows=64,867 width=1,263) (actual time=668.186..13,080.729 rows=432,152 loops=1)

  • Hash Cond: ((imw_matter.system_matter_id)::text = (wf_hz.system_matter_id)::text)
65. 11,717.664 11,717.664 ↓ 6.7 432,175 1

CTE Scan on imw_matter (cost=0.00..1,297.44 rows=64,872 width=1,192) (actual time=13.678..11,717.664 rows=432,175 loops=1)

66. 55.624 654.293 ↑ 1.0 64,863 1

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

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

Hash Join (cost=14,491.54..30,634.20 rows=64,867 width=129) (actual time=245.198..598.669 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. 80.984 434.330 ↑ 1.0 64,863 1

Hash Join (cost=10,581.39..22,850.88 rows=64,867 width=96) (actual time=178.331..434.330 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. 73.430 281.222 ↑ 1.0 65,806 1

Hash Join (cost=6,394.30..14,766.57 rows=65,806 width=99) (actual time=105.934..281.222 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. 66.058 152.034 ↑ 1.0 65,806 1

Hash Join (cost=3,102.15..8,329.82 rows=65,806 width=58) (actual time=49.823..152.034 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.440 36.440 ↑ 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.440 rows=65,806 loops=1)

72. 30.613 49.536 ↑ 1.0 65,806 1

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

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

74. 32.346 55.758 ↑ 1.0 65,806 1

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

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

76. 37.044 72.124 ↑ 1.0 64,863 1

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

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

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

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

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

80. 0.819 524.434 ↓ 418.7 1,256 1

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

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

Hash Join (cost=81.72..4,309.04 rows=3 width=71) (actual time=2.104..523.615 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. 201.065 423.084 ↓ 372.4 347,081 1

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

83. 2.779 2.779 ↓ 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.779 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. 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))
85. 0.667 1.200 ↑ 1.0 1,572 1

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

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

Planning time : 13.856 ms
Execution time : 21,680.500 ms