10.29

结构化的程序设计:顺序、选择、循环(while、do…while、for)
选择:出现了分支、条件
循环:出现了重复(相似的)的代码、一个范围,执行次数不确定
1、while语句----当型循环,先判断条件,后执行循环体语句,循环体最少执行0次
语法
while(表达式)//注意此处,不能有分号
语句;
执行:先判断表达式的值是否为真(成立),如果为真,则执行语句,然后继续判断表达式的值,
一直到表达式为假,while循环结束
注意:表达式为任意合法的表达式,为循环执行的条件,即循环条件
语句为任意合法的一条语句(多条语句,必须加括号),是重复执行的语句,即循环体语句,
为了让循环能够结束,通常在循环体语句里有使循环条件趋于不成立的语句

int x=8; //循环变量赋初值
while(x<10)
{
printf("%d",x);
x++;//x为循环变量,通过改变循环变量的值,循环最终会结束
//++x;
//x=x+1;同义
}
案例
1-100的和
#include “stdio.h”
void main()
{
int sum=0,i=1;
while(i<=100)
{
sum+=i;
i++;//i=i+1;
}
printf("%d\n",sum);
printf("%d %d",sizeof(int),sizeof(long));

}
2、do…while循环:直到型循环,循环体最少执行一次
语法
do{
语句
}while(表达式);//注意此处必须有分号
执行:先执行语句,然后判断表达式是否成立,如果成立,继续执行语句,否则结束do…while循环
注意:语句是循环体语句
表达式为循环条件
当循环条件(表达式)初始为真时,可以和while循环无条件转换

案例1-100的和
int i=1,sum=0;
do{
sum+=i;
i++;
}while(i<=100);
printf("%d",sum);

[root@localhost ~]# ps aux |grep postgre systemd+ 32997 0.1 4.2 34818560 2811840 ? Ss 03:30 0:53 postgres: postgres xytocc_business 10.201.8.41(55674) idle systemd+ 57615 2.3 8.9 34817536 5865664 ? Ss 04:01 12:21 postgres: postgres xytocc_business 10.201.8.41(37090) idle systemd+ 67985 0.1 3.5 34931008 2331456 ? Ss 04:15 0:49 postgres: postgres xytocc_business 10.201.8.42(52818) idle systemd+ 80671 2.5 9.2 34931712 6058112 ? Ss 04:31 12:49 postgres: postgres xytocc_business 10.201.8.41(36894) idle systemd+ 104292 0.2 5.5 34944960 3637184 ? Ss 05:01 1:00 postgres: postgres xytocc_business 10.201.8.42(54392) idle systemd+ 105687 0.2 5.4 34944960 3594432 ? Ss 05:03 0:58 postgres: postgres xytocc_business 10.201.8.43(41320) idle systemd+ 155999 0.0 0.5 34815808 390592 ? Ss 06:08 0:04 postgres: postgres xytocc_business 10.201.8.43(56494) idle systemd+ 183508 0.0 2.4 34813824 1639232 ? Ss Jun14 0:46 postgres: postgres xytocc_business 10.29.105.4(52226) idle systemd+ 184395 0.0 0.0 34813376 19136 ? Ss Jul10 0:00 postgres: postgres xytocc_business 10.201.8.22(35848) idle systemd+ 184396 0.0 0.0 34813376 19200 ? Ss Jul10 0:00 postgres: postgres xytocc_business 10.201.8.22(35864) idle systemd+ 184397 0.0 0.0 34813376 19200 ? Ss Jul10 0:00 postgres: postgres xytocc_business 10.201.8.22(35880) idle systemd+ 184398 0.0 0.0 34813376 19200 ? Ss Jul10 0:00 postgres: postgres xytocc_business 10.201.8.22(35884) idle systemd+ 184399 0.0 0.0 34813376 19200 ? Ss Jul10 0:00 postgres: postgres xytocc_business 10.201.8.22(40948) idle systemd+ 202687 0.0 2.9 34815296 1928064 ? Ss 07:08 0:01 postgres: postgres xytocc_business 10.29.105.4(42024) idle systemd+ 202688 0.0 3.6 34931008 2396800 ? Ss 07:08 0:05 postgres: postgres xytocc_business 10.29.105.4(42026) idle systemd+ 202691 0.0 0.1 34813696 124608 ? Ss 07:08 0:00 postgres: postgres xytocc_business 10.29.105.4(42028) idle systemd+ 202719 0.0 1.0 34814976 713472 ? Ss 07:08 0:00 postgres: postgres xytocc_business 10.29.105.4(42358) idle systemd+ 202720 0.0 3.6 34932032 2405056 ? Ss 07:08 0:09 postgres: postgres xytocc_business 10.29.105.4(42364) idle systemd+ 202721 0.0 3.8 34931840 2515136 ? Ss 07:08 0:05 postgres: postgres xytocc_business 10.29.105.4(42384) idle systemd+ 202986 0.0 0.0 34813504 36544 ? Ss 07:09 0:00 postgres: postgres xytocc_business 10.29.105.4(43296) idle systemd+ 202987 0.0 0.0 34813568 35968 ? Ss 07:09 0:00 postgres: postgres xytocc_business 10.29.105.4(43298) idle systemd+ 203596 0.3 7.3 34950720 4798592 ? Ss 07:10 1:03 postgres: postgres xytocc_business 10.29.105.4(45808) idle systemd+ 203597 0.0 3.7 34951104 2437056 ? Ss 07:10 0:07 postgres: postgres xytocc_business 10.29.105.4(45812) idle systemd+ 203598 0.0 0.9 34922496 594240 ? Ss 07:10 0:05 postgres: postgres xytocc_business 10.29.105.4(45822) idle systemd+ 203626 0.0 0.4 34814848 295296 ? Ss 07:10 0:00 postgres: postgres xytocc_business 10.29.105.4(45824) idle systemd+ 203627 0.0 2.5 34914112 1671872 ? Ss 07:10 0:04 postgres: postgres xytocc_business 10.29.105.4(45826) idle systemd+ 203629 0.1 1.9 34961536 1283840 ? Ss 07:10 0:26 postgres: postgres xytocc_business 10.29.105.4(45828) idle systemd+ 204405 0.0 0.1 34813696 95808 ? Ss 07:10 0:00 postgres: postgres xytocc_business 10.29.105.4(49596) idle systemd+ 255181 0.1 10.6 34930624 7007808 ? Ss 08:14 0:24 postgres: postgres xytocc_business 10.201.8.42(50014) idle systemd+ 269200 0.0 6.1 34915456 4014016 ? Ss 08:32 0:14 postgres: postgres xytocc_business 10.201.8.42(42106) idle systemd+ 269209 0.0 3.7 34913536 2439744 ? Ss 08:32 0:01 postgres: postgres xytocc_business 10.201.8.43(32788) idle systemd+ 269396 2.9 4.5 34995968 2964736 ? Ss 08:32 7:38 postgres: postgres xytocc_business 10.201.8.42(37370) idle systemd+ 269512 0.0 0.0 34813376 22336 ? Ss 08:32 0:00 postgres: postgres xytocc_business 10.201.8.42(52748) idle systemd+ 269513 0.0 1.4 34814336 956224 ? Ss 08:32 0:00 postgres: postgres xytocc_business 10.201.8.43(43914) idle systemd+ 269514 0.0 1.5 34814656 992896 ? Ss 08:32 0:00 postgres: postgres xytocc_business 10.201.8.43(43928) idle systemd+ 269515 0.0 0.0 34826176 45760 ? Ss 08:32 0:00 postgres: postgres xytocc_business 10.201.8.42(52762) idle systemd+ 269683 3.0 4.6 35002944 3027392 ? Ss 08:32 7:57 postgres: postgres xytocc_business 10.201.8.43(43868) idle systemd+ 274217 0.7 4.6 34872128 3068480 ? Ss 08:38 1:54 postgres: postgres xytocc_business 10.201.8.42(34290) idle systemd+ 278993 0.0 5.6 34929792 3739200 ? Ss 08:44 0:04 postgres: postgres xytocc_business 10.29.105.4(21740) idle systemd+ 285162 0.3 18.5 34933568 12196928 ? Ss 08:52 0:47 postgres: postgres xytocc_business 10.201.8.43(34462) idle systemd+ 285163 0.5 15.0 34917312 9861760 ? Ss 08:52 1:18 postgres: postgres xytocc_business 10.201.8.43(34468) idle systemd+ 285164 1.3 17.0 34929024 11188160 ? Ss 08:52 3:17 postgres: postgres xytocc_business 10.201.8.42(33532) idle systemd+ 285165 0.9 7.2 34928320 4760192 ? Ss 08:52 2:16 postgres: postgres xytocc_business 10.201.8.42(33538) idle systemd+ 285166 2.6 12.0 34932288 7887040 ? Ss 08:52 6:25 postgres: postgres xytocc_business 10.201.8.42(33546) idle systemd+ 285173 0.0 6.7 34935040 4402176 ? Ss 08:52 0:11 postgres: postgres xytocc_business 10.201.8.42(33550) idle systemd+ 285180 0.0 0.0 34814080 39616 ? Ss 08:52 0:00 postgres: postgres xytocc_business 10.201.8.42(33552) idle systemd+ 285199 0.0 10.0 34917632 6614080 ? Ss 08:52 0:06 postgres: postgres xytocc_business 10.201.8.43(33250) idle systemd+ 285230 0.0 2.7 34815680 1815296 ? Ss 08:52 0:01 postgres: postgres xytocc_business 10.201.8.42(33568) idle systemd+ 285241 1.1 18.6 34930688 12228096 ? Ss 08:52 2:51 postgres: postgres xytocc_business 10.201.8.43(33274) idle systemd+ 290374 0.0 3.5 34833280 2302464 ? Ss 08:58 0:02 postgres: postgres xytocc_business 10.201.8.43(47906) idle systemd+ 290375 0.0 0.2 34830976 147520 ? Ss 08:58 0:00 postgres: postgres xytocc_business 10.201.8.42(45552) idle systemd+ 290376 0.2 3.5 34833216 2302720 ? Ss 08:58 0:37 postgres: postgres xytocc_business 10.201.8.43(47922) idle systemd+ 292132 4.5 3.6 34932288 2414720 ? Ss 09:00 10:28 postgres: postgres xytocc_business 10.201.8.42(60636) idle systemd+ 295306 0.1 2.6 34947264 1742784 ? Ss 09:03 0:21 postgres: postgres xytocc_business 10.201.8.43(38738) idle systemd+ 295448 1.1 2.7 34954112 1822656 ? Ss 09:03 2:30 postgres: postgres xytocc_business 10.201.8.42(36402) idle systemd+ 295813 4.3 5.0 34896256 3339136 ? Ss 09:04 9:54 postgres: postgres xytocc_business 10.201.8.43(43230) idle systemd+ 298822 3.5 4.9 34896192 3233792 ? Ss 09:07 8:03 postgres: postgres xytocc_business 10.201.8.43(50804) idle systemd+ 300862 0.2 3.5 34833216 2303616 ? Ss 09:09 0:39 postgres: postgres xytocc_business 10.201.8.42(54830) idle systemd+ 300867 0.0 0.0 34813376 22208 ? Ss 09:09 0:00 postgres: postgres xytocc_business 10.201.8.43(48118) idle systemd+ 301682 5.0 4.8 34871808 3209536 ? Ss 09:10 11:08 postgres: postgres xytocc_business 10.201.8.42(47060) idle systemd+ 302123 0.0 2.9 34860160 1942336 ? Ss 09:10 0:00 postgres: postgres xytocc_business 10.29.105.4(54790) idle systemd+ 302124 1.7 4.5 34866368 2996416 ? Ss 09:10 3:53 postgres: postgres xytocc_business 10.29.105.4(54792) idle systemd+ 302125 1.7 4.6 34865152 3061056 ? Ss 09:10 3:54 postgres: postgres xytocc_business 10.29.105.4(54794) idle systemd+ 305965 3.4 4.5 34965632 3010752 ? Ss 09:15 7:26 postgres: postgres xytocc_business 10.201.8.43(49816) idle systemd+ 306118 0.0 0.3 34813568 206208 ? Ss 09:15 0:00 postgres: postgres xytocc_business 10.29.105.4(7924) idle systemd+ 307608 0.2 0.7 34822720 479104 ? Ss 09:16 0:27 postgres: postgres xytocc_business 10.29.105.4(14420) idle systemd+ 314122 5.1 4.8 34869888 3169600 ? Ss 09:23 10:35 postgres: postgres xytocc_business 10.201.8.42(48364) idle systemd+ 357244 0.1 0.7 34821632 477248 ? Ss 10:07 0:12 postgres: postgres xytocc_business 10.29.105.4(34262) idle systemd+ 379279 0.0 0.0 34813760 45376 ? Ss 10:30 0:00 postgres: postgres postgres 10.29.105.4(62716) idle systemd+ 379978 0.0 1.0 34820672 710912 ? Ss 10:31 0:00 postgres: postgres xytocc_business 10.29.105.4(1444) idle systemd+ 380297 0.0 2.8 34825088 1842880 ? Ss 10:31 0:01 postgres: postgres xytocc_business 10.29.105.4(2492) idle systemd+ 381687 0.1 0.7 34826560 481664 ? Ss 10:33 0:14 postgres: postgres xytocc_business 10.29.105.4(7800) idle systemd+ 384137 0.2 3.3 34949824 2193088 ? Ss 10:35 0:17 postgres: postgres xytocc_business 10.29.105.4(17382) idle systemd+ 384276 0.0 0.0 34813632 47232 ? Ss 10:35 0:00 postgres: postgres xytocc_business 10.29.105.4(17870) idle systemd+ 402190 0.0 3.5 34930560 2347072 ? Ss 10:53 0:03 postgres: postgres xytocc_business 10.201.8.43(37662) idle systemd+ 402513 0.0 0.3 34814976 246912 ? Ss 10:53 0:00 postgres: postgres xytocc_business 10.201.8.43(35986) idle systemd+ 403104 0.0 1.7 34818176 1118272 ? Ss 10:54 0:00 postgres: postgres xytocc_business 10.201.8.42(38002) idle systemd+ 403111 0.0 0.0 34813568 37184 ? Ss 10:54 0:00 postgres: postgres xytocc_business 10.201.8.43(41148) idle systemd+ 403112 0.0 0.0 34814400 51264 ? Ss 10:54 0:00 postgres: postgres xytocc_business 10.201.8.43(41158) idle systemd+ 403149 0.0 0.5 34927104 353088 ? Ss 10:54 0:00 postgres: postgres xytocc_business 10.201.8.42(38014) idle systemd+ 403150 0.0 5.5 34954496 3644032 ? Ss 10:54 0:04 postgres: postgres xytocc_business 10.201.8.42(38016) idle systemd+ 403151 0.0 5.0 34924416 3342976 ? Ss 10:54 0:06 postgres: postgres xytocc_business 10.201.8.42(38026) idle systemd+ 403152 0.0 5.9 34956480 3934976 ? Ss 10:54 0:05 postgres: postgres xytocc_business 10.201.8.42(38028) idle systemd+ 403445 0.0 0.3 34814976 219136 ? Ss 10:54 0:00 postgres: postgres xytocc_business 10.201.8.42(60684) idle systemd+ 434814 0.1 0.6 34815680 411520 ? Ss 11:27 0:07 postgres: postgres xytocc_business 10.29.105.4(21224) idle systemd+ 435081 0.0 0.0 34813376 22208 ? Ss 11:27 0:00 postgres: postgres xytocc_business 10.201.8.43(50130) idle systemd+ 435082 0.0 0.0 34813376 22208 ? Ss 11:27 0:00 postgres: postgres xytocc_business 10.201.8.43(50140) idle systemd+ 435083 0.0 0.0 34813376 22336 ? Ss 11:27 0:00 postgres: postgres xytocc_business 10.201.8.43(50156) idle systemd+ 435085 0.0 0.0 34813376 22400 ? Ss 11:27 0:00 postgres: postgres xytocc_business 10.201.8.43(50162) idle systemd+ 435086 0.0 0.0 34813376 22272 ? Ss 11:27 0:00 postgres: postgres xytocc_business 10.201.8.43(50174) idle systemd+ 435143 22.2 24.5 35030400 16089536 ? Rs 11:27 18:32 postgres: postgres xytocc_business 10.201.8.42(36510) SELECT systemd+ 435180 36.0 30.5 35043136 20010816 ? Ss 11:27 29:59 postgres: postgres xytocc_business 10.201.8.42(36526) idle systemd+ 435181 25.8 31.1 35043008 20433216 ? Ss 11:27 21:30 postgres: postgres xytocc_business 10.201.8.42(36528) idle systemd+ 435184 0.0 0.0 34813376 22272 ? Ss 11:27 0:00 postgres: postgres xytocc_business 10.201.8.42(36550) idle systemd+ 435185 0.0 0.0 34813376 22272 ? Ss 11:27 0:00 postgres: postgres xytocc_business 10.201.8.42(36554) idle systemd+ 435186 0.0 0.0 34813376 22336 ? Ss 11:27 0:00 postgres: postgres xytocc_business 10.201.8.42(36556) idle systemd+ 435187 0.0 0.0 34813376 22336 ? Ss 11:27 0:00 postgres: postgres xytocc_business 10.201.8.42(36558) idle systemd+ 435188 0.0 0.0 34813376 22400 ? Ss 11:27 0:00 postgres: postgres xytocc_business 10.201.8.42(36560) idle systemd+ 435213 12.9 28.7 34976704 18852992 ? Ss 11:28 10:47 postgres: postgres xytocc_business 10.29.105.4(22802) idle systemd+ 435214 7.8 30.2 34969792 19841728 ? Ss 11:28 6:30 postgres: postgres xytocc_business 10.29.105.4(22804) idle systemd+ 435215 9.8 30.9 34990976 20297920 ? Ss 11:28 8:09 postgres: postgres xytocc_business 10.29.105.4(22806) idle systemd+ 435216 6.8 30.9 34964032 20273024 ? Ss 11:28 5:41 postgres: postgres xytocc_business 10.29.105.4(22808) idle systemd+ 435219 3.7 30.1 35008064 19752448 ? Ss 11:28 3:07 postgres: postgres xytocc_business 10.29.105.4(22810) REFRESH MATERIALIZED VIEW waiting systemd+ 435220 0.0 0.0 34813376 22272 ? Ss 11:28 0:00 postgres: postgres xytocc_business 10.29.105.4(22822) idle systemd+ 435221 0.0 0.0 34813376 22208 ? Ss 11:28 0:00 postgres: postgres xytocc_business 10.29.105.4(22824) idle systemd+ 435222 0.0 0.0 34813376 22272 ? Ss 11:28 0:00 postgres: postgres xytocc_business 10.29.105.4(22828) idle systemd+ 435223 0.0 0.0 34813376 22336 ? Ss 11:28 0:00 postgres: postgres xytocc_business 10.29.105.4(22832) idle systemd+ 435225 0.0 0.0 34813376 22144 ? Ss 11:28 0:00 postgres: postgres xytocc_business 10.29.105.4(22834) idle systemd+ 435347 12.7 30.9 34977664 20327232 ? Ss 11:28 10:36 postgres: postgres xytocc_business 10.29.105.4(23694) idle systemd+ 435349 11.5 30.9 34968640 20301248 ? Ss 11:28 9:34 postgres: postgres xytocc_business 10.29.105.4(23728) idle systemd+ 435350 10.5 30.9 34979776 20296128 ? Rs 11:28 8:47 postgres: postgres xytocc_business 10.29.105.4(23730) REFRESH MATERIALIZED VIEW systemd+ 435353 3.4 30.8 34960192 20263424 ? Ss 11:28 2:52 postgres: postgres xytocc_business 10.29.105.4(23740) idle systemd+ 435356 0.0 0.0 34813376 22144 ? Ss 11:28 0:00 postgres: postgres xytocc_business 10.29.105.4(23766) idle systemd+ 435357 0.0 0.0 34813376 22272 ? Ss 11:28 0:00 postgres: postgres xytocc_business 10.29.105.4(23772) idle systemd+ 435358 0.0 0.0 34813376 22208 ? Ss 11:28 0:00 postgres: postgres xytocc_business 10.29.105.4(23774) idle systemd+ 435359 0.0 0.0 34813376 22272 ? Ss 11:28 0:00 postgres: postgres xytocc_business 10.29.105.4(23776) idle systemd+ 435360 0.0 0.0 34813376 22272 ? Ss 11:28 0:00 postgres: postgres xytocc_business 10.29.105.4(23780) idle systemd+ 435384 0.0 1.0 34817344 710336 ? Ss Jul10 0:39 postgres: postgres xytocc_business 10.201.8.43(35652) idle systemd+ 435551 32.2 30.0 35036544 19725248 ? Rs 11:28 26:43 postgres: postgres xytocc_business 10.201.8.42(39346) SELECT systemd+ 436008 30.6 30.3 35184896 19918400 ? Ss 11:28 25:19 postgres: postgres xytocc_business 10.201.8.42(36198) idle systemd+ 436037 0.0 2.3 34814592 1517632 ? Ss 11:28 0:02 postgres: postgres xytocc_business 10.201.8.43(47540) idle systemd+ 436222 29.0 29.9 35010944 19651264 ? Ss 11:28 23:55 postgres: postgres xytocc_business 10.201.8.42(58966) idle systemd+ 438235 4.2 30.1 35006464 19779264 ? Ss 11:30 3:25 postgres: postgres xytocc_business 10.29.105.4(31510) idle systemd+ 440158 24.3 30.2 35181696 19851200 ? Ss 11:32 19:12 postgres: postgres xytocc_business 10.201.8.42(36964) idle systemd+ 452858 31.2 21.9 35024384 14392064 ? Ss 11:44 20:47 postgres: postgres xytocc_business 10.201.8.42(43994) idle systemd+ 456016 7.7 4.7 34871872 3141888 ? Ss 11:47 4:56 postgres: postgres xytocc_business 10.201.8.42(59750) idle systemd+ 461249 16.9 29.6 35291584 19419136 ? Rs 11:51 10:01 postgres: postgres xytocc_business 10.201.8.43(50892) REFRESH MATERIALIZED VIEW systemd+ 461400 12.1 29.3 35073152 19245888 ? Ss 11:52 7:10 postgres: postgres xytocc_business 10.201.8.43(49608) idle systemd+ 461415 21.0 30.6 35189120 20083968 ? Ss 11:52 12:24 postgres: postgres xytocc_business 10.201.8.43(49642) idle systemd+ 465784 0.7 3.4 34951488 2258112 ? Ss 11:55 0:25 postgres: postgres xytocc_business 10.201.19.2(40003) idle systemd+ 466701 0.9 3.4 34951488 2242240 ? Ss 11:56 0:31 postgres: postgres xytocc_business 10.201.19.2(40067) idle systemd+ 466702 0.0 0.2 34820160 131648 ? Ss 11:56 0:00 postgres: postgres xytocc_business 10.201.19.2(40068) idle systemd+ 469484 17.0 29.2 35024960 19173248 ? Ss 11:58 8:57 postgres: postgres xytocc_business 10.201.8.43(42498) idle systemd+ 471663 34.2 30.3 35026816 19929792 ? Ss 12:00 17:19 postgres: postgres xytocc_business 10.201.8.42(48218) REFRESH MATERIALIZED VIEW waiting systemd+ 471664 33.6 24.9 35022080 16335360 ? Ss 12:00 17:00 postgres: postgres xytocc_business 10.201.8.42(48230) idle systemd+ 482757 17.6 29.1 34978624 19131776 ? Ss 12:10 7:14 postgres: postgres xytocc_business 10.201.8.43(35554) idle systemd+ 482939 1.1 1.0 34815168 665280 ? Ss 12:10 0:28 postgres: postgres xytocc_business 10.201.9.36(60308) idle systemd+ 488796 1.6 1.0 34815168 666304 ? Ss 12:15 0:35 postgres: postgres xytocc_business 10.201.9.36(37194) idle systemd+ 491194 0.0 0.0 34813376 22272 ? Ss 12:17 0:00 postgres: postgres xytocc_business 10.201.8.23(57432) idle systemd+ 491195 0.0 0.0 34813376 22272 ? Ss 12:17 0:00 postgres: postgres xytocc_business 10.201.8.23(57442) idle systemd+ 491196 0.0 0.0 34813376 22336 ? Ss 12:17 0:00 postgres: postgres xytocc_business 10.201.8.23(57458) idle systemd+ 491198 0.0 0.0 34813376 22336 ? Ss 12:17 0:00 postgres: postgres xytocc_business 10.201.8.23(57466) idle systemd+ 491199 0.0 0.0 34813376 22336 ? Ss 12:17 0:00 postgres: postgres xytocc_business 10.201.8.23(57468) idle systemd+ 491523 0.0 2.6 34820736 1747008 ? Ss 12:17 0:01 postgres: postgres xytocc_business 10.29.105.4(11432) idle systemd+ 491880 0.0 0.0 34813376 32192 ? Ss 12:18 0:00 postgres: postgres xytocc_business 10.29.105.4(12568) idle systemd+ 502342 15.8 23.5 34974272 15423168 ? Ss 12:27 3:46 postgres: postgres xytocc_business 10.201.8.43(60710) idle systemd+ 505742 2.9 1.0 34815168 661952 ? Ss 12:30 0:36 postgres: postgres xytocc_business 10.201.9.36(33718) idle systemd+ 507263 0.0 0.0 34813376 24000 ? Ss 12:31 0:00 postgres: postgres xytocc_business 10.201.8.21(49070) idle systemd+ 511404 0.0 1.3 34820352 902912 ? Ss 12:35 0:00 postgres: postgres xytocc_business 10.29.105.4(11466) idle systemd+ 511405 0.0 0.0 34813568 49344 ? Ss 12:35 0:00 postgres: postgres xytocc_business 10.29.105.4(11468) idle systemd+ 511406 0.0 0.0 34813568 35136 ? Ss 12:35 0:00 postgres: postgres xytocc_business 10.29.105.4(11472) idle systemd+ 512083 0.1 1.2 34823168 810688 ? Ss 12:36 0:01 postgres: postgres xytocc_business 10.29.105.4(13656) idle systemd+ 512292 0.0 0.0 34813376 23808 ? Ss 12:36 0:00 postgres: postgres xytocc_business 10.29.105.4(14310) idle systemd+ 512834 0.0 0.0 34813376 23936 ? Ss 12:36 0:00 postgres: postgres xytocc_business 10.201.8.21(60368) idle systemd+ 512879 0.0 0.0 34813376 20352 ? Ss 12:36 0:00 postgres: postgres xytocc_business 10.29.105.4(16052) idle systemd+ 512880 0.0 0.0 34813376 20352 ? Ss 12:36 0:00 postgres: postgres xytocc_business 10.29.105.4(16054) idle systemd+ 514756 0.0 0.0 34815168 60672 ? Ss 12:38 0:00 postgres: postgres xytocc_business 10.29.105.4(21544) idle systemd+ 517792 0.0 0.0 34813376 20352 ? Ss 12:41 0:00 postgres: postgres xytocc_business 10.29.105.4(31584) idle systemd+ 517793 0.0 0.0 34813376 20352 ? Ss 12:41 0:00 postgres: postgres xytocc_business 10.29.105.4(31586) idle systemd+ 518294 0.0 0.0 34813376 20352 ? Ss 12:41 0:00 postgres: postgres xytocc_business 10.201.8.21(53186) idle systemd+ 518295 0.0 0.0 34813376 20288 ? Ss 12:41 0:00 postgres: postgres xytocc_business 10.201.8.21(53202) idle systemd+ 518333 0.0 0.0 34813376 20352 ? Ss 12:41 0:00 postgres: postgres xytocc_business 10.29.105.4(33150) idle systemd+ 518334 0.0 0.0 34813376 20352 ? Ss 12:41 0:00 postgres: postgres xytocc_business 10.29.105.4(33152) idle systemd+ 518335 0.0 0.0 34813376 20352 ? Ss 12:41 0:00 postgres: postgres xytocc_business 10.29.105.4(33154) idle systemd+ 518743 0.0 0.0 34813376 20352 ? Ss 12:42 0:00 postgres: postgres xytocc_business 10.29.105.4(35070) idle systemd+ 521053 33.6 3.3 34848448 2203136 ? Rs 12:44 2:17 postgres: postgres xytocc_business 10.201.8.42(58882) SELECT systemd+ 521058 0.1 2.0 34816064 1355136 ? Ss 12:44 0:00 postgres: postgres xytocc_business 10.201.8.42(58902) idle systemd+ 521059 20.2 3.1 34834624 2086464 ? Rs 12:44 1:23 postgres: postgres xytocc_business 10.201.8.42(58906) SELECT systemd+ 521197 0.0 0.0 34813376 20352 ? Ss 12:44 0:00 postgres: postgres xytocc_business 10.29.105.4(42208) idle systemd+ 521198 0.0 0.0 34813376 20352 ? Ss 12:44 0:00 postgres: postgres xytocc_business 10.29.105.4(42210) idle systemd+ 521199 0.0 0.0 34813376 20288 ? Ss 12:44 0:00 postgres: postgres xytocc_business 10.29.105.4(42212) idle systemd+ 521762 0.0 0.0 34813376 20224 ? Ss 12:44 0:00 postgres: postgres xytocc_business 10.29.105.4(44158) idle systemd+ 521763 0.0 0.0 34813376 20288 ? Ss 12:44 0:00 postgres: postgres xytocc_business 10.29.105.4(44160) idle systemd+ 521764 0.0 0.0 34813376 20224 ? Ss 12:44 0:00 postgres: postgres xytocc_business 10.29.105.4(44162) idle systemd+ 522320 0.2 0.9 34815232 627264 ? Ss 12:45 0:00 postgres: postgres xytocc_business 10.201.9.36(41252) idle systemd+ 522327 0.4 0.9 34815040 630272 ? Ss 12:45 0:01 postgres: postgres xytocc_business 10.201.9.36(41308) idle systemd+ 522335 5.0 0.9 34816192 644800 ? Ss 12:45 0:17 postgres: postgres xytocc_business 10.201.9.36(41326) idle systemd+ 522336 0.6 0.9 34815104 629760 ? Ss 12:45 0:02 postgres: postgres xytocc_business 10.201.9.36(41334) idle systemd+ 522341 3.9 0.9 34815232 646912 ? Ss 12:45 0:13 postgres: postgres xytocc_business 10.201.9.36(41352) idle systemd+ 522342 0.1 0.9 34815104 615552 ? Ss 12:45 0:00 postgres: postgres xytocc_business 10.201.9.36(41356) idle systemd+ 522347 1.8 0.9 34815232 637248 ? Ss 12:45 0:06 postgres: postgres xytocc_business 10.201.9.36(41366) idle systemd+ 523318 0.0 0.0 34813376 20416 ? Ss 12:46 0:00 postgres: postgres xytocc_business 10.29.105.4(50124) idle systemd+ 523319 0.0 0.0 34813376 20352 ? Ss 12:46 0:00 postgres: postgres xytocc_business 10.29.105.4(50126) idle systemd+ 523828 0.0 0.0 34813376 20416 ? Ss 12:46 0:00 postgres: postgres xytocc_business 10.201.8.21(33150) idle systemd+ 523981 0.0 0.0 34813376 20352 ? Ss 12:46 0:00 postgres: postgres xytocc_business 10.29.105.4(52278) idle systemd+ 523982 0.0 0.0 34813376 20352 ? Ss 12:46 0:00 postgres: postgres xytocc_business 10.29.105.4(52280) idle systemd+ 523983 0.0 0.0 34813376 20352 ? Ss 12:46 0:00 postgres: postgres xytocc_business 10.29.105.4(52282) idle systemd+ 526877 0.0 0.0 34813376 20352 ? Ss 12:49 0:00 postgres: postgres xytocc_business 10.29.105.4(60838) idle systemd+ 526878 0.0 0.0 34813376 20352 ? Ss 12:49 0:00 postgres: postgres xytocc_business 10.29.105.4(60840) idle systemd+ 526900 2.6 5.8 34833984 3865408 ? Ds 12:49 0:02 postgres: autovacuum worker xytocc_business systemd+ 527391 0.0 0.0 34813376 20352 ? Ss 12:49 0:00 postgres: postgres xytocc_business 10.29.105.4(62338) idle systemd+ 527392 0.0 0.0 34813376 20352 ? Ss 12:49 0:00 postgres: postgres xytocc_business 10.29.105.4(62340) idle systemd+ 527393 0.0 0.0 34813376 20352 ? Ss 12:49 0:00 postgres: postgres xytocc_business 10.29.105.4(62342) idle systemd+ 527862 100 9.1 35509440 6005760 ? Rs 12:50 0:48 postgres: postgres xytocc_business 10.201.9.36(48400) SELECT systemd+ 527866 0.0 0.0 34813568 31936 ? Ss 12:50 0:00 postgres: postgres xytocc_business 10.201.9.36(48442) idle systemd+ 527876 94.7 3.2 34814656 2100864 ? Rs 12:50 0:45 postgres: postgres xytocc_business 10.201.9.36(48514) BIND systemd+ 527885 93.9 3.3 34814720 2185728 ? Rs 12:50 0:44 postgres: postgres xytocc_business 10.201.9.36(48528) INSERT root 528826 0.0 0.0 214016 1536 pts/0 S+ 12:51 0:00 grep postgre systemd+ 569629 0.3 16.2 34983040 10678656 ? Ss Jul10 17:53 postgres: postgres xytocc_business 10.201.8.41(38250) idle systemd+ 816752 0.3 47.2 35111040 31024064 ? Ss Jun25 95:37 postgres: postgres xytocc_business 10.201.8.41(44936) idle systemd+ 856330 0.0 0.0 34813376 23424 ? Ss Jul11 0:03 postgres: postgres xytocc_business 10.29.105.4(34090) idle systemd+ 1141065 1.5 10.6 34895872 6967360 ? Ss Jul11 72:02 postgres: postgres xytocc_business 10.29.105.4(20448) idle systemd+ 1141451 1.6 10.1 34897408 6642048 ? Ss Jul11 75:57 postgres: postgres xytocc_business 10.29.105.4(22266) idle systemd+ 1148543 0.0 0.6 34815808 397120 ? Ss Jul11 0:24 postgres: postgres xytocc_business 10.201.8.43(60986) idle systemd+ 1154706 0.5 5.9 34935744 3872704 ? Ss Jul11 25:12 postgres: postgres xytocc_business 10.201.8.43(48754) idle systemd+ 1154707 0.7 5.9 34938496 3899968 ? Ss Jul11 32:45 postgres: postgres xytocc_business 10.201.8.42(34528) idle systemd+ 1195945 2.6 11.0 34908224 7269376 ? Ss Jul11 119:46 postgres: postgres xytocc_business 10.201.8.43(35608) idle systemd+ 1309795 2.2 6.0 34929280 3964096 ? Ss Jul11 97:23 postgres: postgres xytocc_business 10.201.8.41(48050) idle systemd+ 1359058 1.8 14.8 34929344 9769920 ? Ds Jun30 379:01 postgres: postgres xytocc_business 10.201.8.41(43012) INSERT systemd+ 1441579 0.9 14.9 35028800 9825472 ? Ss Jul11 38:16 postgres: postgres xytocc_business 10.201.8.43(46736) idle systemd+ 1467690 0.1 31.3 34964480 20551040 ? Ss Jul11 6:51 postgres: postgres xytocc_business 10.201.8.41(44288) idle systemd+ 1587365 2.5 12.0 35066176 7932800 ? Ss Jul11 103:03 postgres: postgres xytocc_business 10.29.105.4(9276) idle systemd+ 1633448 0.8 0.0 34813568 14208 ? Ss Jul11 35:19 postgres: walsender repl 10.201.9.50(46462) streaming 2CDC/7D44EA88 systemd+ 1637669 0.2 23.2 34813696 15273792 ? Ss Jun30 42:35 postgres: postgres xytocc_business 10.201.8.41(33434) idle systemd+ 1952392 0.2 43.1 35442688 28322624 ? Ss Jul12 9:51 postgres: postgres xytocc_business 10.201.8.42(50898) idle systemd+ 2278828 0.0 17.3 34967552 11385728 ? Ss Jul12 2:15 postgres: postgres xytocc_business 10.201.8.41(47112) idle systemd+ 2293552 1.0 12.6 35038848 8286144 ? Ss Jul12 32:08 postgres: postgres xytocc_business 10.201.8.42(38900) idle systemd+ 2412923 0.1 1.5 34808640 1029440 ? Ss Jun12 75:28 postgres systemd+ 2412956 0.0 0.0 69312 6144 ? Ss Jun12 0:03 postgres: logger systemd+ 2412966 0.4 48.3 34813632 31724736 ? Ss Jun12 203:51 postgres: checkpointer systemd+ 2412967 0.0 46.7 34810368 30653696 ? Ss Jun12 27:28 postgres: background writer systemd+ 2412968 0.1 0.2 34808640 138304 ? Ss Jun12 47:11 postgres: walwriter systemd+ 2412969 0.0 0.0 34812992 11328 ? Ss Jun12 5:24 postgres: autovacuum launcher systemd+ 2412970 0.2 0.0 76032 11200 ? Ds Jun12 135:54 postgres: stats collector systemd+ 2412971 0.0 0.0 34812800 10432 ? Ss Jun12 0:51 postgres: logical replication launcher systemd+ 2412994 0.1 35.7 34942528 23426368 ? Ss Jun12 52:43 postgres: postgres xytocc_business 10.29.105.4(21246) idle systemd+ 2412995 7.8 36.6 35916224 24055424 ? Ss Jun12 3642:53 postgres: postgres xytocc_business 10.29.105.4(21248) idle systemd+ 2413232 0.0 2.2 34813376 1455232 ? Ss Jun12 3:16 postgres: postgres xytocc_business 10.201.8.41(49564) idle systemd+ 2413241 1.2 0.6 34814144 429504 ? Ss Jun12 579:21 postgres: postgres xytocc_business 10.29.105.4(22132) idle systemd+ 2413242 1.2 0.6 34814144 428288 ? Ss Jun12 585:58 postgres: postgres xytocc_business 10.201.8.42(51444) idle systemd+ 2413243 1.2 0.6 34814144 428288 ? Ss Jun12 602:20 postgres: postgres xytocc_business 10.29.105.4(22136) idle systemd+ 2413250 1.2 0.6 34814144 420736 ? Ss Jun12 567:21 postgres: postgres xytocc_business 10.201.8.43(53388) idle systemd+ 2413735 1.8 46.9 34980480 30803392 ? Ss Jun12 870:41 postgres: postgres xytocc_business 10.201.8.43(51974) idle systemd+ 2419961 0.0 3.4 34813376 2245120 ? Ss Jun12 1:06 postgres: postgres xytocc_business 10.29.105.4(55866) idle systemd+ 2419962 0.0 3.4 34813376 2242624 ? Ss Jun12 1:06 postgres: postgres xytocc_business 10.29.105.4(55868) idle systemd+ 2431267 0.1 43.9 34942080 28844224 ? Ss Jun12 89:45 postgres: postgres xytocc_business 10.29.105.4(50476) idle systemd+ 2431268 0.0 29.6 34940544 19459648 ? Ss Jun12 38:22 postgres: postgres xytocc_business 10.29.105.4(50478) idle systemd+ 2433716 0.0 0.1 34813504 86784 ? Ss Jun12 0:46 postgres: postgres xytocc_business 10.29.105.4(63412) idle systemd+ 2439761 0.0 0.1 34813568 82560 ? Ss Jun12 0:44 postgres: postgres xytocc_business 10.29.105.4(30996) idle systemd+ 2540527 0.7 7.6 34890240 4987328 ? Ss Jul12 20:07 postgres: postgres xytocc_business 10.201.8.42(52584) idle systemd+ 2572791 3.3 41.5 34958144 27241024 ? Ss Jul08 275:51 postgres: postgres xytocc_business 10.201.8.41(37346) idle systemd+ 2817354 3.6 20.0 34926016 13177088 ? Ss Jul12 87:08 postgres: postgres xytocc_business 10.201.8.41(59400) idle systemd+ 2835108 0.2 42.0 34941376 27573056 ? Ss Jun12 104:52 postgres: postgres xytocc_business 10.29.105.4(12496) idle systemd+ 2904091 0.0 0.0 34813568 36544 ? Ss Jun23 0:05 postgres: postgres xytocc_business 10.29.105.4(53746) idle systemd+ 3002596 0.0 27.3 34932672 17923584 ? Ss Jul13 1:08 postgres: postgres xytocc_business 10.201.8.41(53886) idle systemd+ 3388834 0.0 6.2 34928768 4104960 ? Ss Jul13 0:50 postgres: postgres xytocc_business 10.201.8.43(44382) idle systemd+ 3419404 2.8 15.8 35098624 10430080 ? Ss Jul09 199:49 postgres: postgres xytocc_business 10.201.8.43(44776) idle systemd+ 3419408 2.7 13.0 35077888 8567168 ? Ss Jul09 193:15 postgres: postgres xytocc_business 10.201.8.42(47776) idle systemd+ 3427806 1.1 3.7 34934016 2490240 ? Ss Jul13 18:07 postgres: postgres xytocc_business 10.201.8.43(47192) idle systemd+ 3448065 0.0 0.0 34813376 23680 ? Ss Jul13 0:01 postgres: postgres xytocc_business 10.29.105.4(21380) idle systemd+ 3535566 0.3 46.6 35674304 30582656 ? Ss Jul09 22:49 postgres: postgres xytocc_business 10.201.8.42(60030) idle systemd+ 3599835 0.0 1.3 34822592 892416 ? Ss Jul13 1:00 postgres: postgres xytocc_business 10.29.105.4(54160) idle systemd+ 3717752 0.5 13.8 34986176 9094848 ? Ss Jul13 7:09 postgres: postgres xytocc_business 10.29.105.4(21708) idle systemd+ 3717754 0.6 10.9 34982144 7188352 ? Ss Jul13 8:28 postgres: postgres xytocc_business 10.29.105.4(21714) idle systemd+ 3736178 0.2 15.0 35421120 9871360 ? Ss Jul13 2:47 postgres: postgres xytocc_business 10.201.8.42(38204) idle systemd+ 3851087 0.3 2.7 34955328 1799552 ? Ss Jul13 3:16 postgres: postgres xytocc_business 10.201.8.41(59724) idle systemd+ 3878356 0.6 4.0 34955456 2676800 ? Ss Jul13 6:34 postgres: postgres xytocc_business 10.201.8.41(56436) idle systemd+ 4105266 1.8 11.2 34961984 7361856 ? Ss 00:54 12:54 postgres: postgres xytocc_business 10.201.8.41(46510) idle 用了多少运行内存
最新发布
07-15
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值