@@ -2,6 +2,7 @@ CREATE EXTENSION pg_stat_wait;
2
2
SELECT * FROM pg_wait_event;
3
3
class_id | event_id | name
4
4
----------+----------+-----------------------------------
5
+ 0 | 0 | MemAllocation
5
6
1 | 0 | BufFreelistLock
6
7
1 | 1 | ShmemIndexLock
7
8
1 | 2 | OidGenLock
@@ -75,96 +76,95 @@ SELECT * FROM pg_wait_event;
75
76
5 | 0 | READ
76
77
5 | 1 | WRITE
77
78
5 | 2 | SYSLOG
78
- 6 | 0 | Allocations
79
79
(74 rows)
80
80
81
81
SELECT * FROM pg_wait_class;
82
- class_id | name
83
- ----------+-------------
82
+ class_id | name
83
+ ----------+---------
84
+ 0 | CPU
84
85
1 | LWLocks
85
86
2 | Locks
86
87
3 | Storage
87
88
4 | Latch
88
89
5 | Network
89
- 6 | Allocations
90
90
(6 rows)
91
91
92
92
SELECT * FROM pg_wait_events;
93
- class_id | class_name | event_id | event_name
94
- ----------+------------- +----------+-----------------------------------
95
- 1 | LWLocks | 0 | BufFreelistLock
96
- 1 | LWLocks | 1 | ShmemIndexLock
97
- 1 | LWLocks | 2 | OidGenLock
98
- 1 | LWLocks | 3 | XidGenLock
99
- 1 | LWLocks | 4 | ProcArrayLock
100
- 1 | LWLocks | 5 | SInvalReadLock
101
- 1 | LWLocks | 6 | SInvalWriteLock
102
- 1 | LWLocks | 7 | WALBufMappingLock
103
- 1 | LWLocks | 8 | WALWriteLock
104
- 1 | LWLocks | 9 | ControlFileLock
105
- 1 | LWLocks | 10 | CheckpointLock
106
- 1 | LWLocks | 11 | CLogControlLock
107
- 1 | LWLocks | 12 | SubtransControlLock
108
- 1 | LWLocks | 13 | MultiXactGenLock
109
- 1 | LWLocks | 14 | MultiXactOffsetControlLock
110
- 1 | LWLocks | 15 | MultiXactMemberControlLock
111
- 1 | LWLocks | 16 | RelCacheInitLock
112
- 1 | LWLocks | 17 | CheckpointerCommLock
113
- 1 | LWLocks | 18 | TwoPhaseStateLock
114
- 1 | LWLocks | 19 | TablespaceCreateLock
115
- 1 | LWLocks | 20 | BtreeVacuumLock
116
- 1 | LWLocks | 21 | AddinShmemInitLock
117
- 1 | LWLocks | 22 | AutovacuumLock
118
- 1 | LWLocks | 23 | AutovacuumScheduleLock
119
- 1 | LWLocks | 24 | SyncScanLock
120
- 1 | LWLocks | 25 | RelationMappingLock
121
- 1 | LWLocks | 26 | AsyncCtlLock
122
- 1 | LWLocks | 27 | AsyncQueueLock
123
- 1 | LWLocks | 28 | SerializableXactHashLock
124
- 1 | LWLocks | 29 | SerializableFinishedListLock
125
- 1 | LWLocks | 30 | SerializablePredicateLockListLock
126
- 1 | LWLocks | 31 | OldSerXidLock
127
- 1 | LWLocks | 32 | SyncRepLock
128
- 1 | LWLocks | 33 | BackgroundWorkerLock
129
- 1 | LWLocks | 34 | DynamicSharedMemoryControlLock
130
- 1 | LWLocks | 35 | AutoFileLock
131
- 1 | LWLocks | 36 | ReplicationSlotAllocationLock
132
- 1 | LWLocks | 37 | ReplicationSlotControlLock
133
- 1 | LWLocks | 38 | UserDefinedLocks
134
- 1 | LWLocks | 39 | WALInsertLocks
135
- 1 | LWLocks | 40 | CLogBufferLocks
136
- 1 | LWLocks | 41 | SubtransBufferLocks
137
- 1 | LWLocks | 42 | MultiXactOffsetBufferLocks
138
- 1 | LWLocks | 43 | MultiXactMemberBufferLocks
139
- 1 | LWLocks | 44 | BufferMgrLocks
140
- 1 | LWLocks | 45 | BufferLWLocks
141
- 1 | LWLocks | 46 | LockMgrLWLocks
142
- 1 | LWLocks | 47 | OldSerXidBufferLocks
143
- 1 | LWLocks | 48 | PredicateLWLocks
144
- 1 | LWLocks | 49 | ProcessLocks
145
- 1 | LWLocks | 50 | AsyncBufferLocks
146
- 2 | Locks | 0 | Relation
147
- 2 | Locks | 1 | RelationExtend
148
- 2 | Locks | 2 | Page
149
- 2 | Locks | 3 | Tuple
150
- 2 | Locks | 4 | Transaction
151
- 2 | Locks | 5 | VirtualTransaction
152
- 2 | Locks | 6 | Object
153
- 2 | Locks | 7 | Userlock
154
- 2 | Locks | 8 | Advisory
155
- 3 | Storage | 0 | SMGR_READ
156
- 3 | Storage | 1 | SMGR_WRITE
157
- 3 | Storage | 2 | SMGR_FSYNC
158
- 3 | Storage | 3 | XLOG_READ
159
- 3 | Storage | 4 | XLOG_WRITE
160
- 3 | Storage | 5 | XLOG_FSYNC
161
- 3 | Storage | 6 | SLRU_READ
162
- 3 | Storage | 7 | SLRU_WRITE
163
- 3 | Storage | 8 | SLRU_FSYNC
164
- 4 | Latch | 0 | Latch
165
- 5 | Network | 0 | READ
166
- 5 | Network | 1 | WRITE
167
- 5 | Network | 2 | SYSLOG
168
- 6 | Allocations | 0 | Allocations
93
+ class_id | class_name | event_id | event_name
94
+ ----------+------------+----------+-----------------------------------
95
+ 0 | CPU | 0 | MemAllocation
96
+ 1 | LWLocks | 0 | BufFreelistLock
97
+ 1 | LWLocks | 1 | ShmemIndexLock
98
+ 1 | LWLocks | 2 | OidGenLock
99
+ 1 | LWLocks | 3 | XidGenLock
100
+ 1 | LWLocks | 4 | ProcArrayLock
101
+ 1 | LWLocks | 5 | SInvalReadLock
102
+ 1 | LWLocks | 6 | SInvalWriteLock
103
+ 1 | LWLocks | 7 | WALBufMappingLock
104
+ 1 | LWLocks | 8 | WALWriteLock
105
+ 1 | LWLocks | 9 | ControlFileLock
106
+ 1 | LWLocks | 10 | CheckpointLock
107
+ 1 | LWLocks | 11 | CLogControlLock
108
+ 1 | LWLocks | 12 | SubtransControlLock
109
+ 1 | LWLocks | 13 | MultiXactGenLock
110
+ 1 | LWLocks | 14 | MultiXactOffsetControlLock
111
+ 1 | LWLocks | 15 | MultiXactMemberControlLock
112
+ 1 | LWLocks | 16 | RelCacheInitLock
113
+ 1 | LWLocks | 17 | CheckpointerCommLock
114
+ 1 | LWLocks | 18 | TwoPhaseStateLock
115
+ 1 | LWLocks | 19 | TablespaceCreateLock
116
+ 1 | LWLocks | 20 | BtreeVacuumLock
117
+ 1 | LWLocks | 21 | AddinShmemInitLock
118
+ 1 | LWLocks | 22 | AutovacuumLock
119
+ 1 | LWLocks | 23 | AutovacuumScheduleLock
120
+ 1 | LWLocks | 24 | SyncScanLock
121
+ 1 | LWLocks | 25 | RelationMappingLock
122
+ 1 | LWLocks | 26 | AsyncCtlLock
123
+ 1 | LWLocks | 27 | AsyncQueueLock
124
+ 1 | LWLocks | 28 | SerializableXactHashLock
125
+ 1 | LWLocks | 29 | SerializableFinishedListLock
126
+ 1 | LWLocks | 30 | SerializablePredicateLockListLock
127
+ 1 | LWLocks | 31 | OldSerXidLock
128
+ 1 | LWLocks | 32 | SyncRepLock
129
+ 1 | LWLocks | 33 | BackgroundWorkerLock
130
+ 1 | LWLocks | 34 | DynamicSharedMemoryControlLock
131
+ 1 | LWLocks | 35 | AutoFileLock
132
+ 1 | LWLocks | 36 | ReplicationSlotAllocationLock
133
+ 1 | LWLocks | 37 | ReplicationSlotControlLock
134
+ 1 | LWLocks | 38 | UserDefinedLocks
135
+ 1 | LWLocks | 39 | WALInsertLocks
136
+ 1 | LWLocks | 40 | CLogBufferLocks
137
+ 1 | LWLocks | 41 | SubtransBufferLocks
138
+ 1 | LWLocks | 42 | MultiXactOffsetBufferLocks
139
+ 1 | LWLocks | 43 | MultiXactMemberBufferLocks
140
+ 1 | LWLocks | 44 | BufferMgrLocks
141
+ 1 | LWLocks | 45 | BufferLWLocks
142
+ 1 | LWLocks | 46 | LockMgrLWLocks
143
+ 1 | LWLocks | 47 | OldSerXidBufferLocks
144
+ 1 | LWLocks | 48 | PredicateLWLocks
145
+ 1 | LWLocks | 49 | ProcessLocks
146
+ 1 | LWLocks | 50 | AsyncBufferLocks
147
+ 2 | Locks | 0 | Relation
148
+ 2 | Locks | 1 | RelationExtend
149
+ 2 | Locks | 2 | Page
150
+ 2 | Locks | 3 | Tuple
151
+ 2 | Locks | 4 | Transaction
152
+ 2 | Locks | 5 | VirtualTransaction
153
+ 2 | Locks | 6 | Object
154
+ 2 | Locks | 7 | Userlock
155
+ 2 | Locks | 8 | Advisory
156
+ 3 | Storage | 0 | SMGR_READ
157
+ 3 | Storage | 1 | SMGR_WRITE
158
+ 3 | Storage | 2 | SMGR_FSYNC
159
+ 3 | Storage | 3 | XLOG_READ
160
+ 3 | Storage | 4 | XLOG_WRITE
161
+ 3 | Storage | 5 | XLOG_FSYNC
162
+ 3 | Storage | 6 | SLRU_READ
163
+ 3 | Storage | 7 | SLRU_WRITE
164
+ 3 | Storage | 8 | SLRU_FSYNC
165
+ 4 | Latch | 0 | Latch
166
+ 5 | Network | 0 | READ
167
+ 5 | Network | 1 | WRITE
168
+ 5 | Network | 2 | SYSLOG
169
169
(74 rows)
170
170
0 commit comments