Redis SLOWLOG pretty printer with formatted timestamps

redis-slowlog-pretty-printer.py

# 1. Requirements:
# python3.6, redis-py

# 2. Run instructions:
# python redis-slowlog-pretty-printer.py <redis endpoint> <port> <# logs to get>
# eg. python redis-slowlog-pretty-printer.py localhost 6379 10

# 3. Sample output:
# <local date/time> [ <execution time> ]: <command>
# 2017-06-22 00:00:00  [ 10.0 s ]:  b'keys *rk54jhk345hnmmlk4lk*'

import redis
import datetime
import sys

pool = redis.ConnectionPool(host=sys.argv[1], port=sys.argv[2], db=0)

r = redis.Redis(connection_pool=pool)

slowlog = r.slowlog_get(sys.argv[3])

for slowlog_entry in slowlog:

    timestamp = datetime.datetime.fromtimestamp(int(slowlog_entry['start_time']))
    duration = round(int(slowlog_entry['duration']) / 1000 / 1000, 0)
    command = slowlog_entry['command']
    
    print(timestamp.strftime('%Y-%m-%d %H:%M:%S'), ' [', duration, 's', ']: ', command)