跳到主要内容

arthas查看sql

参考文章


watch java.sql.Connection prepareStatement '{params,throwExp}' -x 3
watch java.sql.Statement executeQuery '{params,throwExp}' -x 3

watch org.apache.ibatis.mapping.BoundSql getSql '{params,returnObj,throwExp}' -x 3

  • temp

watch java.sql.Statement executeQuery '{params,returnObj,throwExp}' -n 5 -x 3
watch java.sql.Statement executeQuery '{params,returnObj,throwExp}' -x 3
watch java.sql.Statement executeQuery '{params,returnObj,throwExp}' -x 2

# 过滤某个表的sql
watch java.sql.Statement executeQuery '{params,returnObj,throwExp}' -x 2 | grep -C 5 "com_commodity_shop"

# 看到的是jpa的非本地sql
watch javax.persistence.EntityManager createQuery '{params,returnObj,throwExp}' -n 5 -x 3