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.
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.