加入 Gitee

与超过 1200万开发者一起发现、参与优秀开源项目，私有仓库也完全免费：）

克隆/下载

STATEMENT_RESPONSETIME_PERCENTILE.md 3.26 KB

# STATEMENT\_RESPONSETIME\_PERCENTILE<a name="ZH-CN_TOPIC_0245374766"></a>

获取openGaussSQL响应时间P80，P95分布信息。

**表 1**  STATEMENT\_RESPONSETIME\_PERCENTILE的字段

<a name="zh-cn_topic_0237122662_table88111504412"></a>
<table><thead align="left"><tr id="zh-cn_topic_0237122662_row8223550348"><th class="cellrowborder" valign="top" width="28.56714328567143%" id="mcps1.2.4.1.1"><p id="zh-cn_topic_0237122662_p162231550242"><a name="zh-cn_topic_0237122662_p162231550242"></a><a name="zh-cn_topic_0237122662_p162231550242"></a><strong id="zh-cn_topic_0237122662_b13223115012416"><a name="zh-cn_topic_0237122662_b13223115012416"></a><a name="zh-cn_topic_0237122662_b13223115012416"></a>名称</strong></p>
</th>
<th class="cellrowborder" valign="top" width="19.418058194180585%" id="mcps1.2.4.1.2"><p id="zh-cn_topic_0237122662_p1022318505418"><a name="zh-cn_topic_0237122662_p1022318505418"></a><a name="zh-cn_topic_0237122662_p1022318505418"></a><strong id="zh-cn_topic_0237122662_b52239504411"><a name="zh-cn_topic_0237122662_b52239504411"></a><a name="zh-cn_topic_0237122662_b52239504411"></a>类型</strong></p>
</th>
<th class="cellrowborder" valign="top" width="52.014798520147984%" id="mcps1.2.4.1.3"><p id="zh-cn_topic_0237122662_p322317501049"><a name="zh-cn_topic_0237122662_p322317501049"></a><a name="zh-cn_topic_0237122662_p322317501049"></a><strong id="zh-cn_topic_0237122662_b4224150449"><a name="zh-cn_topic_0237122662_b4224150449"></a><a name="zh-cn_topic_0237122662_b4224150449"></a>描述</strong></p>
</th>
</tr>
</thead>
<tbody><tr id="zh-cn_topic_0237122662_row1622414506411"><td class="cellrowborder" valign="top" width="28.56714328567143%" headers="mcps1.2.4.1.1 "><p id="zh-cn_topic_0237122662_p722414502411"><a name="zh-cn_topic_0237122662_p722414502411"></a><a name="zh-cn_topic_0237122662_p722414502411"></a>p80</p>
</td>
<td class="cellrowborder" valign="top" width="19.418058194180585%" headers="mcps1.2.4.1.2 "><p id="zh-cn_topic_0237122662_p12224155017411"><a name="zh-cn_topic_0237122662_p12224155017411"></a><a name="zh-cn_topic_0237122662_p12224155017411"></a>bigint</p>
</td>
<td class="cellrowborder" valign="top" width="52.014798520147984%" headers="mcps1.2.4.1.3 "><p id="zh-cn_topic_0237122662_p152248506410"><a name="zh-cn_topic_0237122662_p152248506410"></a><a name="zh-cn_topic_0237122662_p152248506410"></a>openGauss80%的SQL的响应时间（单位：微秒）。</p>
</td>
</tr>
<tr id="zh-cn_topic_0237122662_row0224050443"><td class="cellrowborder" valign="top" width="28.56714328567143%" headers="mcps1.2.4.1.1 "><p id="zh-cn_topic_0237122662_p722419501420"><a name="zh-cn_topic_0237122662_p722419501420"></a><a name="zh-cn_topic_0237122662_p722419501420"></a>p95</p>
</td>
<td class="cellrowborder" valign="top" width="19.418058194180585%" headers="mcps1.2.4.1.2 "><p id="zh-cn_topic_0237122662_p122244503419"><a name="zh-cn_topic_0237122662_p122244503419"></a><a name="zh-cn_topic_0237122662_p122244503419"></a>bigint</p>
</td>
<td class="cellrowborder" valign="top" width="52.014798520147984%" headers="mcps1.2.4.1.3 "><p id="zh-cn_topic_0237122662_p1622410501748"><a name="zh-cn_topic_0237122662_p1622410501748"></a><a name="zh-cn_topic_0237122662_p1622410501748"></a>openGauss95%的SQL的响应时间（单位：微秒）。</p>
</td>
</tr>
</tbody>
</table>

一键复制编辑原始数据按行查看历史

提交于 2020-06-24 19:41 . Add legal notice, administrator guide, technical white paper and other…

STATEMENT_RESPONSETIME_PERCENTILE

获取openGaussSQL响应时间P80，P95分布信息。

表 1 STATEMENT_RESPONSETIME_PERCENTILE的字段

名称	类型	描述
p80	bigint	openGauss80%的SQL的响应时间（单位：微秒）。
p95	bigint	openGauss95%的SQL的响应时间（单位：微秒）。

https://gitee.com/opengauss/docs.git

git@gitee.com:opengauss/docs.git

opengauss

docs

2.1.0

openGauss / docs

STATEMENT_RESPONSETIME_PERCENTILE

简介

发行版

贡献者

近期动态

openGauss / docs .gitee-modal { width: 500px !important; }

STATEMENT_RESPONSETIME_PERCENTILE

简介

发行版

开源评估指数源自 OSS-Compass 评估体系，评估体系围绕以下三个维度对项目展开评估：

贡献者

近期动态

搜索帮助

openGauss / docs