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.09k stars 2.76k forks source link

support for approximate counts in aggregates #1154

Open 0x777 opened 5 years ago

0x777 commented 5 years ago

For example,

query {
  users_aggregate {
    aggregate {
      count
    }
  }
}

would result in an SQL query which will do a sequential scan.

Maybe we can natively support few tricks from https://www.citusdata.com/blog/2016/10/12/count-performance/

KillianGDK-FDTI commented 2 years ago

Hello, it would be a super nice feature to have. In my app I have to wait dozens of seconds for each aggregate count. An approximate instead will take less that a second and will be a breaking change for us.

Is there any news on that topic ?

Thanks again and congratz to all hasura team :)

manasag commented 9 months ago

This issue will now be reviewed and tracked as part of the Hasura V3 roadmap.