BestHub
Sign in
Tagged articles

EXPLAIN ANALYZE

9 articles · Page 1 of 1
MaGe Linux Operations
MaGe Linux Operations
Aug 4, 2026 · Databases

Why 70% of System Outages Stem from SQL Performance: A MySQL Index Optimization Guide

The article walks through a systematic MySQL 8.0 index‑optimization workflow—starting with diagnosing slow queries and lock waits, validating execution plans with EXPLAIN ANALYZE, safely adding or dropping indexes using online DDL, handling pagination patterns, and verifying improvements via comprehensive metrics before and after.

EXPLAIN ANALYZEMySQLOnline DDL
0 likes · 12 min read
Why 70% of System Outages Stem from SQL Performance: A MySQL Index Optimization Guide
Cloud Architecture
Cloud Architecture
Apr 16, 2026 · Databases

EXPLAIN ANALYZE: The CT Scan That Triggers a Query Performance Revolution

When a core order‑query suddenly slowed from milliseconds to seconds, the team discovered that using PostgreSQL’s EXPLAIN ANALYZE revealed hidden plan regressions, outdated statistics, and index misuse, leading to a systematic, production‑grade methodology for diagnosing and fixing query performance issues.

EXPLAIN ANALYZEPostgreSQLQuery Optimization
0 likes · 32 min read
EXPLAIN ANALYZE: The CT Scan That Triggers a Query Performance Revolution
21CTO
21CTO
Oct 7, 2025 · Databases

What’s New in PostgreSQL 18? UUID v7, Virtual Columns, and More

PostgreSQL 18, released on September 25 2025, introduces developer‑focused features such as native UUID v7 generation, virtual generated columns, enhanced RETURNING clauses, automatic BUFFERS in EXPLAIN ANALYZE, and a unified pg_get_acl() permission function, all aimed at improving everyday database development.

Database DevelopmentEXPLAIN ANALYZEPostgreSQL
0 likes · 8 min read
What’s New in PostgreSQL 18? UUID v7, Virtual Columns, and More
Aikesheng Open Source Community
Aikesheng Open Source Community
May 13, 2025 · Databases

Visualizing MySQL Execution Plans with Flame Graphs

This article explains how to use Flame Graphs to visualize MySQL execution plans, discusses the limitations of traditional EXPLAIN output, introduces the EXPLAIN ANALYZE feature in MySQL 8.0, provides sample SQL and command‑line usage, and shows how the visual tool helps quickly identify performance bottlenecks.

EXPLAIN ANALYZEMySQLSQL Performance
0 likes · 11 min read
Visualizing MySQL Execution Plans with Flame Graphs
JavaEdge
JavaEdge
Sep 15, 2024 · Databases

What’s New in MySQL 9.0? VECTOR Type, Inline FK, JSON EXPLAIN, and More

This article summarizes MySQL 9.0’s new VECTOR column type, inline and implicit foreign‑key constraints, JSON EXPLAIN ANALYZE storage, prepared event statements, performance‑schema variable tables, enhanced EXPLAIN output, LIMIT 1 subquery support, as well as deprecated and removed features with practical examples.

Deprecated featuresEXPLAIN ANALYZEInline foreign key
0 likes · 13 min read
What’s New in MySQL 9.0? VECTOR Type, Inline FK, JSON EXPLAIN, and More
ITPUB
ITPUB
Sep 19, 2019 · Databases

Why Hash Join Beats Nested Loop in MySQL 8.0 – Faster Queries & New EXPLAIN ANALYZE

MySQL 8.0 introduces Hash Join for dramatically faster large‑dataset queries, supports in‑memory and spill‑to‑disk processing, can replace Block Nested‑Loop joins, and adds EXPLAIN ANALYZE with detailed runtime statistics and tree‑style output, highlighting the platform’s rapid evolution.

Database PerformanceEXPLAIN ANALYZEHash Join
0 likes · 3 min read
Why Hash Join Beats Nested Loop in MySQL 8.0 – Faster Queries & New EXPLAIN ANALYZE