# Large query times to Edge historical (8.3)

**URL:** <https://forum.inductiveautomation.com/t/large-query-times-to-edge-historical-8-3/111708>\
**Category:** Ignition\
**Created:** [October 24, 2025, 4:51pm UTC](https://forum.inductiveautomation.com/t/large-query-times-to-edge-historical-8-3/111708 "2025-10-24T16:51:21Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andrew\_Florance](https://avatars.discourse-cdn.com/v4/letter/a/7ab992/32.png) [@Andrew\_Florance](https://forum.inductiveautomation.com/u/Andrew_Florance)\
**Post date:** [October 24, 2025, 4:51pm UTC](https://forum.inductiveautomation.com/t/large-query-times-to-edge-historical-8-3/111708/1 "2025-10-24T16:51:21Z")

</div>

```python
24Oct2025 10:45:54
Post value query took 0 ms, returned 0 values across 2 node ids
DEBUG
QueryEngine

24Oct2025 10:45:54
Time-based datapoint query took 1 seconds, returned 68871 values across 2 node ids
DEBUG
QueryEngine

24Oct2025 10:45:53
Querying raw datapoints: RawQueryOptions{} DataPointQueryOptions{excludeObservations=false, qualityLevelFilter=QualityLevelFilter{levelMask=0}} AbstractQueryOptions{queryKeys=[RawQueryKey[source=sys:thecolony-426:/prov:MQTT Engine:/tag:Edge Nodes/the colony-426/RTU18/IO/OptoMMP/Modules/Channels/LCT/Value], RawQueryKey[source=sys:thecolony-426:/prov:MQTT Engine:/tag:Edge Nodes/the colony-426/RTU01/IO/OptoMMP/Modules/Channels/LCT/Value]], extendedProperties=ImmutablePropertySet[{}], timeRange=TimeRange{startTime=2025-09-26T16:45:52.757Z, endTime=2025-10-24T16:45:52.757Z, bounds=exclusive}, returnSize=null}
DEBUG
QueryEngine

24Oct2025 10:45:53
Querying finished in 980 ms, returned 68871 total datapoints, including 0 post values, 0 seed values, and 0 realtime values, across 2 node ids
DEBUG
QueryEngine

24Oct2025 10:45:53
Post value query took 0 ms, returned 0 values across 2 node ids
DEBUG
QueryEngine

24Oct2025 10:45:53
Time-based datapoint query took 979 ms, returned 68871 values across 2 node ids
DEBUG
QueryEngine

24Oct2025 10:45:52
Querying raw datapoints: RawQueryOptions{} DataPointQueryOptions{excludeObservations=false, qualityLevelFilter=QualityLevelFilter{levelMask=0}} AbstractQueryOptions{queryKeys=[RawQueryKey[source=sys:thecolony-426:/prov:MQTT Engine:/tag:Edge Nodes/the colony-426/RTU18/IO/OptoMMP/Modules/Channels/LCT/Value], RawQueryKey[source=sys:thecolony-426:/prov:MQTT Engine:/tag:Edge Nodes/the colony-426/RTU01/IO/OptoMMP/Modules/Channels/LCT/Value]], extendedProperties=ImmutablePropertySet[{}], timeRange=TimeRange{startTime=2025-09-26T16:45:51.755Z, endTime=2025-10-24T16:45:51.755Z, bounds=exclusive}, returnSize=null}
DEBUG
QueryEngine

24Oct2025 10:45:52
Querying finished in 1 seconds, returned 68871 total datapoints, including 0 post values, 0 seed values, and 0 realtime values, across 2 node ids
DEBUG
QueryEngine

24Oct2025 10:45:52
Post value query took 0 ms, returned 0 values across 2 node ids
DEBUG
QueryEngine

24Oct2025 10:45:52
Time-based datapoint query took 1 seconds, returned 68871 values across 2 node ids
DEBUG
QueryEngine

24Oct2025 10:45:51
Querying raw datapoints: RawQueryOptions{} DataPointQueryOptions{excludeObservations=false, qualityLevelFilter=QualityLevelFilter{levelMask=0}} AbstractQueryOptions{queryKeys=[RawQueryKey[source=sys:thecolony-426:/prov:MQTT Engine:/tag:Edge Nodes/the colony-426/RTU18/IO/OptoMMP/Modules/Channels/LCT/Value], RawQueryKey[source=sys:thecolony-426:/prov:MQTT Engine:/tag:Edge Nodes/the colony-426/RTU01/IO/OptoMMP/Modules/Channels/LCT/Value]], extendedProperties=ImmutablePropertySet[{}], timeRange=TimeRange{startTime=2025-09-26T16:45:50.754Z, endTime=2025-10-24T16:45:50.754Z, bounds=exclusive}, returnSize=null}
DEBUG
QueryEngine

24Oct2025 10:45:51
Querying finished in 985 ms, returned 68871 total datapoints, including 0 post values, 0 seed values, and 0 realtime values, across 2 node ids
DEBUG
QueryEngine

24Oct2025 10:45:51
Post value query took 0 ms, returned 0 values across 2 node ids
DEBUG
QueryEngine

24Oct2025 10:45:51
Time-based datapoint query took 983 ms, returned 68871 values across 2 node ids
TRACE
SyncableRunner

24Oct2025 10:45:50
Did not run sync - Syncable reported nothing to sync for id 1149
TRACE
SyncableRunner

24Oct2025 10:45:50
Last sync ID: 1149
DEBUG
QueryEngine

```

I am seeing gaps in my data, and I am trying to figure out if it’s a plc issue or a gateway issue.

As I understand querying the historian is single threaded. Meaning when a query takes 868ms every other process trying to access the database has to wait.

Why am I seeing these “time-based” queries that are taking 1second? Is this a problem or is this normal? Why am I querying 65k data points and returning nothing?

Just to clarify. I am seeing data gaps in the data being stored on Edge. I am trying to figure out why that is and I am wondering if these 1 second queries are indicative of an issue or if this is normal. Edge DB behavior.