Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit62b5052

Browse files
ildusAlexander Korotkov
authored and
Alexander Korotkov
committed
Fix pg_stat_wait tests
1 parent72d41d4 commit62b5052

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)
[8]ページ先頭
©2009-2025 Movatter.jp