Am Dienstag, den 14.02.2017, 15:53 +0300 schrieb Alexander Korotkov: > +1 > And you could try to use pg_wait_sampling > <https://github.com/postgrespro/pg_wait_sampling> to sampling of wait > events.
I've tried this with your example from your blog post[1] and got this: (pgbench scale 1000) pgbench -Mprepared -S -n -c 100 -j 100 -T 300 -P2 pgbench2 SELECT-only: SELECT * FROM profile_log ; ts | event_type | event | count ----------------------------+---------------+---------------+------- 2017-02-21 15:21:52.45719 | LWLockNamed | ProcArrayLock | 8 2017-02-21 15:22:11.19594 | LWLockTranche | lock_manager | 1 2017-02-21 15:22:11.19594 | LWLockNamed | ProcArrayLock | 24 2017-02-21 15:22:31.220803 | LWLockNamed | ProcArrayLock | 1 2017-02-21 15:23:01.255969 | LWLockNamed | ProcArrayLock | 1 2017-02-21 15:23:11.272254 | LWLockNamed | ProcArrayLock | 2 2017-02-21 15:23:41.313069 | LWLockNamed | ProcArrayLock | 1 2017-02-21 15:24:31.37512 | LWLockNamed | ProcArrayLock | 19 2017-02-21 15:24:41.386974 | LWLockNamed | ProcArrayLock | 1 2017-02-21 15:26:41.530399 | LWLockNamed | ProcArrayLock | 1 (10 rows) writes pgbench runs have far more events logged, see the attached text file. Maybe this is of interest... [1] http://akorotkov.github.io/blog/2016/03/25/wait_monitoring_9_6/
ts | event_type | event | count ----------------------------+---------------+----------------------+------- 2017-02-21 15:45:18.875842 | Lock | tuple | 18 2017-02-21 15:45:18.875842 | LWLockTranche | lock_manager | 35 2017-02-21 15:45:18.875842 | LWLockTranche | buffer_mapping | 1 2017-02-21 15:45:18.875842 | LWLockTranche | buffer_content | 402 2017-02-21 15:45:18.875842 | LWLockTranche | wal_insert | 1880 2017-02-21 15:45:18.875842 | Lock | transactionid | 716 2017-02-21 15:45:18.875842 | LWLockNamed | ProcArrayLock | 644 2017-02-21 15:45:18.875842 | LWLockNamed | CLogControlLock | 255 2017-02-21 15:45:18.875842 | LWLockNamed | XidGenLock | 104 2017-02-21 15:45:18.875842 | Lock | extend | 647 2017-02-21 15:45:28.889785 | Lock | tuple | 65 2017-02-21 15:45:28.889785 | LWLockTranche | lock_manager | 96 2017-02-21 15:45:28.889785 | LWLockTranche | buffer_content | 811 2017-02-21 15:45:28.889785 | LWLockTranche | wal_insert | 2542 2017-02-21 15:45:28.889785 | Lock | transactionid | 1686 2017-02-21 15:45:28.889785 | LWLockNamed | ProcArrayLock | 1194 2017-02-21 15:45:28.889785 | LWLockNamed | CLogControlLock | 1244 2017-02-21 15:45:28.889785 | LWLockNamed | XidGenLock | 401 2017-02-21 15:45:28.889785 | Lock | extend | 818 2017-02-21 15:45:38.904761 | Lock | tuple | 54 2017-02-21 15:45:38.904761 | LWLockTranche | lock_manager | 87 2017-02-21 15:45:38.904761 | LWLockTranche | buffer_content | 756 2017-02-21 15:45:38.904761 | LWLockTranche | wal_insert | 2161 2017-02-21 15:45:38.904761 | Lock | transactionid | 1624 2017-02-21 15:45:38.904761 | LWLockNamed | ProcArrayLock | 1154 2017-02-21 15:45:38.904761 | LWLockNamed | CLogControlLock | 1418 2017-02-21 15:45:38.904761 | LWLockNamed | XidGenLock | 450 2017-02-21 15:45:38.904761 | Lock | extend | 650 2017-02-21 15:45:48.917774 | Lock | tuple | 51 2017-02-21 15:45:48.917774 | LWLockTranche | lock_manager | 85 2017-02-21 15:45:48.917774 | LWLockTranche | buffer_content | 947 2017-02-21 15:45:48.917774 | LWLockTranche | wal_insert | 2050 2017-02-21 15:45:48.917774 | Lock | transactionid | 1625 2017-02-21 15:45:48.917774 | LWLockNamed | ProcArrayLock | 1094 2017-02-21 15:45:48.917774 | LWLockNamed | CLogControlLock | 2575 2017-02-21 15:45:48.917774 | LWLockNamed | XidGenLock | 372 2017-02-21 15:45:48.917774 | Lock | extend | 528 2017-02-21 15:45:58.930732 | Lock | tuple | 63 2017-02-21 15:45:58.930732 | LWLockTranche | lock_manager | 86 2017-02-21 15:45:58.930732 | LWLockTranche | buffer_content | 1026 2017-02-21 15:45:58.930732 | LWLockTranche | wal_insert | 1543 2017-02-21 15:45:58.930732 | Lock | transactionid | 1794 2017-02-21 15:45:58.930732 | LWLockNamed | ProcArrayLock | 1154 2017-02-21 15:45:58.930732 | LWLockNamed | CLogControlLock | 3850 2017-02-21 15:45:58.930732 | LWLockNamed | XidGenLock | 315 2017-02-21 15:45:58.930732 | Lock | extend | 417 2017-02-21 15:46:08.942761 | Lock | tuple | 62 2017-02-21 15:46:08.942761 | LWLockTranche | lock_manager | 102 2017-02-21 15:46:08.942761 | LWLockTranche | buffer_content | 1187 2017-02-21 15:46:08.942761 | LWLockTranche | wal_insert | 1363 2017-02-21 15:46:08.942761 | Lock | transactionid | 1739 2017-02-21 15:46:08.942761 | LWLockNamed | ProcArrayLock | 1172 2017-02-21 15:46:08.942761 | LWLockNamed | CLogControlLock | 4594 2017-02-21 15:46:08.942761 | LWLockNamed | XidGenLock | 290 2017-02-21 15:46:08.942761 | Lock | extend | 317 2017-02-21 15:46:18.959145 | Lock | tuple | 2523 2017-02-21 15:46:18.959145 | LWLockTranche | lock_manager | 68 2017-02-21 15:46:18.959145 | LWLockTranche | buffer_content | 3533 2017-02-21 15:46:18.959145 | LWLockTranche | wal_insert | 1277 2017-02-21 15:46:18.959145 | Lock | transactionid | 4988 2017-02-21 15:46:18.959145 | LWLockNamed | ProcArrayLock | 1002 2017-02-21 15:46:18.959145 | LWLockNamed | CLogControlLock | 6047 2017-02-21 15:46:18.959145 | LWLockNamed | XidGenLock | 161 2017-02-21 15:46:18.959145 | Lock | extend | 6965 2017-02-21 15:46:28.97389 | Lock | tuple | 48 2017-02-21 15:46:28.97389 | LWLockTranche | lock_manager | 85 2017-02-21 15:46:28.97389 | LWLockTranche | buffer_mapping | 2 2017-02-21 15:46:28.97389 | LWLockTranche | buffer_content | 259 2017-02-21 15:46:28.97389 | LWLockTranche | wal_insert | 1136 2017-02-21 15:46:28.97389 | Lock | transactionid | 1839 2017-02-21 15:46:28.97389 | LWLockNamed | ProcArrayLock | 1090 2017-02-21 15:46:28.97389 | LWLockNamed | CLogControlLock | 8033 2017-02-21 15:46:28.97389 | LWLockNamed | XidGenLock | 240 2017-02-21 15:46:28.97389 | Lock | extend | 383 2017-02-21 15:46:38.992836 | Lock | tuple | 54 2017-02-21 15:46:38.992836 | LWLockTranche | lock_manager | 84 2017-02-21 15:46:38.992836 | LWLockTranche | buffer_content | 189 2017-02-21 15:46:38.992836 | LWLockTranche | wal_insert | 1228 2017-02-21 15:46:38.992836 | LWLockTranche | clog | 2 2017-02-21 15:46:38.992836 | Lock | transactionid | 1786 2017-02-21 15:46:38.992836 | LWLockNamed | ProcArrayLock | 1076 2017-02-21 15:46:38.992836 | LWLockNamed | CLogControlLock | 5495 2017-02-21 15:46:38.992836 | LWLockNamed | XidGenLock | 271 2017-02-21 15:46:38.992836 | Lock | extend | 279 2017-02-21 15:46:49.004782 | Lock | tuple | 54 2017-02-21 15:46:49.004782 | LWLockTranche | lock_manager | 78 2017-02-21 15:46:49.004782 | LWLockTranche | buffer_mapping | 2 2017-02-21 15:46:49.004782 | LWLockTranche | buffer_content | 287 2017-02-21 15:46:49.004782 | LWLockTranche | wal_insert | 1083 2017-02-21 15:46:49.004782 | LWLockTranche | clog | 20 2017-02-21 15:46:49.004782 | Lock | transactionid | 1878 2017-02-21 15:46:49.004782 | LWLockNamed | ProcArrayLock | 1157 2017-02-21 15:46:49.004782 | LWLockNamed | CLogControlLock | 12148 2017-02-21 15:46:49.004782 | LWLockNamed | XidGenLock | 257 2017-02-21 15:46:49.004782 | Lock | extend | 378 2017-02-21 15:46:59.017796 | Lock | tuple | 65 2017-02-21 15:46:59.017796 | LWLockTranche | lock_manager | 72 2017-02-21 15:46:59.017796 | LWLockTranche | buffer_content | 361 2017-02-21 15:46:59.017796 | LWLockTranche | wal_insert | 1025 2017-02-21 15:46:59.017796 | LWLockTranche | clog | 24 2017-02-21 15:46:59.017796 | Lock | transactionid | 1855 2017-02-21 15:46:59.017796 | LWLockNamed | ProcArrayLock | 1070 2017-02-21 15:46:59.017796 | LWLockNamed | CLogControlLock | 14638 2017-02-21 15:46:59.017796 | LWLockNamed | XidGenLock | 259 2017-02-21 15:46:59.017796 | Lock | extend | 255 2017-02-21 15:47:09.031658 | Lock | tuple | 55 2017-02-21 15:47:09.031658 | LWLockTranche | lock_manager | 58 2017-02-21 15:47:09.031658 | LWLockTranche | buffer_content | 513 2017-02-21 15:47:09.031658 | LWLockTranche | wal_insert | 935 2017-02-21 15:47:09.031658 | LWLockTranche | clog | 50 2017-02-21 15:47:09.031658 | Lock | transactionid | 1849 2017-02-21 15:47:09.031658 | LWLockNamed | ProcArrayLock | 911 2017-02-21 15:47:09.031658 | LWLockNamed | CLogControlLock | 21200 2017-02-21 15:47:09.031658 | LWLockNamed | XidGenLock | 4056 2017-02-21 15:47:09.031658 | Lock | extend | 284 2017-02-21 15:47:19.043762 | Lock | tuple | 51 2017-02-21 15:47:19.043762 | LWLockTranche | lock_manager | 54 2017-02-21 15:47:19.043762 | LWLockTranche | buffer_mapping | 8 2017-02-21 15:47:19.043762 | LWLockTranche | buffer_content | 668 2017-02-21 15:47:19.043762 | LWLockTranche | wal_insert | 1310 2017-02-21 15:47:19.043762 | LWLockTranche | clog | 31 2017-02-21 15:47:19.043762 | Lock | transactionid | 1836 2017-02-21 15:47:19.043762 | LWLockNamed | ProcArrayLock | 1032 2017-02-21 15:47:19.043762 | LWLockNamed | CLogControlLock | 16069 2017-02-21 15:47:19.043762 | LWLockNamed | XidGenLock | 224 2017-02-21 15:47:19.043762 | Lock | extend | 233 2017-02-21 15:47:29.059835 | Lock | tuple | 51 2017-02-21 15:47:29.059835 | LWLockTranche | lock_manager | 48 2017-02-21 15:47:29.059835 | LWLockTranche | buffer_mapping | 12 2017-02-21 15:47:29.059835 | LWLockTranche | buffer_content | 736 2017-02-21 15:47:29.059835 | LWLockTranche | wal_insert | 1036 2017-02-21 15:47:29.059835 | LWLockTranche | clog | 33 2017-02-21 15:47:29.059835 | Lock | transactionid | 1964 2017-02-21 15:47:29.059835 | LWLockNamed | ProcArrayLock | 998 2017-02-21 15:47:29.059835 | LWLockNamed | CLogControlLock | 14365 2017-02-21 15:47:29.059835 | LWLockNamed | XidGenLock | 2420 2017-02-21 15:47:29.059835 | Lock | extend | 406 2017-02-21 15:47:39.071831 | Lock | tuple | 58 2017-02-21 15:47:39.071831 | LWLockTranche | lock_manager | 29 2017-02-21 15:47:39.071831 | LWLockTranche | buffer_mapping | 2 2017-02-21 15:47:39.071831 | LWLockTranche | buffer_content | 603 2017-02-21 15:47:39.071831 | LWLockTranche | wal_insert | 628 2017-02-21 15:47:39.071831 | LWLockTranche | clog | 115 2017-02-21 15:47:39.071831 | Lock | transactionid | 1993 2017-02-21 15:47:39.071831 | LWLockNamed | ProcArrayLock | 812 2017-02-21 15:47:39.071831 | LWLockNamed | CLogControlLock | 31651 2017-02-21 15:47:39.071831 | LWLockNamed | XidGenLock | 186 2017-02-21 15:47:39.071831 | Lock | extend | 216 2017-02-21 15:47:49.083763 | Lock | tuple | 69 2017-02-21 15:47:49.083763 | LWLockTranche | lock_manager | 36 2017-02-21 15:47:49.083763 | LWLockTranche | buffer_mapping | 4 2017-02-21 15:47:49.083763 | LWLockTranche | buffer_content | 678 2017-02-21 15:47:49.083763 | LWLockTranche | wal_insert | 638 2017-02-21 15:47:49.083763 | LWLockTranche | clog | 123 2017-02-21 15:47:49.083763 | Lock | transactionid | 2064 2017-02-21 15:47:49.083763 | LWLockNamed | ProcArrayLock | 916 2017-02-21 15:47:49.083763 | LWLockNamed | CLogControlLock | 33855 2017-02-21 15:47:49.083763 | LWLockNamed | XidGenLock | 123 2017-02-21 15:47:49.083763 | Lock | extend | 104 2017-02-21 15:47:59.097787 | Lock | tuple | 77 2017-02-21 15:47:59.097787 | LWLockTranche | lock_manager | 37 2017-02-21 15:47:59.097787 | LWLockTranche | buffer_content | 730 2017-02-21 15:47:59.097787 | LWLockTranche | wal_insert | 557 2017-02-21 15:47:59.097787 | LWLockTranche | clog | 133 2017-02-21 15:47:59.097787 | Lock | transactionid | 2145 2017-02-21 15:47:59.097787 | LWLockNamed | ProcArrayLock | 834 2017-02-21 15:47:59.097787 | LWLockNamed | CLogControlLock | 33983 2017-02-21 15:47:59.097787 | LWLockNamed | XidGenLock | 186 2017-02-21 15:47:59.097787 | Lock | extend | 208 2017-02-21 15:48:09.110728 | Lock | tuple | 68 2017-02-21 15:48:09.110728 | LWLockTranche | lock_manager | 28 2017-02-21 15:48:09.110728 | LWLockTranche | buffer_content | 702 2017-02-21 15:48:09.110728 | LWLockTranche | wal_insert | 486 2017-02-21 15:48:09.110728 | LWLockTranche | clog | 125 2017-02-21 15:48:09.110728 | Lock | transactionid | 2105 2017-02-21 15:48:09.110728 | LWLockNamed | ProcArrayLock | 808 2017-02-21 15:48:09.110728 | LWLockNamed | CLogControlLock | 35673 2017-02-21 15:48:09.110728 | LWLockNamed | XidGenLock | 126 2017-02-21 15:48:09.110728 | Lock | extend | 238 2017-02-21 15:48:19.12281 | Lock | tuple | 125 2017-02-21 15:48:19.12281 | LWLockTranche | lock_manager | 37 2017-02-21 15:48:19.12281 | LWLockTranche | buffer_mapping | 18 2017-02-21 15:48:19.12281 | LWLockTranche | buffer_content | 864 2017-02-21 15:48:19.12281 | LWLockTranche | wal_insert | 818 2017-02-21 15:48:19.12281 | LWLockTranche | clog | 89 2017-02-21 15:48:19.12281 | Lock | transactionid | 1960 2017-02-21 15:48:19.12281 | LWLockNamed | ProcArrayLock | 991 2017-02-21 15:48:19.12281 | LWLockNamed | CLogControlLock | 26540 2017-02-21 15:48:19.12281 | LWLockNamed | XidGenLock | 191 2017-02-21 15:48:19.12281 | Lock | extend | 1216 2017-02-21 15:48:29.134766 | Lock | tuple | 49 2017-02-21 15:48:29.134766 | LWLockTranche | lock_manager | 59 2017-02-21 15:48:29.134766 | LWLockTranche | buffer_mapping | 2 2017-02-21 15:48:29.134766 | LWLockTranche | buffer_content | 808 2017-02-21 15:48:29.134766 | LWLockTranche | wal_insert | 1030 2017-02-21 15:48:29.134766 | LWLockTranche | clog | 67 2017-02-21 15:48:29.134766 | Lock | transactionid | 1921 2017-02-21 15:48:29.134766 | LWLockNamed | ProcArrayLock | 1025 2017-02-21 15:48:29.134766 | LWLockNamed | CLogControlLock | 20350 2017-02-21 15:48:29.134766 | LWLockNamed | XidGenLock | 673 2017-02-21 15:48:29.134766 | Lock | extend | 177 2017-02-21 15:48:39.148734 | Lock | tuple | 76 2017-02-21 15:48:39.148734 | LWLockTranche | lock_manager | 85 2017-02-21 15:48:39.148734 | LWLockTranche | buffer_mapping | 2 2017-02-21 15:48:39.148734 | LWLockTranche | buffer_content | 983 2017-02-21 15:48:39.148734 | LWLockTranche | wal_insert | 660 2017-02-21 15:48:39.148734 | LWLockTranche | clog | 131 2017-02-21 15:48:39.148734 | Lock | transactionid | 2028 2017-02-21 15:48:39.148734 | LWLockNamed | ProcArrayLock | 844 2017-02-21 15:48:39.148734 | LWLockNamed | CLogControlLock | 33371 2017-02-21 15:48:39.148734 | LWLockNamed | XidGenLock | 468 2017-02-21 15:48:39.148734 | Lock | extend | 303 2017-02-21 15:48:49.160773 | Lock | tuple | 86 2017-02-21 15:48:49.160773 | LWLockTranche | lock_manager | 37 2017-02-21 15:48:49.160773 | LWLockTranche | buffer_mapping | 3 2017-02-21 15:48:49.160773 | LWLockTranche | buffer_content | 669 2017-02-21 15:48:49.160773 | LWLockTranche | wal_insert | 498 2017-02-21 15:48:49.160773 | LWLockTranche | clog | 167 2017-02-21 15:48:49.160773 | Lock | transactionid | 2139 2017-02-21 15:48:49.160773 | LWLockNamed | ProcArrayLock | 824 2017-02-21 15:48:49.160773 | LWLockNamed | CLogControlLock | 37118 2017-02-21 15:48:49.160773 | LWLockNamed | XidGenLock | 435 2017-02-21 15:48:49.160773 | Lock | extend | 122 2017-02-21 15:48:59.172795 | Lock | tuple | 81 2017-02-21 15:48:59.172795 | LWLockTranche | lock_manager | 20 2017-02-21 15:48:59.172795 | LWLockTranche | buffer_content | 765 2017-02-21 15:48:59.172795 | LWLockTranche | wal_insert | 585 2017-02-21 15:48:59.172795 | LWLockTranche | clog | 143 2017-02-21 15:48:59.172795 | Lock | transactionid | 2126 2017-02-21 15:48:59.172795 | LWLockNamed | ProcArrayLock | 797 2017-02-21 15:48:59.172795 | LWLockNamed | CLogControlLock | 36728 2017-02-21 15:48:59.172795 | LWLockNamed | XidGenLock | 655 2017-02-21 15:48:59.172795 | Lock | extend | 383 2017-02-21 15:49:09.188066 | Lock | tuple | 57 2017-02-21 15:49:09.188066 | LWLockTranche | lock_manager | 29 2017-02-21 15:49:09.188066 | LWLockTranche | buffer_mapping | 2 2017-02-21 15:49:09.188066 | LWLockTranche | buffer_content | 665 2017-02-21 15:49:09.188066 | LWLockTranche | wal_insert | 523 2017-02-21 15:49:09.188066 | LWLockTranche | clog | 133 2017-02-21 15:49:09.188066 | Lock | transactionid | 2082 2017-02-21 15:49:09.188066 | LWLockNamed | ProcArrayLock | 792 2017-02-21 15:49:09.188066 | LWLockNamed | CLogControlLock | 37796 2017-02-21 15:49:09.188066 | LWLockNamed | XidGenLock | 551 2017-02-21 15:49:09.188066 | Lock | extend | 156 2017-02-21 15:49:19.203242 | Lock | tuple | 100 2017-02-21 15:49:19.203242 | LWLockTranche | lock_manager | 42 2017-02-21 15:49:19.203242 | LWLockTranche | buffer_content | 622 2017-02-21 15:49:19.203242 | LWLockTranche | wal_insert | 672 2017-02-21 15:49:19.203242 | LWLockTranche | clog | 158 2017-02-21 15:49:19.203242 | Lock | transactionid | 2175 2017-02-21 15:49:19.203242 | LWLockNamed | ProcArrayLock | 963 2017-02-21 15:49:19.203242 | LWLockNamed | CLogControlLock | 33277 2017-02-21 15:49:19.203242 | LWLockNamed | XidGenLock | 479 2017-02-21 15:49:19.203242 | Lock | extend | 306 2017-02-21 15:49:29.217095 | Lock | tuple | 77 2017-02-21 15:49:29.217095 | LWLockTranche | lock_manager | 27 2017-02-21 15:49:29.217095 | LWLockTranche | buffer_mapping | 2 2017-02-21 15:49:29.217095 | LWLockTranche | buffer_content | 655 2017-02-21 15:49:29.217095 | LWLockTranche | wal_insert | 516 2017-02-21 15:49:29.217095 | LWLockTranche | clog | 131 2017-02-21 15:49:29.217095 | LWLockNamed | CheckpointerCommLock | 1 2017-02-21 15:49:29.217095 | Lock | transactionid | 2034 2017-02-21 15:49:29.217095 | LWLockNamed | ProcArrayLock | 907 2017-02-21 15:49:29.217095 | LWLockNamed | CLogControlLock | 34705 2017-02-21 15:49:29.217095 | LWLockNamed | XidGenLock | 555 2017-02-21 15:49:29.217095 | Lock | extend | 156 2017-02-21 15:49:39.231835 | Lock | tuple | 82 2017-02-21 15:49:39.231835 | LWLockTranche | lock_manager | 25 2017-02-21 15:49:39.231835 | LWLockTranche | buffer_mapping | 2 2017-02-21 15:49:39.231835 | LWLockTranche | buffer_content | 727 2017-02-21 15:49:39.231835 | LWLockTranche | wal_insert | 564 2017-02-21 15:49:39.231835 | LWLockTranche | clog | 169 2017-02-21 15:49:39.231835 | Lock | transactionid | 2136 2017-02-21 15:49:39.231835 | LWLockNamed | ProcArrayLock | 913 2017-02-21 15:49:39.231835 | LWLockNamed | CLogControlLock | 37974 2017-02-21 15:49:39.231835 | LWLockNamed | XidGenLock | 429 2017-02-21 15:49:39.231835 | Lock | extend | 242 2017-02-21 15:49:49.244765 | Lock | tuple | 85 2017-02-21 15:49:49.244765 | LWLockTranche | lock_manager | 46 2017-02-21 15:49:49.244765 | LWLockTranche | buffer_mapping | 4 2017-02-21 15:49:49.244765 | LWLockTranche | buffer_content | 629 2017-02-21 15:49:49.244765 | LWLockTranche | wal_insert | 645 2017-02-21 15:49:49.244765 | LWLockTranche | clog | 139 2017-02-21 15:49:49.244765 | Lock | transactionid | 2032 2017-02-21 15:49:49.244765 | LWLockNamed | ProcArrayLock | 890 2017-02-21 15:49:49.244765 | LWLockNamed | CLogControlLock | 32158 2017-02-21 15:49:49.244765 | LWLockNamed | XidGenLock | 730 2017-02-21 15:49:49.244765 | Lock | extend | 258 2017-02-21 15:49:59.258837 | Lock | tuple | 83 2017-02-21 15:49:59.258837 | LWLockTranche | lock_manager | 43 2017-02-21 15:49:59.258837 | LWLockTranche | buffer_mapping | 1 2017-02-21 15:49:59.258837 | LWLockTranche | buffer_content | 671 2017-02-21 15:49:59.258837 | LWLockTranche | wal_insert | 612 2017-02-21 15:49:59.258837 | LWLockTranche | clog | 129 2017-02-21 15:49:59.258837 | Lock | transactionid | 2044 2017-02-21 15:49:59.258837 | LWLockNamed | ProcArrayLock | 779 2017-02-21 15:49:59.258837 | LWLockNamed | CLogControlLock | 34467 2017-02-21 15:49:59.258837 | LWLockNamed | XidGenLock | 808 2017-02-21 15:49:59.258837 | Lock | extend | 285 2017-02-21 15:50:09.274761 | Lock | tuple | 71 2017-02-21 15:50:09.274761 | LWLockTranche | lock_manager | 29 2017-02-21 15:50:09.274761 | LWLockTranche | buffer_content | 700 2017-02-21 15:50:09.274761 | LWLockTranche | wal_insert | 554 2017-02-21 15:50:09.274761 | LWLockTranche | clog | 167 2017-02-21 15:50:09.274761 | Lock | transactionid | 2052 2017-02-21 15:50:09.274761 | LWLockNamed | ProcArrayLock | 820 2017-02-21 15:50:09.274761 | LWLockNamed | CLogControlLock | 35330 2017-02-21 15:50:09.274761 | LWLockNamed | XidGenLock | 496 2017-02-21 15:50:09.274761 | Lock | extend | 270 (309 rows)
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
