django-sql-explorer icon indicating copy to clipboard operation
django-sql-explorer copied to clipboard

Published 20 hours ago • verified publisher icon chrisclark

Query form submission closes connection

Open sdether opened this issue 3 years ago • 1 comments

If I have a query (either saved or in the playground) that runs longer than 30 seconds, the app closes the connection. It doesn't seem to be a django or db timeout, as I have a DRF view to execute SQL and using that view with the same SQL and DB connection, I can run queries that take several minutes.

Is there a SQL Explorer specific setting for timeouts?

sdether avatar Aug 27 '21 00:08 sdether

I'm not aware of a timeout. But I don't think I've ever had a query run for that long.

marksweb avatar Aug 27 '21 00:08 marksweb

@marksweb @sdether this is configured at the db connection level (not something that SQL explorer controls). It's different per DB. Here is a relevant article for postgres. I feel we should close this issue.

https://medium.com/squad-engineering/configure-postgres-statement-timeouts-from-within-django-6ce4cd33678a

lawson89 avatar Dec 16 '22 13:12 lawson89