explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vesw

Settings
# exclusive inclusive rows x rows loops node
1. 7,629.809 14,861.257 ↓ 6.7 432,152 1

Sort (cost=150,311.64..150,473.81 rows=64,867 width=840) (actual time=14,562.536..14,861.257 rows=432,152 loops=1)

  • Sort Key: wf_hz.matter_number, "*SELECT* 1".end_date
  • Sort Method: external merge Disk: 130472kB
2. 822.022 7,231.448 ↓ 6.7 432,152 1

Hash Left Join (cost=20,788.50..145,127.09 rows=64,867 width=840) (actual time=824.144..7,231.448 rows=432,152 loops=1)

  • Hash Cond: ((wf_hz.system_matter_id)::text = (pos.system_matter_id)::text)
3. 359.990 5,879.691 ↓ 6.7 432,152 1

Hash Join (cost=16,479.42..137,493.55 rows=64,867 width=788) (actual time=294.355..5,879.691 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. 369.561 5,458.556 ↓ 6.7 432,152 1

Hash Join (cost=12,703.27..132,582.22 rows=64,867 width=843) (actual time=232.693..5,458.556 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. 370.691 5,038.526 ↓ 6.7 432,152 1

Hash Join (cost=9,990.12..128,733.90 rows=64,867 width=802) (actual time=181.679..5,038.526 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. 354.148 4,609.714 ↓ 6.7 432,152 1

Hash Join (cost=6,915.97..124,524.58 rows=64,867 width=754) (actual time=123.030..4,609.714 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. 320.433 4,209.873 ↓ 6.7 432,152 1

Hash Right Join (cost=4,328.82..120,802.26 rows=64,867 width=720) (actual time=76.806..4,209.873 rows=432,152 loops=1)

  • Hash Cond: (("*SELECT* 1".system_matter_id)::text = (wf_hz.system_matter_id)::text)
8. 169.406 3,826.474 ↓ 6.7 432,175 1

Append (cost=1,000.90..116,591.60 rows=64,872 width=678) (actual time=13.559..3,826.474 rows=432,175 loops=1)

9. 2.890 393.891 ↓ 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.558..393.891 rows=6,566 loops=1)

10. 5.631 391.001 ↓ 4.2 6,566 1

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

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

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

12. 4.835 26.378 ↓ 1,248.5 4,994 1

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

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

Hash Join (cost=456.97..840.87 rows=4 width=108) (actual time=6.121..15.332 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.255 3.255 ↑ 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.255 rows=7,843 loops=1)

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

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

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

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

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

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

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

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

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

21. 3.110 354.499 ↑ 1.0 1,572 1

Hash Right Join (cost=8,066.80..8,565.12 rows=1,572 width=97) (actual time=309.142..354.499 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.959 350.098 ↓ 21.2 1,526 1

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

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

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

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

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

25. 208.562 253.136 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=242.037..253.136 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. 18.881 44.574 ↓ 2.2 31,359 1

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

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

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

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

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

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

31. 13.967 58.341 ↑ 1.0 1,526 1

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

  • Group Key: imw_t_actv_executable_user_1.system_matter_id
32. 18.476 44.374 ↓ 2.2 31,359 1

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

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

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

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

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

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

37. 0.630 1.178 ↑ 1.0 1,572 1

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

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

39. 192.004 3,263.177 ↓ 6.7 425,609 1

Subquery Scan on *SELECT* 2 (cost=69,287.83..106,572.17 rows=63,296 width=678) (actual time=1,070.105..3,263.177 rows=425,609 loops=1)

40. 318.877 3,071.173 ↓ 6.7 425,609 1

Hash Right Join (cost=69,287.83..105,939.21 rows=63,296 width=646) (actual time=1,070.103..3,071.173 rows=425,609 loops=1)

  • Hash Cond: ((cpl_user_1.system_matter_id)::text = (umttr_1.system_matter_id)::text)
41. 160.909 2,702.437 ↓ 270.5 427,181 1

Append (cost=64,985.67..101,599.55 rows=1,579 width=97) (actual time=1,019.948..2,702.437 rows=427,181 loops=1)

42. 379.981 2,198.029 ↓ 60,801.3 425,609 1

Hash Left Join (cost=64,985.67..93,018.64 rows=7 width=136) (actual time=1,019.946..2,198.029 rows=425,609 loops=1)

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

Hash Join (cost=33,883.92..61,877.05 rows=7 width=109) (actual time=529.130..1,327.522 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. 262.907 262.907 ↑ 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.020..262.907 rows=568,653 loops=1)

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

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

  • Buckets: 524288 Batches: 1 Memory Usage: 54383kB
46. 272.547 272.547 ↑ 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.020..272.547 rows=425,609 loops=1)

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

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

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

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

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

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

51. 2.413 342.673 ↑ 1.0 1,572 1

Hash Right Join (cost=8,066.80..8,565.12 rows=1,572 width=97) (actual time=300.507..342.673 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.568 339.044 ↓ 21.2 1,526 1

Merge Join (cost=7,985.50..8,459.69 rows=72 width=67) (actual time=299.231..339.044 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.854 270.617 ↓ 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=233.821..270.617 rows=1,526 loops=1)

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

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

55. 199.628 243.580 ↓ 2.2 31,359 1

Sort (cost=4,394.69..4,430.50 rows=14,324 width=59) (actual time=233.791..243.580 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. 18.721 43.952 ↓ 2.2 31,359 1

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

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

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

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

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

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

61. 13.772 58.127 ↑ 1.0 1,526 1

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

  • Group Key: imw_t_actv_executable_user_3.system_matter_id
62. 18.650 44.355 ↓ 2.2 31,359 1

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

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

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

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

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

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

67. 26.470 49.859 ↑ 1.0 63,296 1

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

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

69. 29.601 62.966 ↑ 1.0 64,863 1

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

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

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

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

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

73. 35.456 58.121 ↑ 1.0 65,806 1

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

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

75. 27.795 50.469 ↑ 1.0 65,806 1

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

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

77. 26.665 61.145 ↑ 1.0 65,806 1

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

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

79. 0.804 529.735 ↓ 418.7 1,256 1

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

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

Hash Join (cost=81.72..4,309.04 rows=3 width=71) (actual time=2.063..528.931 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. 198.832 428.408 ↓ 372.4 347,081 1

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

82. 2.776 2.776 ↓ 315.0 1,260 1

Seq Scan on imm_department imd (cost=0.00..190.98 rows=4 width=51) (actual time=0.021..2.776 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. 226.800 226.800 ↑ 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.180 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.643 1.159 ↑ 1.0 1,572 1

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

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

Planning time : 13.825 ms
Execution time : 14,997.013 ms