GBase8s数据库如何监控消耗当前消耗最多资源的 SQL

方法 select username,
syssesprof.sid,
lockreqs, lockwts,
deadlks,
lktouts,
logrecs,
isreads, iswrites, isrewrites, isdeletes,
iscommits, isrollbacks, longtxs,
bufreads, bufwrites,
seqscans,
pagreads, pagwrites,
total_sorts, dsksorts, max_sortdiskspace,
logspused
from syssesprof, syssessions
where syssesprof.sid = syssessions.sid
order by bufreads desc;–根据需要按照不同的资源进行排序
onstat -g ses sid
运行情况 username gbasedbt
sid 1149
lockreqs 112494
lockwts 0
deadlks 0
lktouts 0
logrecs 0
isreads 13058
iswrites 0
isrewrites 0
isdeletes 0
iscommits 0
isrollbacks 0
longtxs 0
bufreads 32985
bufwrites 0
seqscans 6
pagreads 2758
pagwrites 0
total_sorts 2
dsksorts 0
max_sortdiskspace 0
logspused 0
健康状况评估 当数据库繁忙时，一般消耗系统最主要的都集中在几个 SQL 上，我
们通过找到当前数据库上消耗最多资源的 SQL，然后进行针对性的优
化，往往能快速找到系统的瓶颈，进而解决系统的性能问题。