smem工具分析 postgresql 的进程内存情况

淡淡的烟草味﹌ 2023-01-06 04:29 185阅读 0赞

# cat /etc/centos-release
    CentOS Linux release 7.4.1708 (Core)
    
    # yum list all |grep -i smem
    
    smem.noarch                                1.4-1.el7              epel          
    
    
    # yum install smem

# smem -U postgres 
      PID User     Command                         Swap      USS      PSS      RSS 
     1268 postgres postgres: logger                   0      160      310     2040 
     1567 postgres postgres: checkpointer             0      200      361     2236 
     1571 postgres postgres: stats collector          0      224      372     2184 
     1572 postgres postgres: logical replicati        0      488      740     2872 
     1570 postgres postgres: autovacuum launch        0      604      921     3216 
     2024 postgres psql                               0     1724     1890     4152 
     1956 postgres -bash                              0     1680     1915     3352 
     1568 postgres postgres: background writer        0      204     6452    14620 
     1569 postgres postgres: walwriter                0      196     8562    18656 
     2025 postgres postgres: postgres postgres        0    46672    48707    53040 
     1149 postgres /usr/pgsql-11/bin/postmaste        0    74368    90754   111664

# smem -U postgres -k
      PID User     Command                         Swap      USS      PSS      RSS 
     1290 postgres postgres: logger                   0   160.0K   340.0K     2.0M 
     1298 postgres postgres: stats collector          0   276.0K   461.0K     2.2M 
     1299 postgres postgres: logical replicati        0   484.0K   809.0K     2.8M 
     1297 postgres postgres: autovacuum launch        0   636.0K  1022.0K     3.2M 
     1295 postgres postgres: background writer        0   196.0K     4.4M    14.3M 
     1296 postgres postgres: walwriter                0   208.0K     8.4M    18.3M 
     1294 postgres postgres: checkpointer             0    28.5M    32.9M    43.2M 
     1152 postgres /usr/pgsql-11/bin/postmaste        0    75.3M    88.1M   109.0M

# smem -U postgres -k |head -1;smem -U postgres -k |grep -i postgres |sort -k 1 -n -r
    
      PID User     Command                         Swap	 USS	  PSS	   RSS
     5917 postgres -bash                              0     1.7M     1.8M     3.4M
     4872 postgres -bash                              0     1.6M     1.7M     3.2M
     3963 postgres postgres: logical replicati        0   448.0K   758.0K     2.7M
     3962 postgres postgres: stats collector          0   216.0K   394.0K     2.1M
     3961 postgres postgres: autovacuum launch        0   552.0K     1.1M     3.5M
     3960 postgres postgres: walwriter                0   196.0K     2.1M     6.2M
     3958 postgres postgres: background writer        0    14.6M    62.6M   113.5M
     3957 postgres postgres: checkpointer             0    20.3M    67.9M   118.2M
     3946 postgres postgres: logger                   0   160.0K   337.0K     2.0M
     3893 postgres /usr/pgsql-11/bin/postmaste        0     5.3M     8.2M    16.6M

VSS – Virtual Set Size 虚拟耗用内存（包含共享库占用的内存）

RSS – Resident Set Size 实际使用物理内存（包含共享库占用的内存）

PSS – Proportional Set Size 实际使用的物理内存（比例分配共享库占用的内存）

USS – Unique Set Size 进程独自占用的物理内存（不包含共享库占用的内存）

参考：  
https://www.selenic.com/smem/