Quantum gravity and the renormalisation group: from the UV to the IR