Ask HN: There is a New Relic for Data Bases?
Guys, I don't have a DBA in my startup, and using MVC, I feel that my queries are sometimes slower than they could be. There is anything similar to New Relic only focused in the queries?
Assuming you are using a popular framework like Symfony or Django, there should be debugging output that will show the queries generated by the ORM. Symfony will show every query and it's execution time for every page load.
You should also look at your database server's configuration options. For example, both mysql and postgresql have options to flag slow queries. You can also dump every query the database makes to a logfile.