Dashboard calls are taking longer than 30 second such as Average Response Time

Document ID : KB000075019
Last Modified Date : 29/03/2018
Show Technical Document Details
Issue:
Looking at the dashboard for metrics like Average Response time, these are taking over 30 seconds to process.

Looking at postgresql-Thu.log during the timeframe, I see many queries averaging 9.8 seconds with 59 queries taking 15-19 seconds

This is the longest
[29786-cemdb-admin-2018-03-22 09:50:13.222 EDT]LOG: duration: 19753.850 ms execute : SELECT v.value, v.vertex_id, b.value as backend FROM appmap_vertex_filter f LEFT JOIN appmap_attribs v ON v.vertex_id = f.vertex_id AND v.start_time = f.start_time AND v.attrib_name = $1 LEFT JOIN appmap_attribs b ON b.vertex_id = f.vertex_id AND b.attrib_name = $2
Environment:
APM 10.7.0 
Cause:
  This was due to a code bug.
Resolution:
This is fixed in APM 10.7 HF 3 and later releases. Please contact APM Support to get a copy of the hotfix.