Marylia Gutierrez
Marylia Gutierrez joined Cockroach Labs at the beginning of 2021, working as the Engineer Manager and developer for the SQL Observability team. She’s worked on bringing new features to help users better understand their workload, with information such as contention, indexes usage, explain plans, among many others. She obtained her Master’s in Human-Computer Interaction from Escola Politécnica da Universidade de São Paulo in Brazil. When she is not observing SQL at work, she is observing tv shows, games and her plants in her personal life.
Product
How to troubleshoot and optimize query performance in CockroachDB
In an ideal world, all workloads are perfect and never face performance issues. In the real world, that’s hard to achieve. Your workload might not always follow best practices, or it could contain problematic queries that cause trouble.
Marylia Gutierrez
June 21, 2023
Engineering
How to use indexes for better workload performance
Indexes are a crucial part of your database schema. They improve workload performance by helping the database locate data without having to scan every row of a table. Although it might be tempting to create an index for every column that your workload uses to filter data, it’s important to consider the performance tradeoffs of indexes. While indexes greatly improve the performance of read queries that use filters, they do come with a cost to write performance: data has to be written for all indexes present on the table.
Marylia Gutierrez
August 23, 2022
Product
Engineering
SQL query tuning with DB Console
Observability is how you understand the current state of your database: how it is behaving, plus any potentially problematic things you should be paying attention to — and identifying improvements based on this information.
Marylia Gutierrez
August 1, 2022