---
title: "Discussion on \"Counting Contiguous Series of Events in Postgres\" | Hashnode"
description: "Discussion on \"Counting Contiguous Series of Events in Postgres\". How to count consecutive events, logins, and streaks in PostgreSQL"
url: "https://hashnode.com/posts/counting-contiguous-series-of-events-in-postgres/61d3172dd335286be6cde701"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Counting Contiguous Series of Events in Postgres](https://thedumbtechguy.hashnode.dev/counting-contiguous-series-of-events-in-postgres?utm_source=hashnode&utm_medium=feed)

How to count consecutive events, logins, and streaks in PostgreSQL

Jan 3, 2022 · 6 min read · thedumbtechguy.hashnode.dev  
Read the article

-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#data-analysis](https://hashnode.com/tag/data-analysis)
-   [#software-engineering](https://hashnode.com/tag/software-engineering)

## Written by

[TheDumbTechGuy](https://hashnode.com/@TheDumbTechGuy)

@TheDumbTechGuy · Accra, Ghana

  
[View profile](https://hashnode.com/@TheDumbTechGuy)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.