added database index for logs `resource`