Real-Time Analytics

Customer-facing analytics dashboards often require sub-second response times. By sharding and parallelizing your SQL queries across multiple nodes, Citus makes it possible to perform real-time queries across billions of records in under a second.

Are You Having Trouble Delivering Sub-Second Responses Over Billions of Rows?

Are you trying to find a way to maintain sub-second responses as your dataset grows?

Lorem ipsum dolor sit amet consectetur adipisicing elit. Quos consequuntur amet molestiae quidem ut. Illum, eligendi provident. Ea, id quod.

Are you worried about having to give up SQL in order to scale out your database?

Lorem ipsum dolor sit amet consectetur adipisicing elit. Est reprehenderit repellendus impedit a in fuga obcaecati vero possimus vitae? Consequuntur, commodi?

Are your users having to wait too long for responses to dashboard queries?

Lorem ipsum dolor sit amet consectetur adipisicing elit. Ullam, magni similique, nulla pariatur vel, veritatis perspiciatis saepe aliquid necessitatibus ducimus illo quaerat odio cupiditate soluta!

Do your customers need to analyze new events & new data as it happens, in real-time?

Lorem ipsum dolor sit, amet consectetur adipisicing elit. Deleniti corporis odio est blanditiis inventore rem!

Does your database performance deteriorate with high concurrency?

Lorem ipsum dolor sit amet consectetur, adipisicing elit. Praesentium voluptates blanditiis, accusamus enim atque recusandae placeat incidunt aut repellat veritatis excepturi. Itaque, a?

Are you fed up with stitching together different databases to get the functionality you need?

Lorem ipsum dolor sit, amet consectetur adipisicing elit. Cum, similique odio molestias aspernatur velit soluta ipsa iusto et quibusdam, est nostrum nam error, asperiores libero officiis.

Are you looking for a way to parallelize your SQL queries?

Lorem ipsum dolor sit amet consectetur adipisicing elit. Ut labore commodi odit mollitia molestias temporibus sapiente animi quasi, accusamus aut iste impedit, assumenda praesentium!

Are you worried about having to query raw data to answer all your requests?

Lorem ipsum dolor sit amet consectetur adipisicing elit. Amet hic error voluptates ipsum libero porro quod laudantium rerum.

Do you wish you could get the job done with Postgres?

Lorem ipsum dolor sit amet consectetur adipisicing elit. Ipsam illo sint laudantium perferendis consequuntur fuga, facilis consequatur voluptas aspernatur!

SQL code for real-time events

Enable Users to Analyze Real-Time Events as They Happen

The Citus extension to PostgreSQL is good at scaling out event data pipelines. For many of our real-time analytics customers, it’s critical that events be analyzed as they happen. Because Citus parallelizes SQL over multiple nodes, Citus can provide real-time responsiveness, even with terabytes of data. Moreover, Citus can pre-aggregate the data in parallel across all servers using standard SQL commands to enable millisecond query times even with billions of events per day.

Sportradar's radar360 dashboard
Citus powers Sportradar’s radar360 analytics dashboard shown above. Read the case study

Deliver Sub-Second Responses to Your Customer Facing Dashboards

Traditional data warehouses are good at supporting teams of in-house data analysts, but not as good at supporting thousands of customers all querying their dashboards at the same time. Because of the intelligent way Citus distributes SQL over multiple nodes, you get massive parallelism AND concurrency, with Citus coordinating hundreds or even thousands of cores for high performance data ingest and fast analytical queries. With support for advanced subqueries and complex joins on co-located tables and reference tables, you can even do advanced queries such as search and funnel analysis. So your users get the insights they need with your interactive dashboards. Citus works well for both real time dashboards and historical dashboards over long time windows.

Chartbeat dashboard
Citus powers Chartbeat’s dashboard shown above.

Get Insanely Fast Analytics Without Re-Architecting Your App

One of our customers describes Citus as insanely fast for real-time analytics (yay.) There are other benefits as well. The fact that Citus is built on Postgres means that applications which are compatible with Postgres will have a faster path to deploying on Citus (the same is true for teams with deep Postgres expertise already)—adopting Citus does not require large-scale application changes. And because Citus is an extension to Postgres (not a fork like so many others), you’ll always be on the most up-to-date version of PostgreSQL. Plus you get all the other Postgres data types and extensions, like JSONB, PostGIS, full text search, HyperLogLog. The list goes on.

Postgres icon + Citus icon

Simplify Your Database Stack with Citus

Some data pipeline solutions are really, really good at one thing. This has caused practitioners to have to stitch together multiple different database technologies to get the job done. One of the things our customers love about Citus is that Citus is multipurpose: you can combine powerful SQL queries with fast inserts and updates, and you can combine analytics workloads with transactional systems of record—reducing the complexity and cost of your operations. All the while keeping the powerful and familiar PostgreSQL expressiveness and features in your toolchest.

Why Citus for Real-Time Analytics Dashboards?

  1. Want to leverage Postgres reliability, rich data types, extensions, & expertise.
  2. Need to enable customers to analyze new events & new data as it happens, in real-time.
  3. Like the idea of staying current with latest Postgres (easy for us, because Citus is an extension.)
  4. The ability to do roll-ups & to pre-aggregate within the database is hugely appealing.
  5. Open source is important and do not want to be locked in to a specific vendor.
  1. Want to keep benefits of relational semantics & SQL: don’t want to give up JOINS to Cassandra.
  2. Have customer-facing dashboards with loads of concurrent users who don’t want to wait for responses.
  3. Looking for an analytics solution that parallelizes SQL & provides millisecond responses.
  4. Don’t want to have stitch together multiple different database technologies to get the job done.
  5. Like convenient set of choices with Citus: open source, on-prem software, & a cloud database.

One Great Database, Three Convenient Ways

Our Citus extension to Postgres is available as a fully-managed database as a service, as on-prem enterprise software, and as open source. One of our engineers likes to say that at Citus, we make sharding your PostgreSQL database simple. So you can focus on your application—not your database.

Being on a fully relational data model with the full indexing and querying power of Postgres was extremely valuable when it came to adding new analytics capabilities. Yet Citus also enabled us to maintain very fast response times, even with extremely complex queries.

Dan Robinson, CTO at Heap

Learn More About Citus & Real-Time Analytics Apps

Ready to See if Citus is Right for You?