Archive
Rustikon Talk - Rust Performance Profiling using hotpath-rs
May 17, 2026
Recently I gave a talk at the Rustikon conference about hotpath-rs - a Rust profiler focused on time, memory, CPU, and async performance debugging. I cover the project’s origin story and how it works under the hood. I also show a live instrumentation demo featuring the Zed editor.
How to Automate MEV Analysis on EVM Chains using OpenClaw MCP
April 25, 2026
Searching for MEV profit opportunities often requires tedious blockchain monitoring and analysis. In this tutorial, I’ll describe how to automate this process using the mevlog-rs MCP interface and the OpenClaw agent. We’ll use a secure SSL connection and Telegram chat for communication. We’ll also discuss the pros and cons of using OpenClaw vs. a manual MCP integration.
How to Extract long-tail MEV Profit from Uniswap
March 25, 2025
Any imbalance that makes it past the Mempool is a potential source of MEV profit. In this post, I describe the process of discovering, analyzing, and executing a long-tail MEV strategy on the Ethereum Mainnet. We will discuss Mempool monitoring, oracle backrunning, recurring Defi exploits, and more. I’ll also showcase how to use mevlog.rs CLI and web interface for finding long-tail profit opportunities.
How to Discover long-tail MEV Strategies using Revm
March 17, 2025
It’s extremely challenging for MEV newcomers to profit from popular strategies. That’s why, I’ve refined my searching approach to focus on niche and less obvious opportunities. In this blog post, I’ll showcase a Rust CLI tool that helps me query blockchain data to discover long-tail MEV. I will also describe Revm vs RPC EVM tracing techniques and their performance characteristics.
How to Send deadbeef Transactions with Alloy
December 11, 2024
0x0000000 vanity accounts are so last season. Now it’s all about custom tx prefixes. In this blog post, we will learn how to impress your Etherscan followers and fry a few CPU cores along the way.
How to use Cloudflare Workers proxy with Rust
October 2, 2024
Visits counter was a critical feature of every website just 20 years ago. In this tutorial, we will implement it with Rust Cloudflare Workers by adding persistence and dynamic behaviors to an otherwise static page. We will also discuss other practical use cases of CF workers edge proxy.
How I’ve built an unprofitable Crypto MEV Bot in Rust
September 18, 2024
MEV bots are money-printing machines. At least in theory. For the last ~year, I’ve been working on the MEV crypto bot for Ethereum EVM-compatible chains. In this blog post, I’ll describe the ins and outs of trying to get into the MEV game with a limited web3 skillset and relatively small capital.
Easy to Overlook PostgreSQL Query Performance Issues
August 27, 2024
Performance issues in the PostgreSQL layer usually start to manifest only when your app reaches a certain scale. In this blog post, I’ll discuss easy-to-miss database config tweaks and common problems that I’ve encountered in multiple projects.
How to Optimize MEV Arbitrage Smart Contract with Yul and Huff
June 11, 2024
Minimizing gas usage directly impacts the profitability of your MEV bot. In this blog post, we will start with a straightforward but nonoptimal approach for swapping two UniswapV2 pairs and gradually improve it. We will start with Solidity-level fixes and later descend into the lower layers of the Ethereum EVM with Yul and Huff assembly languages.
How to Simulate MEV Arbitrage with REVM, Anvil and Alloy
May 16, 2024
EVM simulation engine is a core component of any competitive MEV strategy. In this tutorial, I’ll describe how to use Anvil and its lower-level counterpart REVM to detect UniswapV3 MEV arbitrage opportunities. We will implement a working proof of concept using alloy-rs (a successor to ethers-rs). I’ll also discuss techniques for improving the performance and scalability of REVM-based simulations.
How learning Rust changed my Ruby Workflow
March 5, 2024
For the last few months, I’ve been working semi-full-time on my first Rust project. After the first painful weeks of struggling against The Compiler, I feel I’m now spoiled by Rust development experience. In this blog post, I’ll describe improvements to my Ruby workflow that originate from what I’ve seen in the Rust ecosystem.
Five Easy to Miss PostgreSQL Query Performance Bottlenecks
January 18, 2022
PostgreSQL query planner is full of surprises, so a common-sense approach to writing performant queries is sometimes misleading. In this blog post, I’ll describe examples of optimizing seemingly obvious queries with the help of EXPLAIN ANALYZE and Postgres metadata analysis.
PostgreSQL EXPLAIN ANALYZE for Web Developers - Indexes
April 13, 2021
Interpreting the output of SQL EXPLAIN ANALYZE might seem like dark magic at first. In this blog post, I’ll be well… explaining it based on common use cases from web applications. Read on if you’ve ever wanted to start using EXPLAIN ANALYZE for debugging slow PostgreSQL queries but did not manage to wrap your head around it. We’ll discuss how the PostgreSQL query planner decides whether to use an index.
How to Fix PostgreSQL Performance Issues with PG Extras
September 28, 2020
PostgreSQL database queries are a common performance bottleneck for web apps. Before you resort to more complex optimization techniques like caching or read replicas, you should double-check if your database engine does not need tuning and queries are not underperforming. In this blog post, I present a step by step guide on using PG Extras library to spot and resolve common PostgreSQL database performance issues.
How to Track Down and Fix Performance of Slow SQL Queries
March 12, 2018
Scaling issues are great because it means that you have traffic on your website. Before you decide that your database “doesn’t scale!” and start a rewrite to a tech stack with potentially more performance, maybe you should double check queries that your PostgreSQL database executes. Below I describe some tools and techniques you can use to track down, diagnose and optimize slow SQL query execution.