Articles on: PostgreSQL and MySQL

PostgreSQL timeout

By default, we have a 30-minute timeout for any report created. If your PostgreSQL query is taking longer than 30 minutes to execute the connection will be automatically interrupted and you'll see a TIMEOUT error in SyncWith. You should try to optimize your query to run more quickly, using tools like EXPLAIN ANALYZE, and then update your SyncWith report to use the optimized query.

Updated on: 02/06/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!