PostgreSQL – pg_stat_statements, explained

January 25, 2022September 5, 2022

This post's contentWhat is pg_stat_statements ?How do I know if pg_stat_statements is enabled?I don't see the pg_stat_statements table. How can I enable it?How does enabling pg_stat_statements impact performance and does it create an overhead?How to disable pg_stat_statements?Who can access and see the content of pg_stat_statements?How pg_stat_statements is different from slowlogs?What columns does pg_stat_statements include?How do… Continue reading PostgreSQL – pg_stat_statements, explained

Best PostgreSQL Monitoring & Observability Tools in 2022

January 4, 2022September 5, 2022

This post's content#1: EverSQL for PostgreSQL#2: DataDog#3: Percona Monitoring and Management (PMM) #4: VividCortex (DPM)#5: OPM - Open PostgreSQL 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… Continue reading Best PostgreSQL Monitoring & Observability Tools in 2022

New – AWS DevOps Guru for RDS for Database performance

December 2, 2021January 25, 2022

This post's contentHow to enable AWS DevOps Guru for RDS:What’s new in AWS DevOps Guru for RDS Aurora:Optimize Slow Queries directly from RDS Summary 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… 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 2022

March 16, 2021January 2, 2022

This post's content#1 - SnowSQL CLI client#2 - DBeaver#3 - EverSQL Cost Optimization for Snowflake#4 Partner Connect by Snowflake#5 - FiveTran#6 - SQLMorph #7 - DataGrip by JetBrain#8 - ETL Tools (ETL EcoSystem)#9 - Snowflake Free Public Datasets #1 - SnowSQL CLI client SnowSQL is the command-line client to execute SQL queries and perform all DDL… Continue reading Top 9 Snowflake Productivity Tools in 2022

Better Database Performance with Google Cloud SQL Insights

January 29, 2021January 25, 2022

This post's contentHow to enable Cloud SQL Insights:What’s new in Google Cloud SQL Insights:Optimize Slow Queries directly from Google Cloud SQL Insights Summary 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… Continue reading Better Database Performance with Google Cloud SQL Insights

How to enable slow query log in PostgreSQL [2022 update]

January 10, 2021January 25, 2022

PostgreSQL allows logging slow queries to a file, with a configured query duration threshold. Parsing the slow log with tools such as EverSQL Query Optimizer will allow you to quickly locate the most common and slowest SQL queries in the database. You can optimize these queries automatically using EverSQL Query Optimizer. Enabling PostgreSQL Slow Query Log… Continue reading How to enable slow query log in PostgreSQL [2022 update]

Top 5 SQL Optimization Tools in 2022

December 9, 2020January 2, 2022

This post's content#1 - EverSQL#2 -ApexSQL Plan#3 - SQL Azure Query Performance Insights#4 -Toad SQL Optimizer for Oracle#5 - SQL tuning 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… Continue reading Top 5 SQL Optimization Tools in 2022

How to Fix MySQL High CPU Usage?

November 24, 2020February 22, 2022

This post's content1. Locate the root cause2. Fix the performance issue3. Make sure it will not happen again4. Summary 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… Continue reading How to Fix MySQL High CPU Usage?

How to enable slow query log on Google Cloud SQL for MySQL and PostgreSQL

September 3, 2020June 15, 2021

In this post, we will quickly demonstrate how to enable Slow Query Log on Google Cloud SQL for MySQL. Open Cloud SQL Dashboard Click Edit on your Database For Cloud SQL MySQL instances, add these 3 flags (a.k.a. configuration parameters) to your instance: log_output - file / table / none We recommend to choose file, which… Continue reading How to enable slow query log on Google Cloud SQL for MySQL and PostgreSQL