JVM SQL信息

接口

/send/api/sql

属性说明

名称

含义

注释

header

tid

租户码

appid

应用ID

srid

服务ID

sql

content

数组

bmn

事务名

uri

指标名

txid

事务id

sid

分布式事务id

sqlstr

sql语句

max

最大执行时间

min

最大执行时间

time

总执行时间

cnt

次数

时间戳

stk

堆栈

avgtime

平均执行时间

业务操作名称

busiid

业务操作ID

样例

[
{

    "content": [            

        {

            "min": 13,

            "mn": "Datastore/operation/Oracle/other",

            "sid": "1490331088218f346113",

            "max": 13,

            "cnt": 1,

            "ts": 1490331091868,

            "uri": "/ServiceDispatcherServlet/default",

            "stk": [

                "oracle.jdbc.driver.OraclePreparedStatement.executeQuery\(OraclePreparedStatement.java:3479\)",

                "nc.jdbc.framework.crossdb.CrossDBPreparedStatement.executeQuery\(CrossDBPreparedStatement.java:103\)",

                "nc.jdbc.framework.JdbcSession.executeQuery\(JdbcSession.java:299\)",

                "nc.md.common.MetaDataDAO.queryObjectByCond\(MetaDataDAO.java:76\)",

                "nc.mddb.manager.impl.TableColumnDAO.queryColumnsByTableID\(TableColumnDAO.java:79\)",

                "nc.mddb.manager.impl.DataModelPersistUtils.toTable\(DataModelPersistUtils.java:69\)",

                "nc.mddb.manager.impl.TableDAO.retrieveObjectFromRSDataMaps\(TableDAO.java:101\)",

                "nc.md.common.MetaDataDAO.queryObjectByCond\(MetaDataDAO.java:86\)",

                "nc.mddb.manager.impl.TableDAO.queryTableByID\(TableDAO.java:50\)",

                "nc.mddb.manager.cache.MDDBCachePoolProxy.getTableViewByID\(MDDBCachePoolProxy.java:112\)",

                "nc.mddb.manager.impl.DataModelQueryServiceImp.getTableByTableID\(DataModelQueryServiceImp.java:42\)",

                "nc.mddb.MDDBBaseQueryFacade.getTableByID\(MDDBBaseQueryFacade.java:31\)",

                "nc.mddb.model.impl.ForeignKey.getEndTable\(ForeignKey.java:59\)",

                "nc.mddb.model.impl.Table.initTableRelation\(Table.java:195\)",

                "nc.mddb.model.impl.Table.getForeignKeies\(Table.java:79\)",

                "nc.mddb.manager.impl.DataModelPersistUtils.toTable\(DataModelPersistUtils.java:71\)",

                "nc.mddb.manager.impl.TableDAO.retrieveObjectFromRSDataMaps\(TableDAO.java:101\)",

                "nc.md.common.MetaDataDAO.queryObjectByCond\(MetaDataDAO.java:86\)",

                "nc.mddb.manager.impl.TableDAO.queryTableByID\(TableDAO.java:50\)",

                "nc.mddb.manager.cache.MDDBCachePoolProxy.getTableViewByID\(MDDBCachePoolProxy.java:112\)",

                "Skipping 122 lines....\(:0\)",

                "org.apache.catalina.core.StandardHostValve.invoke\(StandardHostValve.java:168\)",

                "org.apache.catalina.valves.ErrorReportValve.invoke\(ErrorReportValve.java:98\)",

                "org.apache.catalina.core.StandardEngineValve.invoke\(StandardEngineValve.java:118\)",

                "org.apache.catalina.connector.CoyoteAdapter.service\(CoyoteAdapter.java:407\)",

                "org.apache.coyote.http11.AbstractHttp11Processor.process\(AbstractHttp11Processor.java:987\)",

                "org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process\(AbstractProtocol.java:539\)",

                "org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run\(JIoEndpoint.java:300\)",

                "java.util.concurrent.ThreadPoolExecutor$Worker.runTask\(ThreadPoolExecutor.java:886\)",

                "java.util.concurrent.ThreadPoolExecutor$Worker.run\(ThreadPoolExecutor.java:908\)",

                "java.lang.Thread.run\(Thread.java:619\)"

            ],

            "id": 1157529897,

            "time": 13,

            "bmn": "WebTransaction/Uri/ServiceDispatcherServlet/default",

            "txid": "1490331088218f346113",

            "sqlstr": " select \* from \( select row\_number \(\) over \( partition by id order by versiontype desc \) rn, t1.columnlength, t1.columnsequence, t1.columntype, t1.defaultvalue, t1.description, t1.displayname, t1.forlocale, t1.groupid, t1.help, t1.id, t1.isactive, t1.name, t1.nullable, t1.pkey, t1.precise, t1.resid, t1.sqldatetype, t1.tableid, t1.ts, t1.versiontype FROM md\_column t1 where tableID = ? \) a where a.rn = ? order by columnsequence"

        }

    ],

    "header": {

        "srid": "YtWELYpvZc0164342496",

        "pt": "sql",

        "appid": "ztRUFZRPDK0151963951",

        "tid": "RitGmoBwfw0151671866"

    }

}
]

PreviousJVM事务统计信息 Nextbrower

Last updated 7 years ago

[ { "content": [ { "min": 13, "mn": "Datastore/operation/Oracle/other", "sid": "1490331088218f346113", "max": 13, "cnt": 1, "ts": 1490331091868, "uri": "/ServiceDispatcherServlet/default", "stk": [ "oracle.jdbc.driver.OraclePreparedStatement.executeQuery$OraclePreparedStatement.java:3479$", "nc.jdbc.framework.crossdb.CrossDBPreparedStatement.executeQuery$CrossDBPreparedStatement.java:103$", "nc.jdbc.framework.JdbcSession.executeQuery$JdbcSession.java:299$", "nc.md.common.MetaDataDAO.queryObjectByCond$MetaDataDAO.java:76$", "nc.mddb.manager.impl.TableColumnDAO.queryColumnsByTableID$TableColumnDAO.java:79$", "nc.mddb.manager.impl.DataModelPersistUtils.toTable$DataModelPersistUtils.java:69$", "nc.mddb.manager.impl.TableDAO.retrieveObjectFromRSDataMaps$TableDAO.java:101$", "nc.md.common.MetaDataDAO.queryObjectByCond$MetaDataDAO.java:86$", "nc.mddb.manager.impl.TableDAO.queryTableByID$TableDAO.java:50$", "nc.mddb.manager.cache.MDDBCachePoolProxy.getTableViewByID$MDDBCachePoolProxy.java:112$", "nc.mddb.manager.impl.DataModelQueryServiceImp.getTableByTableID$DataModelQueryServiceImp.java:42$", "nc.mddb.MDDBBaseQueryFacade.getTableByID$MDDBBaseQueryFacade.java:31$", "nc.mddb.model.impl.ForeignKey.getEndTable$ForeignKey.java:59$", "nc.mddb.model.impl.Table.initTableRelation$Table.java:195$", "nc.mddb.model.impl.Table.getForeignKeies$Table.java:79$", "nc.mddb.manager.impl.DataModelPersistUtils.toTable$DataModelPersistUtils.java:71$", "nc.mddb.manager.impl.TableDAO.retrieveObjectFromRSDataMaps$TableDAO.java:101$", "nc.md.common.MetaDataDAO.queryObjectByCond$MetaDataDAO.java:86$", "nc.mddb.manager.impl.TableDAO.queryTableByID$TableDAO.java:50$", "nc.mddb.manager.cache.MDDBCachePoolProxy.getTableViewByID$MDDBCachePoolProxy.java:112$", "Skipping 122 lines....$:0$", "org.apache.catalina.core.StandardHostValve.invoke$StandardHostValve.java:168$", "org.apache.catalina.valves.ErrorReportValve.invoke$ErrorReportValve.java:98$", "org.apache.catalina.core.StandardEngineValve.invoke$StandardEngineValve.java:118$", "org.apache.catalina.connector.CoyoteAdapter.service$CoyoteAdapter.java:407$", "org.apache.coyote.http11.AbstractHttp11Processor.process$AbstractHttp11Processor.java:987$", "org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process$AbstractProtocol.java:539$", "org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run$JIoEndpoint.java:300$", "java.util.concurrent.ThreadPoolExecutor$Worker.runTask$ThreadPoolExecutor.java:886$", "java.util.concurrent.ThreadPoolExecutor$Worker.run$ThreadPoolExecutor.java:908$", "java.lang.Thread.run$Thread.java:619$" ], "id": 1157529897, "time": 13, "bmn": "WebTransaction/Uri/ServiceDispatcherServlet/default", "txid": "1490331088218f346113", "sqlstr": " select \* from $ select row\_number \($ over $ partition by id order by versiontype desc $ rn, t1.columnlength, t1.columnsequence, t1.columntype, t1.defaultvalue, t1.description, t1.displayname, t1.forlocale, t1.groupid, t1.help, t1.id, t1.isactive, t1.name, t1.nullable, t1.pkey, t1.precise, t1.resid, t1.sqldatetype, t1.tableid, t1.ts, t1.versiontype FROM md\_column t1 where tableID = ? \) a where a.rn = ? order by columnsequence" } ], "header": { "srid": "YtWELYpvZc0164342496", "pt": "sql", "appid": "ztRUFZRPDK0151963951", "tid": "RitGmoBwfw0151671866" } } ]