explain Archives

Where the open source database community meets: Use code PERCONA75 and secure your spot for Percona Live. Register

Downloads

Blog

Contact Us

Percona Blog - Tag - explain

MongoDB: Investigate Queries with explain() and Index Usage (part 2)

June 20, 2018

|

Bradley Mickel

Webinar: How to Analyze and Tune MySQL Queries for Better Performance

October 18, 2017

|

Matthew Boehm

Webinar Thursday, October 19, 2017: What You Need to Get the Most Out of Indexes – Part 2

May 20, 2016

|

Sveta Smirnova

Introduction to Troubleshooting Performance – Troubleshooting Slow Queries webinar: Q & A

February 29, 2016

|

Sveta Smirnova

EXPLAIN FORMAT=JSON knows everything about UNIONs: union_result and query_specifications

January 25, 2016

|

Sveta Smirnova

EXPLAIN FORMAT=JSON has details for subqueries in HAVING, nested selects and subqueries that update values

Far
Enough.

Said no pioneer ever.

Get Started

Open source database software from experts who stand with you in production. Forever free from lock-in and other corporate BS.

Connect

Terms of Use

|

|

|

|

MySQL, PostgreSQL, InnoDB, MariaDB, MongoDB and Kubernetes are trademarks for their respective owners.

MongoDB: Investigate Queries with explain() and Index Usage (part 2)

Webinar: How to Analyze and Tune MySQL Queries for Better Performance

Webinar Thursday, October 19, 2017: What You Need to Get the Most Out of Indexes – Part 2

Introduction to Troubleshooting Performance – Troubleshooting Slow Queries webinar: Q & A

EXPLAIN FORMAT=JSON: nested_loop makes JOIN hierarchy transparent

EXPLAIN FORMAT=JSON: cost_info knows why optimizer prefers one index to another

EXPLAIN FORMAT=JSON: buffer_result is not hidden!

EXPLAIN FORMAT=JSON knows everything about UNIONs: union_result and query_specifications

EXPLAIN FORMAT=JSON has details for subqueries in HAVING, nested selects and subqueries that update values

Far Enough.

Far
Enough.