explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kiaj

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 7,150.356 ↑ 1.0 20 1

Subquery Scan on T (cost=480,715.77..620,353.25 rows=20 width=768) (actual time=5,829.103..7,150.356 rows=20 loops=1)

2.          

CTE INTRUST

3. 81.344 96.529 ↑ 1.0 136,224 1

Bitmap Heap Scan on CZOA_T_READMORE_TASK A1 (cost=2,051.79..29,428.69 rows=139,272 width=106) (actual time=19.969..96.529 rows=136,224 loops=1)

  • Recheck Cond: (TASKINSTANCE_ACTORID_ = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING)
  • Heap Blocks: exact=25,454
4. 15.185 15.185 ↑ 1.0 136,226 1

Bitmap Index Scan on IDX_CZOA_T_READMORE_TASK_02 (cost=0.00..2,016.97 rows=139,272 width=0) (actual time=15.185..15.185 rows=136,226 loops=1)

  • Index Cond: (TASKINSTANCE_ACTORID_ = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING)
5. 0.084 5,647.818 ↑ 1.0 20 1

Limit (cost=451,287.08..451,288.23 rows=20 width=1,406) (actual time=5,647.518..5,647.818 rows=20 loops=1)

6. 0.480 5,647.734 ↑ 271.8 20 1

Result (cost=451,287.08..451,599.59 rows=5,435 width=1,406) (actual time=5,647.512..5,647.734 rows=20 loops=1)

7. 21.853 5,647.254 ↑ 271.8 20 1

Sort (cost=451,287.08..451,300.67 rows=5,435 width=1,406) (actual time=5,647.224..5,647.254 rows=20 loops=1)

  • Sort Key: ((T_1.TYPE)::INTEGER), T_1.CREATE_ DESC
  • Sort Method: top-N heapsort Memory: 45kB
8. 12.499 5,625.401 ↓ 3.3 17,894 1

Subquery Scan on T_1 (cost=0.00..451,142.46 rows=5,435 width=1,406) (actual time=35.583..5,625.401 rows=17,894 loops=1)

9. 11.931 5,612.902 ↓ 3.3 17,894 1

Append (cost=0.00..451,020.17 rows=5,435 width=1,216) (actual time=35.574..5,612.902 rows=17,894 loops=1)

10. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=1,216) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
11. 8.524 759.770 ↓ 4.0 2,513 1

Nested Loop Left Join (cost=1,090.32..60,170.05 rows=621 width=938) (actual time=35.573..759.770 rows=2,513 loops=1)

12. 1.247 718.577 ↓ 4.1 2,513 1

Hash Left Join (cost=1,089.90..58,319.44 rows=620 width=467) (actual time=35.528..718.577 rows=2,513 loops=1)

  • Hash Cond: (R.BLANK1 = CZOA_T_DATAITEM.NAME)
13. 0.529 717.285 ↓ 4.1 2,513 1

Nested Loop Left Join (cost=1,068.44..58,294.07 rows=620 width=460) (actual time=35.468..717.285 rows=2,513 loops=1)

14. 8.793 701.678 ↓ 4.1 2,513 1

Hash Join (cost=1,068.15..58,091.06 rows=620 width=458) (actual time=35.442..701.678 rows=2,513 loops=1)

  • Hash Cond: ((NULL::CHARACTER VARYING) = R.RECEIVE_ID)
15. 2.392 660.135 ↓ 46.1 28,557 1

Append (cost=0.00..57,008.18 rows=620 width=320) (actual time=2.618..660.135 rows=28,557 loops=1)

16. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=320) (actual time=0.000..0.001 rows=0 loops=1)

  • One-Time Filter: false
17. 0.171 3.373 ↓ 2.6 982 1

Subquery Scan on *SELECT* 2 (cost=1,029.78..1,038.44 rows=385 width=468) (actual time=2.618..3.373 rows=982 loops=1)

18. 1.511 3.202 ↓ 2.6 982 1

HashAggregate (cost=1,029.78..1,034.59 rows=385 width=554) (actual time=2.617..3.202 rows=982 loops=1)

  • Group Key: N.BUSINESS_ID, N.TITLE, N.MANAGE_URL, N.SUB_PROCESS_FLAG, N.STYLE, N.RECORD_IDENTY, N.TASK_ID, N.MANAGE_TIME
19. 1.436 1.691 ↓ 2.6 982 1

Bitmap Heap Scan on TBL_MANAGE_NO N (cost=12.53..1,021.12 rows=385 width=446) (actual time=0.357..1.691 rows=982 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=743
20. 0.255 0.255 ↓ 2.6 1,000 1

Bitmap Index Scan on IDX_TBL_MANAGE_NO_09 (cost=0.00..12.43 rows=385 width=0) (actual time=0.255..0.255 rows=1,000 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
21. 12.195 654.369 ↓ 117.8 27,575 1

Subquery Scan on *SELECT* 3_1 (cost=52,463.76..55,969.74 rows=234 width=300) (actual time=273.190..654.369 rows=27,575 loops=1)

22. 35.126 642.174 ↓ 117.8 27,575 1

Nested Loop Anti Join (cost=52,463.76..55,966.82 rows=234 width=288) (actual time=273.184..642.174 rows=27,575 loops=1)

23. 4.713 382.840 ↓ 119.8 28,026 1

Subquery Scan on E (cost=52,463.34..54,219.58 rows=234 width=230) (actual time=273.142..382.840 rows=28,026 loops=1)

  • Filter: (E.RANK = 1)
  • Rows Removed by Filter: 419
24. 93.723 378.127 ↑ 1.6 28,445 1

WindowAgg (cost=52,463.34..53,634.17 rows=46,833 width=270) (actual time=273.135..378.127 rows=28,445 loops=1)

25. 237.043 284.404 ↑ 1.6 28,445 1

Sort (cost=52,463.34..52,580.42 rows=46,833 width=262) (actual time=273.123..284.404 rows=28,445 loops=1)

  • Sort Key: E_1.BUSINESS_ID, E_1.CREATE_TIME DESC, E_1.MANAGE_TIME DESC
  • Sort Method: quicksort Memory: 11,548kB
26. 41.879 47.361 ↑ 1.6 28,445 1

Bitmap Heap Scan on TBL_MANAGE_END_PARTITION_CURRENT E_1 (cost=816.91..48,830.22 rows=46,833 width=262) (actual time=8.674..47.361 rows=28,445 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=20,760
27. 5.482 5.482 ↑ 1.6 28,460 1

Bitmap Index Scan on IDX_03_12_TBL_MANAGE_END_PARTITION_CURRENT (cost=0.00..805.20 rows=46,833 width=0) (actual time=5.482..5.482 rows=28,460 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
28. 224.208 224.208 ↓ 0.0 0 28,026

Index Only Scan using TBL_MANAGE_NO_INDEX_1 on TBL_MANAGE_NO N_1 (cost=0.42..7.43 rows=1 width=33) (actual time=0.008..0.008 rows=0 loops=28,026)

  • Index Cond: ((BUSINESS_ID = E.BUSINESS_ID) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Filter: (((RECORD_IDENTY)::INTEGER = 0) OR ((RECORD_IDENTY)::INTEGER = 2))
  • Rows Removed by Filter: 0
  • Heap Fetches: 452
29. 13.513 32.750 ↑ 1.0 19,809 1

Hash (cost=820.29..820.29 rows=19,829 width=170) (actual time=32.750..32.750 rows=19,809 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 3,556kB
30. 19.237 19.237 ↑ 1.0 19,809 1

Seq Scan on TBL_ARCHIVES_RECEIVE_PARTITION_CURRENT R (cost=0.00..820.29 rows=19,829 width=170) (actual time=0.015..19.237 rows=19,809 loops=1)

31. 15.078 15.078 ↓ 0.0 0 2,513

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP (cost=0.29..0.32 rows=1 width=35) (actual time=0.006..0.006 rows=0 loops=2,513)

  • Index Cond: (R.RECEIVE_ID = BUSINESS_ID)
32. 0.003 0.045 ↓ 1.3 4 1

Hash (cost=21.42..21.42 rows=3 width=23) (actual time=0.044..0.045 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
33. 0.011 0.042 ↓ 1.3 4 1

Bitmap Heap Scan on CZOA_T_DATAITEM (cost=11.35..21.42 rows=3 width=23) (actual time=0.038..0.042 rows=4 loops=1)

  • Recheck Cond: (ELEMENTCODE = 'emergent'::CHARACTER VARYING)
  • Heap Blocks: exact=3
34. 0.031 0.031 ↓ 1.3 4 1

Bitmap Index Scan on IDX_CZOA_T_DATAITEM_01 (cost=0.00..11.35 rows=3 width=0) (actual time=0.031..0.031 rows=4 loops=1)

  • Index Cond: (ELEMENTCODE = 'emergent'::CHARACTER VARYING)
35. 32.669 32.669 ↑ 1.0 1 2,513

Index Scan using IDX_CZOA_T_READMORE_01 on CZOA_T_READMORE RD (cost=0.42..2.96 rows=1 width=340) (actual time=0.013..0.013 rows=1 loops=2,513)

  • Index Cond: (R.RECEIVE_ID = BUSINESSID_)
36. 5.994 1,323.496 ↓ 24.6 15,268 1

Subquery Scan on *SELECT* 3 (cost=12.36..61,660.61 rows=621 width=1,093) (actual time=2.380..1,323.496 rows=15,268 loops=1)

37. 45.074 1,317.502 ↓ 24.6 15,268 1

Nested Loop Left Join (cost=12.36..61,654.40 rows=621 width=1,093) (actual time=2.379..1,317.502 rows=15,268 loops=1)

38. 17.269 1,089.212 ↓ 24.6 15,268 1

Nested Loop Left Join (cost=11.93..61,206.31 rows=620 width=398) (actual time=2.350..1,089.212 rows=15,268 loops=1)

  • Join Filter: (S.EMERGENT_LEVEL = CZOA_T_DATAITEM_1.NAME)
  • Rows Removed by Join Filter: 45,809
39. 1.662 1,071.943 ↓ 24.6 15,268 1

Nested Loop Left Join (cost=0.58..61,156.98 rows=620 width=391) (actual time=2.310..1,071.943 rows=15,268 loops=1)

40. 23.968 978.673 ↓ 24.6 15,268 1

Nested Loop (cost=0.29..60,962.33 rows=620 width=389) (actual time=2.298..978.673 rows=15,268 loops=1)

41. 2.592 669.135 ↓ 46.1 28,557 1

Append (cost=0.00..57,008.18 rows=620 width=320) (actual time=2.275..669.135 rows=28,557 loops=1)

42. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=320) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
43. 0.179 3.067 ↓ 2.6 982 1

Subquery Scan on *SELECT* 2_1 (cost=1,029.78..1,038.44 rows=385 width=468) (actual time=2.274..3.067 rows=982 loops=1)

44. 1.508 2.888 ↓ 2.6 982 1

HashAggregate (cost=1,029.78..1,034.59 rows=385 width=554) (actual time=2.273..2.888 rows=982 loops=1)

  • Group Key: N_2.BUSINESS_ID, N_2.TITLE, N_2.MANAGE_URL, N_2.SUB_PROCESS_FLAG, N_2.STYLE, N_2.RECORD_IDENTY, N_2.TASK_ID, N_2.MANAGE_TIME
45. 1.170 1.380 ↓ 2.6 982 1

Bitmap Heap Scan on TBL_MANAGE_NO N_2 (cost=12.53..1,021.12 rows=385 width=446) (actual time=0.291..1.380 rows=982 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=743
46. 0.210 0.210 ↓ 2.6 1,000 1

Bitmap Index Scan on IDX_TBL_MANAGE_NO_09 (cost=0.00..12.43 rows=385 width=0) (actual time=0.210..0.210 rows=1,000 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
47. 13.221 663.475 ↓ 117.8 27,575 1

Subquery Scan on *SELECT* 3_2 (cost=52,463.76..55,969.74 rows=234 width=300) (actual time=261.741..663.475 rows=27,575 loops=1)

48. 41.844 650.254 ↓ 117.8 27,575 1

Nested Loop Anti Join (cost=52,463.76..55,966.82 rows=234 width=288) (actual time=261.736..650.254 rows=27,575 loops=1)

49. 5.209 384.202 ↓ 119.8 28,026 1

Subquery Scan on E_2 (cost=52,463.34..54,219.58 rows=234 width=230) (actual time=261.696..384.202 rows=28,026 loops=1)

  • Filter: (E_2.RANK = 1)
  • Rows Removed by Filter: 419
50. 101.922 378.993 ↑ 1.6 28,445 1

WindowAgg (cost=52,463.34..53,634.17 rows=46,833 width=270) (actual time=261.689..378.993 rows=28,445 loops=1)

51. 231.949 277.071 ↑ 1.6 28,445 1

Sort (cost=52,463.34..52,580.42 rows=46,833 width=262) (actual time=261.677..277.071 rows=28,445 loops=1)

  • Sort Key: E_3.BUSINESS_ID, E_3.CREATE_TIME DESC, E_3.MANAGE_TIME DESC
  • Sort Method: quicksort Memory: 11,548kB
52. 39.748 45.122 ↑ 1.6 28,445 1

Bitmap Heap Scan on TBL_MANAGE_END_PARTITION_CURRENT E_3 (cost=816.91..48,830.22 rows=46,833 width=262) (actual time=8.574..45.122 rows=28,445 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=20,760
53. 5.374 5.374 ↑ 1.6 28,460 1

Bitmap Index Scan on IDX_03_12_TBL_MANAGE_END_PARTITION_CURRENT (cost=0.00..805.20 rows=46,833 width=0) (actual time=5.374..5.374 rows=28,460 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
54. 224.208 224.208 ↓ 0.0 0 28,026

Index Only Scan using TBL_MANAGE_NO_INDEX_1 on TBL_MANAGE_NO N_3 (cost=0.42..7.43 rows=1 width=33) (actual time=0.008..0.008 rows=0 loops=28,026)

  • Index Cond: ((BUSINESS_ID = E_2.BUSINESS_ID) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Filter: (((RECORD_IDENTY)::INTEGER = 0) OR ((RECORD_IDENTY)::INTEGER = 2))
  • Rows Removed by Filter: 0
  • Heap Fetches: 452
55. 285.570 285.570 ↑ 1.0 1 28,557

Index Scan using IDX_05_01_TBL_ARCHIVES_SEND_PARTITION_CURRENT on TBL_ARCHIVES_SEND_PARTITION_CURRENT S (cost=0.29..6.36 rows=1 width=101) (actual time=0.010..0.010 rows=1 loops=28,557)

  • Index Cond: (SEND_ID = (NULL::CHARACTER VARYING))
56. 91.608 91.608 ↓ 0.0 0 15,268

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP_1 (cost=0.29..0.30 rows=1 width=35) (actual time=0.006..0.006 rows=0 loops=15,268)

  • Index Cond: (S.SEND_ID = BUSINESS_ID)
57. 0.000 0.000 ↓ 1.3 4 15,268

Materialize (cost=11.35..21.44 rows=3 width=23) (actual time=0.000..0.000 rows=4 loops=15,268)

58. 0.007 0.033 ↓ 1.3 4 1

Bitmap Heap Scan on CZOA_T_DATAITEM CZOA_T_DATAITEM_1 (cost=11.35..21.42 rows=3 width=23) (actual time=0.029..0.033 rows=4 loops=1)

  • Recheck Cond: (ELEMENTCODE = 'emergent'::CHARACTER VARYING)
  • Heap Blocks: exact=3
59. 0.026 0.026 ↓ 1.3 4 1

Bitmap Index Scan on IDX_CZOA_T_DATAITEM_01 (cost=0.00..11.35 rows=3 width=0) (actual time=0.026..0.026 rows=4 loops=1)

  • Index Cond: (ELEMENTCODE = 'emergent'::CHARACTER VARYING)
60. 183.216 183.216 ↑ 1.0 1 15,268

Index Scan using IDX_CZOA_T_READMORE_01 on CZOA_T_READMORE RD_1 (cost=0.42..0.70 rows=1 width=340) (actual time=0.012..0.012 rows=1 loops=15,268)

  • Index Cond: (S.SEND_ID = BUSINESSID_)
61. 0.007 740.798 ↑ 179.2 4 1

Subquery Scan on *SELECT* 4 (cost=0.99..60,989.64 rows=717 width=1,160) (actual time=0.749..740.798 rows=4 loops=1)

62. 0.016 740.791 ↑ 179.2 4 1

Nested Loop Left Join (cost=0.99..60,982.47 rows=717 width=1,160) (actual time=0.745..740.791 rows=4 loops=1)

  • Join Filter: NULL::BOOLEAN
63. 0.003 740.775 ↑ 179.2 4 1

Nested Loop Left Join (cost=0.99..60,968.13 rows=717 width=636) (actual time=0.737..740.775 rows=4 loops=1)

64. 0.006 740.760 ↑ 155.2 4 1

Nested Loop Left Join (cost=0.71..60,743.38 rows=621 width=634) (actual time=0.730..740.760 rows=4 loops=1)

65. 0.000 740.718 ↑ 155.0 4 1

Nested Loop (cost=0.28..57,728.99 rows=620 width=327) (actual time=0.716..740.718 rows=4 loops=1)

66. 2.553 657.538 ↓ 46.1 28,568 1

Append (cost=0.00..56,878.59 rows=620 width=352) (actual time=0.297..657.538 rows=28,568 loops=1)

67. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=352) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
68. 1.758 1.962 ↓ 2.6 982 1

Bitmap Heap Scan on TBL_MANAGE_NO N_4 (cost=12.53..1,022.08 rows=385 width=489) (actual time=0.295..1.962 rows=982 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=743
69. 0.204 0.204 ↓ 2.6 1,000 1

Bitmap Index Scan on IDX_TBL_MANAGE_NO_09 (cost=0.00..12.43 rows=385 width=0) (actual time=0.204..0.204 rows=1,000 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
70. 12.546 653.022 ↓ 117.9 27,586 1

Subquery Scan on *SELECT* 3_3 (cost=52,463.76..55,852.66 rows=234 width=333) (actual time=281.192..653.022 rows=27,586 loops=1)

71. 39.283 640.476 ↓ 117.9 27,586 1

Nested Loop Anti Join (cost=52,463.76..55,849.74 rows=234 width=321) (actual time=281.182..640.476 rows=27,586 loops=1)

72. 5.060 376.889 ↓ 119.8 28,038 1

Subquery Scan on E_4 (cost=52,463.34..54,102.50 rows=234 width=263) (actual time=280.515..376.889 rows=28,038 loops=1)

  • Filter: (E_4.RANK = 1)
  • Rows Removed by Filter: 407
73. 79.920 371.829 ↑ 1.6 28,445 1

WindowAgg (cost=52,463.34..53,517.08 rows=46,833 width=303) (actual time=280.496..371.829 rows=28,445 loops=1)

74. 245.278 291.909 ↑ 1.6 28,445 1

Sort (cost=52,463.34..52,580.42 rows=46,833 width=295) (actual time=279.961..291.909 rows=28,445 loops=1)

  • Sort Key: E_5.BUSINESS_ID, E_5.CREATE_TIME DESC
  • Sort Method: quicksort Memory: 15,435kB
75. 41.364 46.631 ↑ 1.6 28,445 1

Bitmap Heap Scan on TBL_MANAGE_END_PARTITION_CURRENT E_5 (cost=816.91..48,830.22 rows=46,833 width=295) (actual time=8.438..46.631 rows=28,445 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=20,760
76. 5.267 5.267 ↑ 1.6 28,460 1

Bitmap Index Scan on IDX_03_12_TBL_MANAGE_END_PARTITION_CURRENT (cost=0.00..805.20 rows=46,833 width=0) (actual time=5.267..5.267 rows=28,460 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
77. 224.304 224.304 ↓ 0.0 0 28,038

Index Only Scan using TBL_MANAGE_NO_INDEX_1 on TBL_MANAGE_NO N_5 (cost=0.42..7.43 rows=1 width=33) (actual time=0.008..0.008 rows=0 loops=28,038)

  • Index Cond: ((BUSINESS_ID = E_4.BUSINESS_ID) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Filter: (((RECORD_IDENTY)::INTEGER = 0) OR ((RECORD_IDENTY)::INTEGER = 2))
  • Rows Removed by Filter: 0
  • Heap Fetches: 453
78. 85.704 85.704 ↓ 0.0 0 28,568

Index Scan using IDX_08_01_CZOA_T_PRIVATE_OFF_BEIJING_PARTITION_CURRENT on CZOA_T_PRIVATE_OFF_BEIJING_PARTITION_CURRENT T_2 (cost=0.28..1.35 rows=1 width=39) (actual time=0.003..0.003 rows=0 loops=28,568)

  • Index Cond: (DATAKEY_REPORT = (NULL::CHARACTER VARYING))
79. 0.036 0.036 ↑ 1.0 1 4

Index Scan using IDX_CZOA_T_READMORE_01 on CZOA_T_READMORE RD_2 (cost=0.42..4.85 rows=1 width=340) (actual time=0.009..0.009 rows=1 loops=4)

  • Index Cond: (T_2.DATAKEY_REPORT = BUSINESSID_)
80. 0.012 0.012 ↓ 0.0 0 4

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP_2 (cost=0.29..0.35 rows=1 width=35) (actual time=0.003..0.003 rows=0 loops=4)

  • Index Cond: (T_2.DATAKEY_REPORT = BUSINESS_ID)
81. 0.000 0.000 ↓ 0.0 0 4

Result (cost=0.00..0.00 rows=0 width=7) (actual time=0.000..0.000 rows=0 loops=4)

  • One-Time Filter: false
82. 0.001 641.962 ↓ 0.0 0 1

Subquery Scan on *SELECT* 5 (cost=883.09..59,741.51 rows=621 width=1,185) (actual time=641.962..641.962 rows=0 loops=1)

83. 0.006 641.961 ↓ 0.0 0 1

Nested Loop Left Join (cost=883.09..59,735.30 rows=621 width=1,185) (actual time=641.961..641.961 rows=0 loops=1)

84. 0.003 641.955 ↓ 0.0 0 1

Nested Loop Left Join (cost=882.66..57,983.89 rows=620 width=330) (actual time=641.955..641.955 rows=0 loops=1)

  • Join Filter: NULL::BOOLEAN
85. 0.004 641.952 ↓ 0.0 0 1

Nested Loop Left Join (cost=882.66..57,977.69 rows=620 width=323) (actual time=641.952..641.952 rows=0 loops=1)

86. 5.495 641.948 ↓ 0.0 0 1

Hash Join (cost=882.38..57,775.69 rows=620 width=321) (actual time=641.948..641.948 rows=0 loops=1)

  • Hash Cond: ((NULL::CHARACTER VARYING) = T_3.INFO_PUB_ID)
87. 2.313 626.086 ↓ 46.1 28,568 1

Append (cost=0.00..56,878.59 rows=620 width=352) (actual time=1.347..626.086 rows=28,568 loops=1)

88. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=352) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
89. 1.999 3.005 ↓ 2.6 982 1

Bitmap Heap Scan on TBL_MANAGE_NO N_6 (cost=12.53..1,022.08 rows=385 width=489) (actual time=1.345..3.005 rows=982 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=743
90. 1.006 1.006 ↓ 2.6 1,000 1

Bitmap Index Scan on IDX_TBL_MANAGE_NO_09 (cost=0.00..12.43 rows=385 width=0) (actual time=1.005..1.006 rows=1,000 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
91. 11.578 620.767 ↓ 117.9 27,586 1

Subquery Scan on *SELECT* 3_4 (cost=52,463.76..55,852.66 rows=234 width=333) (actual time=266.025..620.767 rows=27,586 loops=1)

92. 32.759 609.189 ↓ 117.9 27,586 1

Nested Loop Anti Join (cost=52,463.76..55,849.74 rows=234 width=321) (actual time=266.020..609.189 rows=27,586 loops=1)

93. 4.647 352.126 ↓ 119.8 28,038 1

Subquery Scan on E_6 (cost=52,463.34..54,102.50 rows=234 width=263) (actual time=265.982..352.126 rows=28,038 loops=1)

  • Filter: (E_6.RANK = 1)
  • Rows Removed by Filter: 407
94. 70.980 347.479 ↑ 1.6 28,445 1

WindowAgg (cost=52,463.34..53,517.08 rows=46,833 width=303) (actual time=265.975..347.479 rows=28,445 loops=1)

95. 230.258 276.499 ↑ 1.6 28,445 1

Sort (cost=52,463.34..52,580.42 rows=46,833 width=295) (actual time=265.939..276.499 rows=28,445 loops=1)

  • Sort Key: E_7.BUSINESS_ID, E_7.CREATE_TIME DESC
  • Sort Method: quicksort Memory: 15,435kB
96. 40.685 46.241 ↑ 1.6 28,445 1

Bitmap Heap Scan on TBL_MANAGE_END_PARTITION_CURRENT E_7 (cost=816.91..48,830.22 rows=46,833 width=295) (actual time=8.736..46.241 rows=28,445 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=20,760
97. 5.556 5.556 ↑ 1.6 28,460 1

Bitmap Index Scan on IDX_03_12_TBL_MANAGE_END_PARTITION_CURRENT (cost=0.00..805.20 rows=46,833 width=0) (actual time=5.556..5.556 rows=28,460 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
98. 224.304 224.304 ↓ 0.0 0 28,038

Index Only Scan using TBL_MANAGE_NO_INDEX_1 on TBL_MANAGE_NO N_7 (cost=0.42..7.43 rows=1 width=33) (actual time=0.008..0.008 rows=0 loops=28,038)

  • Index Cond: ((BUSINESS_ID = E_6.BUSINESS_ID) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Filter: (((RECORD_IDENTY)::INTEGER = 0) OR ((RECORD_IDENTY)::INTEGER = 2))
  • Rows Removed by Filter: 0
  • Heap Fetches: 453
99. 4.538 10.367 ↑ 1.0 22,239 1

Hash (cost=604.39..604.39 rows=22,239 width=33) (actual time=10.367..10.367 rows=22,239 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,668kB
100. 5.829 5.829 ↑ 1.0 22,239 1

Seq Scan on TBL_PORTALWB_INFO_PUB T_3 (cost=0.00..604.39 rows=22,239 width=33) (actual time=0.285..5.829 rows=22,239 loops=1)

101. 0.000 0.000 ↓ 0.0 0

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP_3 (cost=0.29..0.32 rows=1 width=35) (never executed)

  • Index Cond: (T_3.INFO_PUB_ID = BUSINESS_ID)
102. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=7) (never executed)

  • One-Time Filter: false
103. 0.000 0.000 ↓ 0.0 0

Index Scan using IDX_CZOA_T_READMORE_01 on CZOA_T_READMORE RD_3 (cost=0.42..2.80 rows=1 width=340) (never executed)

  • Index Cond: (T_3.INFO_PUB_ID = BUSINESSID_)
104. 0.000 781.311 ↑ 6.6 109 1

Subquery Scan on *SELECT* 6 (cost=12.34..62,242.05 rows=718 width=1,616) (actual time=4.028..781.311 rows=109 loops=1)

105. 0.362 786.686 ↑ 6.6 109 1

Nested Loop Left Join (cost=12.34..62,234.87 rows=718 width=1,616) (actual time=4.673..786.686 rows=109 loops=1)

106. 0.149 785.670 ↑ 5.7 109 1

Nested Loop Left Join (cost=12.05..61,861.35 rows=621 width=1,226) (actual time=4.642..785.670 rows=109 loops=1)

107. 0.076 783.886 ↑ 5.7 109 1

Nested Loop Left Join (cost=11.63..57,283.22 rows=620 width=919) (actual time=4.618..783.886 rows=109 loops=1)

  • Join Filter: (S_1.EMERGENT_LEVEL = CZOA_T_DATAITEM_2.NAME)
  • Rows Removed by Join Filter: 327
108. 0.000 783.701 ↑ 5.7 109 1

Nested Loop (cost=0.28..57,233.89 rows=620 width=912) (actual time=4.576..783.701 rows=109 loops=1)

109. 2.429 643.243 ↓ 46.1 28,568 1

Append (cost=0.00..56,878.59 rows=620 width=352) (actual time=0.348..643.243 rows=28,568 loops=1)

110. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=352) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
111. 2.005 2.251 ↓ 2.6 982 1

Bitmap Heap Scan on TBL_MANAGE_NO N_8 (cost=12.53..1,022.08 rows=385 width=489) (actual time=0.347..2.251 rows=982 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=743
112. 0.246 0.246 ↓ 2.6 1,000 1

Bitmap Index Scan on IDX_TBL_MANAGE_NO_09 (cost=0.00..12.43 rows=385 width=0) (actual time=0.241..0.246 rows=1,000 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
113. 12.072 638.562 ↓ 117.9 27,586 1

Subquery Scan on *SELECT* 3_5 (cost=52,463.76..55,852.66 rows=234 width=333) (actual time=272.962..638.562 rows=27,586 loops=1)

114. 32.766 626.490 ↓ 117.9 27,586 1

Nested Loop Anti Join (cost=52,463.76..55,849.74 rows=234 width=321) (actual time=272.959..626.490 rows=27,586 loops=1)

115. 4.859 369.420 ↓ 119.8 28,038 1

Subquery Scan on E_8 (cost=52,463.34..54,102.50 rows=234 width=263) (actual time=272.923..369.420 rows=28,038 loops=1)

  • Filter: (E_8.RANK = 1)
  • Rows Removed by Filter: 407
116. 79.658 364.561 ↑ 1.6 28,445 1

WindowAgg (cost=52,463.34..53,517.08 rows=46,833 width=303) (actual time=272.918..364.561 rows=28,445 loops=1)

117. 235.577 284.903 ↑ 1.6 28,445 1

Sort (cost=52,463.34..52,580.42 rows=46,833 width=295) (actual time=272.909..284.903 rows=28,445 loops=1)

  • Sort Key: E_9.BUSINESS_ID, E_9.CREATE_TIME DESC
  • Sort Method: quicksort Memory: 15,435kB
118. 43.029 49.326 ↑ 1.6 28,445 1

Bitmap Heap Scan on TBL_MANAGE_END_PARTITION_CURRENT E_9 (cost=816.91..48,830.22 rows=46,833 width=295) (actual time=10.196..49.326 rows=28,445 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=20,760
119. 6.297 6.297 ↑ 1.6 28,460 1

Bitmap Index Scan on IDX_03_12_TBL_MANAGE_END_PARTITION_CURRENT (cost=0.00..805.20 rows=46,833 width=0) (actual time=6.297..6.297 rows=28,460 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
120. 224.304 224.304 ↓ 0.0 0 28,038

Index Only Scan using TBL_MANAGE_NO_INDEX_1 on TBL_MANAGE_NO N_9 (cost=0.42..7.43 rows=1 width=33) (actual time=0.008..0.008 rows=0 loops=28,038)

  • Index Cond: ((BUSINESS_ID = E_8.BUSINESS_ID) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Filter: (((RECORD_IDENTY)::INTEGER = 0) OR ((RECORD_IDENTY)::INTEGER = 2))
  • Rows Removed by Filter: 0
  • Heap Fetches: 453
121. 142.840 142.840 ↓ 0.0 0 28,568

Index Scan using IDX_09_01_TBL_ARCHIVES_INFO_REPORT_PARTITION_CURRENT on TBL_ARCHIVES_INFO_REPORT_PARTITION_CURRENT S_1 (cost=0.28..0.55 rows=1 width=624) (actual time=0.005..0.005 rows=0 loops=28,568)

  • Index Cond: (SEND_ID = (NULL::CHARACTER VARYING))
122. 0.072 0.109 ↓ 1.3 4 109

Materialize (cost=11.35..21.44 rows=3 width=23) (actual time=0.000..0.001 rows=4 loops=109)

123. 0.010 0.037 ↓ 1.3 4 1

Bitmap Heap Scan on CZOA_T_DATAITEM CZOA_T_DATAITEM_2 (cost=11.35..21.42 rows=3 width=23) (actual time=0.032..0.037 rows=4 loops=1)

  • Recheck Cond: (ELEMENTCODE = 'emergent'::CHARACTER VARYING)
  • Heap Blocks: exact=3
124. 0.027 0.027 ↓ 1.3 4 1

Bitmap Index Scan on IDX_CZOA_T_DATAITEM_01 (cost=0.00..11.35 rows=3 width=0) (actual time=0.027..0.027 rows=4 loops=1)

  • Index Cond: (ELEMENTCODE = 'emergent'::CHARACTER VARYING)
125. 1.635 1.635 ↑ 1.0 1 109

Index Scan using IDX_CZOA_T_READMORE_01 on CZOA_T_READMORE RD_4 (cost=0.42..7.37 rows=1 width=340) (actual time=0.015..0.015 rows=1 loops=109)

  • Index Cond: (S_1.SEND_ID = BUSINESSID_)
126. 0.654 0.654 ↓ 0.0 0 109

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP_4 (cost=0.29..0.58 rows=1 width=35) (actual time=0.006..0.006 rows=0 loops=109)

  • Index Cond: (S_1.SEND_ID = BUSINESS_ID)
127. 0.003 700.088 ↓ 0.0 0 1

Subquery Scan on *SELECT* 7 (cost=0.71..57,418.41 rows=72 width=1,496) (actual time=700.087..700.088 rows=0 loops=1)

128. 0.000 700.085 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.71..57,417.69 rows=72 width=1,496) (actual time=700.085..700.085 rows=0 loops=1)

  • Join Filter: NULL::BOOLEAN
129. 23.481 700.085 ↓ 0.0 0 1

Nested Loop (cost=0.71..57,416.25 rows=72 width=1,037) (actual time=700.085..700.085 rows=0 loops=1)

  • Join Filter: (P.DATAKEY = (NULL::CHARACTER VARYING))
  • Rows Removed by Join Filter: 285,680
130. 2.358 648.036 ↓ 46.1 28,568 1

Append (cost=0.00..56,878.59 rows=620 width=352) (actual time=0.293..648.036 rows=28,568 loops=1)

131. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=352) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
132. 1.643 1.845 ↓ 2.6 982 1

Bitmap Heap Scan on TBL_MANAGE_NO N_10 (cost=12.53..1,022.08 rows=385 width=489) (actual time=0.292..1.845 rows=982 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=743
133. 0.202 0.202 ↓ 2.6 1,000 1

Bitmap Index Scan on IDX_TBL_MANAGE_NO_09 (cost=0.00..12.43 rows=385 width=0) (actual time=0.201..0.202 rows=1,000 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
134. 12.283 643.832 ↓ 117.9 27,586 1

Subquery Scan on *SELECT* 3_6 (cost=52,463.76..55,852.66 rows=234 width=333) (actual time=272.751..643.832 rows=27,586 loops=1)

135. 39.118 631.549 ↓ 117.9 27,586 1

Nested Loop Anti Join (cost=52,463.76..55,849.74 rows=234 width=321) (actual time=272.747..631.549 rows=27,586 loops=1)

136. 4.784 368.127 ↓ 119.8 28,038 1

Subquery Scan on E_10 (cost=52,463.34..54,102.50 rows=234 width=263) (actual time=272.710..368.127 rows=28,038 loops=1)

  • Filter: (E_10.RANK = 1)
  • Rows Removed by Filter: 407
137. 79.546 363.343 ↑ 1.6 28,445 1

WindowAgg (cost=52,463.34..53,517.08 rows=46,833 width=303) (actual time=272.704..363.343 rows=28,445 loops=1)

138. 236.274 283.797 ↑ 1.6 28,445 1

Sort (cost=52,463.34..52,580.42 rows=46,833 width=295) (actual time=272.695..283.797 rows=28,445 loops=1)

  • Sort Key: E_11.BUSINESS_ID, E_11.CREATE_TIME DESC
  • Sort Method: quicksort Memory: 15,435kB
139. 41.672 47.523 ↑ 1.6 28,445 1

Bitmap Heap Scan on TBL_MANAGE_END_PARTITION_CURRENT E_11 (cost=816.91..48,830.22 rows=46,833 width=295) (actual time=9.814..47.523 rows=28,445 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=20,760
140. 5.851 5.851 ↑ 1.6 28,460 1

Bitmap Index Scan on IDX_03_12_TBL_MANAGE_END_PARTITION_CURRENT (cost=0.00..805.20 rows=46,833 width=0) (actual time=5.851..5.851 rows=28,460 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
141. 224.304 224.304 ↓ 0.0 0 28,038

Index Only Scan using TBL_MANAGE_NO_INDEX_1 on TBL_MANAGE_NO N_11 (cost=0.42..7.43 rows=1 width=33) (actual time=0.008..0.008 rows=0 loops=28,038)

  • Index Cond: ((BUSINESS_ID = E_10.BUSINESS_ID) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Filter: (((RECORD_IDENTY)::INTEGER = 0) OR ((RECORD_IDENTY)::INTEGER = 2))
  • Rows Removed by Filter: 0
  • Heap Fetches: 453
142. 28.441 28.568 ↑ 2.3 10 28,568

Materialize (cost=0.71..317.61 rows=23 width=749) (actual time=0.000..0.001 rows=10 loops=28,568)

143. 0.000 0.127 ↑ 2.3 10 1

Nested Loop Left Join (cost=0.71..317.50 rows=23 width=749) (actual time=0.033..0.127 rows=10 loops=1)

144. 0.016 0.098 ↑ 2.0 10 1

Nested Loop Left Join (cost=0.42..179.25 rows=20 width=747) (actual time=0.026..0.098 rows=10 loops=1)

145. 0.012 0.012 ↑ 2.0 10 1

Seq Scan on "P#CZOA_T_PROPOSAL_PARTITION_CURRENT" P (cost=0.00..10.20 rows=20 width=440) (actual time=0.012..0.012 rows=10 loops=1)

146. 0.070 0.070 ↓ 0.0 0 10

Index Scan using IDX_CZOA_T_READMORE_03 on CZOA_T_READMORE RD_5 (cost=0.42..8.44 rows=1 width=340) (actual time=0.007..0.007 rows=0 loops=10)

  • Index Cond: (P.DATAKEY = BUSINESSID_)
147. 0.030 0.030 ↓ 0.0 0 10

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP_5 (cost=0.29..6.90 rows=1 width=35) (actual time=0.003..0.003 rows=0 loops=10)

  • Index Cond: (P.DATAKEY = BUSINESS_ID)
148. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=7) (never executed)

  • One-Time Filter: false
149. 0.003 653.405 ↓ 0.0 0 1

Subquery Scan on *SELECT* 8 (cost=4,406.35..61,844.41 rows=718 width=1,168) (actual time=653.404..653.405 rows=0 loops=1)

150. 0.000 653.402 ↓ 0.0 0 1

Nested Loop Left Join (cost=4,406.35..61,837.23 rows=718 width=1,156) (actual time=653.402..653.402 rows=0 loops=1)

  • Join Filter: NULL::BOOLEAN
151. 0.000 653.402 ↓ 0.0 0 1

Nested Loop Left Join (cost=4,406.35..61,822.87 rows=718 width=697) (actual time=653.402..653.402 rows=0 loops=1)

152. 3.973 653.403 ↓ 0.0 0 1

Hash Join (cost=4,406.06..61,299.39 rows=621 width=695) (actual time=653.402..653.403 rows=0 loops=1)

  • Hash Cond: ((NULL::CHARACTER VARYING) = CTCI.DATAKEY)
153. 2.442 644.931 ↓ 46.1 28,568 1

Append (cost=0.00..56,878.59 rows=620 width=352) (actual time=0.288..644.931 rows=28,568 loops=1)

154. 0.001 0.001 ↓ 0.0 0 1

Result (cost=0.00..0.00 rows=0 width=352) (actual time=0.001..0.001 rows=0 loops=1)

  • One-Time Filter: false
155. 1.643 1.842 ↓ 2.6 982 1

Bitmap Heap Scan on TBL_MANAGE_NO N_12 (cost=12.53..1,022.08 rows=385 width=489) (actual time=0.287..1.842 rows=982 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=743
156. 0.199 0.199 ↓ 2.6 1,000 1

Bitmap Index Scan on IDX_TBL_MANAGE_NO_09 (cost=0.00..12.43 rows=385 width=0) (actual time=0.199..0.199 rows=1,000 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
157. 12.263 640.646 ↓ 117.9 27,586 1

Subquery Scan on *SELECT* 3_7 (cost=52,463.76..55,852.66 rows=234 width=333) (actual time=277.106..640.646 rows=27,586 loops=1)

158. 39.671 628.383 ↓ 117.9 27,586 1

Nested Loop Anti Join (cost=52,463.76..55,849.74 rows=234 width=321) (actual time=277.101..628.383 rows=27,586 loops=1)

159. 4.769 364.408 ↓ 119.8 28,038 1

Subquery Scan on E_12 (cost=52,463.34..54,102.50 rows=234 width=263) (actual time=277.062..364.408 rows=28,038 loops=1)

  • Filter: (E_12.RANK = 1)
  • Rows Removed by Filter: 407
160. 71.968 359.639 ↑ 1.6 28,445 1

WindowAgg (cost=52,463.34..53,517.08 rows=46,833 width=303) (actual time=277.056..359.639 rows=28,445 loops=1)

161. 241.030 287.671 ↑ 1.6 28,445 1

Sort (cost=52,463.34..52,580.42 rows=46,833 width=295) (actual time=277.045..287.671 rows=28,445 loops=1)

  • Sort Key: E_13.BUSINESS_ID, E_13.CREATE_TIME DESC
  • Sort Method: quicksort Memory: 15,435kB
162. 40.442 46.641 ↑ 1.6 28,445 1

Bitmap Heap Scan on TBL_MANAGE_END_PARTITION_CURRENT E_13 (cost=816.91..48,830.22 rows=46,833 width=295) (actual time=9.537..46.641 rows=28,445 loops=1)

  • Recheck Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Heap Blocks: exact=20,760
163. 6.199 6.199 ↑ 1.6 28,460 1

Bitmap Index Scan on IDX_03_12_TBL_MANAGE_END_PARTITION_CURRENT (cost=0.00..805.20 rows=46,833 width=0) (actual time=6.199..6.199 rows=28,460 loops=1)

  • Index Cond: ((RECORD_IDENTY = ANY ('{0,2}'::BPCHAR[])) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
164. 224.304 224.304 ↓ 0.0 0 28,038

Index Only Scan using TBL_MANAGE_NO_INDEX_1 on TBL_MANAGE_NO N_13 (cost=0.42..7.43 rows=1 width=33) (actual time=0.008..0.008 rows=0 loops=28,038)

  • Index Cond: ((BUSINESS_ID = E_12.BUSINESS_ID) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Filter: (((RECORD_IDENTY)::INTEGER = 0) OR ((RECORD_IDENTY)::INTEGER = 2))
  • Rows Removed by Filter: 0
  • Heap Fetches: 453
165. 0.260 4.499 ↑ 1.0 558 1

Hash (cost=4,399.07..4,399.07 rows=559 width=407) (actual time=4.499..4.499 rows=558 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 179kB
166. 0.765 4.239 ↑ 1.0 558 1

Nested Loop Left Join (cost=0.42..4,399.07 rows=559 width=407) (actual time=0.030..4.239 rows=558 loops=1)

167. 0.126 0.126 ↑ 1.0 558 1

Seq Scan on CZOA_T_COMMUNICATION_INFO_PARTITION_CURRENT CTCI (cost=0.00..22.58 rows=558 width=100) (actual time=0.012..0.126 rows=558 loops=1)

168. 3.348 3.348 ↑ 1.0 1 558

Index Scan using IDX_CZOA_T_READMORE_01 on CZOA_T_READMORE RD_6 (cost=0.42..7.83 rows=1 width=340) (actual time=0.006..0.006 rows=1 loops=558)

  • Index Cond: (CTCI.DATAKEY = BUSINESSID_)
169. 0.000 0.000 ↓ 0.0 0

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP_6 (cost=0.29..0.83 rows=1 width=35) (never executed)

  • Index Cond: (CTCI.DATAKEY = BUSINESS_ID)
170. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..0.00 rows=0 width=7) (never executed)

  • One-Time Filter: false
171. 0.000 0.019 ↓ 0.0 0 1

Subquery Scan on *SELECT* 9 (cost=1,086.74..8,541.05 rows=591 width=1,056) (actual time=0.019..0.019 rows=0 loops=1)

172. 0.001 0.019 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,086.74..8,535.14 rows=591 width=1,056) (actual time=0.019..0.019 rows=0 loops=1)

173. 0.000 0.018 ↓ 0.0 0 1

Nested Loop Left Join (cost=1,086.31..3,965.78 rows=590 width=192) (actual time=0.018..0.018 rows=0 loops=1)

174. 0.000 0.018 ↓ 0.0 0 1

Hash Join (cost=1,086.03..3,532.98 rows=590 width=190) (actual time=0.018..0.018 rows=0 loops=1)

  • Hash Cond: (P_1.BUSINESSID_ = R_1.RECEIVE_ID)
175. 0.002 0.018 ↓ 0.0 0 1

Bitmap Heap Scan on JBPM_PASSREAD_PARTITION_CURRENT P_1 (cost=17.88..2,456.29 rows=703 width=108) (actual time=0.018..0.018 rows=0 loops=1)

  • Recheck Cond: (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING)
  • Filter: (TYPE_ <> '3'::NUMERIC)
176. 0.016 0.016 ↓ 0.0 0 1

Bitmap Index Scan on IDX_04_03_JBPM_PASSREAD_PARTITION_CURRENT (cost=0.00..17.70 rows=703 width=0) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING)
177. 0.000 0.000 ↓ 0.0 0

Hash (cost=820.29..820.29 rows=19,829 width=115) (never executed)

178. 0.000 0.000 ↓ 0.0 0

Seq Scan on TBL_ARCHIVES_RECEIVE_PARTITION_CURRENT R_1 (cost=0.00..820.29 rows=19,829 width=115) (never executed)

179. 0.000 0.000 ↓ 0.0 0

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP_7 (cost=0.29..0.72 rows=1 width=35) (never executed)

  • Index Cond: (P_1.BUSINESSID_ = BUSINESS_ID)
180. 0.000 0.000 ↓ 0.0 0

Index Scan using IDX_CZOA_T_READMORE_01 on CZOA_T_READMORE RD_7 (cost=0.42..7.70 rows=1 width=340) (never executed)

  • Index Cond: (P_1.BUSINESSID_ = BUSINESSID_)
181. 0.000 0.010 ↓ 0.0 0 1

Subquery Scan on *SELECT* 10 (cost=18.88..12,794.77 rows=705 width=1,157) (actual time=0.010..0.010 rows=0 loops=1)

182. 0.001 0.010 ↓ 0.0 0 1

Nested Loop Left Join (cost=18.88..12,787.72 rows=705 width=1,157) (actual time=0.010..0.010 rows=0 loops=1)

183. 0.000 0.009 ↓ 0.0 0 1

Nested Loop Left Join (cost=18.46..7,346.70 rows=703 width=165) (actual time=0.009..0.009 rows=0 loops=1)

184. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=18.17..6,831.01 rows=703 width=163) (actual time=0.009..0.009 rows=0 loops=1)

185. 0.000 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on JBPM_PASSREAD_PARTITION_CURRENT P_2 (cost=17.88..2,456.29 rows=703 width=108) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING)
  • Filter: (TYPE_ <> '3'::NUMERIC)
186. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on IDX_04_03_JBPM_PASSREAD_PARTITION_CURRENT (cost=0.00..17.70 rows=703 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING)
187. 0.000 0.000 ↓ 0.0 0

Index Scan using IDX_05_01_TBL_ARCHIVES_SEND_PARTITION_CURRENT on TBL_ARCHIVES_SEND_PARTITION_CURRENT S_2 (cost=0.29..6.21 rows=1 width=88) (never executed)

  • Index Cond: (SEND_ID = P_2.BUSINESSID_)
188. 0.000 0.000 ↓ 0.0 0

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP_8 (cost=0.29..0.72 rows=1 width=35) (never executed)

  • Index Cond: (P_2.BUSINESSID_ = BUSINESS_ID)
189. 0.000 0.000 ↓ 0.0 0

Index Scan using IDX_CZOA_T_READMORE_01 on CZOA_T_READMORE RD_8 (cost=0.42..7.70 rows=1 width=340) (never executed)

  • Index Cond: (P_2.BUSINESSID_ = BUSINESSID_)
190. 0.001 0.093 ↓ 0.0 0 1

Subquery Scan on *SELECT* 11 (cost=1.14..187.88 rows=1 width=1,384) (actual time=0.093..0.093 rows=0 loops=1)

191. 0.001 0.092 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.14..187.87 rows=1 width=1,384) (actual time=0.092..0.092 rows=0 loops=1)

192. 0.000 0.091 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.85..187.11 rows=1 width=633) (actual time=0.091..0.091 rows=0 loops=1)

193. 0.009 0.091 ↓ 0.0 0 1

Nested Loop (cost=0.43..179.40 rows=1 width=326) (actual time=0.091..0.091 rows=0 loops=1)

194. 0.012 0.012 ↑ 2.0 10 1

Seq Scan on "P#CZOA_T_PROPOSAL_PARTITION_CURRENT" PR (cost=0.00..10.20 rows=20 width=300) (actual time=0.011..0.012 rows=10 loops=1)

195. 0.070 0.070 ↓ 0.0 0 10

Index Scan using IDX_04_04_JBPM_PASSREAD_PARTITION_CURRENT on JBPM_PASSREAD_PARTITION_CURRENT P_3 (cost=0.43..8.45 rows=1 width=108) (actual time=0.007..0.007 rows=0 loops=10)

  • Index Cond: ((BUSINESSID_ = PR.DATAKEY) AND (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING))
  • Filter: (TYPE_ <> '3'::NUMERIC)
196. 0.000 0.000 ↓ 0.0 0

Index Scan using IDX_CZOA_T_READMORE_01 on CZOA_T_READMORE RD_9 (cost=0.42..7.70 rows=1 width=340) (never executed)

  • Index Cond: (P_3.BUSINESSID_ = BUSINESSID_)
197. 0.000 0.000 ↓ 0.0 0

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP_9 (cost=0.29..0.72 rows=1 width=35) (never executed)

  • Index Cond: (P_3.BUSINESSID_ = BUSINESS_ID)
198. 0.000 0.009 ↓ 0.0 0 1

Subquery Scan on *SELECT* 12 (cost=78.59..2,790.72 rows=32 width=1,155) (actual time=0.009..0.009 rows=0 loops=1)

199. 0.000 0.009 ↓ 0.0 0 1

Nested Loop Left Join (cost=78.59..2,790.40 rows=32 width=1,155) (actual time=0.009..0.009 rows=0 loops=1)

200. 0.001 0.009 ↓ 0.0 0 1

Nested Loop Left Join (cost=78.31..2,765.88 rows=32 width=468) (actual time=0.008..0.009 rows=0 loops=1)

201. 0.000 0.008 ↓ 0.0 0 1

Hash Join (cost=77.88..2,519.25 rows=32 width=161) (actual time=0.008..0.008 rows=0 loops=1)

  • Hash Cond: (P_4.BUSINESSID_ = S_3.SEND_ID)
202. 0.000 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on JBPM_PASSREAD_PARTITION_CURRENT P_4 (cost=17.88..2,456.29 rows=703 width=108) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING)
  • Filter: (TYPE_ <> '3'::NUMERIC)
203. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on IDX_04_03_JBPM_PASSREAD_PARTITION_CURRENT (cost=0.00..17.70 rows=703 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING)
204. 0.000 0.000 ↓ 0.0 0

Hash (cost=46.67..46.67 rows=1,067 width=86) (never executed)

205. 0.000 0.000 ↓ 0.0 0

Seq Scan on TBL_ARCHIVES_INFO_REPORT_PARTITION_CURRENT S_3 (cost=0.00..46.67 rows=1,067 width=86) (never executed)

206. 0.000 0.000 ↓ 0.0 0

Index Scan using IDX_CZOA_T_READMORE_01 on CZOA_T_READMORE RD_10 (cost=0.42..7.70 rows=1 width=340) (never executed)

  • Index Cond: (P_4.BUSINESSID_ = BUSINESSID_)
207. 0.000 0.000 ↓ 0.0 0

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP_10 (cost=0.29..0.72 rows=1 width=35) (never executed)

  • Index Cond: (P_4.BUSINESSID_ = BUSINESS_ID)
208. 0.000 0.009 ↓ 0.0 0 1

Subquery Scan on *SELECT* 13 (cost=48.14..2,632.87 rows=17 width=1,181) (actual time=0.009..0.009 rows=0 loops=1)

209. 0.001 0.009 ↓ 0.0 0 1

Nested Loop Left Join (cost=48.14..2,632.70 rows=17 width=1,181) (actual time=0.008..0.009 rows=0 loops=1)

210. 0.000 0.008 ↓ 0.0 0 1

Nested Loop Left Join (cost=47.86..2,619.67 rows=17 width=462) (actual time=0.008..0.008 rows=0 loops=1)

211. 0.001 0.008 ↓ 0.0 0 1

Hash Join (cost=47.43..2,488.65 rows=17 width=155) (actual time=0.008..0.008 rows=0 loops=1)

  • Hash Cond: (P_5.BUSINESSID_ = CTCI_1.DATAKEY)
212. 0.000 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on JBPM_PASSREAD_PARTITION_CURRENT P_5 (cost=17.88..2,456.29 rows=703 width=108) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING)
  • Filter: (TYPE_ <> '3'::NUMERIC)
213. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on IDX_04_03_JBPM_PASSREAD_PARTITION_CURRENT (cost=0.00..17.70 rows=703 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (TRANSFERUSERID = '8a227e8c5011650601501844dfcb4333'::CHARACTER VARYING)
214. 0.000 0.000 ↓ 0.0 0

Hash (cost=22.58..22.58 rows=558 width=80) (never executed)

215. 0.000 0.000 ↓ 0.0 0

Seq Scan on CZOA_T_COMMUNICATION_INFO_PARTITION_CURRENT CTCI_1 (cost=0.00..22.58 rows=558 width=80) (never executed)

216. 0.000 0.000 ↓ 0.0 0

Index Scan using IDX_CZOA_T_READMORE_01 on CZOA_T_READMORE RD_11 (cost=0.42..7.70 rows=1 width=340) (never executed)

  • Index Cond: (P_5.BUSINESSID_ = BUSINESSID_)
217. 0.000 0.000 ↓ 0.0 0

Index Scan using BUSINESS_ID on CZOA_T_ISPOSAL IP_11 (cost=0.29..0.72 rows=1 width=35) (never executed)

  • Index Cond: (P_5.BUSINESSID_ = BUSINESS_ID)
218.          

SubPlan (for Subquery Scan)

219. 0.680 0.680 ↓ 0.0 0 40

Index Scan using IDX_100_03 on "P#CZOA_T_DICTIONARY" (cost=0.14..8.17 rows=1 width=32) (actual time=0.017..0.017 rows=0 loops=40)

  • Index Cond: (T.PROCESSDEFINITIONNAME = CONTENT)
  • Filter: ((STATUS = '1'::BPCHAR) AND (CODE = 'guomifuyinjian'::CHARACTER VARYING))
220. 0.160 788.480 ↑ 1.0 1 40

Aggregate (cost=3,483.53..3,483.54 rows=1 width=8) (actual time=19.712..19.712 rows=1 loops=40)

221. 788.320 788.320 ↓ 0.0 0 40

CTE Scan on INTRUST (cost=0.00..3,481.80 rows=693 width=0) (actual time=19.708..19.708 rows=0 loops=40)

  • Filter: ((TASKINSTANCE_ENTRUSTUSERID_ <> TASKINSTANCE_ACTORID_) AND ((TASKINSTANCE_ID_)::TEXT = T.TASK_ID))
  • Rows Removed by Filter: 136,224
222. 0.200 713.640 ↑ 1.0 1 40

Aggregate (cost=3,481.81..3,481.82 rows=1 width=8) (actual time=17.840..17.841 rows=1 loops=40)

223. 713.440 713.440 ↓ 0.0 0 40

CTE Scan on INTRUST INTRUST_1 (cost=0.00..3,481.80 rows=3 width=0) (actual time=17.836..17.836 rows=0 loops=40)

  • Filter: (((TASKINSTANCE_ID_)::TEXT = T.TASK_ID) AND (TASKINSTANCE_ENTRUSTUSERID_ = TASKINSTANCE_ACTORID_))
  • Rows Removed by Filter: 136,224
224. 0.280 0.280 ↓ 0.0 0 40

Index Only Scan using "IDX_07_03_P#CZOA_T_PROPOSAL_PARTITION_CURRENT" on "P#CZOA_T_PROPOSAL_PARTITION_CURRENT" PR_1 (cost=0.14..8.15 rows=1 width=32) (actual time=0.007..0.007 rows=0 loops=40)

  • Index Cond: (DATAKEY = T.BUSINESSID_)
  • Heap Fetches: 0
Planning time : 26.475 ms
Execution time : 7,074.466 ms