SnoutData Cloud

SnoutTime

Time series, built into your Postgres. Automatic partitions, compressed history, and fresh rollups in SnoutData Cloud.

Open the dashboard Read the docs
A dashboard opened from a series table's rollups, with bar charts of the latest bucket's top hosts

Turn rollups into a dashboard in one click.

Read the docs

Your data ages. SnoutTime handles it.

  1. Write

    New data lands in regular Postgres partitions, ready for queries.

  2. Compress

    Older partitions become a compressed column store. Late writes still work.

  3. Expire

    Retention removes old partitions automatically, on your schedule.

How it works

More from every time series.

Always-current rollups

Query summaries that include the latest rows, even before the next refresh.

Read the docs

Time-aware SQL

Bucket readings, fill gaps, and calculate rates with built-in time functions.

Read the docs

Your Postgres tools

Keep your SQL, joins, drivers, and ORM. A series table is still a Postgres table.

Read the docs
See the setup SQL

Create a table, choose a time interval, and set how long to keep your data. SnoutTime handles the partitions from there.

Setup guide
metrics.sql
create extension if not exists snouttime;

create table metrics (
  ts   timestamptz not null,
  host text        not null,
  cpu  float8
);

-- one partition per day, made ahead of the data
select snouttime.create_series('metrics', 'ts',
  partition_interval => '1 day');

-- seal each day into the column store a day after it ends
select snouttime.set_sealing('metrics', interval '1 day');

-- keep 90 days; older partitions are dropped whole
select snouttime.set_retention('metrics', interval '90 days');

-- an hourly rollup per host, never stale
select snouttime.create_rollup('metrics_hourly', 'metrics',
  interval '1 hour',
  select_list => 'host, count(*) as n, max(cpu) as cpu_max',
  group_by    => 'host');

In every SnoutData Cloud project.

Available on every plan. Enable SnoutTime from the dashboard, Desktop, or SQL.

Cloud only. Local development and object-storage tiering are not available yet.

Open the dashboard About SnoutData Cloud Limits and upgrades