The complete PostgreSQL Index Advisor guide [Online]

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]

Using Datadog? Now you can auto-optimize PostgreSQL and MySQL queries

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

Top 7 CI/CD tools for PostgreSQL and MySQL databases in 2022

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

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

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]

PostgreSQL – pg_stat_statements, explained

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

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

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