hasura / hasura/graphql-engine

v2.0.3 long queries

Open
#7,464 5 comments 0 reactions 0 assignees View on GitHub
a/data/postgres c/server k/bug p/high
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.