Puzzling Postgres: a story of solving an unreproducible performance issue

Corresponding tweet for this thread:

Share link for this tweet.