brendangregg

#!/usr/bin/python
#
# biolatency	Summarize block device I/O latency as a histogram.
#		For Linux, uses BCC, eBPF.
#
# USAGE: biolatency [-h] [-T] [-Q] [-m] [interval] [count]
#
# Copyright (c) 2015 Brendan Gregg.
# Licensed under the Apache License, Version 2.0 (the "License")
#

mikeyk

def run_pg_fouine():
    info = host_info[env.host_string]
    db_name = info.tags.get('Name')
    sudo('perl -pi -e "s/log_min_duration_statement = .*/log_min_duration_statement = 0/" /etc/postgresql/9.*/main/postgresql.conf')
    sudo('/etc/init.d/postgresql reload')
    time.sleep(30)
    sudo('perl -pi -e "s/log_min_duration_statement = .*/log_min_duration_statement = 500/" /etc/postgresql/9.*/main/postgresql.conf')
    sudo('/etc/init.d/postgresql reload')
    run('tail -n 100000 /var/log/postgresql/postgresql-9.*-main.log > /tmp/pgfouine.txt')
    run('gzip -f /tmp/pgfouine.txt')