https://docs.mirrorship.cn/zh/assets/js/0c15c053.47b38292.js

1"use strict";(self.webpackChunkstarrocks=self.webpackChunkstarrocks||[]).push([[1803],{3354:(e,r,s)=>{s.r(r),s.d(r,{assets:()=>d,contentTitle:()=>i,default:()=>h,frontMatter:()=>c,metadata:()=>n,toc:()=>a});let n=JSON.parse('{"id":"sql-reference/sql-statements/cluster-management/plan_profile/SHOW_PROFILELIST","title":"SHOW PROFILELIST","description":"SHOW PROFILELIST lists the query profile records cached in your StarRocks cluster.","source":"@site/i18n/zh/docusaurus-plugin-content-docs/version-4.1/sql-reference/sql-statements/cluster-management/plan_profile/SHOW_PROFILELIST.md","sourceDirName":"sql-reference/sql-statements/cluster-management/plan_profile","slug":"/sql-reference/sql-statements/cluster-management/plan_profile/SHOW_PROFILELIST","permalink":"/zh/docs/sql-reference/sql-statements/cluster-management/plan_profile/SHOW_PROFILELIST","draft":false,"unlisted":false,"editUrl":"https://github.com/StarRocks/starrocks/edit/main/docs/zh/sql-reference/sql-statements/cluster-management/plan_profile/SHOW_PROFILELIST.md","tags":[],"version":"4.1","frontMatter":{"displayed_sidebar":"docs","description":"SHOW PROFILELIST lists the query profile records cached in your StarRocks cluster."},"sidebar":"docs","previous":{"title":"EXPLAIN ANALYZE","permalink":"/zh/docs/sql-reference/sql-statements/cluster-management/plan_profile/EXPLAIN_ANALYZE"},"next":{"title":"\u5BFC\u5165\u5BFC\u51FA","permalink":"/zh/docs/sql-reference/sql-statements/loading_unloading/"}}');var t=s(74848),l=s(28453);let c={displayed_sidebar:"docs",description:"SHOW PROFILELIST lists the query profile records cached in your StarRocks cluster."},i="SHOW PROFILELIST",d={},a=[{value:"\u529F\u80FD",id:"\u529F\u80FD",level:2},{value:"\u8BED\u6CD5",id:"\u8BED\u6CD5",level:2},{value:"\u53C2\u6570\u8BF4\u660E",id:"\u53C2\u6570\u8BF4\u660E",level:2},{value:"\u8FD4\u56DE",id:"\u8FD4\u56DE",level:2},{value:"\u793A\u4F8B",id:"\u793A\u4F8B",level:2},{value:"\u76F8\u5173 SQL",id:"\u76F8\u5173-sql",level:2}];function o(e){let r={a:"a",code:"code",h1:"h1",h2:"h2",header:"header",li:"li",p:"p",pre:"pre",strong:"strong",table:"table",tbody:"tbody",td:"td",th:"th",thead:"thead",tr:"tr",ul:"ul",...(0,l.R)(),...e.components};return(0,t.jsxs)(t.Fragment,{children:[(0,t.jsx)(r.header,{children:(0,t.jsx)(r.h1,{id:"show-profilelist",children:"SHOW PROFILELIST"})}),"\n",(0,t.jsx)(r.h2,{id:"\u529F\u80FD",children:"\u529F\u80FD"}),"\n",(0,t.jsxs)(r.p,{children:["\u5217\u51FA StarRocks \u96C6\u7FA4\u4E2D\u7F13\u5B58\u7684 Query Profile \u8BB0\u5F55\u3002\u66F4\u591A\u4FE1\u606F\uFF0C\u53C2\u8003 ",(0,t.jsx)(r.a,{href:"/zh/docs/best_practices/query_tuning/query_profile_overview",children:"Query Profile \u6982\u8FF0"}),"\u3002"]}),"\n",(0,t.jsx)(r.p,{children:"\u6B64\u529F\u80FD\u81EA v3.1 \u8D77\u652F\u6301\u3002"}),"\n",(0,t.jsxs)(r.p,{children:["\u9ED8\u8BA4\u60C5\u51B5\u4E0B\uFF0C\u8BE5\u64CD\u4F5C\u65E0\u9700\u4EFB\u4F55\u6743\u9650\u3002\u5982\u679C\u5C06 FE \u914D\u7F6E\u9879 ",(0,t.jsx)(r.code,{children:"authorization_enable_query_profile_access_check"})," \u8BBE\u7F6E\u4E3A ",(0,t.jsx)(r.code,{children:"true"}),"\uFF0C\u7528\u6237\u53EA\u80FD\u67E5\u770B\u81EA\u5DF1\u6267\u884C\u7684\u67E5\u8BE2\u7684 Query Profile \u8BB0\u5F55\uFF1B\u67E5\u770B\u5176\u4ED6\u7528\u6237\u6267\u884C\u7684\u67E5\u8BE2\u7684 Query Profile \u8BB0\u5F55\uFF0C\u9700\u8981 SYSTEM \u7EA7 OPERATE \u6743\u9650\u3002\u6709\u5173\u6388\u6743\u64CD\u4F5C\uFF0C\u53C2\u89C1 ",(0,t.jsx)(r.a,{href:"/zh/docs/sql-reference/sql-statements/account-management/GRANT",children:"GRANT"}),"\u3002"]}),"\n",(0,t.jsx)(r.h2,{id:"\u8BED\u6CD5",children:"\u8BED\u6CD5"}),"\n",(0,t.jsx)(r.pre,{children:(0,t.jsx)(r.code,{className:"language-SQL",children:"SHOW PROFILELIST [LIMIT n]\n"})}),"\n",(0,t.jsx)(r.h2,{id:"\u53C2\u6570\u8BF4\u660E",children:"\u53C2\u6570\u8BF4\u660E"}),"\n",(0,t.jsxs)(r.p,{children:[(0,t.jsx)(r.code,{children:"LIMIT n"}),"\uFF1A\u5217\u51FA\u6700\u65B0 n \u6761\u8BB0\u5F55\u3002"]}),"\n",(0,t.jsx)(r.h2,{id:"\u8FD4\u56DE",children:"\u8FD4\u56DE"}),"\n",(0,t.jsxs)(r.table,{children:[(0,t.jsx)(r.thead,{children:(0,t.jsxs)(r.tr,{children:[(0,t.jsx)(r.th,{children:(0,t.jsx)(r.strong,{children:"\u8FD4\u56DE"})}),(0,t.jsx)(r.th,{children:(0,t.jsx)(r.strong,{children:"\u8BF4\u660E"})})]})}),(0,t.jsxs)(r.tbody,{children:[(0,t.jsxs)(r.tr,{children:[(0,t.jsx)(r.td,{children:"QueryId"}),(0,t.jsx)(r.td,{children:"\u67E5\u8BE2 ID\u3002"})]}),(0,t.jsxs)(r.tr,{children:[(0,t.jsx)(r.td,{children:"StartTime"}),(0,t.jsx)(r.td,{children:"\u67E5\u8BE2\u5F00\u59CB\u65F6\u95F4\u3002"})]}),(0,t.jsxs)(r.tr,{children:[(0,t.jsx)(r.td,{children:"Time"}),(0,t.jsx)(r.td,{children:"\u67E5\u8BE2\u65F6\u957F\u3002"})]}),(0,t.jsxs)(r.tr,{children:[(0,t.jsx)(r.td,{children:"State"}),(0,t.jsxs)(r.td,{children:["\u67E5\u8BE2\u72B6\u6001\uFF0C\u5176\u4E2D\u5305\u62EC",(0,t.jsx)(r.code,{children:"Error"}

1),"\uFF1A\u67E5\u8BE2\u5F02\u5E38\u3002",(0,t.jsx)(r.code,{children:"Finished"}),"\uFF1A\u67E5\u8BE2\u6267\u884C\u7ED3\u675F\u3002",(0,t.jsx)(r.code,{children:"Running"}),"\uFF1A\u67E5\u8BE2\u6B63\u5728\u6267\u884C\u3002"]})]}),(0,t.jsxs)(r.tr,{children:[(0,t.jsx)(r.td,{children:"Statement"}),(0,t.jsx)(r.td,{children:"\u67E5\u8BE2\u5BF9\u5E94 SQL\u3002"})]})]})]}),"\n",(0,t.jsx)(r.h2,{id:"\u793A\u4F8B",children:"\u793A\u4F8B"}),"\n",(0,t.jsx)(r.p,{children:"\u793A\u4F8B\u4E00\uFF1A\u5217\u51FA\u6700\u65B0 5 \u6761 Query Profile \u8BB0\u5F55\u3002"}),"\n",(0,t.jsx)(r.pre,{children:(0,t.jsx)(r.code,{className:"language-SQL",children:"SHOW PROFILELIST LIMIT 5;\n"})}),"\n",(0,t.jsx)(r.h2,{id:"\u76F8\u5173-sql",children:"\u76F8\u5173 SQL"}),"\n",(0,t.jsxs)(r.ul,{children:["\n",(0,t.jsx)(r.li,{children:(0,t.jsx)(r.a,{href:"/zh/docs/sql-reference/sql-statements/cluster-management/plan_profile/ANALYZE_PROFILE",children:"ANALYZE PROFILE"})}),"\n",(0,t.jsx)(r.li,{children:(0,t.jsx)(r.a,{href:"/zh/docs/sql-reference/sql-statements/cluster-management/plan_profile/EXPLAIN_ANALYZE",children:"EXPLAIN ANALYZE"})}),"\n"]})]})}function h(e={}){let{wrapper:r}={...(0,l.R)(),...e.components};return r?(0,t.jsx)(r,{...e,children:(0,t.jsx)(o,{...e})}):o(e)}},28453:(e,r,s)=>{s.d(r,{R:()=>c,x:()=>i});var n=s(96540);let t={},l=n.createContext(t);function c(e){let r=n.useContext(l);return n.useMemo(function(){return"function"==typeof e?e(r):{...r,...e}},[r,e])}function i(e){let r;return r=e.disableParentContext?"function"==typeof e.components?e.components(t):e.components||t:c(e.components),n.createElement(l.Provider,{value:r},e.children)}}}]);