Created
June 29, 2015 08:12
-
-
Save grayhemp/9725d1613ab5c3ff74ab to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| skonoplev@OSF10074:~/Projects/pgcookbook$ sudo bash bin/stat_system.sh | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Load average: 1min=0.21 5min=0.31 15min=0.32 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO CPU usage, %: user=4.25 nice=0.00 system=2.48 idle=93.23 iowait=0.02 irq=0.00 softirq=0.00 steal=0.00 guest=0.00 guest_nice=0.00 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Memory size, kB: total=15521756 used=2666064 free=9988544 buffers=321688 cached=2545460 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Swap size, kB: total=15850492 used=0 free=15850492 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Context switch, /s: value=4218 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Page count, /s: in=0 out=903 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Swap page count, /s: in=0 out=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO count, /s: partition=sda1 read=0 read_merged=0 write=16 write_merged=17 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO size, kB/s: partition=sda1 read=0 write=903 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO ticks, ms/s: partition=sda1 read=0 write=15 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO queue, ms/s: partition=sda1 active=11 weighted=15 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk space, kB: partition=sda1 path="/" total=230400164 used=22726296 available=195947176 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk space usage, %: partition=sda1 path="/" percent=11 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO count, /s: partition=sda2 read=0 read_merged=0 write=0 write_merged=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO size, kB/s: partition=sda2 read=0 write=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO ticks, ms/s: partition=sda2 read=0 write=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO queue, ms/s: partition=sda2 active=0 weighted=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO count, /s: partition=sda5 read=0 read_merged=0 write=0 write_merged=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO size, kB/s: partition=sda5 read=0 write=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO ticks, ms/s: partition=sda5 read=0 write=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Disk IO queue, ms/s: partition=sda5 active=0 weighted=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Network bytes, B/s: iface=eth0 received=0 sent=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Network packets, /s: iface=eth0 received=0 sent=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Network errors, /s: iface=eth0 received=0 sent=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Network bytes, B/s: iface=lo received=25033 sent=25033 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Network packets, /s: iface=lo received=40 sent=40 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Network errors, /s: iface=lo received=0 sent=0 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Network bytes, B/s: iface=wlan0 received=200 sent=165 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Network packets, /s: iface=wlan0 received=0 sent=1 | |
| 2015-06-29T01:11:54-0700 OSF10074 18740 stat_system.sh INFO Network errors, /s: iface=wlan0 received=0 sent=0 | |
| skonoplev@OSF10074:~/Projects/pgcookbook$ sudo -u postgres bash bin/stat_postgres.sh | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Instance responsiveness: value=true | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Databases size, B: value=86625380 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Activity by state count: active=1 disabled=0 fastpath_function_call=0 idle=0 idle_in_transaction=0 idle_in_transaction_aborted_=0 unknown=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Activity by state max age of transaction, s: active=0.00 disabled=null fastpath_function_call=null idle=null idle_in_transaction=null idle_in_transaction_aborted_=null unknown=null | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Lock waiting activity count: value=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Lock waiting activity age, s: min=null max=null | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Deadlocks count: value=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Block operations count, /s: buffer_cache_hit=4441 read=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Buffer cache hit fraction: value=1.00 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Temp files count: value=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Temp data written size, B: value=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Transaction count: commit=52 rollback=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Tuple extraction count: fetched=13526 returned=43870 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Tuple operations count: inserted=0 updated=0 deleted=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Locks by granted count: not_granted=0 granted=2 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Prepared transactions count: value=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Prepared transaction age, s: min=null max=null | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Bgwriter checkpoint count: scheduled=0 requested=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Bgwriter checkpoint time, ms: write=0 sync=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Bgwriter buffers written by method count: checkpoint=0 backend=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Bgwriter event count: maxwritten_stops=0 backend_fsyncs=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Conflict with recovery count by type: tablespace=0 lock=0 snapshot=0 bufferpin=0 deadlock=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Replication connections count: value=0 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Seq scan fraction: value=0.10 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Hot update fraction: value=null | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Dead and live tuple numer: dead=854 live=116915 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Dead tuple fraction: value=0.00 | |
| 2015-06-29T01:11:57-0700 OSF10074 19347 stat_postgres.sh INFO Vacuum and analyze counts: vacuum=0 analyze=0 autovacuum=0 autoanalyze=0 | |
| skonoplev@OSF10074:~/Projects/pgcookbook$ ls -l bin/ | |
| total 224 | |
| -rw-rw-r-- 1 skonoplev skonoplev 5494 Jun 24 12:02 archive_tables.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 4190 Apr 3 14:54 commit_schema.sh | |
| lrwxrwxrwx 1 skonoplev skonoplev 17 Mar 3 01:23 config.sh -> config.sh.example | |
| -rw-rw-r-- 1 skonoplev skonoplev 5820 Jun 26 13:31 config.sh.example | |
| -rw-rw-r-- 1 skonoplev skonoplev 1913 Jun 24 11:18 describe_pgbouncer.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 2174 Jun 23 18:26 describe_postgres.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 1761 Jun 23 18:26 describe_skytools.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 6374 Apr 17 15:50 describe_system.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 4033 Apr 8 18:29 manage_dumps.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 6161 Jun 23 18:30 manage_pitr.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 1046 Apr 8 18:36 process_until_0.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 3844 Apr 8 18:37 refresh_matviews.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 4157 Apr 7 16:26 replica_lag.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 10090 Apr 8 18:24 restore_dump.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 1377 Apr 7 17:08 ssh_tunnel.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 8078 Jun 17 12:11 stat_pgbouncer.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 6933 Jun 24 17:38 stat_postgres_buffercache.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 40056 Jun 26 12:15 stat_postgres_objects.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 18187 Jun 18 14:11 stat_postgres.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 1321 Jun 18 14:10 stat_postgres_system.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 11125 Jun 26 12:42 stat_skytools.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 11571 Jun 26 15:35 stat_statements.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 2828 Jun 26 13:41 stat_system_programs.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 15417 Jun 26 13:41 stat_system.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 2255 Jun 24 11:50 terminate_activity.sh | |
| -rw-rw-r-- 1 skonoplev skonoplev 5532 Jun 17 12:03 utils.sh |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment