Hasura is a scalable GraphQL engine on Postgres that provides instant APIs with authorization. It supports live queries for clients over GraphQL subscriptions. In a test setup, Hasura handled 1 million active live queries while maintaining under 28% load on Postgres and around 850 peak connections. The architecture enabling this performance is detailed in their GitHub repo.