Design a powerful & modern SQL debug page

Draw an HTML admin page for EFIK which provide this feature.

possibility to see all requests (SQL and HTTP) without details (ex. one line per request with execution time).
One color per line type (HTTP inbound, SQL query, HTTP outbound, ...), Or one dynamic color per request id to see all consequences of a request ?
possibility to filter and see only SQL queries, or only inbound HTTP request, only outbound HTTP requests...
possibility to see without clicking on the line:
- the full URL for HTTP
- an extract of the SQL query?
- the execution time
- an icon to see if it hits the cache
highlight request with a {{PRINT}} inside
possibility to see intermediate CTE results
possibility to see execution plan (use ANALYZE JSON, use extension auto_analyze) !
Show tips to optimize requests:
- detect Index Scan without Condition in PG plan -> means Seq Scan (https://explain.depesz.com/s/6OXV)
- detect bad trigger (parallel, cost, executed each time, ...)
- detect multiple update of the same row (SQL)
- detect bad index usage (compare WHERE close with index, menu_set_date vs menu_get_date ?)
The source of data are stored in log files (parsed like a CSV by efik in a streaming mode) -> we should be able to parse multiple gigabyte of log files.
Idea: Possibility to start a global BEGIN transaction and replay a request to see the progression between each optimizations?

TODO

Find how we activate this debug mode? In debug mode, we log all request like without {{PRINT}}???