Query Performance Benchmark — EXPLAIN ANALYZE, V8 Heap & p95 Profiler
Empirical PostgreSQL EXPLAIN ANALYZE, V8 heap allocation, wire payload & p50/p95 latency benchmark suite by Dương Phúc Khánh (khanhdp.com).
Free
Works with the AI Agents you already use
Claude Code
Cursor
Codex CLI
Muse
Dots+21 moreClaude CodeCursorCodex CLIMuseDots
Manus
Grok
Grok Bot+18 agentsAbout this skill
This skill establishes an empirical, quantitative benchmark and verification standard for database query optimizations (ORM, Prisma, raw SQL, and API endpoints).
Core Philosophy: Never claim a query or endpoint is "optimized" or "faster" based on subjective intuition or superficial patches. Every performance-related PR must provide empirical proof across 4 measurement dimensions, 3 workload scales, and Big-O mathematical complexity analysis.
B --> C["Phase 3: 4-Dimension Measurement (100 iterations)"]
subgraph Dimensions["4 Trụ Cột Đo Lường Định Lượng"] D1["1. Network Wire Payload & Row Count<br>(TCP socket bytes, transferred rows)"] D2["2. PostgreSQL Engine EXPLAIN<br>(ANALYZE, BUFFERS, shared hit/read)"] D3["3. V8 / Runtime Heap Memory Churn<br>(heapUsed differential, GC pressure)"] D4["4. Latency Percentiles<br>(p50 median, p95 tail, mean latency)"] end
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 3 days ago
- Free with an Agensi account
Requires
Node.js