Project Export in import/export and direct transfer - PG::QueryCanceled: ERROR: canceling statement due to statement timeout
Some projects fail to export due to the error PG::QueryCanceled: ERROR: canceling statement due to statement timeout
. This issue may arise from inadequate table indexes during the export process rather than from the batch size
mentioned in #441426 (closed).
The Kibana filter displays the project details along with the SQL query that encountered the error. With this information, we can assess potential performance issues of the SQL queries using Database Lab. When utilizing Database Lab, it's essential to use the project_id
of the project that failed to examine SQL performance, especially when exporting a large number of records.