Mean square decay of Fourier transforms in Euclidean and non Euclidean spaces