update sql queries for response time and error count gadgets