Generating series with Postgres
Social websites usually have a feature that displays the users engagement with a site or a log of a particular activity over time.
SQL - Postgres Long running queries
Quick snippet to discover queries that have been running for over 1 minute on Postgres