{"id":1333,"date":"2022-10-17T11:23:27","date_gmt":"2022-10-17T03:23:27","guid":{"rendered":"http:\/\/175.24.184.226\/?p=1333"},"modified":"2023-02-09T18:05:13","modified_gmt":"2023-02-09T10:05:13","slug":"%e6%9f%a5%e7%9c%8b%e6%95%b0%e6%8d%ae%e5%ba%93%e8%bf%9e%e6%8e%a5","status":"publish","type":"post","link":"\/?p=1333","title":{"rendered":"\u5e38\u7528SQL"},"content":{"rendered":"<p>\u5e38\u7528SQL\uff1a<\/p>\n<ol>\n<li>\u67e5\u770b\u6570\u636e\u5e93\u8fde\u63a5\u6570\u60c5\u51b5\uff1a\n<pre><code class=\"language-sql\">select * from pg_stat_activity;<\/code><\/pre>\n<\/li>\n<li>\u67e5\u627e\u8868\u4e2d\u91cd\u590d\u8bb0\u5f55,\u91cd\u590d\u8bb0\u5f55\u662f\u6839\u636e\u5355\u4e2a\u5b57\u6bb5\u6765\u5224\u65ad,\u5e76\u7edf\u8ba1\u91cd\u590d\u6b21\u6570\n<pre><code class=\"language-sql\">SELECT [\u91cd\u590d\u5b57\u6bb5],COUNT(1) AS num FROM [\u8868\u540d]GROUP BY [\u91cd\u590d\u5b57\u6bb5] HAVING COUNT(1) &gt; 1<\/code><\/pre>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u5e38\u7528SQL\uff1a \u67e5\u770b\u6570\u636e\u5e93\u8fde\u63a5\u6570\u60c5\u51b5\uff1a select * from pg_stat_activity; \u67e5\u627e\u8868\u4e2d\u91cd\u590d\u8bb0\u5f55,\u91cd\u590d\u8bb0\u5f55\u662f\u6839\u636e\u5355   \u2026 &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[22],"tags":[],"_links":{"self":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1333"}],"collection":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1333"}],"version-history":[{"count":2,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1333\/revisions"}],"predecessor-version":[{"id":1483,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1333\/revisions\/1483"}],"wp:attachment":[{"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1333"},{"taxonomy":"post_tag","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}