Varada vs. AWS Athena: Performance Benchmarking | Guy Mast, Varada Product Manager | varada.io скачать в хорошем качестве

Varada vs. AWS Athena: Performance Benchmarking | Guy Mast, Varada Product Manager | varada.io

In this video Guy Mast, Varada's Product Manager, explains how you can use the Presto Analyzer to identify resource-heavy Presto operators. The Presto Analyzer instantly identifies which Presto operations are the most resource-intensive and expensive. You can also identify which Presto query types consume most of the cluster resources (create table, insert, select, etc.). In most cases ScanFilter takes most of the resources. With better partitioning strategy or with indexing you can optimize queries and reduce the amount of data scanned, which of course will lead to much lower resource consumption and will significantly improve query performance. Varada recently released a new open source tool that enables data platform teams to easily analyze, monitor and optimize presto clusters, both PrestoDB and Trino. The Presto Analyzer offers workload-level insights on how clusters perform, and enables to instantly identify heavy users and bottlenecks, and effectively optimize performance and concurrency. Go to github: https://github.com/varadaio/presto-wo... Learn more: https://varada.io/blog/presto/presto-... ✿ Social Links: LinkedIn:   / varadaio   Twitter:   / varadaio   🌐Check Out Our Website! https://varada.io 🔔 SUBSCRIBE IF YOU ARE NEW AND TURN THE BELL ON Watch More Videos: ▶️Optimize Presto Joins    • Optimize Presto Joins | varada.io   ▶️ Identify Presto Query Patterns and Outliers    • Identify Presto Query Patterns and Outlier...   ▶️ The State of Data Virtualization Survey, Q1'2021    • The State of Data Virtualization Survey, Q...   Thanks for being with us! 👍 Like the video 💬 Comment if you made it till the end! 🔗 Share the video with anyone you think it might help :)