惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

V
V2EX - 技术
D
DataBreaches.Net
阮一峰的网络日志
阮一峰的网络日志
Recent Announcements
Recent Announcements
V
V2EX
Hugging Face - Blog
Hugging Face - Blog
T
The Exploit Database - CXSecurity.com
Simon Willison's Weblog
Simon Willison's Weblog
Cisco Talos Blog
Cisco Talos Blog
Microsoft Security Blog
Microsoft Security Blog
C
Cyber Attacks, Cyber Crime and Cyber Security
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
K
Kaspersky official blog
F
Fortinet All Blogs
GbyAI
GbyAI
Forbes - Security
Forbes - Security
The Cloudflare Blog
博客园 - 司徒正美
博客园_首页
量子位
Schneier on Security
Schneier on Security
G
GRAHAM CLULEY
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
P
Proofpoint News Feed
N
News | PayPal Newsroom
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
博客园 - 聂微东
T
Tor Project blog
V
Vulnerabilities – Threatpost
Y
Y Combinator Blog
Jina AI
Jina AI
Help Net Security
Help Net Security
T
Threat Research - Cisco Blogs
Recent Commits to openclaw:main
Recent Commits to openclaw:main
C
Cybersecurity and Infrastructure Security Agency CISA
Project Zero
Project Zero
N
News and Events Feed by Topic
I
Intezer
B
Blog
美团技术团队
C
CERT Recently Published Vulnerability Notes
NISL@THU
NISL@THU
L
LINUX DO - 最新话题
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
Blog — PlanetScale
Blog — PlanetScale
AWS News Blog
AWS News Blog
T
Tailwind CSS Blog
The Last Watchdog
The Last Watchdog
雷峰网
雷峰网
有赞技术团队
有赞技术团队

The Practical Developer

The Libuv Thread Pool Trap: Why Node.js Async APIs Stall Under Load Postgres Covering Indexes with INCLUDE: Eliminate Heap Fetches on Read-Heavy Workloads Postgres DISTINCT ON: The Fastest Way to Get the Latest Row Per Group Postgres Transaction Isolation: The Anomalies Your App Actually Faces in Production Linux TCP Tuning for Node.js Microservices: The Kernel Settings That Stop Silent Connection Drops Under Load Postgres HOT Updates and Fillfactor: Why Not All Writes Are Created Equal Database Connection Pool Leaks: Finding the Promise That Never Returns Its Seat Linux OOM Killer in Production: Why Your Node.js Containers Die Without a Stack Trace Postgres Materialized Views: Refresh Strategies That Do Not Lock Your Dashboards API Dependency Health Checks: Why /health Is Not Enough Authorization with Zanzibar Tuples: How Google Manages Permissions and How To Build the Same Check in Node.js Postgres Advisory Locks: The 20-Character Primitive That Replaces Redis for Coordination Dead Letter Queues: The Message Queue Pattern That Saves You at 2 a.m. File Descriptor Exhaustion: The Kernel Limit That Silently Drops Node.js Connections Graceful Degradation: The Pattern That Turns Total Outages into Partial Success PostgreSQL Full-Text Search: Dropping Elasticsearch for 90% of Use Cases S3 Presigned Multipart Uploads: Stop Your API Server from Being a File Upload Bottleneck MessagePack vs JSON: The Binary Serialization Switch That Cut Our Internal RPC Overhead by 40% DNS Caching in Node.js: The Silent Cause of Production Latency Spikes Reliable Cron Jobs: The Pattern That Stops Double Runs, Missed Executions, And The 2 AM Page GraphQL Query Complexity: Stop the OOM Query Before It Reaches Your Resolver Node.js Event Loop Lag: The Hidden Metric Behind Random Latency Spikes API Request Validation with Zod: The Schema That Catches Bad Input Before It Corrupts Your Database Load Shedding in Node.js: How to Reject Traffic Before You Drown Request Hedging: Cut Tail Latency In Half Without Overprovisioning Git Bisect: The Automated Binary Search That Finds Breaking Commits in Minutes Node.js Garbage Collection Tuning: Stop Letting V8 Pause Your Event Loop Node.js Server Timeouts: The Settings That Stop Slow Clients from Holding Sockets Hostage Postgres BRIN Indexes: The Time-Series Secret That Shrinks Indexes by 99% Event Sourcing with PostgreSQL: The Pragmatic 80% Solution Node.js Cluster Mode: Scaling the Event Loop Across CPU Cores Postgres Partial Indexes: Stopping Soft Deletes from Ruining Your Query Performance Request Coalescing with the Singleflight Pattern: Stop Drowning Your Database on Every Cache Miss The Bulkhead Pattern: Why One Slow Endpoint Should Not Drown Your Whole Service Node.js AsyncLocalStorage: End-to-End Request Context Without the Propagation Hell Postgres Deadlocks: Logging the Victim, Reproducing the Race, and Fixing the Lock Order Your Node.js HTTP Client Is the Bottleneck: Connection Pool Tuning That Works Optimistic Locking in Postgres: Stop Losing Data to Race Conditions Postgres Read Replicas: Stop Serving Stale Data to Your Users Cursor Pagination: Why Offset Queries Explode at Scale and How to Fix Them Node.js Worker Threads: 60 Lines That Stop a CSV Upload from Timing Out Every Other Request Reliable Webhook Delivery: Architecture for Outbound HTTP You Can Trust Request Timeouts and Deadline Propagation: Stop the Chain of Slowness Advanced Security Practices in Node.js Graceful Shutdown in Node.js: The 40 Lines That Stop 502s During Deploys Finding Node.js Memory Leaks with Heap Snapshots Idempotency Keys in 30 Lines: Stop Your Webhook From Charging Customers Twice Backpressure In Node.js: The Fix For Slow-Motion Queue Meltdowns Retries Done Right: Jitter, Budgets, and the Stampede You Did Not See Coming The Cache Stampede: Why Your "Just Add Redis" Layer Crashes Postgres at 3 a.m. Postgres SKIP LOCKED: An 80-Line Job Queue You Can Run Without Redis Stop Doing Work Nobody Wants: AbortController in Node.js, Done Right The N+1 Query Problem: We Found 23 In One Codebase And Killed Every One I Tried 5 AI Coding Tools for a Month. Here Is What I Actually Use CI/CD From Zero to Production in 30 Minutes With GitHub Actions Node.js vs Bun vs Deno: Which Runtime Should You Pick in 2025? Kubernetes Resource Requests And Limits: The Numbers That Decide If Your Cluster Is Stable The Three Pillars of Observability Are A Myth: What Actually Matters In Production pnpm Vs npm Vs yarn Vs Bun For Monorepos: Which One Earns The Migration In 2024 JSONB Indexing In Postgres: GIN Vs Expression Indexes, And When Each Is The Right Choice A Code Review Checklist That Ends The Same Three Arguments Every Sprint gRPC Vs REST In 2024: When The Switch Pays For Itself React Suspense For Data Fetching: The Pattern That Replaces Half Your Loading State Code The Five-Stage Rollout: How To Ship A Risky Change Without Holding Your Breath GitHub Actions In A Monorepo: Caching, Path Filters, And Secret Boundaries That Actually Work The Blameless Postmortem That Actually Improves Things: A Template And Six Hard-Won Rules Recursive CTEs In Postgres: How To Query A Tree Without N Round Trips Node.js Streams: When They Actually Help, And When They Just Add Complexity Playwright Vs Cypress In 2024: The Honest Comparison Of Which One Earns The Test Time React Server Components: The Mental Model That Makes The "use client" Boundary Obvious Pod Disruption Budgets: The K8s Object That Keeps Your Service Up During Cluster Maintenance Postgres LISTEN/NOTIFY: The Pub/Sub You Already Have And Are Not Using Chaos Engineering Starter Kit: The Five Drills That Don't Need Netflix-Scale Spec-Driven API Development With OpenAPI: How To Stop Drifting From Your Docs Saga Pattern vs Two-Phase Commit: Distributed Transactions Without The Lies Kubernetes Autoscaling Beyond CPU: The Custom-Metric HPA Pattern That Actually Works Postgres Partitioning For Time-Series: The Boring Setup That Saves Your Database Distributed Locks With Redis: An Honest Look At Redlock And When You Don't Need It HTTP/2 vs HTTP/3: What Actually Changes For Your App, And What Doesn't Image Optimization For The Web In 2023: srcset, AVIF, And The Lighthouse Score You Actually Want Kafka vs RabbitMQ: A Decision Tree That Doesn't Hate You UUID vs Bigint Primary Keys In Postgres: The Index Math That Decides For You Postgres Streaming Vs. Logical Replication: Which One Solves Your Actual Problem ESLint Rules That Earn Their Keep: The Twelve I Enable On Every Project Pre-Commit Hooks That Pay For Themselves: Husky, lint-staged, And The Five Rules That Stick Zero-Downtime Database Migrations: The Six-Step Pattern That Rules Them All Circuit Breakers In Node.js: 50 Lines That Stop A Failing Dependency From Taking Down Your Service Postgres VACUUM Is Not Magic: How Your Hot Table Bloats To 80GB And How To Fix It Kubernetes Liveness And Readiness Probes: The Difference That Causes Half Your Outages Rate Limiting In Production: A Token Bucket In 30 Lines Of Redis The Outbox Pattern: How To Stop Losing Events When Postgres And Kafka Disagree Load Testing With k6: The Three Scenarios That Find Real Bugs (Not Synthetic Numbers) Postgres Row-Level Security For Multi-Tenant Apps: The Pattern That Stops You From Leaking Data Rebase vs. Merge: The Team Policy That Ends The Argument Forever OpenTelemetry in Node.js: Distributed Tracing That Actually Helps During an Incident Feature Flags That Pay Rent: The 4 Flag Types And When To Delete Each ETag, Last-Modified, and the Caching Headers Most APIs Get Wrong Connection Pooling Without the Cargo Cult: pgbouncer in 100 Lines of Config JSONB Is Not a Schema: When To Reach For It in Postgres, And When To Stop Bash Strict Mode: The Three Lines That Stop Your Deploy Script From Lying To You
Flame Graphs: How To Find The Slow Function In 30 Seconds Without Profiling Theatre
The Practica · 2023-06-09 · via The Practical Developer

The team has spent three days trying to figure out why the report endpoint takes 4 seconds. They added timestamps. They added logs. They added a custom timer wrapper. The slowest thing they instrumented takes 90 ms; the other 3.9 seconds are unaccounted for. Somebody finally captures a flame graph; the bottleneck is a JSON.stringify in a middleware nobody had thought to instrument. Two-line fix. Three days of work avoided.

Flame graphs are the single best general-purpose tool for “where does the time go?” They are also the most under-used. Every developer has seen one in a blog post; few have generated one for their own code. This post is how to read a flame graph, how to capture one in Node.js (and Python, and a browser), and the four shapes that tell you what kind of bug you have.

How to read a flame graph

A flame graph is a stack of bars. The x-axis is time spent (or samples taken); the y-axis is call depth. Each bar represents a function. The bar’s width is what you care about: it shows how much time was spent in that function (and its children).

[main                                                              ]
[ handleRequest          ][ handleRequest         ][ handleRequest ]
[ middleware ][ db query ][ middleware ][ db query][ middleware ][ db ]
[ jsonStringify ]

The widest bar at any level is the place that took the most time. If a bar is wide and no children fill the width, the time is being spent in that function itself (CPU work, blocking call). If a bar is wide and its children fill the width, time is being spent in the children.

The right way to read it: start at the top. Find the widest bar. Drop down a level. Find the widest bar there. Repeat until you reach a leaf. That leaf is your bottleneck.

It is not “the tallest stack is the problem.” Height tells you call depth, not cost.

Capturing a flame graph in Node.js

Node has a built-in profiler. Run your service with --prof:

node --prof server.js
# ... hammer the slow endpoint ...
# Stop the process. A file like isolate-0xNNN-v8.log is generated.
node --prof-process isolate-0xNNN-v8.log > profile.txt

The profile.txt is human-readable but not visual. For an actual flame graph, use 0x:

npx 0x -- node server.js
# ... load the endpoint ...
# Ctrl-C
# Browser opens with an interactive flame graph.

Or clinic for a richer tooling suite:

npx clinic flame -- node server.js
npx clinic doctor -- node server.js  # diagnoses common issues

For a production service running under load, capture a profile via the V8 inspector:

node --inspect=0.0.0.0:9229 server.js
# Connect chrome://inspect, hit "Profile", run for 10s, download.
# Or:
curl http://localhost:9229/json/list | jq
# Use a tool like @observablehq/inspector or upload the cpuprofile to speedscope.app

speedscope.app is the best free flame graph viewer. Drop in a .cpuprofile, get an interactive graph.

Capturing in other runtimes

Python: py-spy is the right tool. It is non-invasive and attaches to a running process.

py-spy record -o profile.svg --duration 30 -- python app.py

Go: built-in pprof.

go tool pprof -http=:8080 http://localhost:6060/debug/pprof/profile?seconds=30

Browser JavaScript: Chrome DevTools → Performance tab → record. Then “Show flame chart.”

The general principle is the same: sample the running process at high frequency, build a stack-time graph, view in a flame visualizer.

The four shapes you’ll see

1. The flat-top. One function takes 90% of the width with no children visible. The bottleneck is in that function’s own code: a tight loop, a synchronous parse, a regex backtracking, JSON.stringify on a giant object.

[ getReport               ]
[ formatRows              ]
[ JSON.stringify          ]   ← this whole bar, no children

The function is doing CPU-intensive work. Either reduce its work (don’t stringify, stream), make it async (worker thread), or pre-compute upstream.

2. The wide-with-children. A function is wide, but its children are also wide and fill its width. The cost is in the children, not the function. Drill down.

[ handleRequest                                           ]
[ middleware ][ getUser ][ getOrders ][ render            ]
              [ db.query ][ db.query ][ render            ]
                                      [ template ][ render]

render is wide; drill into it.

3. The pile-of-narrow. Many narrow bars at the same level, summing to a lot of width. Often: many small calls to the same function, none individually expensive but repeated 10,000 times.

[ processItems                                            ]
[ pi ][ pi ][ pi ][ pi ][ pi ][ pi ][ pi ][ pi ][ pi ][...]

This is the N+1 query pattern, the loop-with-100k-iterations pattern, the “we call hashFunction 50,000 times in a request” pattern. Aggregate the operation, not the individual call.

4. The async-shaped gap. A function appears wide but with empty space underneath. The time is being spent waiting (I/O, network) rather than doing CPU work. CPU profilers often hide this; you need an event-loop or async profiler.

clinic doctor highlights event-loop blocking specifically. For pure async wait analysis, Node’s async-profiler or distributed tracing (see the OpenTelemetry post) are the right tool.

Reading a real flame graph

A common pattern: the team thought the database was slow. The flame graph showed:

[ http handler                                            ]
[ middleware ][ db.fetchOrder ][ JSON.stringify           ]
              [ pg.query     ][ JSON.stringify           ]
                              [ JSON.stringify (deeply nested) ]

The DB query was 50ms (narrow bar). JSON.stringify of the response was 800ms, because the response had a deeply nested object with circular references and 500 KB of data. The fix: a custom serializer that flattened the response to 30 KB.

The team had been adding console.time to the DB code for two days. The DB was never the problem.

How not to get fooled

Flame graphs are sampling-based. A few things to watch for:

Sample too short. A 1-second profile of a busy server might not capture the slow code path at all. Aim for at least 30 seconds under realistic load. Longer is better.

Optimization missed by V8. Node’s JIT can fold out function calls; what looks like one big bar might be five tiny ones the profiler couldn’t separate. Run with --no-turbo-inlining if you suspect this and need granular data.

Wall-clock vs CPU. Most profilers measure CPU samples, not wall time. If your slow function is await db.query(), the time spent waiting is not on the CPU and won’t show up. For wall-clock breakdown, use a tracing tool, not a flame graph.

Multi-threaded confusion. Worker threads, child processes, and goroutines may need separate profiles or merged graphs.

A workflow that works

The workflow I use when given a “this is slow” report:

  1. Reproduce the slow request locally with realistic data.
  2. Run with 0x or clinic flame.
  3. Hit the slow endpoint a few times to warm up, then capture.
  4. Open the flame graph. Find the widest top-level bar. Drop down. Find the next.
  5. Identify the leaf. Make a hypothesis. Verify with a benchmark.
  6. Fix. Re-profile. Confirm improvement.

This loop takes 20 minutes for a typical bottleneck. The “let me add some logs” version takes hours and often misses the actual cause.

Three cases where flame graphs are misleading:

  • I/O-bound code. Use distributed tracing or async profiling instead.
  • Memory issues. Use heap snapshots, not flame graphs.
  • Garbage collection pauses. Use the V8 GC traces (--trace-gc) and a memory profiler.

For the canonical “function X is using too much CPU” question, flame graphs are the answer. For other questions, use the matching tool.

The takeaway

A flame graph turns “where does the time go” from a guessing game into a five-minute investigation. Capture one, find the widest top-level bar, drop down level by level until you hit a leaf. The leaf is your bottleneck. Make one change, re-profile, confirm.

The team that adopts flame graphs as a default investigation tool stops adding console.time to random places. The next time someone says “the API is slow,” the answer is “let’s profile it,” and 30 minutes later you have a fix.


A note from Yojji

The kind of performance investigation that takes “the dashboard says p99 is up” to “we found the regression in 20 minutes and shipped a fix” (flame graphs, profilers, the muscle memory to use them) is the kind of senior engineering Yojji’s teams bring to client work.

Yojji is an international custom software development company founded in 2016, with teams across Europe, the US, and the UK. They specialize in the JavaScript ecosystem, cloud platforms, and full-cycle product engineering, including the performance work that decides whether a feature still feels good at production load.