Laurenz Albe schrieb am 19.02.2025 um 09:43: >> We have PostgreSQL 16 running in GCP cloud SQL. When export job runs we >> are noticing these messages excessively: >> >> db=postgres,user=postgres ERROR: canceling statement due to user request >> >> Does Export cancel the SQLs? If not, why are we noticing these messages >> excessively during the export operation? The load on the instance is minimal. > > I am not sure what exactly you mean by "export". A pg_dump? > But I am not aware of any operation that would cancel statements in other > sessions. Perhaps someone or something in your application sends cancel > requests when a statement is running too long, and the concurrent export > slows down the system. What if the "export" is done on a read-only replica? Could this be a "canceling statement due to conflict with recovery" in disguise?
