Skip to content

Instantly share code, notes, and snippets.

@cjbottaro

cjbottaro/gist:cc5d7d3ae4329e35d7f9

Created April 27, 2015 20:34
Show Gist options
  • Save cjbottaro/cc5d7d3ae4329e35d7f9 to your computer and use it in GitHub Desktop.
Save cjbottaro/cc5d7d3ae4329e35d7f9 to your computer and use it in GitHub Desktop.
Download ZIP
log_lock_waits output (partial)
Raw
gistfile1.txt
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:35 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 97776 still waiting for ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1000.090 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:29 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96629 still waiting for ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1000.175 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:22 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 97110 still waiting for ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1001.027 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:32 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96891 still waiting for ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1004.263 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:22 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 97169 still waiting for ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1004.772 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:34 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96469 still waiting for ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1004.809 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:23 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96740 still waiting for ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1004.800 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:22 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96508 still waiting for ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1004.806 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:22 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 98208 still waiting for ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1004.821 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:31 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96495 acquired ShareLock on transaction 777170827 after 1196.585 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 273157
[scholarship_app_development] LOG: process 96563 acquired ExclusiveLock on tuple (139,43) of relation 5444644 of database 5158717 after 1168.134 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 273157
[scholarship_app_development] LOG: process 96728 acquired ShareLock on transaction 777167461 after 1841.814 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:49 +0000' WHERE id = 45572
[scholarship_app_development] LOG: process 97242 acquired ShareLock on transaction 777167461 after 1376.933 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 45572
[scholarship_app_development] LOG: process 97264 acquired ExclusiveLock on tuple (206,21) of relation 5267373 of database 5158717 after 1349.076 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 45572
[scholarship_app_development] LOG: process 98138 acquired ExclusiveLock on tuple (206,21) of relation 5267373 of database 5158717 after 1290.910 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 45572
[scholarship_app_development] LOG: process 98163 acquired ExclusiveLock on tuple (206,21) of relation 5267373 of database 5158717 after 1176.841 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 45572
[scholarship_app_development] LOG: process 98045 acquired ExclusiveLock on tuple (206,21) of relation 5267373 of database 5158717 after 1170.255 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 45572
[scholarship_app_development] LOG: process 97498 acquired ShareLock on transaction 777172697 after 1112.231 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 117353
[scholarship_app_development] LOG: process 97665 still waiting for ShareLock on transaction 777172468 after 1000.099 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 1779
[scholarship_app_development] LOG: process 96791 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1152.752 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:35 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 97110 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1152.908 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:32 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96891 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1152.953 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:22 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96336 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1154.032 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:29 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 97169 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1154.063 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:34 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96469 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1154.103 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:23 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 97302 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1154.138 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:35 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96740 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1154.207 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:22 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96629 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1154.261 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:22 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96508 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1154.322 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:22 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 97776 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1154.383 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:29 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 98208 acquired ExclusiveLock on tuple (408,65) of relation 5436886 of database 5158717 after 1154.423 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:31 +0000' WHERE id = 455423
[scholarship_app_development] LOG: process 96927 still waiting for ShareLock on transaction 777173858 after 1000.115 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 47690
[scholarship_app_development] LOG: process 96535 still waiting for ShareLock on transaction 777172557 after 1000.117 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 56757
[scholarship_app_development] LOG: process 97665 acquired ShareLock on transaction 777172468 after 1126.948 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 1779
[scholarship_app_development] LOG: process 96535 acquired ShareLock on transaction 777172557 after 1097.734 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 56757
[scholarship_app_development] LOG: process 97996 still waiting for ShareLock on transaction 777170171 after 1000.133 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:41 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97355 still waiting for ShareLock on transaction 777170171 after 1000.101 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:46 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97502 still waiting for ShareLock on transaction 777170171 after 1000.151 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 96927 acquired ShareLock on transaction 777173858 after 1141.839 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 47690
[scholarship_app_development] LOG: process 96828 still waiting for ShareLock on transaction 777170171 after 1002.079 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:38 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97721 still waiting for ShareLock on transaction 777170171 after 1002.044 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:46 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97401 still waiting for ShareLock on transaction 777170171 after 1002.224 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:45 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97618 still waiting for ShareLock on transaction 777170171 after 1002.075 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:41 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97297 still waiting for ShareLock on transaction 777170171 after 1002.058 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:41 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97404 still waiting for ShareLock on transaction 777170171 after 1002.089 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:47 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97774 still waiting for ShareLock on transaction 777170171 after 1002.101 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:40 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97952 still waiting for ShareLock on transaction 777170171 after 1002.267 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:30 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 96904 still waiting for ShareLock on transaction 777170171 after 1002.245 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:43 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97283 still waiting for ShareLock on transaction 777170171 after 1002.219 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:38 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97408 still waiting for ShareLock on transaction 777170171 after 1002.192 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:40 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 96365 still waiting for ShareLock on transaction 777170171 after 1002.173 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97358 still waiting for ShareLock on transaction 777170171 after 1002.159 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:46 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 96978 still waiting for ShareLock on transaction 777170171 after 1002.081 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:49 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 96334 still waiting for ShareLock on transaction 777170171 after 1001.624 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97544 still waiting for ShareLock on transaction 777170171 after 1001.585 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97717 still waiting for ShareLock on transaction 777170171 after 1002.155 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97996 acquired ShareLock on transaction 777170171 after 1003.065 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:41 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97502 acquired ShareLock on transaction 777170171 after 1002.936 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97404 acquired ShareLock on transaction 777170171 after 1002.760 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:47 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 96828 acquired ShareLock on transaction 777170171 after 1002.917 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:38 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97717 acquired ShareLock on transaction 777170171 after 1002.300 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97355 acquired ShareLock on transaction 777170171 after 1008.412 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:46 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97618 acquired ShareLock on transaction 777170171 after 1009.037 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:41 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97297 acquired ShareLock on transaction 777170171 after 1009.068 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:41 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 96334 acquired ShareLock on transaction 777170171 after 1008.186 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97544 acquired ShareLock on transaction 777170171 after 1008.655 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:50 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 96978 acquired ShareLock on transaction 777170171 after 1009.243 ms
[scholarship_app_development] STATEMENT: UPDATE applications SET updated_at = '2015-04-27 20:25:49 +0000' WHERE id = 48419
[scholarship_app_development] LOG: process 97358 acquired ShareLock on transaction 777170171 after 1009.373 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment