​​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

​​Rybbit - (★ 11.5k at GitHub) open-source and privacy-friendly alternative to Google Analytics that is 10x more intuitive.

#analyse #monitoring #analytic