实时数仓 Hologres执行计划的相关内容

[帮助文档] Hologres中通过Explain或Explain Analyze查看执行计划

当SQL查询性能不佳或查询结果不符合预期时，Hologres提供了Explain和Explain Analyze命令用于分析查询语句执行计划，可以帮助您了解Hologres如何执行查询语句，以便您对查询语句或数据库结构进行调整优化。本文介绍在Hologres中通过Explain和Explain An...

Hologres怎么确认有用到了广播算子的优化，执行计划中哪里能看出来吗？

实时数仓Hologres 干货20讲

20 课时 |

405 人已学 |

加入学习

实时数仓 Hologres 实战课程

5 课时 |

223 人已学 |

加入学习

实时数仓入门课程

7 课时 |

1889 人已学 |

加入学习

Hologres的hg_table_statistic 里面只是执行计划里没生效？

Hologres的hg_table_statistic 里面每天都有几次统计记录且这个表的数据量基本没有变化表里有统计信息，只是执行计划里没生效？

Hologres这执行计划不是只扫描了一次吗?

Hologres这执行计划不是只扫描了一次吗?就是他这个扫描两次，我在他这个案例的执行计划看不出

Hologres中我们有个sql执行计划貌似有问题 ide一跑就页面卡死什么原因？

Hologres中我们有个sql执行计划貌似有问题 ide一跑就页面卡死什么原因？实例IDhgprecn-cn-7mz2k3o10007。不到一万行数，看下执行计划就会导致库一段时间无法连接。

常见的 SQL通过Hologres的Frontend完成了一定的短路优化后，生成最后的执行计划，并发

常见的 SQL通过Hologres的Frontend完成了一定的短路优化后，生成最后的执行计划，并发送给后端后做了怎样的处理？

[帮助文档] 如何使用HoloWeb查看执行计划和运行分析

HoloWeb支持以树形图的形式展现SQL查询的逻辑执行计划和物理执行计划，以便帮助用户更便捷的分析执行计划。本文为您介绍如何使用HoloWeb的执行计划和运行分析功能查看SQL语句的执行计划。

共有8条

< 1 >

跳转至： GO

更新时间 2024-02-15 17:46:17

本页面内关键词为智能算法引擎基于机器学习所生成，如有任何问题，可在页面下方点击"联系我们"与我们沟通。

产品推荐

{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"img","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"","iconImg":"https://img.alicdn.com/tfs/TB1zEY.qQ9l0K4jSZFKXXXFjpXa-200-200.png","contentLink":"https://www.aliyun.com/product/bigdata/hologram","title":" 实时数仓Hologres(原交互式分析)","des":"Hologres基于创新的HSAP架构，将您原先数仓架构中的OLAP系统（Greenplum/Presto/Impala/ClickHouse）、KV数据库/Serving系统（HBase/Redis）统一在一个大数据计算引擎中，并提供快速的离线实时一体化分析能力。","link1":"https://www.aliyun.com/product/bigdata/hologram","btn1":"产品详情","link2":"https://free.aliyun.com/?crowd=personal&pipCode=hologram","btn2":"免费试用5000CU时","btn3":"产品文档","link3":"https://help.aliyun.com/product/113622.html?spm=5176.19600405.J_5253785160.5.54ab77c13TZCq7","infoGroup":[{"infoName":"优惠活动","infoContent":{"firstContentName":"首购首月888元","firstContentLink":"https://common-buy.aliyun.com/?spm=5176.19600405.J_5253785160.2.54ab77c13TZCq7&commodityCode=hologram_combo_public_cn","lastContentLink":"https://common-buy.aliyun.com/package?spm=5176.19600405.J_5253785160.7.54ab77c13TZCq7&planCode=package_HGQBI_cn&accounttraceid=8645eef606d74c0b8238a9f0c54e348ccqwu","lastContentName":"组合套餐推荐"}},{"infoName":"产品入门","infoContent":{"firstContentName":" HoloWeb快速入门","lastContentName":"Hologres快速上手","firstContentLink":"https://help.aliyun.com/document_detail/170507.html?spm=5176.19600405.J_2964307260.5.54ab77c13TZCq7","lastContentLink":"https://help.aliyun.com/document_detail/113648.html?spm=5176.19600405.J_2964307260.2.54ab77c13TZCq7"}},{"infoName":"最佳实践","infoContent":{"firstContentLink":"https://help.aliyun.com/document_detail/162594.html?spm=a2c4g.11174283.6.744.7d54729fBVxVd8","firstContentName":"性能调优","lastContentName":"数仓搭建","lastContentLink":"https://help.aliyun.com/document_detail/163258.html?spm=a2c4g.11174283.6.748.7d54729fBVxVd8"}},{"infoName":"最新动态","infoContent":{"firstContentLink":"https://www.aliyun.com/product/new?category=217&product=453","firstContentName":"产品最新动态","lastContentLink":"","lastContentName":""}}]}],"card":[],"search":[],"infoCard":[{"bannerUrl":"https://img.alicdn.com/tfs/TB1Xf81a3gP7K4jSZFqXXamhVXa-5169-974.jpg","bannerTitle":"mPaaS 小程序","bannerContent":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。<br>不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","liveButtonName":"查看详情","liveButtonLink":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","contentTitle":"提供即开即用的端上体验","homePageLink":"https://common-buy.aliyun.com/?spm=5176.14673561.J_8751524360.2.56702709BussF3&commodityCode=mpaas_beta#/open","homePageName":"免费试用","linkGroup":[{"linkContent":"发布包大小极致优化，节省流量和存储。"},{"linkContent":"服务迭代不再受发版限制，快速发布，快速迭代。"},{"linkContent":"业务开发效率更加优秀，一次开发，多端运行。"}]}],"title":{"mainTitle":"mPaaS","subtitle":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","linkUrl":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","btnText":"查看详情"},"visual":{"topbg":"https://img.alicdn.com/tfs/TB1bQuBIYH1gK0jSZFwXXc7aXXa-3840-740.gif","icon":"","textColor":"dark"},"dataList":[{"summary":"啦啦啦","author":"wuwu","linksUrl":"#"}],"sceneCard":[],"txt":[]}

{"$env":{"JSON":{}},"$page":{"env":"production"},"$context":{"optioninfo":{"dynamic":"ture","static":"true"},"simplifiedDisplay":"newEdition","newCard":[{"ifIcon":"img","link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"","iconImg":"https://img.alicdn.com/tfs/TB1zEY.qQ9l0K4jSZFKXXXFjpXa-200-200.png","contentLink":"https://www.aliyun.com/product/bigdata/hologram","title":" 实时数仓Hologres(原交互式分析)","des":"Hologres基于创新的HSAP架构，将您原先数仓架构中的OLAP系统（Greenplum/Presto/Impala/ClickHouse）、KV数据库/Serving系统（HBase/Redis）统一在一个大数据计算引擎中，并提供快速的离线实时一体化分析能力。","link1":"https://www.aliyun.com/product/bigdata/hologram","btn1":"产品详情","link2":"https://free.aliyun.com/?crowd=personal&pipCode=hologram","btn2":"免费试用5000CU时","btn3":"产品文档","link3":"https://help.aliyun.com/product/113622.html?spm=5176.19600405.J_5253785160.5.54ab77c13TZCq7","infoGroup":[{"infoName":"优惠活动","infoContent":{"firstContentName":"首购首月888元","firstContentLink":"https://common-buy.aliyun.com/?spm=5176.19600405.J_5253785160.2.54ab77c13TZCq7&commodityCode=hologram_combo_public_cn","lastContentLink":"https://common-buy.aliyun.com/package?spm=5176.19600405.J_5253785160.7.54ab77c13TZCq7&planCode=package_HGQBI_cn&accounttraceid=8645eef606d74c0b8238a9f0c54e348ccqwu","lastContentName":"组合套餐推荐"}},{"infoName":"产品入门","infoContent":{"firstContentName":" HoloWeb快速入门","lastContentName":"Hologres快速上手","firstContentLink":"https://help.aliyun.com/document_detail/170507.html?spm=5176.19600405.J_2964307260.5.54ab77c13TZCq7","lastContentLink":"https://help.aliyun.com/document_detail/113648.html?spm=5176.19600405.J_2964307260.2.54ab77c13TZCq7"}},{"infoName":"最佳实践","infoContent":{"firstContentLink":"https://help.aliyun.com/document_detail/162594.html?spm=a2c4g.11174283.6.744.7d54729fBVxVd8","firstContentName":"性能调优","lastContentName":"数仓搭建","lastContentLink":"https://help.aliyun.com/document_detail/163258.html?spm=a2c4g.11174283.6.748.7d54729fBVxVd8"}},{"infoName":"最新动态","infoContent":{"firstContentLink":"https://www.aliyun.com/product/new?category=217&product=453","firstContentName":"产品最新动态","lastContentLink":"","lastContentName":""}}]}],"card":[],"search":[],"infoCard":[{"bannerUrl":"https://img.alicdn.com/tfs/TB1Xf81a3gP7K4jSZFqXXamhVXa-5169-974.jpg","bannerTitle":"mPaaS 小程序","bannerContent":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。<br>不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","liveButtonName":"查看详情","liveButtonLink":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","contentTitle":"提供即开即用的端上体验","homePageLink":"https://common-buy.aliyun.com/?spm=5176.14673561.J_8751524360.2.56702709BussF3&commodityCode=mpaas_beta#/open","homePageName":"免费试用","linkGroup":[{"linkContent":"发布包大小极致优化，节省流量和存储。"},{"linkContent":"服务迭代不再受发版限制，快速发布，快速迭代。"},{"linkContent":"业务开发效率更加优秀，一次开发，多端运行。"}]}],"title":{"mainTitle":"mPaaS","subtitle":"源自于支付宝小程序框架，亿级线上业务体量的锤炼，安全性媲美支付宝原生能力。不仅面向自有 App 投放小程序，更可快速构建打包，覆盖支付宝、淘宝、钉钉等应用。","linkUrl":"https://www.aliyun.com/product/mobilepaas/mpaas-miniprogram","btnText":"查看详情"},"visual":{"topbg":"https://img.alicdn.com/tfs/TB1bQuBIYH1gK0jSZFwXXc7aXXa-3840-740.gif","icon":"","textColor":"dark"},"dataList":[{"summary":"啦啦啦","author":"wuwu","linksUrl":"#"}],"sceneCard":[],"txt":[]}}