Guest User

Untitled

a guest
Nov 23rd, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.80 KB | None | 0 0
  1. < 2017-11-23 15:15:20.037 -03 >HINT: Close open transactions soon to avoid wraparound problems.
  2. < 2017-11-23 15:15:20.048 -03 >WARNING: oldest xmin is far in the past
  3. < 2017-11-23 15:15:20.048 -03 >HINT: Close open transactions soon to avoid wraparound problems.
  4. < 2017-11-23 15:15:20.059 -03 >WARNING: oldest xmin is far in the past
  5.  
  6. < 2017-11-22 10:25:04.262 -03 >LOG: database system was shut down at 2017-11-22 10:00:04 -03
  7. < 2017-11-22 10:25:04.387 -03 >LOG: MultiXact member wraparound protections are now enabled
  8. < 2017-11-22 10:25:04.389 -03 >LOG: autovacuum launcher started
  9. < 2017-11-22 10:25:04.389 -03 >LOG: database system is ready to accept connections
  10. < 2017-11-22 10:25:15.910 -03 >WARNING: there is no transaction in progress
  11. ...
  12. < 2017-11-22 10:25:20.259 -03 >WARNING: oldest xmin is far in the past
  13. < 2017-11-22 10:25:20.259 -03 >HINT: Close open transactions soon to avoid wraparound problems.
  14.  
  15. postgres@bchlnx361:pg_log $ ps -fea | grep vacuum
  16. postgres 409 403 0 Nov22 ? 00:00:02 postgres: autovacuum launcher process
  17.  
  18. maintenance_work_mem = 2280MB
  19. autovacuum_work_mem = -1
  20. autovacuum = on
  21. log_autovacuum_min_duration = 0
  22. autovacuum_max_workers = 2
  23. autovacuum_naptime = 60
  24. autovacuum_vacuum_threshold = 5000
  25. autovacuum_analyze_threshold = 50000
  26. autovacuum_vacuum_scale_factor = 0.01
  27. autovacuum_analyze_scale_factor = 0.05
  28. autovacuum_freeze_max_age = 1000000000
  29. autovacuum_multixact_freeze_max_age = 400000000
  30. autovacuum_vacuum_cost_delay = 20ms
  31. autovacuum_vacuum_cost_limit = -1
  32.  
  33. zabbix_db=# select tuple_count, dead_tuple_count from pgstattuple('public.triggers');
  34. tuple_count | dead_tuple_count
  35. -------------+------------------
  36. 73657 | 5161183
  37. (1 row)
Add Comment
Please, Sign In to add comment