This post's contentWhat is an Index?How to create a PostgreSQL IndexHow does the Online PostgreSQL Index Advisor work?FAQDo I need to provide my database credentials to work with the Index Advisor?Does the Index Advisor provide the commands to create the missing indexes?How to maintain indexes?How to list all PostgreSQL Indexes?How to list all on Indexes… Continue reading The complete PostgreSQL Index Advisor guide [Online]

EverSQL's optimization capabilities can be integrated with your Datadog's Database Monitoring, to automatically and continuously optimize your SQL queries. You can find EverSQL on Datadog's integrations section. The integration can be implemented manually or automatically by adding the EverSQL Sensor, which utilizes EverSQL's Optimization capabilities, to automatically optimize queries that you found on Datadog's Database… Continue reading Using Datadog? Now you can auto-optimize PostgreSQL and MySQL queries

This post's content#1 - LiquiBase#2 - EverSQL#3 - JFrog#4 - ELK stack#5 - Datadog#6 - DBmaestro#7 - Grafana #1 - LiquiBase Liquibase Community is an open-source project that helps millions of developers rapidly manage database schema changes. With Liquibsae you can track, version, and deploy database changes. Liquibase also has a paid version that includes… Continue reading Top 7 CI/CD tools for PostgreSQL and MySQL databases in 2022

This post's content1. Enable Slowlog2. Deploy EverSQL AI-powered Sensor3. Be amazed at how accurate the ML algorithm is4. Receive anomaly alerts via Slack or email5. Summary - Finding database performance anomalies 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… Continue reading Database performance anomaly detection in 3 minutes [PostgreSQL, MySQL]

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

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

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

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

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