Query Performance Optimization at Alibaba Cloud Log Analytics Service

简介: PrestoCon Day 2023,链接:https://prestoconday2023.sched.com/event/1Mjdc?iframe=no首页自我介绍,分享题目概要各个性能优化项能够优化的资源类别limit快速短路有什么优点?有啥特征?进一步的优化空间?避免不必要块的生成逻辑单元分布式执行,global 阶段的算子哪些字段无需输出?公共子表达式结合FilterNode和Proje

PrestoCon Day 2023,链接:https://prestoconday2023.sched.com/event/1Mjdc?iframe=no

首页

自我介绍,分享题目

概要

各个性能优化项能够优化的资源类别

limit快速短路

有什么优点?有啥特征?进一步的优化空间?

避免不必要块的生成

逻辑单元分布式执行,global 阶段的算子哪些字段无需输出?

公共子表达式

结合FilterNode和ProjectNode,复杂表达式拆分

合并相似数据源

arbitrary函数

Q&A

相关实践学习
日志服务之使用Nginx模式采集日志
本文介绍如何通过日志服务控制台创建Nginx模式的Logtail配置快速采集Nginx日志并进行多维度分析。
相关文章
|
弹性计算 Apache iOS开发
A Quick Guide to Analyzing Apache Logs on Alibaba Cloud Log Service
This article describes how you can deploy Logstash and Kibana on Alibaba Cloud Log Service to monitor, analyze, and visualize Apache logs.
2275 0
A Quick Guide to Analyzing Apache Logs on Alibaba Cloud Log Service
|
存储 Cloud Native NoSQL
【Paper Reading】Cloud-Native Transactions and Analytics in SingleStore
HTAP & 云原生是如今数据库技术演进的两大热点方向。HTAP 代表既有传统的 HANA Delta RowStore+Main ColumnStore,Oracle In-MemoryColumnStore 等方案,也有像 TiDB,Snowflake Unistore这样新的技术架构;云原生代表则是以 S3 为低成本主存的 Snowflake,Redshift RA3,提供灵活弹性和Serverless 能力。SingleStore 则是首次把两者结合起来,基于计算存储分离的云原生架构,用一份存储提供低成本高性能的 HTAP 能力。
【Paper Reading】Cloud-Native Transactions and Analytics in SingleStore
|
开发工具 对象存储
How to Apply Alibaba Cloud Object Storage Service Resources to Websites
This article discusses the various applications of OSS and addresses some of the most common issues when applying OSS to websites.
1713 0
|
SQL 关系型数据库 RDS
Troubleshooting High CPU Usage on Alibaba Cloud SQL Server
A primary issue with SQL Server is its sensitivity to latency, often resulting in performance issues.
1297 0
Troubleshooting High CPU Usage on Alibaba Cloud SQL Server
|
弹性计算 安全
Alibaba Cloud Server Guard: A Comprehensive Assessment
The massive amounts of computing resources available in current cloud environments are extremely attractive to hackers.
2776 0
|
安全 流计算
Global Live-streaming For Business: Getting Started on the Cloud
Live-streaming is the transmission of video or audio content simultaneously recorded and broadcast in real time to an audience.
1816 0
Global Live-streaming For Business: Getting Started on the Cloud
|
关系型数据库 PostgreSQL RDS
Cloud Massive Task Scheduling System Database Design - Alibaba Cloud RDS PostgreSQL Cases
PostgreSQL is crucial to cloud massive task scheduling system. Here we will describe how to design a system database for cloud massive task scheduling.
1193 0
Cloud Massive Task Scheduling System Database Design - Alibaba Cloud RDS PostgreSQL Cases
|
JavaScript Java Docker
Service Tracing Analysis on Spring Cloud Applications Using Zipkin
This article briefly introduces how to use Zipkin to perform service analysis on Spring Cloud applications.
3549 0