explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f0A9

Settings
# exclusive inclusive rows x rows loops node
1. 7,753.378 15,909.552 ↓ 6.7 432,152 1

Sort (cost=198,122.64..198,284.81 rows=64,867 width=840) (actual time=14,624.610..15,909.552 rows=432,152 loops=1)

  • Sort Key: wf_hz.matter_number, "*SELECT* 1".end_date
  • Sort Method: external merge Disk: 130448kB
2. 884.882 8,156.174 ↓ 6.7 432,152 1

Hash Left Join (cost=20,788.50..168,991.09 rows=64,867 width=840) (actual time=853.193..8,156.174 rows=432,152 loops=1)

  • Hash Cond: ((wf_hz.system_matter_id)::text = (pos.system_matter_id)::text)
3. 410.410 6,713.924 ↓ 6.7 432,152 1

Hash Join (cost=16,479.42..161,357.55 rows=64,867 width=788) (actual time=295.771..6,713.924 rows=432,152 loops=1)

  • Hash Cond: (((hz.ks_cd)::text = (ks_sk.ks_cd)::text) AND ((ss_kh.data_no)::text = (ks_sk.data_no)::text))
4. 413.055 6,242.395 ↓ 6.7 432,152 1

Hash Join (cost=12,703.27..156,446.22 rows=64,867 width=843) (actual time=234.149..6,242.395 rows=432,152 loops=1)

  • Hash Cond: (((hz.ks_cd)::text = (ss_kh.ks_cd)::text) AND ((hz.data_no)::text = (ss_kh.data_no)::text))
5. 422.477 5,776.208 ↓ 6.7 432,152 1

Hash Join (cost=9,990.12..152,597.90 rows=64,867 width=802) (actual time=180.488..5,776.208 rows=432,152 loops=1)

  • Hash Cond: (((hz.ks_cd)::text = (kh.ks_cd)::text) AND ((hz.data_kr_no)::text = (kh.data_kr_no)::text))
6. 404.528 5,296.066 ↓ 6.7 432,152 1

Hash Join (cost=6,915.97..148,388.58 rows=64,867 width=754) (actual time=122.303..5,296.066 rows=432,152 loops=1)

  • Hash Cond: (((wf_hz.ks_cd)::text = (hz.ks_cd)::text) AND ((wf_hz.data_no)::text = (hz.data_no)::text))
7. 380.775 4,845.919 ↓ 6.7 432,152 1

Hash Right Join (cost=4,328.82..144,666.26 rows=64,867 width=720) (actual time=76.148..4,845.919 rows=432,152 loops=1)

  • Hash Cond: (("*SELECT* 1".system_matter_id)::text = (wf_hz.system_matter_id)::text)
8. 171.609 4,402.696 ↓ 6.7 432,175 1

Append (cost=1,000.90..140,455.60 rows=64,872 width=678) (actual time=13.431..4,402.696 rows=432,175 loops=1)

9. 2.925 386.728 ↓ 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.431..386.728 rows=6,566 loops=1)

10. 5.197 383.803 ↓ 4.2 6,566 1

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

  • Hash Cond: ((cpl_user.system_matter_id)::text = (umttr.system_matter_id)::text)
11. 2.462 377.453 ↓ 4.2 6,566 1

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

12. 4.520 25.409 ↓ 1,248.5 4,994 1

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

  • Hash Cond: ((cpl_user.system_matter_id)::text = (ct.system_matter_id)::text)
13. 5.603 14.699 ↓ 1,248.5 4,994 1

Hash Join (cost=456.97..840.87 rows=4 width=108) (actual time=6.039..14.699 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))
14. 3.123 3.123 ↑ 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.013..3.123 rows=7,843 loops=1)

  • Filter: ((locale_id)::text = 'ja'::text)
15. 2.557 5.973 ↑ 1.0 4,994 1

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

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

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

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

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 115kB
18. 2.685 5.645 ↓ 1.6 1,572 1

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

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

  • Filter: ((status)::text = ANY ('{apply,reapply,discontinue,pullback,sendbacktopullback,approve,sendback}'::text[]))
  • Rows Removed by Filter: 2849
20. 0.951 349.582 ↑ 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=303.889..349.582 rows=1,572 loops=1)

21. 3.025 348.631 ↑ 1.0 1,572 1

Hash Right Join (cost=8,066.80..8,565.12 rows=1,572 width=97) (actual time=303.886..348.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))
22. 2.900 344.317 ↓ 21.2 1,526 1

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

  • Merge Cond: ((exex_user_numbering.system_matter_id)::text = (exex_user_count.system_matter_id)::text)
23. 6.951 275.332 ↓ 21.2 1,526 1

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

  • Filter: (exex_user_numbering.row_num = 1)
  • Rows Removed by Filter: 29833
24. 20.733 268.381 ↓ 2.2 31,359 1

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

25. 203.188 247.648 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=236.909..247.648 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: quicksort Memory: 5178kB
26. 19.058 44.460 ↓ 2.2 31,359 1

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

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

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

  • Filter: ((locale_id)::text = 'ja'::text)
29. 7.195 66.085 ↑ 1.0 1,526 1

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

  • Sort Key: exex_user_count.system_matter_id
  • Sort Method: quicksort Memory: 168kB
30. 0.590 58.890 ↑ 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.849..58.890 rows=1,526 loops=1)

31. 13.819 58.300 ↑ 1.0 1,526 1

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

  • Group Key: imw_t_actv_executable_user_1.system_matter_id
32. 18.595 44.481 ↓ 2.2 31,359 1

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

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

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

  • Filter: ((locale_id)::text = 'ja'::text)
35. 0.721 1.289 ↑ 1.0 1,572 1

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

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

37. 0.609 1.153 ↑ 1.0 1,572 1

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

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

39. 191.446 3,844.359 ↓ 6.7 425,609 1

Subquery Scan on *SELECT* 2 (cost=75,110.83..130,436.17 rows=63,296 width=678) (actual time=1,120.266..3,844.359 rows=425,609 loops=1)

40. 370.405 3,652.913 ↓ 6.7 425,609 1

Hash Right Join (cost=75,110.83..129,803.21 rows=63,296 width=646) (actual time=1,120.265..3,652.913 rows=425,609 loops=1)

  • Hash Cond: ((cpl_user_1.system_matter_id)::text = (umttr_1.system_matter_id)::text)
41. 163.242 3,233.916 ↓ 270.5 427,181 1

Append (cost=70,808.67..125,463.55 rows=1,579 width=97) (actual time=1,071.400..3,233.916 rows=427,181 loops=1)

42. 472.743 2,722.831 ↓ 60,801.3 425,609 1

Hash Left Join (cost=70,808.67..116,882.64 rows=7 width=136) (actual time=1,071.399..2,722.831 rows=425,609 loops=1)

  • Hash Cond: ((cpl_user_1.system_matter_id)::text = (ct_1.system_matter_id)::text)
43. 927.259 1,771.746 ↓ 60,801.3 425,609 1

Hash Join (cost=39,706.92..85,741.05 rows=7 width=109) (actual time=592.767..1,771.746 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. 252.367 252.367 ↑ 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.021..252.367 rows=568,653 loops=1)

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

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

  • Buckets: 131072 Batches: 4 Memory Usage: 13595kB
46. 294.265 294.265 ↑ 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.011..294.265 rows=425,609 loops=1)

  • Filter: ((status)::text = ANY ('{apply,reapply,discontinue,pullback,sendbacktopullback,approve,sendback}'::text[]))
  • Rows Removed by Filter: 143044
47. 22.470 478.342 ↓ 1.4 63,296 1

Hash (cost=30,533.95..30,533.95 rows=45,424 width=27) (actual time=478.342..478.342 rows=63,296 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 4468kB
48. 206.117 455.872 ↓ 1.4 63,296 1

HashAggregate (cost=29,625.47..30,079.71 rows=45,424 width=27) (actual time=429.352..455.872 rows=63,296 loops=1)

  • Group Key: ct_1.system_matter_id
49. 249.755 249.755 ↑ 1.0 425,609 1

Seq Scan on imw_t_cpl_matter_task ct_1 (cost=0.00..27,496.24 rows=425,845 width=27) (actual time=0.011..249.755 rows=425,609 loops=1)

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

51. 2.453 347.027 ↑ 1.0 1,572 1

Hash Right Join (cost=8,066.80..8,565.12 rows=1,572 width=97) (actual time=304.100..347.027 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))
52. 2.587 343.253 ↓ 21.2 1,526 1

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

  • Merge Cond: ((exex_user_numbering_1.system_matter_id)::text = (exex_user_count_1.system_matter_id)::text)
53. 6.871 274.803 ↓ 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=237.295..274.803 rows=1,526 loops=1)

  • Filter: (exex_user_numbering_1.row_num = 1)
  • Rows Removed by Filter: 29833
54. 20.135 267.932 ↓ 2.2 31,359 1

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

55. 203.308 247.797 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=237.256..247.797 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: quicksort Memory: 5178kB
56. 19.003 44.489 ↓ 2.2 31,359 1

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

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

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

  • Filter: ((locale_id)::text = 'ja'::text)
59. 7.158 65.863 ↑ 1.0 1,526 1

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

  • Sort Key: exex_user_count_1.system_matter_id
  • Sort Method: quicksort Memory: 168kB
60. 0.547 58.705 ↑ 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.658..58.705 rows=1,526 loops=1)

61. 13.698 58.158 ↑ 1.0 1,526 1

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

  • Group Key: imw_t_actv_executable_user_3.system_matter_id
62. 18.706 44.460 ↓ 2.2 31,359 1

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

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

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

  • Filter: ((locale_id)::text = 'ja'::text)
65. 0.741 1.321 ↑ 1.0 1,572 1

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

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

67. 25.413 48.592 ↑ 1.0 63,296 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 6204kB
68. 23.179 23.179 ↑ 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.010..23.179 rows=63,296 loops=1)

69. 28.838 62.448 ↑ 1.0 64,863 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 6467kB
70. 33.610 33.610 ↑ 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..33.610 rows=64,863 loops=1)

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

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

  • Buckets: 131072 Batches: 1 Memory Usage: 5266kB
72. 18.404 18.404 ↑ 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.007..18.404 rows=65,806 loops=1)

73. 34.938 57.665 ↑ 1.0 65,806 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 8262kB
74. 22.727 22.727 ↑ 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.006..22.727 rows=65,806 loops=1)

75. 29.236 53.132 ↑ 1.0 65,806 1

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

  • Buckets: 131072 Batches: 1 Memory Usage: 5784kB
76. 23.896 23.896 ↑ 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..23.896 rows=65,806 loops=1)

77. 26.626 61.119 ↑ 1.0 65,806 1

Hash (cost=2,789.06..2,789.06 rows=65,806 width=24) (actual time=61.119..61.119 rows=65,806 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4634kB
78. 34.493 34.493 ↑ 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.008..34.493 rows=65,806 loops=1)

79. 0.811 557.368 ↓ 418.7 1,256 1

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

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 139kB
80. 106.279 556.557 ↓ 418.7 1,256 1

Hash Join (cost=81.72..4,309.04 rows=3 width=71) (actual time=2.075..556.557 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))
81. 217.066 449.115 ↓ 372.4 347,081 1

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

82. 2.729 2.729 ↓ 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.729 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. 229.320 229.320 ↑ 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.182 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.657 1.163 ↑ 1.0 1,572 1

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

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

Planning time : 17.040 ms
Execution time : 16,041.811 ms