Sequential Scans by database/table

select dbsname, tabname, sum(seqscans) tot_scans

from sysptprof

where seqscans > 0 
and dbsname not like "sys%" 
group by 1,2 
order by 3 desc 

The output is as follows:

dbsname              tabname                     tot_scans 

airgen_10_0          systemrelease                    2352
airgen_10_5_old      systemrelease                    1596
airgen_10_5          systemrelease                    1596
airgen_10_0          fanout_comp                      1587
airgen_10_5_old      sysusers                         1248
airgen_10_0          sysusers                         1241
airgen_10_5          sysusers                         1231
airgen_10_0          join_map                         1036
airgen_10_0          fanout_param                      958
airgen_10_0          func_call                         770
airgen_10_5          nenmoclassmap                     586
airgen_10_5_old      nenmoclassmap                     586