I have recently been trying to pull logs from the API and have noticed a lot of duplicate entries being returned. Is this normal? The type I am sending it is “query” so I should be getting only the queries back. When I sorted by query_id, which I am assuming is the unique ID for the query, I get about 100 duplicate rows returned for each query_id. And those said duplicates also have the same timestamp.
At first I though maybe that was all of the results - but when I looked at the actual results (query_body) they too were duplicated 100 times in the same second. So I am puzzled as to how I can even use the logs API to see what was queried if there are so many duplicates and only 1,000 rows are retained.
Any assistance in this would be greatly appreciated.