gistfile1.txt

select (regexp_matches(substring(query from 41), E'\"([a-z_]*)\"'))[1] as endpoint, 
sum(calls) as calls, 
sum(total_time) as total_time_ms, 
avg(mean_time) as mean_time_ms, 
avg(stddev_time) as stddev_time_ms, 
sum(shared_blks_hit) as shared_blks_hit, 
sum(shared_blks_read) as shared_blks_read, 
sum(shared_blks_dirtied) as shared_blks_dirtied 
from admin.pg_stat_statements() 
where query ilike '%_postgrest_t%' 
group by 1 order by mean_time_ms desc;