Citus Cloud uses a Citus Cloud cluster to power metrics fro the service. At this inside baseball post we look at how we’ve designed our data and metrics with Citus so we can provide real-time metrics to all Citus Cloud customers. Whether you’re looking to use Citus Cloud or you want to provide your own real-time analytics across events this is a great highlight of what Citus can provide.

Pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database as an extension. It uses the same syntax as regular cron, but it allows you to schedule PostgreSQL commands directly from the database. If you have the need for running jobs on a regular basis such in database rollups, vacuum, or the shard rebalancer then give pg_cron a look.

Here’s a walk through of a fairly complex query which calculates run rates and percentage growth rate over time for an ‘as-a-service’ business. It breaks the query apart step by step and leverages a number of Postgres features such as CTEs and window functions.