How to solve SQLSTATE[57014]: Query canceled: 7 ERROR: canceling statement due to statement timeout" error?

Question

PostgreSQL

I am using symfony 3 and postgresql. I get an error with a capacious request, how to solve this problem?
SQLSTATE[57014]: Query canceled: 7 ERROR: canceling statement due to statement timeout",

Answer 1

Look for where statement_timeout is set. Such an error is precisely when this setting is triggered. And it must be included intentionally. So look for where it is set, from the DBMS config, database and user settings to the manually made set in the application.