Tweaking GraphQL performance using Postgres’ Explain command

The Hasura GraphQL Engine has been optimized for performance and scalability. It processes incoming requests through stages such as parsing, validation, conversion to SQL, execution by Postgres, and returning JSON responses. To further improve the performance of GraphQL queries, a recent version of Hasura introduced an API that outputs generated SQL along with the execution plan prepared by Postgres' Explain command. This feature helps identify performance bottlenecks and suggests improvements such as adding indexes to reduce latency. The team plans to make insights from Explain more actionable and possibly automate database admin tasks for developers in future iterations.