EXPLAIN FORMAT=JSON is Cool! 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 FORMAT=JSON is Cool!

April 6, 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

January 9, 2016

|

Sveta Smirnova

ordering_operation: EXPLAIN FORMAT=JSON knows everything about ORDER BY processing

January 5, 2016

|

Sveta Smirnova

grouping_operation, duplicates_removal: EXPLAIN FORMAT=JSON has all details about GROUP BY

December 29, 2015

|

Sveta Smirnova

EXPLAIN FORMAT=JSON: order_by_subqueries, group_by_subqueries details on subqueries in ORDER BY and GROUP BY

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.

EXPLAIN FORMAT=JSON wrap-up

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

ordering_operation: EXPLAIN FORMAT=JSON knows everything about ORDER BY processing

grouping_operation, duplicates_removal: EXPLAIN FORMAT=JSON has all details about GROUP BY

EXPLAIN FORMAT=JSON: order_by_subqueries, group_by_subqueries details on subqueries in ORDER BY and GROUP BY

Far Enough.

Far
Enough.