RSS你会用了吗?答曰:不会

在查关于RBAC权限管理设计的时候看到了RSS的相关内容,自己也经常用RSS,可是猛的一问,RSS你会用了吗? 11.gif答曰:不会。
如果想了解这方面的资料的话,大家可以参考一下如下文章( (作者:李天平    转载请注明)):

Web2.0时代,RSS你会用了吗?(技术实现总结)

出自:http://www.cnblogs.com/ltp/archive/2006/01/15/317725.html

     如见Web2.0被吵的如火如荼,同时也有很多的评论褒贬不一。有人说Web2.0就是“一帮人在看皇帝的新装而已”。也有人说Web2.0将是一场变革。无论这些争论有没有价值,但我相信,存在就有它的必然性。也许Web2.0更像是一种商业模式,一个观念的变革而非技术。
     不管怎样,它来了,你准备好了吗?
     说到Web2.0,就会提到Blog、TAG、SNS、RSS、wiki这些软件应用和xml、ajax等这些新理论和技术实现。
RSS毋容置疑就是其重要的应用之一。

     那么什么是RSS?它到底有什么用呢?

     RSS是站点与站点之间共享内容的一种简易方式(也称为“聚合内容”),通常被用于新闻和其他按顺序排列的网站,例如Blog网站。网站提供RSS输出,有利于让用户发现网站内容的更新。网站用户可以在客户端借助于类似新闻资讯阅读器等支持RSS的新闻聚合工具软件,在不打开网站内容页面的情况下阅读支持RSS输出的网站内容。
     RSS是基于XML的一种形式。并且所有的RSS文件都要遵守万维网联盟(W3C)站点发布的XML 1.0规范。具体格式可以查一下RSS 2.0规范,这里就不再重复粘贴了。

下面是我总结的几种RSS的技术实现代码:

1.在线生成RSS聚合页

(1)创建Rss.aspx
<%@ Page language="c#" Codebehind="Rss.aspx.cs" AutoEventWireup="false" Inherits="LiTianPing.Rss" %>
只留下这一行,其余的都删掉。

(2)后台代码;Rss.aspx.cs

  private void Page_Load(object sender, System.EventArgs e)
  {    
   Response.ContentType="text/xml";
   Response.Write(GetRSS());
  }

  /// <summary>
  /// 取得聚合文章
  /// </summary>
  /// <returns></returns>
  public string GetRSS()
  {
   News t=new News();//自己的业务类
   DataSet ds=t.GetListByClass(1);//根据类别得到数据
   
   StringBuilder strCode=new StringBuilder();
   strCode.Append("<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"yes\" ?>");
   strCode.Append("<rss version='2.0' xmlns:dc=\"http://purl.org/dc/elements/1.1/\"");
   strCode.Append(" xmlns:trackback=\"http://madskills.com/public/xml/rss/module/trackback/\" ");
   strCode.Append(" xmlns:wfw=\"http://wellformedweb.org/CommentAPI/\" xmlns:slash=\"http://purl.org/rss/1.0/modules/slash/\">");
   strCode.Append("<channel>");
   strCode.Append("<title>李天平RSSDemo</title>");
   strCode.Append("<link>http://"+Request.ServerVariables["SERVER_NAME"]+"</link> ");
   strCode.Append("<description>天道酬勤</description> ");  
   strCode.Append("<copyright>Copyright 2005</copyright> ");      
   
   foreach(DataRow row in ds.Tables[0].Rows)
   {
    string Id=row["Id"].ToString();
    string title=row["title"].ToString();
    string description=row["description"].ToString();
    string pubdate=row["pubdate"].ToString();
    string ClassId=row["ClassId"].ToString();
    //string author=row["author"].ToString();

    strCode.Append("<item>");
    strCode.Append("<title>"+title+"</title>");
    strCode.Append("<link>http://"+Request.ServerVariables["SERVER_NAME"]+"/NewsShow.aspx?ID="+Id+"</link>");
    strCode.Append("<subject>"+description+"</subject>");
    strCode.Append("<description><![CDATA["+description+"]]></description>");    
    strCode.Append("<PubDate>"+pubdate+"</PubDate>");
    strCode.Append("<category>"+ClassId+"</category>");
    strCode.Append("</item>");    
   }
   strCode.Append("</channel>");
   strCode.Append("</rss>");  
   return strCode.ToString();
  }

 (3) XmlTextWriter实现方式2;Rss.aspx.cs

  string xmlDoc="rss.xml"; 
 private void Page_Load(object sender, System.EventArgs e)
  {    
   xmlDoc=Server.MapPath(".")+xmlDoc;   
   GetRSS2();
   XmlDocument doc= new XmlDocument();
   doc.Load(xmlDoc);
   Response.ContentType = "text/xml";
   doc.Save(Response.Output);
  }
  /// <summary>
  /// 取得聚合文章
  /// </summary>
  /// <returns></returns>
  public void GetRSS2()
  {
   News t=new News();
   DataSet ds=t.GetListByClass(1);
   
   XmlTextWriter writer = new XmlTextWriter(xmlDoc,Encoding.UTF8);
   writer.Formatting = Formatting.Indented;
   writer.WriteStartDocument(true);
   writer.WriteComment("RSS页的实现");
   writer.WriteStartElement("rss");
   writer.WriteAttributeString("version","2.0");      
   writer.WriteStartElement("channel");   
   writer.WriteStartElement("title");
   writer.WriteString("李天平RSSDemo");
   writer.WriteEndElement();
   writer.WriteStartElement("link");   
   writer.WriteString("http://"+Request.ServerVariables["SERVER_NAME"]);
   writer.WriteEndElement();   
   writer.WriteStartElement("description");
   writer.WriteString("天道酬勤");
   writer.WriteEndElement();
   writer.WriteStartElement("copyright");
   writer.WriteString("Copyright 2005");
   writer.WriteEndElement();
   writer.WriteStartElement("language");
   writer.WriteString("zh-cn");
   writer.WriteEndElement();  
      
   foreach(DataRow row in ds.Tables[0].Rows)
   {
    string Id=row["Id"].ToString();
    string title=row["title"].ToString();
    string description=row["description"].ToString();
    string pubdate=row["pubdate"].ToString();
    string ClassId=row["ClassId"].ToString();
    //string author=row["author"].ToString();

    writer.WriteStartElement("item");
    writer.WriteStartElement("title");
    writer.WriteString(title);
    writer.WriteEndElement();
    writer.WriteStartElement("link");
    writer.WriteString("http://"+Request.ServerVariables["SERVER_NAME"]+"/NewsShow.aspx?ID="+Id) ;
    writer.WriteEndElement();
    writer.WriteStartElement("description");
    writer.WriteCData(description);
    writer.WriteEndElement();
    writer.WriteStartElement("pubDate");
    writer.WriteString(pubdate);
    writer.WriteEndElement();
    writer.WriteStartElement("category");
    writer.WriteString(ClassId);
    writer.WriteEndElement();
    writer.WriteEndElement();  
   }
   writer.WriteEndElement();
   writer.WriteEndElement();
   writer.Flush();
   writer.Close();
 
  }
2.在线RSS阅读获取。

页面代码:
  <P style="FONT-SIZE: 11px">
   Feed种子:<asp:TextBox id="FeedUrl" runat="server" Width="440px"></asp:TextBox><BR>
   显示条数:<asp:TextBox id="Num" runat="server" Width="48px"></asp:TextBox></P>
  <P style="FONT-SIZE: 11px">
   <asp:Button id="GetFeed" runat="server" Text="获得RSS"></asp:Button><BR>
   <BR>
   <asp:Label id="RssFeed" runat="server"></asp:Label></P>

后台代码:
  /// <summary>
  /// 获得要显示的Feed种子数据
  /// </summary>
  /// <param name="RssUrl"></param>
  /// <param name="showNewsCount"></param>
  /// <returns></returns>
  public string LoadRSS(string RssUrl, int showNewsCount)
  {
   string strRssList = "";
   string strMsg;
   try
   {      
    XmlDocument objXMLDoc = new XmlDocument();   
    objXMLDoc.Load(RssUrl);  
    XmlNodeList objItems = objXMLDoc.GetElementsByTagName("item");    
  
    if(showNewsCount > 30)
     showNewsCount = 10;  
    if(showNewsCount < 1)
     showNewsCount = objItems.Count;
  
    string title="";
    string link=""; 
    int i;

    if(objXMLDoc.HasChildNodes == true)
    {
     i = 1;
        foreach(XmlNode objNode in objItems)
     {
      if(i<=showNewsCount)
      {
       if(objNode.HasChildNodes == true)
       {
        XmlNodeList objItemsChild = objNode.ChildNodes;
        foreach(XmlNode objNodeChild in objItemsChild)
        {
         switch(objNodeChild.Name)
         {
          case "title":
           title = objNodeChild.InnerText;
           break;
          case "link":
           link = objNodeChild.InnerText;
           break;          
         }         
        }
        i = i+1;
        strRssList += "<a href=" + link +" target=_blank>" + title + "</a><br>"; 
       }      
      }
     }       
    }
    strMsg = strRssList;
   }
   catch
   {
    strMsg = "RSS Feed 源数据出错!";
   }
   return strMsg;
  }

  //获取按钮,获取指定RSS
  private void GetFeed_Click(object sender, System.EventArgs e)
  {
   if(FeedUrl.Text == "")//RSS地址
   {
    RssFeed.Text = "信息源不能为空,您可刷新重试或联系管理员!";
    return ;
   }  
   RssFeed.Text = LoadRSS(FeedUrl.Text,Convert.ToInt32(Num.Text)); //获取指定数目 
  }

3.无刷新动态更新的在线RSS阅读获取

<%@ Page language="c#" Codebehind="XmlHttp.aspx.cs" AutoEventWireup="false" Inherits="LiTianPing.XmlHttp" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
 <HEAD>
  <title>XmlHttp</title>
  <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
  <meta name="CODE_LANGUAGE" Content="C#">
  <meta name="vs_defaultClientScript" content="JavaScript">
  <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
  <style>td { font-size: 9pt}
  </style>
  <script>
  <!-- 
  var oDiv
  var xh    
  function getXML()
  {   
   xh =new ActiveXObject("Microsoft.XMLHTTP");
   oDiv = document.getElementById("rssitem");
   oDiv.style.display= "";
   try
   {
    //如果是本地改成下面语句直接读取
    //xh.open("GET","/Rss.aspx",false);    
    xh.open("GET","Http://ltp.cnblogs.com/Rss.aspx",false);
    xh.send(null);
    loadData(xh,oDiv);
   }
   catch(e)
   {
    error(oDiv);
   }
  }
  function loadData(xh,oDiv)
  {
   if (xh.readyState == 4)
   {
    xml = xh.responsexml;
    var i;
    var nodes = xml.selectNodes("/rss/channel/item");
    var bloglink = xml.selectSingleNode("/rss/channel/link").text;
    oDiv.innerHTML = "";
    var html;    
    for(i=0;i<nodes.length;i++)
    {    
        
      html += "<div >";
      html += "    <div >";
      html += "        <a class=font1 href='" +nodes[i].selectSingleNode("link").text + "' target='_blank'>" + nodes[i].selectSingleNode("title").text +"</a><BR><BR>";
      html += "    </div>";
      html += "    <div >";
      html += "        " +nodes[i].selectSingleNode("description").text;
      html += "    </div>"           
      //html += "    </div>";
      html += "</div><hr>";

    }
    oDiv.innerHTML = html;
   }
   else
   {
    error(oDiv);
   }
  }

  function error(oDiv)
  {
   oDiv.innerHTML = "载入失败";
  }
  -->
  </script>
 </HEAD>
 <body MS_POSITIONING="GridLayout" onload="window.setTimeout('getXML()',200);">
  <form id="Form1" method="post" runat="server">
   <div align=center>
   <table cellpadding="0" cellspacing="0" border="0" width="80%">
    <tr>
     <td>
      <div id="rssitem" style="WIDTH:80%">数据载入中...</div>
     </td>
    </tr>
   </table>
   </div>
  </form>
 </body>
</HTML>

转载于:https://www.cnblogs.com/edrp/archive/2007/03/11/671232.html

[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、付费专栏及课程。

余额充值