Profiling queries

You use profiling to analyze the complexity of the queries.

Before you begin

You must have a query to analyze open.

About this task

You can profile the following query types containing only SELECT statements:
  • visual queries
  • analytical queries

You can also profile Cloudant queries.

To profile a query:

Procedure

  1. Open the required query in the Visual Query Editor.
  2. Click the Profile Query (Profile Query icon) toolbar button.
    The Query Profiler view opens. It displays the time spent on running the query and fetching its results if there are any.
  3. Click the SQL Text (SQL Text icon) toolbar button in the Query Profiler view to see the SQL text of the last profiled query.
    The SQL text is displayed in the Query Profiler window.
  4. For Cloudant queries, click the Cloudant Query URL toolbar button in the Query Profiler view to see the detailed URL of the profiled Cloudant query.
    The URL is displayed in the Query Profiler window.