[ https://issues.apache.org/jira/browse/HBASE-4542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13228038#comment-13228038 ]
Lars Hofhansl commented on HBASE-4542: -------------------------------------- Could you confirm that "Add-filter-info-to-slow-query-logging-2012-03-06_14_28_13.patch" is the patch to apply? Otherwise I'll extract the patch from svn. Thanks. > add filter info to slow query logging > ------------------------------------- > > Key: HBASE-4542 > URL: https://issues.apache.org/jira/browse/HBASE-4542 > Project: HBase > Issue Type: Improvement > Affects Versions: 0.89.20100924 > Reporter: Kannan Muthukkaruppan > Assignee: Madhuwanti Vaidya > Fix For: 0.94.0, 0.96.0 > > Attachments: > 0001-jira-HBASE-4542-Add-filter-info-to-slow-query-loggin.patch, > Add-filter-info-to-slow-query-logging-2012-03-06_14_28_13.patch, > D1263.2.patch, D1539.1.patch > > > Slow query log doesn't report filters in effect. > For example: > {code} > (operationTooSlow): \ > {"processingtimems":3468,"client":"10.138.43.206:40035","timeRange": > [0,9223372036854775807],\ > "starttimems":1317772005821,"responsesize":42411, \ > "class":"HRegionServer","table":"myTable","families":{"CF1":"ALL"]},\ > "row":"6c3b8efa132f0219b7621ed1e5c8c70b","queuetimems":0,\ > "method":"get","totalColumns":1,"maxVersions":1,"storeLimit":-1} > {code} > the above would suggest that all columns of myTable:CF1 are being requested > for the given row. But in reality there could be filters in effect (such as > ColumnPrefixFilter, ColumnRangeFilter, TimestampsFilter() etc.). We should > enhance the slow query log to capture & report this information. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira