Database Query Middleware.py

class DatabaseLoggingMiddleware(object):

    def process_request(self, request):
        request.start_time = time.time()

    def process_response(self, request, response):
        if 'content-type' in response._headers and response._headers['content-type'][1].startswith('application/json') and response.status_code == 200:
            end_time = time.time()
            total_execution_time_msec = int((end_time - request.start_time) * 1000)

            data = json.loads(response.content)
            if not isinstance(data, dict):
                return response

            if 'meta' not in data:
                data['meta'] = {}
            data['meta']['n_queries'] = len(connection.queries)

            data['meta']['queries'] = connection.queries
            data['meta']['total_time'] = sum([float(q['time']) for q in connection.queries])
            data['meta']['total_execution_time'] = total_execution_time_msec / 1000.0
            response.content = json.dumps(data)

        return response