WITH query_stats AS ( SELECT query_hash AS query_hash, pghero_query_stats.user AS user, array_agg(LEFT(query, $1) ORDER BY REPLACE(LEFT(query, $2), $3, $4) COLLATE "C" ASC) AS query, (SUM(total_time) / $5 / $6) AS total_minutes, (SUM(total_time) / SUM(calls)) AS average_time, SUM(calls) AS calls FROM pghero_query_stats WHERE database = $7 AND query_hash IS NOT NULL AND captured_at >= $8 GROUP BY 1, 2 ) SELECT query_hash, query_stats.user, query[$9] AS query, query[array_length(query, $10)] AS explainable_query, total_minutes, average_time, calls, total_minutes * $11 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT $12 /*pghero*/
|
Approx. Time
Origin
|
|
|---|---|
| pghero | 100% |
Total Time ms
Loading...
Average Time ms
Loading...
Calls
Loading...
Tables
| Name | Rows | Indexes |
|---|---|---|
| pghero_query_stats | 157,281 |
|