Paid

[PREMIUM] PostgreSQL Autovacuum Diagnostic: 10 Queries to Know It's Running or Winning

Autovacuum running and autovacuum winning are different things.

9 hrs ago • Haider Z @ Microsoft

[PREMIUM] PostgreSQL Extended Statistics Diagnostic with 8 Queries

Last week I wrote about the VLDB paper that proved PostgreSQL’s independence assumption drives most bad plans. Here are the 8 queries I use to find…

Apr 28 • Haider Z @ Microsoft

[PREMIUM] PostgreSQL Query Plan Diagnostic with 9 Queries

When PostgreSQL Ignores Your Index and Chooses a Sequential Scan

Apr 21 • Haider Z @ Microsoft

[PREMIUM] PostgreSQL Sev-1 Prevention Checklist

Slow query checklist tells you what’s broken right now. This one tells you what will break next week before your users find out first.

Apr 10 • Haider Z @ Microsoft

Unlock Full Sev1 Database Premium Access 🚀

Hey, You’ve seen the free insights.

Apr 4 • Haider Z @ Microsoft

[PREMIUM] PostgreSQL WAL Troubleshooting: 9 Diagnostic Queries

Diagnostic Queries for WAL Pressure, Replication Slot Lag, and Archive Failures

Apr 3 • Haider Z @ Microsoft

[PREMIUM] Silent PostgreSQL Memory Killer

Technical deep-dive for PostgreSQL administrators, backend engineers, and platform teams running PostgreSQL on Linux. If you manage a database with…

Mar 31 • Haider Z @ Microsoft

[RCA] DELETE That Took Down Production for 3 Hours

A routine cleanup job. A 30-second maintenance window. And a database that refused to commit.

Mar 10 • Haider Z @ Microsoft

[Premium] PostgreSQL Query Performance Debugging: Techniques Beyond EXPLAIN ANALYZE

Methods DBAs and SREs use to catch performance problems that EXPLAIN ANALYZE alone will never show you

Mar 3 • Haider Z @ Microsoft

[PREMIUM] PostgreSQL Performance Troubleshooting Checklist

Your database is slow. Your users are angry. Here's exactly what to check and in what order.

Feb 26 • Haider Z @ Microsoft

[Premium] How Misunderstood Lock Modes Cause CPU Spikes

8 Lock Modes, 3 Sev-1 Patterns, and the Diagnostic SQL Pack to Fix Them

Feb 25

[Premium] The systemd Setting That Silently Breaks PostgreSQL Parallel Queries

The official documentation explains exactly why you're seeing "could not remove shared memory segment" warnings. Here's what it says and how to fix it.

Feb 16 • Haider Z @ Microsoft

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts