Troubleshooting Query Timeouts
To troubleshoot timeout errors in Bulk API 2.0 query operations, apply additional
filter criteria.
If you use a SOQL query with the ORDER BY clause, and you experience query time outs, then remove the ORDER BY clause before any subsequent troubleshooting. Use of ORDER BY in a Bulk 2.0 query disables PKChunking for the query. With PKChunking disabled, the query takes longer to execute, and potentially results in query timeouts.