The author recently hosted a 45-minute technical session on analyzing Prometheus data in SQL, which was recorded and published for public access. The session covered the benefits of storing long-term metrics data, including cost management, planning capacity, identifying root causes, and viewing patterns and trends over longer time periods. The author also shared their own experience with building a custom monitoring system using open-source software, including Prometheus, Grafana, and TimescaleDB, and provided best practices for setting up retention policies, creating aggregates, and joining aggregate data with relational data to create visualizations in Grafana. Additionally, the session covered various questions from the audience, including support for PostgreSQL functions and operators, compression availability, and using Grafana's $__timeGroupAlias macro instead of TimescaleDB's time_bucket function.