×
![]()
Query Service App Release Notes
The initial installation of ITRS Analytics includes all required app, such as the Web Console, bundled by default. No separate installation steps are required for individual apps. For installation guidance, refer to the Install ITRS Analytics apps documentation.
To stay informed about the most recent updates and packaging versions, you can refer to the ITRS Analytics Packaging Changelog. This resource provides direct links to release notes for each bundled version of the ITRS Analytics Platform and its apps, bill of materials listing all included components, and references to the published Docker images.
App Query Service 2.19.0 Copied
Released: 30 October 2025
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-994 | Query Service app now auto-reconnects to the Platform when KV or Signal subscriptions encounter an error. |
| ESCA-997 | Prevented the creation of a new pipeline when a dataview has only UI changes. |
| ESCA-1000 | Optimized EntitySink to reduce I/O and disk pressure during indexing. |
| ESCA-1373 | Deleted signal and attribute history older than one month to optimize storage. You can adjust the retention duration through the signalHistoryThreshold configuration. Setting it to P0D disables the maintenance job. |
| ESCA-1380 | Extended GetTemplateRequest.TemplateTransformation to include a sort order transformation, allowing the UI to set sorting behavior without modifying the dataview object. |
| ESCA-1391 | Extended dashboard configuration to include settings for summary rows. |
| ESCA-1394 | Extended the Dashboard API to support a Severity column. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-1409 | Updated Postgres to address the critical-severity security vulnerability CVE-2025-6965. |
App Query Service 2.16.0 Copied
Released: 11 August 2025
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-950 | Unused fields have been removed from queryEntitySummaryStats to optimize the database query. |
| ESCA-953 | Updated the layout of the severity attributes table to optimize query performance. |
| ESCA-954 | Improved error reporting for dataviews in an error state. |
| ESCA-956 | The activity stream used by the Entity Viewer app is disabled during Query Service database bootstrapping from the Platform to prevent excessive updates from being sent to the UI. |
| ESCA-968 | Added support for visualizing dataviews as charts. |
| ESCA-971 | Optimized EntityActivityInitQueries by using a numeric identifier instead of a text field. |
| ESCA-976 | Optimized the discoverDashboards endpoint for improved performance. |
| ESCA-978 | Optimized the database query for queryEntitySeverity. |
| ESCA-979 | The Dashboard API has been extended to include a HistogramBarChart type. |
| ESCA-980 | The Dashboard DataviewLayout has been updated to support defining multiple layouts. |
| ESCA-981 | Moved the Dashboard visualisation duration field to the parent object. |
| ESCA-982 | Extended the EntityFilter to support filtering entities that have either logs or traces. |
| ESCA-984 | The severity state of dashboard tabs is now reported correctly for dataviews that include optional columns. |
App Query Service 2.15.0 Copied
Released: 16 June 2025
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-853 | Removed the deprecated Dashboard message DashboardTileAction. |
| ESCA-924 | Limit the number of entities returned by the activity stream used in the Entity Viewer. |
| ESCA-928 | Added a new Dashboard endpoint to enable the UI to search for filter keys and their values. |
| ESCA-931 | Optimized the getGroupedColumns query in the Dashboard API. |
| ESCA-932 | Extended the Dashboard API with the Traces dataview template. |
| ESCA-934 | Extended the Dashboard API to expose all available metric units for a column. |
| ESCA-935 | Synchronized access to an internal cache used by the signal sink. |
| ESCA-936 | Removed the deprecated field DiscoverGroupedColumnsResponse.HierarchyKey.search_match_type. |
| ESCA-935 | Changed the threading model for ActivitySubscriber. |
App Query Service 2.14.0 Copied
Released: 10 June 2025
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-879 | The dashboard endpoint for retrieving entity datapoints are now grouped by hierarchy. |
| ESCA-902 | The DPD pipeline builder no longer incorrectly adds duplicate “exist” filters. |
| ESCA-904 | Added the DiscoverDashboardNavigationsResponse.filter_type to allow the UI to differentiate between permanent and transient filters. |
| ESCA-905 | Added tab information to the DiscoverDashboards endpoint. |
| ESCA-908 | Extended the DiscoverDashboards endpoint to resolve dashboards based on associated sibling entities. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-906 | Resolved an issue where the Entity Viewer could throw an error during signal activity resolution due to a missing metric reference. |
App Query Service 2.13.0 Copied
Released: 6 May 2025
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-727 | Exposed the severity counts for dataviews. |
| ESCA-867 | Generated better traces in the Query Service Sink. |
| ESCA-868 | Renamed helm properties signalLookbackPeriod, attributeLookbackPeriod, and entityLookbackPeriod to signalsSubscribeFrom, attributesSubscribeFrom, and entitiesSubscribeFrom respectively. |
| ESCA-871 | An exception is now thrown if onComplete has been called on the stream. |
| ESCA-873 | Added tab navigation targets to the dashboard discovery endpoint. |
| ESCA-874 | Resolved tab navigation targets using the table view hierarchy. |
| ESCA-877 | Added a new endpoint for tracking the dashboard severity state. |
| ESCA-878 | Added column sizing config to the Dashboard API. |
| ESCA-880 | Added age visualization to the Dashboard API. |
| ESCA-881 | Optimized EQL evaluation by using a cache. |
| ESCA-883 | Implemented changes to the dashboard navigations endpoint to simplify navigation from Entity Viewer to the Dashboards app. |
App Query Service 2.12.0 Copied
Released: 3 April 2025
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-830 | Upgraded Postgres to version 17.4. |
| ESCA-832 | The Dashboard API now supports tile layouts. |
| ESCA-852 | Updated the API to support dashboard tabs and tab navigation. |
| ESCA-855 | Added export and import capabilities to the Dashboard API. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-786 | CVE-2023-29403 has been resolved in Postgres. |
App Query Service 2.11.0 Copied
Released: 26 March 2025
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-817 | The Dashboard subscription endpoint for metric visualizations now validates that the dataview ID is set. |
| ESCA-818 | Updated the DiscoverDashboard endpoint to account for both parent and child entities. |
| ESCA-835 | Optimized the layout and indexing of signals in the database, reducing disk fragmentation that can negatively impact insert and read performance on tables with large numbers of signals. |
| ESCA-837 | Previously, a timestamp value was incorrectly indexed for string attributes. This has been corrected, resulting in a 20% reduction in table size. |
| ESCA-838 | Unit values are no longer indexed for non-numerical attributes, reducing table size by 13%. |
| ESCA-840 | Simplified the EntityQueries.resolveAttributes query. |
| ESCA-842 | Simplified the Entity Viewer search query by removing a join to the attributes table. |
| ESCA-848 | Optimized the queries used by the Alerting app. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-831 | Fixed an issue where the Query Service sink was restarted when under heavy load. The indexers have been updated to avoid thread locking and starvation of the health check probe. |
| ESCA-847 | Optimized entity stats query used by the Entities app by simplifying a lookup on the attributes table. |
App Query Service 2.10.0 Copied
Released: 19 March 2025
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-806 | Added support for global dashboard filters. |
| ESCA-809 | Upgraded Postgres to version 17.3. |
| ESCA-810 | Removed unused GetDimensionStatistics endpoint. |
| ESCA-811 | Removed unused entity_severity_timeline.severity_previous DB field. |
| ESCA-812 | Removed unused entity_snooze_timeline.severity_previous DB field. |
| ESCA-814 | Entity display labels are dynamically generated for Dashboard dataviews. |
| ESCA-816 | Reduced CPU usage in the DB activity poller. |
App Query Service 2.9.0 Copied
Released: 20 February 2025
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-719 | Data-level RBAC is now applied to dashboard subscriptions. |
| ESCA-771 | Added the flag dashboard data model to mark a dataview as hidden. |
| ESCA-772 | Extended the Dashboard API with global filters. |
| ESCA-787 | Dynamic graphs now react faster to dataview updates. |
| ESCA-789 | Optimized signal update query by not issuing a query if there is no update needed from the signal hierarchy cache. |
App Query Service 2.8.0 Copied
Released: 6 February 2025
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-726 | Upgraded to Postgres version 17 to resolve CVEs. |
| ESCA-742 | Removed deleted entities from the contents table. |
| ESCA-743 | Removed signals hierarchies for deleted entities. |
| ESCA-744 | Simplified the Alerting app query. |
| ESCA-745 | Exposed a limit so that the Alerting app can specify how many signals to analyze. |
| ESCA-746 | Exposed the number of signals analyzed by Alerting app DB queries. |
| ESCA-759 | Fixed an issue with Dashboard columns being incorrectly marked as stale. |
| ESCA-760 | Permanent dashboard filters apply only to the DPD expression. Transient filters are added as output filters and do not modify the expression. |
| ESCA-762 | Extended the Dashboard API to support multi-line charts. |
| ESCA-764 | Simplified the threading model to avoid deadlocks. |
| ESCA-765 | Simplified the expression builder to avoid deeply nested DPD expressions. |
| ESCA-766 | Added support for filtering on non-string Attribute columns. |
| ESCA-767 | Optimized count query used by the AnalyzeDataview endpoint. |
| ESCA-769 | The correct display value is now returned for metric subscriptions in the Dashboard API. |
| ESCA-770 | Optional columns in the DB lookup are ignored when discovering available columns for a dataview. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-698 | Fixed an issue where RBAC scopes were incorrectly applied to Query Service DB queries. The Query Service now uses the same Keycloak client as the Platform. |
App Query Service 2.7.0 Copied
Released: 28 January 2025
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-649 | Added the first version the new Dashboards API, which exposes the DPD dataview API to apps. This is an experimental API pending the official release of the Dashboards app. |
| ESCA-713 | Resource requests and limits are now set for all Query Service init containers. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-741 | Fixed an issue where the wrong set of signals were returned when applying the triggeredDuring signal filter. |
App Query Service 2.6.0 Copied
Released: 7 November 2024
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-669 | Added a new attribute named itrsgroup.com/apps:display-name to entities. This attribute, if provided, will be used to set the display name for the entity in the UI. |
| ESCA-688 | Since the System Overview app is no longer supported, the ticker endpoint in the Query Service has been removed. |
| ESCA-694 | Added more aggressive purging of EntityActivityCache, which could become sizeable if the rate of entity updates is high. |
| ESCA-696 | Restarts are now avoided during the startup phase. |
| ESCA-697 | Logging of slow queries is now enabled by default, and can be controlled using minQueryLogDuration in the helm chart. If not set, the value defaults to 5 seconds. |
| ESCA-699 | Optimized the getDataview endpoint. |
Legacy releases Copied
App Query Service 2.5.0 Copied
Released: 25 October 2024
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-655 | Reduced the default CPU and MEM request limits. |
| ESCA-684 | Removed signal counts from entity query endpoints due to performance reasons. The counts are still in the API but are set to zero to ensure that existing apps do not break. |
| ESCA-689 | Optimized the query plan for the API endpoint querySignalBucketedCounts. |
App Query Service 2.4.0 Copied
Released: 29 August 2024
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-654 | App workloads now restart if any of their configuration options change via a helm upgrade. |
App Query Service 2.3.1 Copied
Released: 13 August 2024
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-581 | Upgraded Postgres to version 16.2 to resolve critical CVEs. |
| ESCA-650 | Upgraded BusyBox to version 1.36.1 to resolve critical CVEs. |
| ESCA-653 | Upgraded iam-tools to version 2.6.0 to resolve critical CVEs. |
App Query Service 2.3.0 Copied
Released: 28 June 2024
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-604 | Fixed an issue where the getDataview endpoint resulted in missing metrics in the Entities app. This issue only occurred for dataviews that contained more than 100 cells. |
App Query Service 2.2.0 Copied
Released: 5 June 2024
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-595 | Supported helm upgrades. |
| ESCA-596 | Supported the new OK severity state added in ITRS Analytics Platform 2.3.0. |
| ESCA-607 | The output of getSignalInfo is now sorted by the signal name to avoid signals moving around the UI between updates. |
| ESCA-608 | Added GetDatapointInfoRequest.metric_statistics_window as a workaround to an issue with histogram metrics. |
| ESCA-609 | Implemented a temporary solution to visually differentiate stale metrics from active metrics in the UI. |
| ESCA-629 | The tiles in queryGroupedEntityStats are now sorted by labels in ascending order. |
| ESCA-630 | The GetDataviewResponse now contains metric type information at the column level. |
| ESCA-631 | The rows in GetDataviewResponse are now sorted by the entity display label. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-604 | Fixed an issue where containment rules were not updated during a helm upgrade. |
App Query Service 2.1.0 Copied
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-533 | Added the getLogicalEntityPath endpoint, which is used by the UI to resolve an entity’s path in the logical state tree. |
| ESCA-534 | The resolveAttributes API endpoint now includes a flag that tells the UI if an attribute is a status metric. |
| ESCA-536 | Added the GetHistogramStatistics and GetHistogramSeries endpoints to make it easier for the UI to work with histogram data points from the ITRS Analytics Platform. These endpoints are experimental and might change or be moved to the ITRS Analytics Platform. |
| ESCA-539 | Replaced the existing GetLatestMetricValues endpoint with the new GetMetricStatistics endpoint. GetLatestMetricValues will be removed once the System Overview app is deprecated. |
| ESCA-542 | Added an endpoint for getting a dataview, such as the representation of metrics for child entities. The primary use case for this is for the new Entities app and the Entities Viewer page. |
| ESCA-544 | Added an endpoint for getting the unique set of child hierarchies for an entity. |
| ESCA-545 | Added an endpoint for getting metrics available for a dataview. This endpoint is experimental and not currently used by any app. |
| ESCA-549 | Added the GetDatapointInfo endpoint, which returns information for a datapoint (metric, histogram, log, etc.) for an entity. |
| ESCA-550 | Added a search filter to QueryEntityGroupedStats. This enables filtering in the logical tree view for the Entity Viewer. |
| ESCA-551 | Exposed a Logs API to hide the raw Loki API. The Logs API exposes endpoints for querying logs and statistics. This API is experimental and will be migrated to the ITRS Analytics Platform at some point. |
| ESCA-552 | Optimized query expressions referencing the hierarchy attribute. |
| ESCA-553 | Exposed the new getMetricSeries endpoint for getting a metric series from the ITRS Analytics Platform. The endpoint adds additional functionality such as unit conversion. In a future release, this endpoint will also do gap filling and caching. |
| ESCA-558 | Added the QueryEntityFacets and QueryGroupedEntityFacets endpoints for returning facet counts for a set of entities. |
| ESCA-568 | Extended EntityInfo with EntityInfo.display_label so the UI can display a user-friendly display name without needing to have logic in the UI for deciding what the display name should be. |
| ESCA-570 | Added the new GetSignalInfo endpoint for retrieving signals triggered within a time window. The signals returned are enriched with metric information. |
| ESCA-571 | Added KeyType.STATUS so entity queries can be filtered by entities having status metric only. |
| ESCA-572 | Added the QueryRelatedEntities endpoint for resolving related entities. This is an experimental feature and will be enhanced once the ITRS Analytics Platform supports relationship graphs. Currently, the endpoint resolves relationships by looking at dimension commonalities. |
| ESCA-575 | Extended EntityInfo with EntityInfo.has_logs_descendants. This flag tells the UI if any descendent entities have logs. |
| ESCA-576 | Updated Kubernetes containment rules in line with the changes in ITRS Analytics Platform 2.2.0. |
| ESCA-577 | Added QueryEntityGroupedStatsResponse.count, which gives the total number of entities in the response. |
| ESCA-579 | It is now possible to specify how grouping is done in QueryEntityGroupedStats. Either entities matching the ALL or ANY keys are included. |
| ESCA-582 | Added the streaming activity endpoint for notifying the UI when the following happens.
The UI will subscribe to the aforementioned events and update itself accordingly. In most cases, this will result in a complete refresh upon receiving an activity update from the Query Service. |
| ESCA-584 | Added the GetStatusMetricSeries endpoint to simplify the retrieval of status metric history. The endpoint retrieves the history and also takes into account stale status metric. If the latest status metric update falls outside of the requested time window, it will be returned in the response. |
| ESCA-586 | Optimized the query for getSignalTimeline by simplifying a join and adding a specialized index. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-573 | Previously, search did not work if multiple scopes were specified in the search UI. For example, if both Attributes and Dimensions were applied in the scope, then nothing will be returned from the Query Service. This issue has been resolved. |
App Query Service 2.0.0 Copied
Released: 8 December 2023
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-480 | The getLatestMetrics endpoint now returns metrics ordered in descending order by metric name. |
| ESCA-488 | Upgraded app for compatibility with ITRS Analytics Platform 2.0. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-395 | Fixed an issue where the Query Service could fail and restart if dimensions had a null value. |
App Query Service 1.9.0 Copied
Released: 12 July 2023
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-252 | Removed the deprecated ResolveAttributesResponse.attribute field. |
| ESCA-417 | Added CountByEntityKeyValues.key to the gRPC API to make the code cleaner in the Alerting app. |
| ESCA-453 | The API for QuerySignalTimelineRequest and QuerySignalTimelineBucketsRequest has been updated to make it clearer which arguments must be passed in. The changes are backward compatible, while the old, deprecated fields will be removed in a future release. |
| ESCA-464 | Reduced the following Linkerd-related settings:
|
| ESCA-479 | The bucketed timeline endpoints now return the bucket size used by the backend. This information is needed by the UI to request further information for a bucket. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-263 | The snooze status is now returned correctly by the Query Service. The root cause was fixed in ITRS Analytics Platform 1.4 and has been validated against Query Service 1.9.0. |
| ESCA-423 | When subscribing to a ticker event, a statistics message is sent to the subscriber on initialize request. Prior to this change, statistics were only sent when an entity was updated. |
| ESCA-452 | Due to a lack of API validation, the Query Service threw an NPE if the wrong query parameters were provided in the request. This issue has been fixed by adding additional validation to the service. Additionally, some old fields in the request payload have been deprecated. |
App Query Service 1.8.0 Copied
Released: 31 May 2023
New features and enhancements Copied
These are the new features and enhancements of this release:
Note
App Query Service 1.8.0 requires ITRS Analytics Platform version 1.4.0. You must upgrade to App Query Service 1.8.0 since its earlier versions are not compatible with ITRS Analytics Platform 1.4.0.
| Issue key | Release description |
|---|---|
| ESCA-428 | Search matches are now returned for the queryEntityInfo endpoint. This feature will be available in the next version of the System Overview app (1.6.0). |
| ESCA-438 | Added support for searching entities where the search term matches descendant entities. This feature will be available in the next version of the System Overview app (1.6.0). |
| ESCA-439 | The Query Service sends a statistics update to the subscriber with every entity update. If the Query Service is flooded with entity updates, the UI will receive a very large number of statistics updates. The Query Service now limits the update rate for statistics updates to one message per second. |
| ESCA-441 | Searching by multiple search terms is now supported. This feature will be available in the next version of the System Overview app (1.6.0). |
| ESCA-442 | The signal sink has been optimized by replacing some queries with caches. The signal sink main loop has also been optimized to reduce the number of database calls. |
| ESCA-444 | Changes have been made to support the updated Signal subscription API in the ITRS Analytics Platform. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-440 | Fixed an issue where rapidly changing filters in the System Overview app could deadlock the Query Service. This only happened when the database was put under heavy load with a lot of entity updates. |
App Query Service 1.7.0 Copied
Released: 27 March 2023
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-341 | A streaming event ticker API is now available, which can add multiple named filters that associate events within groups in the UI. |
| ESCA-398 | When set, a new field in the UI can request for the event ticker API to return snapshots of currently triggered entities before sending real-time updates. |
| ESCA-410 | The ticker subscription endpoint now sends a message when an entity is removed from the subscription. |
| ESCA-411 | EntityInfo object, used in the Overview app, now supports real-time updates in preparation for getting ordered dimensions from the Platform gRPC API. This optimizes lookups in the UI to getDimensionOrdering in the Query Service. |
| ESCA-418 | Optimized the database poller for real-time events to avoid connection pool starvation. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-409 | An issue where NullPointerException was thrown by the Signals KPI endpoint when querying Signals without metric or log references has been fixed. |
| ESCA-413 | The querySignalBucketedCounts endpoint now returns the same number of objects in the current and previous periods. |
App Query Service 1.6.0 Copied
Released: 31 January 2023
New features and enhancements Copied
These are the new features and enhancements of this release:
Note
App Query Service 1.6.0 requires ITRS Analytics Platform version 1.3.0 and is not compatible with earlier versions of the ITRS Analytics Platform.
| Issue key | Release description |
|---|---|
| ESCA-347 | Improved EntitySink insert performance by 50% by using multi-value inserts instead of batched inserts. |
| ESCA-388 | Query logging for slow queries is now enabled by default. |
| ESCA-390 | Optimised bucketed signal statistics by doing a single query. The query is used by the Signals KPI view. |
| ESCA-392 | QuerySignalBucketedCounts, used by the Signal KPI view in the Alerting app, has been updated so the Distinct Entity KPI now shows the distinct count for entities with triggered signals. Prior to this change, the count was calculated as the distinct entities with transitioned signals. |
| ESCA-395 | ITRS Analytics Platform version 1.3.0 replaces the last-observed attribute with an inactive-since attribute, reducing the number of entity updates sent to the Query Service each hour. Query Service version 1.5.0 and earlier versions are not compatible with ITRS Analytics Platform 1.3.0. |
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| ESCA-396 | An issue has been fixed where due to timestamp precision difference between PostgreSQL and Java, some signals could be incorrectly indexed resulting to inaccurate severity timelines in the UI. |
App Query Service 1.5.0 Copied
Released: 13 December 2022
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-301 | PostgreSQL has been upgraded to version 15. |
| ESCA-341 | A streaming event ticker endpoint has been created. This enables adding multiple named filters, which can be used to associate events with the groups in the UI. |
| ESCA-342 | Optimised queryKeys by moving the join to the Names table last in the query plan. |
| ESCA-343 | Removed the redundant join when the EntityFilter is empty. |
| ESCA-345 | The index now only scans for GetEntitySeverity, which reduces the amount of data needed. |
| ESCA-346 | Removed the following unused fields: EntitySummaryStatistics.entity_count_unclassified_roots from the API and is_root from the database schema. |
| ESCA-348 | Improved index performance by batch inserting the attribute history |
| ESCA-349 | Default PostgreSQL CPU settings have been updated. |
| ESCA-363 | Optimised the SignalFilter by doing a pre-lookup on signalId, which avoids a join at query time. |
| ESCA-367 | Optimised EntityKeyPivotBuilder used by the Overview app to query the grouped entity statistics. |
| ESCA-368 | Consecutive NONE signals are dropped since they are of no interest to the Query Service, freeing up storage space. |
| ESCA-370 | A unique index for the Signals table has been added, which resolves an issue where the table could contain duplicated rows if the sink is restarted. |
App Query Service 1.4.0 Copied
Released: 9 November 2022
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-310 | Optimised storage of signals in the App Query Service, which now stores repeated namespaces and names only once. |
| ESCA-316 | Memory thresholds can now be manually configured. |
| ESCA-317 | The table and index sizes for the entity attributes table have been reduced by 30%. |
| ESCA-333 | The QueryEntityInfo database query has been optimised to reduce the number of database calls. The query is now executed as a single query, which has dropped the execution time from 2 to 3 seconds to ~400 ms. |
| ESCA-335 | To take type alignment into account and reduce table size, columns in tables have been reordered. |
App Query Service 1.3.0 Copied
Released: 17 October 2022
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-299 | The App Query Service getDimensionTable endpoint, which is used by the dimension table displayed in the Alerting app, has been updated to hide the final dimension key if the optional label is the same. |
| ESCA-300 | A database trigger for signals has been replaced with a cache for faster inserts. |
| ESCA-302 | To optimise insert performance, fsync and full_page_writes have been turned off. By disabling PostgreSQL durability features and guarantees, App Query Service is bootstrapped from the ITRS Analytics Platform on start-up and can deal with a corrupted state. |
| ESCA-303 | Unlogged tables are now used to improve insert performance. |
| ESCA-307 | PostgreSQL settings are now automatically adjusted based on available memory. |
App Query Service 1.2.0 Copied
Released: 4 October 2022
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-286 | Entities that have a severity status or are snoozed now get indexed regardless of their age to ensure that Overview app data (tree view) remains consistent. |
| ESCA-292 | The materialised hierarchy view has been removed. This improves performance since the view consumes a lot of CPU resources and takes a long time to update when there is a large number of entities in the system. |
| ESCA-294 | The QuerySignalInfo endpoint has been removed since the Alerting app now uses new endpoints which are based on the ITRS Analytics Platform attribute history. |
| ESCA-296 | Free-text search no longer searches for descendants. This feature has been removed since it causes performance issues in the App Query Service. |
| ESCA-297 | The SQL query for free-text search has been optimised. |
App Query Service 1.1.2 Copied
Released: 16 September 2022
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-279 | Classifications are now included in the entity_info view. |
| ESCA-285 | Metrics with no associated name or value are filtered from GetLatestMetricValues and logged as a warning. |
| ESCA-287 | Queue size parameters for signals, entities, and attributes can now be configured separately. |
| ESCA-290 | Modifying the Docker registry value is now allowed, enabling you to use a single values file. |
App Query Service 1.1.1 Copied
Released: 30 August 2022
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-275 | The parameters for batch size, subscription queue size, and entity attribute lookback period can now be manually configured. |
App Query Service 1.1.0 Copied
Released: 23 August 2022
New features and enhancements Copied
These are the new features and enhancements of this release:
| Issue key | Release description |
|---|---|
| ESCA-253 | Timelines and signals in the QuerySignalInfo endpoint are now exposed. By adding the timeline to QuerySignalInfosResponse, requests to the backend are lessened. |
| ESCA-256 | Bucketed timelines for individual signals are now exposed. This allows the retrieval of bucketed signal timelines for a single entity. |
| ESCA-259 | Configuration changes related to WAL data tuning as well as calculating settings based on Kubernetes resources have been implemented for improved performance. |
| ESCA-260 | When entities get evicted from the ITRS Analytics Platform, the App Query Service also evicts the said entities to ensure consistency. |
| ESCA-261 | JOOQ SQL queries and timing are now logged, which can help in diagnosing performance issues. |
| ESCA-264 | GetLatestMetricValues has been added to the API, which can be used to request metrics for direct descendants of an entity. |
| ESCA-266 | To enable metrics collection by the Kubernetes plugin, the following environment variables have been added to PostgreSQL deployment: NODE, NAMESPACE, POD, and CONTAINER. |
| ESCA-270 | To improve resource handling, the main daemon has been split into two separate processes: subscribe to entities and upsert in the DB container (write) and query the DB container for requests from the front-end (read). |
App Query Service 1.0.1 Copied
Released: 2 August 2022
Issues fixed Copied
These are the issues we have fixed in this release:
| Issue key | Release description |
|---|---|
| HUBG-216 | An error in deploying ITRS Analytics apps when the Kubernetes cluster can’t resolve the node hostname has been fixed. |
Disclaimer
The information contained in this document is for general information and guidance on our products, services, and other matters. It is only for information purposes and is not intended as advice which should be relied upon. We try to ensure that the content of this document is accurate and up-to-date, but this cannot be guaranteed. Changes may be made to our products, services, and other matters which are not noted or recorded herein. All liability for loss and damage arising from reliance on this document is excluded (except where death or personal injury arises from our negligence or loss or damage arises from any fraud on our part).
["ITRS Analytics"]
["Release Notes"]