Monitoring Dashboard Performance Profile

Arcadia Enterprise helps you debug your dashboard performance by providing detailed statistics on the rendering and querying operations of the visuals.

  1. Open an existing dashboard. We selected Life Expectancy Dashboard.
    viewing the life expectancy dashboard
  2. Use the keyboard shortcut Shift + Control + G to open the Performance Profile interface.
    viewing the performance profile interface
    Performance Profile Interface

    You can view the following information on the Performance Profile interface:

    1. Download

      Click Download to download the performance profile of your dashboard and save it on your local system.

    2. Rendering Engine

      The Rendering Engine table shows the following real-time statistics for rendering operations on all visuals of the dashboard:

      • Average Render Time
      • Total Render Time
      • Render Count
      • Maximum Render Time
    3. Query Engine

      The Query Engine table shows the following real-time statistics on the query operations:

      • Average Query Time
      • Total Query Time
      • Query Count
      • Maximum Query Time
    4. Query Execution by Visual ID

      The Query Execution by Visual ID visual displays the timeline of each operation. Hover over one of the time segment lines that represent either the visual, or additional tasks. The tooltip shows the Duration, ID, Type, Detail, and Error statistics.

      • Notice that the ID of the visual is 0 in the following image; this is the stand-in ID for ancillary tasks Arcadia Enterprise performs when building a dashboard.
        viewing the visual id=zero when the dashboard is built
        Query Execution by Visual ID
      • Hover over a line that represents a visual ID (we selected 59), and view the duration, type, and details of the query performed on that visual.

        viewing the query execution statistics by hovering over the visual id
        Query Execution by Visual ID
      • To zoom in on a particular time segment, drag to select the area. We selected 11:51:52.000. You can now drill down to the details of this time selection. Click Clear Time Selection to return to the original view.

        selecting and zooming in on a particular time segment, then clearing the selection
        Query Execution by Visual ID
    5. Query Details section shows statistics of all the visuals and queries in a table.
      • Time shows the time when the query operation started.
      • ID shows the ID of the visual.
      • Type shows the query type: startup, set data result, draw visual, or table rows processed.
      • Duration shows the query execution time, in seconds.
      • Detail shows the syntax of the query.
      • Error shows any errors that occurred during query execution.
    6. Click Done to exit the performance profile interface and return to your dashboard.