Database performance anomaly detection in 3 minutes [PostgreSQL, MySQL]

February 14, 2022September 5, 2022

How to detect PostregSQL/MySQL performance anomalies in 3 minutes? Remember when your website checkout didn't work for 4 hours just because PostgreSQL was overloaded and CPU reached 100%? Here is a quick guide on detecting these anomalies as soon as they start. 1. Enable Slowlog PostgreSQL has a unique mechanism that can capture SQL queries… Continue reading Database performance anomaly detection in 3 minutes [PostgreSQL, MySQL]

How to Fix PostgreSQL High CPU Usage?

January 25, 2022July 16, 2023

We all love PostgreSQL, but sometimes, usually around 3 AM, it can reach a 100% CPU usage, which can be annoying for us, and a disaster for our customers. So how can you find the root cause and fix it? 1. Locate the root cause There might be many reasons for the 100% CPU Usage.… Continue reading How to Fix PostgreSQL High CPU Usage?

PostgreSQL – pg_stat_statements, explained

January 25, 2022July 16, 2023

pg_stat_statements is a external library and a name of a table that collects tons of information about your database's executed queries. Like many database performance components, it has pros and cons. here are some frequently asked questions: What is pg_stat_statements ? pg_stat_statements is a preload shared library that you can use in order to load… Continue reading PostgreSQL – pg_stat_statements, explained

Best PostgreSQL Monitoring & Observability Tools in 2023

January 4, 2022July 16, 2023

PostgreSQL is becoming one of the most popular relational databases in 2022, as you can see its Growth on DBengine records, or in the latest StackOverflow developers survey. We have decided to review and list the top 5 PostgreSQL Monitoring tools in this article. #1: EverSQL for PostgreSQL EverSQL provides a unique PostgreSQL monitoring solution, mainly… Continue reading Best PostgreSQL Monitoring & Observability Tools in 2023

New – AWS DevOps Guru for RDS for Database performance

December 2, 2021January 25, 2022

AWS DevOps Guru launched a RDS support for Aurora (AWS DevOps Guru for RDS), allowing you to closely monitor the database performance and identify potential performance issues. AWS RDS Performance Insights is available since 2018, and they are now integrating it with their newest DevOps guru platform. AWS describe these two products in a very… Continue reading New – AWS DevOps Guru for RDS for Database performance

How to optimize slow INSERT queries in MySQL

April 17, 2021September 5, 2022

At some points, many of our customers need to handle insertions of large data sets and run into slow insert statements. This article will try to give some guidance on how to speed up slow INSERT SQL queries. The following recommendations may help optimize your data loading operations: Remove existing indexes - Inserting data to… Continue reading How to optimize slow INSERT queries in MySQL

Top 9 Snowflake Productivity Tools in 2023

March 16, 2021January 6, 2023

#1 - SnowSQL CLI client SnowSQL is the command-line client to execute SQL queries and perform all DDL and DML operations, including loading data into and unloading data out of snowflake tables. Pros: SnowSQL can be run as an interactive shell or in batch mode through stdin or using the -f option. Supports Windows, Mac and Linux You can… Continue reading Top 9 Snowflake Productivity Tools in 2023

Better Database Performance with Google Cloud SQL Insights

January 29, 2021January 25, 2022

Google Cloud launched an advanced database performance tool (Cloud SQL Insights), allowing you to closely monitor the database performance and identify potential performance issues. Many Google Cloud SQL users have waited for it for a long time, as both AWS and Azure already offer similar products for a while. AWS RDS Performance Insights is available… Continue reading Better Database Performance with Google Cloud SQL Insights

Top 5 SQL Optimization Tools in 2023

December 9, 2020January 6, 2023

Companies have more data in today's world, and queries that took a few seconds might take a few minutes or even hours. If you have a complex SQL query and looking for an automated tool that will help you, we tested the most popular tools and created this article for you. Here is a list… Continue reading Top 5 SQL Optimization Tools in 2023

How to Fix MySQL High CPU Usage?

November 24, 2020February 22, 2022

So you thought your database is in good shape, but suddenly your CPU usage spiked and reached 100% at 2AM. How would you go about tracking the root cause and fix it? 1. Locate the root cause If you are using CloudWatch or any infrastructure monitoring solution, you can start your investigation there. To understand… Continue reading How to Fix MySQL High CPU Usage?