-
-
Save kevinburkeshyp/4f5eef58411b1c3c1160a6f6008135b8 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
2016-04-06 20:34:43.488 UTC 2016-04-06 20:34:43 UTC [14899-570572e3.3a33-1] 00000 LOG: autovacuum launcher started | |
... snip, 120k lines of logs, but no more vacuum mentions ... | |
2016-04-06 20:38:03.822 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3198] 00000 ubuntu@circle_test LOG: duration: 0.301 ms | |
2016-04-06 20:38:03.823 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3199] 00000 ubuntu@circle_test LOG: duration: 0.217 ms | |
2016-04-06 20:38:03.823 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3200] 00000 ubuntu@circle_test LOG: execute <unnamed>: SELECT "users"."id", "users"."email" FROM "users" AS "users" WHERE LOWER("users"."id") = $1 LIMIT 1 | |
2016-04-06 20:38:03.823 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3201] 00000 ubuntu@circle_test DETAIL: parameters: $1 = 'usr_e2503c0e-c851-4b8e-a838-a40e0aeb8c49' | |
2016-04-06 20:38:03.823 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3202] 00000 ubuntu@circle_test LOG: duration: 0.092 ms | |
2016-04-06 20:38:03.945 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3203] 00000 ubuntu@circle_test LOG: statement: -- clearDB: does not notify them | |
ALTER TABLE accesstokens DISABLE TRIGGER ALL; DELETE FROM accesstokens; ALTER TABLE accesstokens ENABLE TRIGGER ALL; | |
ALTER TABLE addresses DISABLE TRIGGER ALL; DELETE FROM addresses; ALTER TABLE addresses ENABLE TRIGGER ALL; | |
... snip ... | |
ALTER TABLE warehouses DISABLE TRIGGER ALL; DELETE FROM warehouses; ALTER TABLE warehouses ENABLE TRIGGER ALL; | |
ALTER SEQUENCE "arrivalestimates_autoId_seq" RESTART WITH 1; | |
2016-04-06 20:38:04.947 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3204] 00000 ubuntu@circle_test LOG: process 16877 still waiting for AccessExclusiveLock on relation 16789 of database 16387 after 1000.113 ms | |
2016-04-06 20:38:04.947 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3205] 00000 ubuntu@circle_test DETAIL: Process holding the lock: 16936. Wait queue: 16877. | |
2016-04-06 20:38:04.947 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3206] 00000 ubuntu@circle_test STATEMENT: -- clearDB: does not notify them | |
ALTER TABLE accesstokens DISABLE TRIGGER ALL; DELETE FROM accesstokens; ALTER TABLE accesstokens ENABLE TRIGGER ALL; | |
ALTER TABLE addresses DISABLE TRIGGER ALL; DELETE FROM addresses; ALTER TABLE addresses ENABLE TRIGGER ALL; | |
... snip ... | |
ALTER TABLE warehouses DISABLE TRIGGER ALL; DELETE FROM warehouses; ALTER TABLE warehouses ENABLE TRIGGER ALL; | |
ALTER SEQUENCE "arrivalestimates_autoId_seq" RESTART WITH 1; | |
2016-04-06 20:38:22.009 UTC 2016-04-06 20:37:48 UTC [16930-5705739c.4222-599] 00000 ubuntu@circle_test LOG: disconnection: session time: 0:00:33.697 user=ubuntu database=circle_test host=127.0.0.1 port=41318 | |
2016-04-06 20:38:22.009 UTC 2016-04-06 20:35:33 UTC [16878-57057315.41ee-3255] 00000 ubuntu@circle_test LOG: disconnection: session time: 0:02:48.744 user=ubuntu database=circle_test host=127.0.0.1 port=39176 | |
2016-04-06 20:38:22.010 UTC 2016-04-06 20:35:33 UTC [16880-57057315.41f0-3213] 00000 ubuntu@circle_test LOG: disconnection: session time: 0:02:48.747 user=ubuntu database=circle_test host=127.0.0.1 port=39178 | |
2016-04-06 20:38:22.012 UTC 2016-04-06 20:35:33 UTC [16874-57057315.41ea-3262] 00000 ubuntu@circle_test LOG: disconnection: session time: 0:02:48.746 user=ubuntu database=circle_test host=127.0.0.1 port=39172 | |
2016-04-06 20:38:22.013 UTC 2016-04-06 20:35:33 UTC [16879-57057315.41ef-3213] 00000 ubuntu@circle_test LOG: disconnection: session time: 0:02:48.755 user=ubuntu database=circle_test host=127.0.0.1 port=39177 | |
2016-04-06 20:38:22.014 UTC 2016-04-06 20:35:33 UTC [16873-57057315.41e9-3172] 00000 ubuntu@circle_test LOG: disconnection: session time: 0:02:48.750 user=ubuntu database=circle_test host=127.0.0.1 port=39171 | |
2016-04-06 20:38:22.014 UTC 2016-04-06 20:35:33 UTC [16876-57057315.41ec-3177] 00000 ubuntu@circle_test LOG: disconnection: session time: 0:02:48.755 user=ubuntu database=circle_test host=127.0.0.1 port=39174 | |
2016-04-06 20:38:22.016 UTC 2016-04-06 20:35:33 UTC [16875-57057315.41eb-3267] 00000 ubuntu@circle_test LOG: disconnection: session time: 0:02:48.758 user=ubuntu database=circle_test host=127.0.0.1 port=39173 | |
2016-04-06 20:38:22.019 UTC 2016-04-06 20:35:33 UTC [16872-57057315.41e8-3210] 00000 ubuntu@circle_test LOG: disconnection: session time: 0:02:48.749 user=ubuntu database=circle_test host=127.0.0.1 port=39170 | |
2016-04-06 20:38:22.020 UTC 2016-04-06 20:35:33 UTC [16871-57057315.41e7-3233] 00000 ubuntu@circle_test LOG: disconnection: session time: 0:02:48.753 user=ubuntu database=circle_test host=127.0.0.1 port=39169 | |
2016-04-06 20:38:23.141 UTC 2016-04-06 20:38:03 UTC [16936-570573ab.4228-1] 57014 ERROR: canceling autovacuum task | |
2016-04-06 20:38:23.141 UTC 2016-04-06 20:38:03 UTC [16936-570573ab.4228-2] 57014 CONTEXT: automatic vacuum of table "circle_test.public.events" | |
2016-04-06 20:38:23.141 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3207] 00000 ubuntu@circle_test LOG: process 16877 acquired AccessExclusiveLock on relation 16789 of database 16387 after 19193.981 ms | |
2016-04-06 20:38:23.141 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3208] 00000 ubuntu@circle_test STATEMENT: -- clearDB: does not notify them | |
ALTER TABLE accesstokens DISABLE TRIGGER ALL; DELETE FROM accesstokens; ALTER TABLE accesstokens ENABLE TRIGGER ALL; | |
ALTER TABLE addresses DISABLE TRIGGER ALL; DELETE FROM addresses; ALTER TABLE addresses ENABLE TRIGGER ALL; | |
... snip ... | |
ALTER TABLE warehouses DISABLE TRIGGER ALL; DELETE FROM warehouses; ALTER TABLE warehouses ENABLE TRIGGER ALL; | |
ALTER SEQUENCE "arrivalestimates_autoId_seq" RESTART WITH 1; | |
2016-04-06 20:38:23.151 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3209] 00000 ubuntu@circle_test LOG: duration: 19206.338 ms | |
2016-04-06 20:38:23.152 UTC 2016-04-06 20:35:33 UTC [16877-57057315.41ed-3210] 00000 ubuntu@circle_test LOG: disconnection: session time: 0:02:49.879 user=ubuntu database=circle_test host=127.0.0.1 port=39175 |
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
# Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory | |
# per transaction slot, plus lock space (see max_locks_per_transaction). | |
# It is not advisable to set max_prepared_transactions nonzero unless you | |
# actively intend to use prepared transactions. | |
#work_mem = 4MB # min 64kB | |
#maintenance_work_mem = 64MB # min 1MB | |
#autovacuum_work_mem = -1 # min 1MB, or -1 to use maintenance_work_mem | |
#max_stack_depth = 2MB # min 100kB | |
dynamic_shared_memory_type = posix # the default is the first option | |
# supported by the operating system: | |
# posix | |
# sysv | |
# windows | |
# mmap | |
# use none to disable dynamic shared memory | |
# - Disk - | |
#temp_file_limit = -1 # limits per-session temp file space | |
# in kB, or -1 for no limit | |
# - Kernel Resource Usage - | |
#max_files_per_process = 1000 # min 25 | |
# (change requires restart) | |
#shared_preload_libraries = '' # (change requires restart) | |
# - Cost-Based Vacuum Delay - | |
#vacuum_cost_delay = 0 # 0-100 milliseconds | |
#vacuum_cost_page_hit = 1 # 0-10000 credits | |
#vacuum_cost_page_miss = 10 # 0-10000 credits | |
#vacuum_cost_page_dirty = 20 # 0-10000 credits | |
#vacuum_cost_limit = 200 # 1-10000 credits | |
#vacuum_freeze_min_age = 50000000 | |
#vacuum_freeze_table_age = 150000000 | |
#vacuum_multixact_freeze_min_age = 5000000 | |
#vacuum_multixact_freeze_table_age = 150000000 | |
#------------------------------------------------------------------------------ | |
# AUTOVACUUM PARAMETERS | |
#------------------------------------------------------------------------------ | |
#autovacuum = on # Enable autovacuum subprocess? 'on' | |
# requires track_counts to also be on. | |
#log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions and | |
# their durations, > 0 logs only | |
# actions running at least this number | |
# of milliseconds. | |
#autovacuum_max_workers = 3 # max number of autovacuum subprocesses | |
# (change requires restart) | |
#autovacuum_naptime = 1min # time between autovacuum runs | |
#autovacuum_vacuum_threshold = 50 # min number of row updates before | |
# vacuum | |
#autovacuum_analyze_threshold = 50 # min number of row updates before | |
# analyze | |
#autovacuum_vacuum_scale_factor = 0.2 # fraction of table size before vacuum | |
#autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze | |
#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum | |
# (change requires restart) | |
#autovacuum_multixact_freeze_max_age = 400000000 # maximum multixact age | |
# before forced vacuum | |
# (change requires restart) | |
#autovacuum_vacuum_cost_delay = 20ms # default vacuum cost delay for | |
# autovacuum, in milliseconds; | |
# -1 means use vacuum_cost_delay | |
#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for | |
# autovacuum, -1 means use | |
# vacuum_cost_limit | |
# - What to Log - | |
#debug_print_parse = off | |
#debug_print_rewritten = off | |
#debug_print_plan = off | |
#debug_pretty_print = on | |
#log_checkpoints = off | |
#log_connections = off | |
log_disconnections = on | |
log_duration = on | |
#log_error_verbosity = default # terse, default, or verbose messages | |
#log_hostname = off | |
log_line_prefix = '%m %s [%p-%c-%l] %e %q%u@%d ' # special values: | |
# %a = application name | |
# %u = user name | |
# %d = database name | |
# %r = remote host and port | |
# %h = remote host | |
# %p = process ID | |
# %t = timestamp without milliseconds | |
# %m = timestamp with milliseconds | |
# %i = command tag | |
# %e = SQL state | |
# %c = session ID | |
# %l = session line number | |
# %s = session start timestamp | |
# %v = virtual transaction ID | |
# %x = transaction ID (0 if none) | |
# %q = stop here in non-session | |
# processes | |
# %% = '%' | |
# e.g. '<%u%%%d> ' | |
log_lock_waits = on # log lock waits >= deadlock_timeout | |
log_statement = 'all' # none, ddl, mod, all | |
deadlock_timeout = 1s |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment