pg_stat_user.sql

-- salva statistics de uso de tabelas
create temporary table "Abelardo Vieira Mota" as  
select * from pg_catalog.pg_stat_user_tables;

-- SQL qualquer

-- verifica que mudanças houve
select 
n.schemaname, n.relname, 
t.seq_scan - n.seq_scan as seq_scan, 
t.idx_scan - n.idx_scan as idx_scan, 
t.n_tup_ins - n.n_tup_ins as tup_ins, 
t.n_tup_upd - n.n_tup_upd as tup_upd, 
t.n_tup_del - n.n_tup_del as tup_del
from pg_catalog.pg_stat_user_tables t 
inner join "Abelardo Vieira Mota" n on n.relid = t.relid
	and (n.seq_scan, n.idx_scan, n.n_tup_ins, n.n_tup_upd, n.n_tup_del) <>
		(t.seq_scan, t.idx_scan, t.n_tup_ins, t.n_tup_upd, t.n_tup_del);