Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@ajeetraina

ajeetraina/stats.txt

Created September 26, 2021 08:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ajeetraina/c78f1c79e126204ad9396d861f328327 to your computer and use it in GitHub Desktop.
Save ajeetraina/c78f1c79e126204ad9396d861f328327 to your computer and use it in GitHub Desktop.
Download ZIP
Stats from a five minute window
Raw
stats.txt
select
now(), -- UTC
count(1)/300 as eps -- averaged over prev 300s
from statistics.events
where approx_event_time > now() - interval'5 minute';
now | eps
-------------------------------+------
2021-05-14 05:06:28.974982+00 | 1646
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment