Skip to main content

How to Fix Slow Queries

In this video you'll get a demo of how to find and fix slow queries in CockroachDB. Andy Woods, a Sr Product Manager at CockroachDB, takes you through a demo of our Slow Query Log. In the demo you'll see how you can set different parameters for evaluating query performance. If you have additional questions about the Slow Query Log you can reference some of the links that Andy mentions in the video: Troubleshoot SQL Behavior: https://www.cockroachlabs.com/docs/v20.1/query-behavior-troubleshooting.html What is TPC-C: http://www.tpc.org/tpcc/ CockroachDB Performance: https://www.cockroachlabs.com/docs/v19.2/performance.html TPCC Benchmark Comparison: https://www.cockroachlabs.com/blog/tpcc-100k/ 00:00 Introductions 00:29 Slow Query Log Demo Starts 2:26 How to open the slow query log ---------- Careers: https://www.cockroachlabs.com/careers CockroachCloud: https://www.cockroachlabs.com/product/cockroachcloud/ Blog: https://www.cockroachlabs.com/blog/ Docs: https://www.cockroachlabs.com/docs/stable/ Community Slack: https://cockroa.ch/Welcome-to-Slack Twitter: https://twitter.com/CockroachDB