SQL Queries Comparison

Blackfire tells you the evolution of SQL queries between two profiles.

By Fabien Potencier, on Jun 11, 2015

One of the most popular Blackfire feature is the ability to compare profiles. We have a unique way to display comparisons, both as a call graph and as a function calls table.

But what about HTTP requests and SQL queries?

When profiling code with database calls, you get the executed SQL statements both in the toolbar and in the callgraph:

sql-toolbar

And when comparing two profiles, the toolbar displays the difference between both profiles; new queries, differences in the number of calls or time to retrieve the data, and queries that are not executed anymore:

sql-comparison

SQL queries comparison is one of the Blackfire Enterprise Edition features. If you are interested, don’t hesitate to get in touch and contact us at sales [at] blackfire.io.

Happy profiling!

Fabien Potencier

Fabien Potencier is the CEO and founder of Blackfire.io. He founded the Symfony project in 2004 as he constantly looked for better ways to build websites. Fabien is also the creator of several other Open-Source projects, a writer, a blogger, a speaker at international conferences, and the happy father of two wonderful kids.
Read more articles from this author »