hidepin/es_pg_stat_statements.md

Last active July 2, 2017 12:23

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/hidepin/d2b81f123c758b8384f4fdf31bece246.js"></script>
Save hidepin/d2b81f123c758b8384f4fdf31bece246 to your computer and use it in GitHub Desktop.

Download ZIP

pg_stat_statementsをelasticsearchで解析

Raw

es_pg_stat_statements.md

psql -U postgres -c "COPY (SELECT * from pg_stat_statements) TO '/tmp/pg_stat_statements-`date +%Y%m%d%H%M`.log' WITH DELIMITER '^';"                                           
COPY 390

for i in {1..6}
do psql -U postgres -c "COPY (SELECT * from pg_stat_statements) TO '/tmp/pg_stat_statements-`date +%Y%m%d%H%M`.log' WITH DELIMITER '^';"
sleep 300
done

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment