Most Prometheus metrics recording durations are subject to a time-of-measurement bias, causing misleading graphs that can derail investigations. See how an open-source Tracer can help solve this problem.

This post covers the implementation of pgreplay-go, a tool to realistically simulate captured Postgres traffic. I'll explain why existing tools didn't fit and explain some challenges in the implementation, focusing on what I learned personally from the process.

Diving into the Postgres query planner to understand its decisions- and occasionally- its mistakes. Explore a query plan that went wrong, discovering the statistics that informed the bad decision.

R. Chatley and L. Jones, "Diggit: Automated code review via software repository mining," 2018 IEEE 25th International Conference on Software Analysis, Evolution and Reengineering (SANER), Campobasso, Italy, 2018, pp. 567-571. doi:10.1109/SANER.2018.8330261

By flagging code smells in review, diggit raises awareness of problems at a point in the development process where code can easily be changed, with an audience of devs who are immediately familiar with program context.