​​SQL Explain Plan Visualizer by Datadog.

This is a very useful tool for analysing your SQL query performance and identifying bottlenecks. Simply call the command for your SQL database, like this:

EXPLAIN (ANALYSE, FORMAT JSON, VERBOSE, BUFFERS) [your query]

The console will then generate a detailed JSON report. Copy this report and paste it into the visualiser to explore your query’s weaknesses.

#sql #report #analyse #postgresdb #mysql