Skip to content

Commit 62b5052

Browse files
ildusAlexander Korotkov
authored andcommitted
Fix pg_stat_wait tests
1 parent 72d41d4 commit 62b5052

File tree

1 file changed

+80
-80
lines changed

1 file changed

+80
-80
lines changed

contrib/pg_stat_wait/expected/descriptions.out

Lines changed: 80 additions & 80 deletions
Original file line numberDiff line numberDiff line change
@@ -2,6 +2,7 @@ CREATE EXTENSION pg_stat_wait;
22
SELECT * FROM pg_wait_event;
33
class_id | event_id | name
44
----------+----------+-----------------------------------
5+
0 | 0 | MemAllocation
56
1 | 0 | BufFreelistLock
67
1 | 1 | ShmemIndexLock
78
1 | 2 | OidGenLock
@@ -75,96 +76,95 @@ SELECT * FROM pg_wait_event;
7576
5 | 0 | READ
7677
5 | 1 | WRITE
7778
5 | 2 | SYSLOG
78-
6 | 0 | Allocations
7979
(74 rows)
8080

8181
SELECT * FROM pg_wait_class;
82-
class_id | name
83-
----------+-------------
82+
class_id | name
83+
----------+---------
84+
0 | CPU
8485
1 | LWLocks
8586
2 | Locks
8687
3 | Storage
8788
4 | Latch
8889
5 | Network
89-
6 | Allocations
9090
(6 rows)
9191

9292
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
169169
(74 rows)
170170

0 commit comments

Comments
 (0)