Count how many times each key has changed in your jsonb papertrail storage

count-versions.rb

# If you use the default table name
PaperTrail::Version.connection.execute(<<-SQL
select k as key, count(*)
from versions v cross join lateral
     jsonb_object_keys(v.object_changes) k
group by k order by count(*) desc;
SQL
).to_a

# If your table name is papertrail_versions
PaperTrail::Version.connection.execute(<<-SQL
select k as key, count(*)
from papertrail_versions v cross join lateral
     jsonb_object_keys(v.object_changes) k
group by k order by count(*) desc;
SQL
).to_a