explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CcKP

Settings
# exclusive inclusive rows x rows loops node
1. 710.588 12,915.805 ↓ 6.7 432,155 1

Hash Left Join (cost=38,040.60..236,777.92 rows=64,867 width=840) (actual time=1,237.210..12,915.805 rows=432,155 loops=1)

  • Hash Cond: ((wf_hz.system_matter_id)::text = (pos.system_matter_id)::text)
2. 757.357 11,663.204 ↓ 6.7 432,155 1

Hash Right Join (cost=33,720.60..229,133.46 rows=64,867 width=788) (actual time=695.152..11,663.204 rows=432,155 loops=1)

  • Hash Cond: (("*SELECT* 1".system_matter_id)::text = (wf_hz.system_matter_id)::text)
3. 184.857 10,224.274 ↓ 6.7 432,185 1

Append (cost=1,008.56..183,113.18 rows=64,909 width=678) (actual time=13.365..10,224.274 rows=432,185 loops=1)

4. 2.971 494.497 ↓ 4.1 6,576 1

Subquery Scan on *SELECT* 1 (cost=1,008.56..10,045.48 rows=1,613 width=677) (actual time=13.363..494.497 rows=6,576 loops=1)

5. 4.872 491.526 ↓ 4.1 6,576 1

Hash Right Join (cost=1,008.56..10,029.35 rows=1,613 width=645) (actual time=13.361..491.526 rows=6,576 loops=1)

  • Hash Cond: ((cpl_user.system_matter_id)::text = (umttr.system_matter_id)::text)
6. 2.413 485.544 ↓ 4.1 6,576 1

Append (cost=904.19..9,886.67 rows=1,613 width=97) (actual time=12.223..485.544 rows=6,576 loops=1)

7. 3.878 24.042 ↓ 1,250.2 5,001 1

Hash Left Join (cost=904.19..1,288.66 rows=4 width=135) (actual time=12.222..24.042 rows=5,001 loops=1)

  • Hash Cond: ((cpl_user.system_matter_id)::text = (ct.system_matter_id)::text)
8. 5.018 13.964 ↓ 1,250.2 5,001 1

Hash Join (cost=460.87..844.77 rows=4 width=108) (actual time=6.004..13.964 rows=5,001 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))
9. 2.993 2.993 ↓ 1.0 7,853 1

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

  • Filter: ((locale_id)::text = 'ja'::text)
10. 2.510 5.953 ↑ 1.0 5,001 1

Hash (cost=385.31..385.31 rows=5,037 width=85) (actual time=5.953..5.953 rows=5,001 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 649kB
11. 3.443 3.443 ↑ 1.0 5,001 1

Seq Scan on imw_t_cpl_task cplt (cost=0.00..385.31 rows=5,037 width=85) (actual time=0.010..3.443 rows=5,001 loops=1)

  • Filter: ((status)::text = ANY ('{apply,reapply,discontinue,pullback,sendbacktopullback,approve,sendback}'::text[]))
  • Rows Removed by Filter: 2852
12. 0.539 6.200 ↓ 1.6 1,575 1

Hash (cost=430.70..430.70 rows=1,010 width=27) (actual time=6.200..6.200 rows=1,575 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 115kB
13. 2.625 5.661 ↓ 1.6 1,575 1

HashAggregate (cost=410.50..420.60 rows=1,010 width=27) (actual time=5.256..5.661 rows=1,575 loops=1)

  • Group Key: ct.system_matter_id
14. 3.036 3.036 ↑ 1.0 5,001 1

Seq Scan on imw_t_cpl_task ct (cost=0.00..385.31 rows=5,037 width=27) (actual time=0.005..3.036 rows=5,001 loops=1)

  • Filter: ((status)::text = ANY ('{apply,reapply,discontinue,pullback,sendbacktopullback,approve,sendback}'::text[]))
  • Rows Removed by Filter: 2852
15. 0.856 459.089 ↑ 1.0 1,575 1

Subquery Scan on *SELECT* 2_1 (cost=8,082.03..8,597.97 rows=1,609 width=97) (actual time=409.713..459.089 rows=1,575 loops=1)

16. 2.573 458.233 ↑ 1.0 1,575 1

Hash Right Join (cost=8,082.03..8,581.88 rows=1,609 width=97) (actual time=409.710..458.233 rows=1,575 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))
17. 2.725 454.363 ↓ 21.2 1,529 1

Merge Join (cost=7,998.81..8,473.97 rows=72 width=67) (actual time=408.363..454.363 rows=1,529 loops=1)

  • Merge Cond: ((exex_user_numbering.system_matter_id)::text = (exex_user_count.system_matter_id)::text)
18. 7.100 385.936 ↓ 21.2 1,529 1

Subquery Scan on exex_user_numbering (cost=4,402.41..4,868.92 rows=72 width=59) (actual time=343.094..385.936 rows=1,529 loops=1)

  • Filter: (exex_user_numbering.row_num = 1)
  • Rows Removed by Filter: 29854
19. 20.822 378.836 ↓ 2.2 31,383 1

WindowAgg (cost=4,402.41..4,689.49 rows=14,354 width=59) (actual time=343.070..378.836 rows=31,383 loops=1)

20. 311.522 358.014 ↓ 2.2 31,383 1

Sort (cost=4,402.41..4,438.30 rows=14,354 width=59) (actual time=343.059..358.014 rows=31,383 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
21. 19.753 46.492 ↓ 2.2 31,383 1

Merge Join (cost=0.76..3,411.33 rows=14,354 width=59) (actual time=0.083..46.492 rows=31,383 loops=1)

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

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 129
23. 23.556 23.556 ↑ 1.0 31,622 1

Index Scan using idx_imw_t_actv_exe_user on imw_t_actv_executable_user (cost=0.29..2,789.69 rows=31,663 width=59) (actual time=0.017..23.556 rows=31,622 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
24. 6.680 65.702 ↑ 1.0 1,529 1

Sort (cost=3,596.39..3,600.27 rows=1,552 width=27) (actual time=65.262..65.702 rows=1,529 loops=1)

  • Sort Key: exex_user_count.system_matter_id
  • Sort Method: quicksort Memory: 168kB
25. 0.573 59.022 ↑ 1.0 1,529 1

Subquery Scan on exex_user_count (cost=3,483.10..3,514.14 rows=1,552 width=27) (actual time=58.001..59.022 rows=1,529 loops=1)

26. 13.953 58.449 ↑ 1.0 1,529 1

HashAggregate (cost=3,483.10..3,498.62 rows=1,552 width=26) (actual time=57.999..58.449 rows=1,529 loops=1)

  • Group Key: imw_t_actv_executable_user_1.system_matter_id
27. 18.617 44.496 ↓ 2.2 31,383 1

Merge Join (cost=0.76..3,411.33 rows=14,354 width=26) (actual time=0.094..44.496 rows=31,383 loops=1)

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

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 129
29. 22.736 22.736 ↑ 1.0 31,622 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,789.69 rows=31,663 width=26) (actual time=0.019..22.736 rows=31,622 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
30. 0.725 1.297 ↑ 1.0 1,575 1

Hash (cost=59.09..59.09 rows=1,609 width=65) (actual time=1.297..1.297 rows=1,575 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 166kB
31. 0.572 0.572 ↑ 1.0 1,575 1

Seq Scan on imw_t_actv_task task_1 (cost=0.00..59.09 rows=1,609 width=65) (actual time=0.005..0.572 rows=1,575 loops=1)

32. 0.553 1.110 ↓ 1.0 1,575 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 158kB
33. 0.557 0.557 ↓ 1.0 1,575 1

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

34. 202.778 9,544.920 ↓ 6.7 425,609 1

Subquery Scan on *SELECT* 2 (cost=90,723.73..173,067.70 rows=63,296 width=678) (actual time=6,351.154..9,544.920 rows=425,609 loops=1)

35. 629.741 9,342.142 ↓ 6.7 425,609 1

Hash Right Join (cost=90,723.73..172,434.74 rows=63,296 width=646) (actual time=6,351.152..9,342.142 rows=425,609 loops=1)

  • Hash Cond: ((his.system_matter_id)::text = (umttr_1.system_matter_id)::text)
36. 219.504 8,658.921 ↓ 264.3 427,184 1

Subquery Scan on his (cost=85,741.57..166,484.36 rows=1,616 width=644) (actual time=6,297.210..8,658.921 rows=427,184 loops=1)

37. 184.162 8,439.417 ↓ 264.3 427,184 1

Append (cost=85,741.57..166,468.20 rows=1,616 width=97) (actual time=6,297.207..8,439.417 rows=427,184 loops=1)

38. 498.783 7,757.708 ↓ 60,801.3 425,609 1

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

  • Merge Cond: ((ct_1.system_matter_id)::text = (cpl_user_1.system_matter_id)::text)
39. 242.396 762.280 ↓ 1.4 63,296 1

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

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

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

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

  • Sort Key: cpl_user_1.system_matter_id
  • Sort Method: external sort Disk: 54288kB
42. 983.242 1,773.950 ↓ 60,801.3 425,609 1

Hash Join (cost=39,706.92..85,741.05 rows=7 width=109) (actual time=568.093..1,773.950 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))
43. 223.079 223.079 ↑ 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..223.079 rows=568,653 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
44. 290.847 567.629 ↑ 1.0 425,609 1

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

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

  • Filter: ((status)::text = ANY ('{apply,reapply,discontinue,pullback,sendbacktopullback,approve,sendback}'::text[]))
  • Rows Removed by Filter: 143044
46. 0.881 497.547 ↑ 1.0 1,575 1

Subquery Scan on *SELECT* 2_2 (cost=8,082.03..8,597.97 rows=1,609 width=97) (actual time=448.311..497.547 rows=1,575 loops=1)

47. 2.434 496.666 ↑ 1.0 1,575 1

Hash Right Join (cost=8,082.03..8,581.88 rows=1,609 width=97) (actual time=448.310..496.666 rows=1,575 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))
48. 2.676 492.971 ↓ 21.2 1,529 1

Merge Join (cost=7,998.81..8,473.97 rows=72 width=67) (actual time=447.002..492.971 rows=1,529 loops=1)

  • Merge Cond: ((exex_user_numbering_1.system_matter_id)::text = (exex_user_count_1.system_matter_id)::text)
49. 7.186 424.430 ↓ 21.2 1,529 1

Subquery Scan on exex_user_numbering_1 (cost=4,402.41..4,868.92 rows=72 width=59) (actual time=381.550..424.430 rows=1,529 loops=1)

  • Filter: (exex_user_numbering_1.row_num = 1)
  • Rows Removed by Filter: 29854
50. 21.292 417.244 ↓ 2.2 31,383 1

WindowAgg (cost=4,402.41..4,689.49 rows=14,354 width=59) (actual time=381.535..417.244 rows=31,383 loops=1)

51. 343.428 395.952 ↓ 2.2 31,383 1

Sort (cost=4,402.41..4,438.30 rows=14,354 width=59) (actual time=381.517..395.952 rows=31,383 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
52. 21.802 52.524 ↓ 2.2 31,383 1

Merge Join (cost=0.76..3,411.33 rows=14,354 width=59) (actual time=0.084..52.524 rows=31,383 loops=1)

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

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 129
54. 27.460 27.460 ↑ 1.0 31,622 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,789.69 rows=31,663 width=59) (actual time=0.016..27.460 rows=31,622 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
55. 6.691 65.865 ↑ 1.0 1,529 1

Sort (cost=3,596.39..3,600.27 rows=1,552 width=27) (actual time=65.446..65.865 rows=1,529 loops=1)

  • Sort Key: exex_user_count_1.system_matter_id
  • Sort Method: quicksort Memory: 168kB
56. 0.582 59.174 ↑ 1.0 1,529 1

Subquery Scan on exex_user_count_1 (cost=3,483.10..3,514.14 rows=1,552 width=27) (actual time=58.183..59.174 rows=1,529 loops=1)

57. 13.770 58.592 ↑ 1.0 1,529 1

HashAggregate (cost=3,483.10..3,498.62 rows=1,552 width=26) (actual time=58.182..58.592 rows=1,529 loops=1)

  • Group Key: imw_t_actv_executable_user_3.system_matter_id
58. 18.789 44.822 ↓ 2.2 31,383 1

Merge Join (cost=0.76..3,411.33 rows=14,354 width=26) (actual time=0.091..44.822 rows=31,383 loops=1)

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

  • Index Cond: ((start_date <= now()) AND (end_date > now()) AND (delete_flag = '0'::text))
  • Heap Fetches: 129
60. 22.804 22.804 ↑ 1.0 31,622 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,789.69 rows=31,663 width=26) (actual time=0.016..22.804 rows=31,622 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
61. 0.696 1.261 ↑ 1.0 1,575 1

Hash (cost=59.09..59.09 rows=1,609 width=65) (actual time=1.261..1.261 rows=1,575 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 166kB
62. 0.565 0.565 ↑ 1.0 1,575 1

Seq Scan on imw_t_actv_task task_2 (cost=0.00..59.09 rows=1,609 width=65) (actual time=0.006..0.565 rows=1,575 loops=1)

63. 30.225 53.480 ↑ 1.0 63,296 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 3352kB
64. 23.255 23.255 ↑ 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.009..23.255 rows=63,296 loops=1)

65. 54.997 681.573 ↑ 1.0 64,864 1

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

  • Buckets: 32768 Batches: 4 Memory Usage: 2879kB
66. 97.911 626.576 ↑ 1.0 64,864 1

Hash Join (cost=14,491.54..30,634.20 rows=64,867 width=129) (actual time=272.459..626.576 rows=64,864 loops=1)

  • Hash Cond: (((hz.ks_cd)::text = (kh.ks_cd)::text) AND ((hz.data_kr_no)::text = (kh.data_kr_no)::text))
67. 81.954 461.899 ↑ 1.0 64,864 1

Hash Join (cost=10,581.39..22,850.88 rows=64,867 width=96) (actual time=205.254..461.899 rows=64,864 loops=1)

  • Hash Cond: (((hz.ks_cd)::text = (wf_hz.ks_cd)::text) AND ((ss_kh.data_no)::text = (wf_hz.data_no)::text))
68. 72.563 281.556 ↓ 1.0 65,807 1

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

  • Hash Cond: (((hz.ks_cd)::text = (ss_kh.ks_cd)::text) AND ((hz.data_no)::text = (ss_kh.data_no)::text))
69. 66.326 152.690 ↓ 1.0 65,807 1

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

  • Hash Cond: (((ks_sk.ks_cd)::text = (hz.ks_cd)::text) AND ((ks_sk.data_no)::text = (hz.data_no)::text))
70. 36.646 36.646 ↓ 1.0 65,807 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.646 rows=65,807 loops=1)

71. 30.933 49.718 ↓ 1.0 65,807 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 2636kB
72. 18.785 18.785 ↓ 1.0 65,807 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.785 rows=65,807 loops=1)

73. 32.710 56.303 ↓ 1.0 65,807 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 2896kB
74. 23.593 23.593 ↓ 1.0 65,807 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..23.593 rows=65,807 loops=1)

75. 51.310 98.389 ↑ 1.0 64,864 1

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

  • Buckets: 65536 Batches: 2 Memory Usage: 3496kB
76. 47.079 47.079 ↑ 1.0 64,864 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..47.079 rows=64,864 loops=1)

  • Filter: ((ki_wf_st)::text = ANY ('{05,10,90,91}'::text[]))
  • Rows Removed by Filter: 943
77. 43.453 66.766 ↓ 1.0 65,807 1

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

  • Buckets: 65536 Batches: 4 Memory Usage: 2311kB
78. 23.313 23.313 ↓ 1.0 65,807 1

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

79. 1.187 542.013 ↓ 419.7 1,259 1

Hash (cost=4,319.96..4,319.96 rows=3 width=71) (actual time=542.013..542.013 rows=1,259 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 140kB
80. 103.837 540.826 ↓ 419.7 1,259 1

Hash Join (cost=83.65..4,319.96 rows=3 width=71) (actual time=2.074..540.826 rows=1,259 loops=1)

  • Hash Cond: (((pos.system_matter_id)::text = (task.system_matter_id)::text) AND ((pos.node_name)::text = (task.node_name)::text))
81. 205.045 435.848 ↓ 372.4 347,099 1

Nested Loop (cost=0.42..4,229.72 rows=932 width=92) (actual time=0.092..435.848 rows=347,099 loops=1)

82. 2.743 2.743 ↓ 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.743 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
83. 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 (cost=0.42..1,003.53 rows=615 width=71) (actual time=0.010..0.181 rows=275 loops=1,260)

  • Index Cond: (((ks_cd)::text = (imd.company_cd)::text) AND ((approve_auth_dept_code)::text = (imd.department_cd)::text))
84. 0.610 1.141 ↑ 1.0 1,575 1

Hash (cost=59.09..59.09 rows=1,609 width=37) (actual time=1.141..1.141 rows=1,575 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 123kB
85. 0.531 0.531 ↑ 1.0 1,575 1

Seq Scan on imw_t_actv_task task (cost=0.00..59.09 rows=1,609 width=37) (actual time=0.004..0.531 rows=1,575 loops=1)

Planning time : 13.956 ms
Execution time : 13,017.577 ms