Modern tools for analyzing sql queries, what are they (brands)?

Question

SQL

Good afternoon,
10 years ago I used Toad to analyze sql queries (it was in postgresql)
I strongly suspect that the tools have stepped forward since then.
I would be grateful for a list of those. Next, I myself google benchmarks, reviews, etc. I just don't know where to google.
(I googled articles on Habré, everything was some old, 5 years ago. Either these tools have reached such perfection that nothing else is needed, or it’s no longer necessary to analyze ... I also googled in bourgeoisie, but there are so many things, what .. I decided to ask here, do not blame me ...)

Answer 1

Regarding postgresql:
Analysis of a specific query - explain (analyze,buffers) plus a little knowledge of what the numbers mean. Sometimes https://explain.depesz.com/ is used to visualize numbers.
Analysis of load from requests in total - contrib pg_stat_statements plus any selections you like on the received view. For example, top queries by execution time, or which queries read data the most or which write temporary files - counters are already enough for this.
Third-party utilities won't say anything that the database itself won't say.
For other bases - see other bases. explain is probably for everyone, and for sure everyone has some kind of native metrics for queries.