Home / Companies / Hasura / Blog / Post Details
Content Deep Dive

Tweaking GraphQL performance using Postgres’ Explain command

Blog post from Hasura

Post Details
Company
Date Published
Author
Sandip
Word Count
695
Company Posts That Month
2
Language
English
Hacker News Points
-
Post removed?
No
Summary

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.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.