Because the result is returned to the client as the response for the query and is stored inside the cursor. fetch*() only return it to Python.
psycopg by date:
Соглашаюсь с условиями обработки персональных данных