Tracking execution statistics of all query statements executed by a server

Proposal:
To provide a way to track execution statistics so it can be possible to identify bad designed queries running on server.
Something similar to https://www.postgresql.org/docs/current/pgstatstatements.html.

Current behavior:
There is no way to track execution statistics of all query statements executed by a server.

Desired behavior:
A way to track execution statistics of all query statements executed by a server so it became possible to create dashboards and alarms in order to identify bad designed query statements witch can degrade the server.

Alternatives considered:
Usage of co-monitor dashboard or any statistics provided by Telegraf but information provided is not detailed enough.

Use case:
We have InfluxCloud v1 and we had our plan upgraded due to performance issues on server. Later we discovered these issues were related to bad designed queries running on server. We want a way to know the problem beforehand so we can handle it as soon as possible.

EDIT: It also helps in query optimizations... having this kind of information can help to produce periodic reports about queries impacting server so we can prioritize them for optimizations

The issue names no repository files, tests, or entry points. Start by locating the server query-execution and statistics components, then determine the scope of collecting statement-level metrics and exposing them for dashboards; done requires a documented, usable way to inspect execution statistics for all server queries.