hasura / hasura/graphql-engine
v2.0.3 long queries
- Dominant language
- TypeScript
- Stars
- 32.1k
- Forks
- 3k
- PR merge metrics
- PR metrics pending
Description
Hey guys, we are running versoin 1.3 and version 2 pointing at the same PostGreSQl DB. When we run a query that happens to return a lot of data, Hasura 2.0.3 just bails on it. No error, no timeout, just nothing in the GraphQL payload window.
However, when we run exactly the same query in version 1.3, pointing at the same DB, it does return the payload.
When we use the Analyse feature to get the SQL query and we run this on the DB directly, there is only about 1-2 seconds difference in the return time for the payload in SQL compare to Hasura 1.3.
however v2 just bails on the query and does nothing - we have found this to be the case after multiple tests. For queries that exceed 1 min (or thereabouts) version 2 does nothing.
We have 1.3 in dev and 2 in prod and would prefer not to have to rebuild to 1.3.
We have also indexed the tables in PGQSL following the how to guide on improving query performance (but from the above, that was really irrelevant and made no difference)
We are running 2.0.3 in an Azure container pointing at an Azure database for Postgres SQL. 1.3 is running in docker desktop on a VM
Was difficult to find any support from Hasura for self managed instances (other than GitHub). A support chat feature on your website wouldn't go astray.
Contributor guide
Assessment
This issue has not been assessed yet.