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.