pg_stat_statements, aggregating IN (...)

Run Settings
LanguagePlaintext
SELECT regexp_replace(query, 'IN \([^)]*\)', 'IN (...)') AS query, sum(calls) AS calls, sum(total_time) AS total_time, min(min_time) AS min_time, max(max_time) AS max_time, sum(total_time) / sum(calls) AS mean_time, |/ sum(calls * stddev_time ^ 2) / sum(calls) AS stddev_time FROM pg_stat_statements GROUP BY 1
Editor Settings
Theme
Key bindings
Full width
Lines