Latest Data values from deep past

[watm24]

Hello.

Can you help me please.
My Zabbix version is 5.4.8.
I need to look at exact values on one of the device item from deep past.
1. I go to Latest Data, choose Date/Time range and I'm able to see graph.
But when switching to Values I see no data.
2. Administration - General - GUI. Limit for search and filter results = 1000
Now I set this parameter to 100000.
I go to step 1 and able to see values on Date/Time range.

So it looks like Zabbix at first limits SELECT query by LIMIT and then applies timerange filter.
Is it possible to change this behavior to: SELECT -> timerange -> LIMIT?
This item receives data every 15 minutes and I need to check exact values stored for 2 years.
This will lead to 71424 values on dataset.
And I think changing global 'Limit for search and filter results' can slow down other queries.

Thank you.

[max.]

Hello watm24, how are you?

Can you share the housekeeping data storage period for history and trends?
I'm trying to replicate in my zabbix instance and it works, time filter executes before the limit.

Also you can try to troubleshoot in debug mode to see the actual query. In my case:
SQL (0.006439): SELECT h.* FROM history h WHERE h.itemid=53204 AND h.clock>=1587308625 AND h.clock<=1650380625 ORDER BY h.clock DESC LIMIT 1000

My guess is that the information is not actually in the database.
Try to connect to the database and execute the query yourself and see if there is any values.

Regards

[watm24]

Also you can try to troubleshoot in debug mode to see the actual query. In my case:
SQL (0.006439): SELECT h.* FROM history h WHERE h.itemid=53204 AND h.clock>=1587308625 AND h.clock<=1650380625 ORDER BY h.clock DESC LIMIT 1000

My guess is that the information is not actually in the database.
Try to connect to the database and execute the query yourself and see if there is any values.

Hi max!
Thank you for pointing me at debug mode.
You were right... manually check result - there is no data in database.

Thanks again!