Read activity stats for a particular table
select relname as "table",
seq_scan as "table scans",
idx_scan as "index lookups"
from pg_stat_user_tables
where relname = 'my_table';
select relname as "table",
seq_scan as "table scans",
idx_scan as "index lookups"
from pg_stat_user_tables
where relname = 'my_table';