NikolayS

-- based on pg_stat_statements only
with data as (
  select
    lower(regexp_replace(query, '^\W*(\w+)\W+.*$',  '\1')) word,
    count(*) cnt,
    sum(calls) calls,
    sum(total_time) total_time
  from pg_stat_statements
  --where not query ~* '^\W*set\W+' -- uncomment this to exclude `SET ...`
  group by 1