[HBASE-4542] add filter info to slow query logging

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.89.20100924
• Fix Version/s: 0.94.0, 0.95.0
• Hadoop Flags: Reviewed
• Assignee: Madhuwanti Vaidya
• Reporter: Kannan Muthukkaruppan
• Created: 05/Oct/11 18:14
• Updated: 26/Feb/13 08:12
• Resolved: 21/Mar/12 19:03

Description

Slow query log doesn't report filters in effect.

For example:

(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}

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.