search

hasura / graphql-engine

Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
https://hasura.io
Apache License 2.0
31.19k stars 2.77k forks source link

Hasura GraphQL 504 error(Gateway Time-out) while run the query in GraphQL console - API explorer tool #8605

Open mdafzaljay opened 2 years ago

mdafzaljay commented 2 years ago

While I do the search for user email Id using '_ilike' in Hasura GraphQL console - API explorer tool and also in API calls. Its took too long time to load after 30 seconds its thrown 504 error(Gateway Time-out). Its happens 3/4 times. Sometimes it shows data. I am getting indeterminate results while do the search. That table have 2.3 millions of data in Postgres DB and its gets update every 30 minutes. I tried with indexing also to fetch the data faster that also not work.. Can someone help me out on this...

creativecomposer commented 1 month ago

Happens to me as well. The API explorer cannot fetch the data if the limit operator is used. Server version: v2.37.1