Query Profiling

When implementing your database application, you need to fill the database with data and test your queries retrieving this data.

Database Workbench shows you the query execution plan in the SQL Editor.

  • Test your queries in the SQL Editor
  • Check query execution plan
  • Create indices and re-test your queries

When testing SQL queries, Database Workbench shows you the query execution time at the bottom of the SQL Editor.

But query profiling doesn't end there. Many database systems support retrieving a query plan that explains in detail how a query is being executed.

This query plan is displayed at Plan Analysis tab. Different database systems use different structures for the plan. When possible, Database Workbench shows the query plan in a tree view for extra clarity.

When possible, Database Workbench will retrieve query statistics for the operation as well.

These tools help you to check your query performance, create indices where required and speed up data retrieval.