Adding this just so I have my notes in one place: https://vividcortex.com

Lol I had also posted about this in the CakePHP Slack and someone shared this video that just came out yesterday after I posted about this tool.

https://youtu.be/kkjAxSViOAA?si=FZqWm14hZwPMjjGh
Saving a SaaS on the weekend - PlanetScale

It's about analyzing a query to put an index to shrink a query from searching 500,000 rows to ~1,400 each time

This analysis is what I want automated lol

Oops I forgot to finish my thought.

Two of the better related tools are Sentry and planetscale.

I think planetscale does the closest to what I want, but SaaS/you pay them to host your DB.

I'm familiar with about half of those. Not quite the same thing I'm describing.

I also don't want it tied to a SaaS service by someone else. Quite a few of my things are on-prem only.

I copy/pasted into gpt3 except I removed the word "idea"

Speaking of AI

It sounds like you're describing a database performance monitoring and optimization tool. Such tools are essential for maintaining and improving the efficiency of database systems. There are several tools available in the market that provide the functionalities you mentioned. Here are a few examples:

Database Performance Monitoring Tools:

New Relic: New Relic offers database monitoring capabilities that provide insights into the performance of your database queries. It can help identify slow queries, analyze query plans, and provide recommendations for improvement.

AppDynamics: AppDynamics is another application performance monitoring tool that includes database monitoring features. It can track and analyze database queries, helping you optimize performance.

Datadog: Datadog provides database monitoring solutions that allow you to track query performance, set up alerts for slow queries, and gain insights into database bottlenecks.

Query Optimization Tools:

pt-query-digest (Percona Toolkit): This tool can analyze MySQL queries and provide detailed reports on query performance. It helps identify slow queries and suggests improvements.

pgBadger: While primarily a PostgreSQL log analyzer, pgBadger can help analyze PostgreSQL logs and identify slow queries, providing insights into performance bottlenecks.

Database Indexing Tools:

Datomic: Datomic is a database that offers a unique approach to indexing and querying data. It provides a powerful query language and automatically indexes data for efficient querying.

AWS Database Performance Insights: If you are using Amazon RDS, it includes a feature called Performance Insights, which provides a dashboard with metrics about database load.

Remember to choose a tool that is compatible with your specific database management system (e.g., MySQL, PostgreSQL, MongoDB) and that aligns with your application architecture and requirements. Additionally, consider factors such as ease of use, integration capabilities, and community support when selecting a tool for your needs.

@umer936 lol true

@.:A-MAN:.
I realized this bc there's a query that's been in one of the work webapps since 2009 or so and I've never touched it.

My coworker was on that site for some upgrades and noticed it was slow and my boss added an INDEX and it made the query from 5sec to <1sec.

I'm always on the test servers instead of the real servers and the test servers have a tiny subset of the data.
Additionally, it may not have been a problem when developing but then 10 years later maybe that query is slow bc the table got big.
My users have been using it and they don't know to ask because it just gradually got slower - nothing broke.

I'm not going to go through and performance test every DB query across 70+ webapps I support all the time. I know everything works but something else should tell me how to make it work better.

Plus, I never really got good at indexes or other DB features but it's almost 2024 - I shouldn't have to be good at anything anymore lol

That would be legit