Guest User

Untitled

a guest
Oct 21st, 2017
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. 21:49:26.171 UTC [44861] ubuntu@myapp LOG: duration: 3063.262 ms statement: COMMIT
  2. 21:49:26.171 UTC [44890] ubuntu@myapp LOG: duration: 748.307 ms statement: COMMIT
  3. 21:49:26.171 UTC [44882] ubuntu@myapp LOG: duration: 1497.461 ms statement: COMMIT
  4. 21:49:26.171 UTC [44893] ubuntu@myapp LOG: duration: 655.063 ms statement: COMMIT
  5. 21:49:26.171 UTC [44894] ubuntu@myapp LOG: duration: 559.743 ms statement: COMMIT
  6. 21:49:26.172 UTC [44883] ubuntu@myapp LOG: duration: 1415.733 ms statement: COMMIT
  7.  
  8. AWS EC2 m4.4xlarge (16 cores, 64GB RAM)
  9. Elastic Block Store gp2 volumes (105 IOPS, burst upto 3000 IOPS)
  10.  
  11. 10/15/2017 08:28:35 PM
  12. avg-cpu: %user %nice %system %iowait %steal %idle
  13. 10.44 0.00 0.93 0.15 0.06 88.43
  14.  
  15. Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await r_await w_await svctm %util
  16. xvda 0.00 0.00 0.00 2.00 0.00 0.04 38.67 0.00 0.00 0.00 0.00 0.00 0.00
  17. xvdb 0.00 2.67 0.00 44.67 0.00 0.41 18.99 0.13 2.81 0.00 2.81 1.07 4.80
  18.  
  19. 10/15/2017 10:18:11 PM
  20.  
  21. avg-cpu: %user %nice %system %iowait %steal %idle
  22. 8.16 0.00 0.65 11.90 0.04 79.24
  23.  
  24. Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await r_await w_await svctm %util
  25. xvda 0.00 4.00 0.00 1.00 0.00 0.02 48.00 0.00 1.33 0.00 1.33 1.33 0.13
  26. xvdb 0.00 0.00 1.67 1312.00 0.01 163.50 254.90 142.56 107.64 25.60 107.75 0.76 100.00
  27.  
  28. shared_buffers = 2GB
  29. checkpoint_timeout = 30min # range 30s-1d
  30. max_wal_size = 2GB
  31. min_wal_size = 700MB
  32. checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 - 1.0
  33. #checkpoint_flush_after = 256kB # measured in pages, 0 disables
  34. #checkpoint_warning = 30s # 0 disables
Add Comment
Please, Sign In to add comment