Skip to content

Instantly share code, notes, and snippets.

@matheusoliveira

matheusoliveira/pg-show-tps.sh

Created August 22, 2014 16:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save matheusoliveira/e525231be84d741bd097 to your computer and use it in GitHub Desktop.
Save matheusoliveira/e525231be84d741bd097 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pg-show-tps.sh
while true; do ( psql -AXtqc "SELECT 'atstart='||extract(epoch from now())||E'\n'||'before='||sum(xact_commit + xact_rollback) FROM pg_stat_database;"; sleep 1; psql -AXtqc "SELECT 'atend='||extract(epoch from now())||E'\n'||'after='||sum(xact_commit + xact_rollback) FROM pg_stat_database;"; echo -e 'after-before\natend-atstart\nafter\nbefore\n(after-before) / (atend-atstart)' ) | bc -l; echo; done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment