DATA = pg_stat_wait--1.0.sql

PG_CPPFLAGS = -DPG_STAT_WAIT_TESTS

EXTRA_CLEAN =$(pg_regress_clean_files) ./regression_output ./isolation_output

EXTRA_INSTALL=contrib/pg_stat_wait

PG_CONFIG = pg_config

include$(top_srcdir)/contrib/contrib-global.mk

check: regresscheck isolationcheck

check: regresscheck

submake-regress:

$(MAKE) -C$(top_builddir)/src/test/regress all

submake-pg_stat_wait:

$(MAKE) -C$(top_builddir)/contrib/pg_stat_wait

REGRESSCHECKS=file_tracedescriptions

REGRESSCHECKS=descriptions file_trace

regresscheck: all | submake-regress submake-pg_stat_wait

$(MKDIR_P) regression_output

--temp-instance=./tmp_check\

--load-extension=pg_stat_wait\

--temp-install=./tmp_check\

--extra-install=contrib/pg_stat_wait\

--outputdir=./regression_output\

isolationcheck: all | submake-isolation submake-pg_stat_wait

$(MKDIR_P) isolation_output

--temp-instance=./tmp_check\

--extra-install=contrib/pg_stat_wait\

--temp-config=./waits.conf\

--load-extension=pg_stat_wait\

--outputdir=./isolation_output\

CREATE EXTENSION pg_stat_wait;

SELECT * FROM pg_wait_event;

class_id | event_id | name

----------+----------+-----------------------------------

0 | 0 |

1 | 0 |

1 | 0 | BufFreelistLock

1 | 1 | ShmemIndexLock

1 | 2 | OidGenLock

1 | 3 | XidGenLock

1 | 35 | AutoFileLock

1 | 36 | ReplicationSlotAllocationLock

1 | 37 | ReplicationSlotControlLock

1 | 38 | CommitTsControlLock

1 | 39 | CommitTsLock

1 | 40 | ReplicationOriginLock

1 | 41 | UserDefinedLocks

1 | 42 | WALInsertLocks

1 | 43 | CLogBufferLocks

1 | 44 | CommitTSBufferLocks

1 | 45 | SubtransBufferLocks

1 | 46 | MultiXactOffsetBufferLocks

1 | 47 | MultiXactMemberBufferLocks

1 | 48 | BufferMgrLocks

1 | 49 | BufferLWLocks

1 | 50 | LockMgrLWLocks

1 | 51 | OldSerXidBufferLocks

1 | 52 | PredicateLWLocks

1 | 53 | ProcessLocks

1 | 54 | AsyncBufferLocks

1 | 38 | UserDefinedLocks

1 | 39 | WALInsertLocks

1 | 40 | CLogBufferLocks

1 | 41 | SubtransBufferLocks

1 | 42 | MultiXactOffsetBufferLocks

1 | 43 | MultiXactMemberBufferLocks

1 | 44 | BufferMgrLocks

1 | 45 | BufferLWLocks

1 | 46 | LockMgrLWLocks

1 | 47 | OldSerXidBufferLocks

1 | 48 | PredicateLWLocks

1 | 49 | ProcessLocks

1 | 50 | AsyncBufferLocks

2 | 0 | Relation

2 | 1 | RelationExtend

2 | 2 | Page

2 | 3 | Tuple

2 | 4 | Transaction

2 | 5 | VirtualTransaction

2 | 6 | SpeculativeToken

2 | 7 | Object

2 | 8 | Userlock

2 | 9 | Advisory

2 | 6 | Object

2 | 7 | Userlock

2 | 8 | Advisory

3 | 0 | SMGR_READ

3 | 1 | SMGR_WRITE

3 | 2 | SMGR_FSYNC

5 | 1 | WRITE

5 | 2 | SYSLOG

6 | 0 | Allocations

(80 rows)

(74 rows)

SELECT * FROM pg_wait_class;

class_id | name

SELECT * FROM pg_wait_events;

class_id | class_name | event_id | event_name

----------+-------------+----------+-----------------------------------

1 | LWLocks | 0 |

1 | LWLocks | 0 |BufFreelistLock

1 | LWLocks | 1 | ShmemIndexLock

1 | LWLocks | 2 | OidGenLock

1 | LWLocks | 3 | XidGenLock

1 | LWLocks | 35 | AutoFileLock

1 | LWLocks | 36 | ReplicationSlotAllocationLock

1 | LWLocks | 37 | ReplicationSlotControlLock

1 | LWLocks | 38 | CommitTsControlLock

1 | LWLocks | 39 | CommitTsLock

1 | LWLocks | 40 | ReplicationOriginLock

1 | LWLocks | 41 | UserDefinedLocks

1 | LWLocks | 42 | WALInsertLocks

1 | LWLocks | 43 | CLogBufferLocks

1 | LWLocks | 44 | CommitTSBufferLocks

1 | LWLocks | 45 | SubtransBufferLocks

1 | LWLocks | 46 | MultiXactOffsetBufferLocks

1 | LWLocks | 47 | MultiXactMemberBufferLocks

1 | LWLocks | 48 | BufferMgrLocks

1 | LWLocks | 49 | BufferLWLocks

1 | LWLocks | 50 | LockMgrLWLocks

1 | LWLocks | 51 | OldSerXidBufferLocks

1 | LWLocks | 52 | PredicateLWLocks

1 | LWLocks | 53 | ProcessLocks

1 | LWLocks | 54 | AsyncBufferLocks

1 | LWLocks | 38 | UserDefinedLocks

1 | LWLocks | 39 | WALInsertLocks

1 | LWLocks | 40 | CLogBufferLocks

1 | LWLocks | 41 | SubtransBufferLocks

1 | LWLocks | 42 | MultiXactOffsetBufferLocks

1 | LWLocks | 43 | MultiXactMemberBufferLocks

1 | LWLocks | 44 | BufferMgrLocks

1 | LWLocks | 45 | BufferLWLocks

1 | LWLocks | 46 | LockMgrLWLocks

1 | LWLocks | 47 | OldSerXidBufferLocks

1 | LWLocks | 48 | PredicateLWLocks

1 | LWLocks | 49 | ProcessLocks

1 | LWLocks | 50 | AsyncBufferLocks

2 | Locks | 0 | Relation

2 | Locks | 1 | RelationExtend

2 | Locks | 2 | Page

2 | Locks | 3 | Tuple

2 | Locks | 4 | Transaction

2 | Locks | 5 | VirtualTransaction

2 | Locks | 6 | SpeculativeToken

2 | Locks | 7 | Object

2 | Locks | 8 | Userlock

2 | Locks | 9 | Advisory

2 | Locks | 6 | Object

2 | Locks | 7 | Userlock

2 | Locks | 8 | Advisory

3 | Storage | 0 | SMGR_READ

3 | Storage | 1 | SMGR_WRITE

3 | Storage | 2 | SMGR_FSYNC

5 | Network | 1 | WRITE

5 | Network | 2 | SYSLOG

6 | Allocations | 0 | Allocations

(79 rows)

(74 rows)

funcctx->tuple_desc=BlessTupleDesc(tupdesc);

funcctx->user_fctx=palloc0(sizeof(WaitEventContext));

((WaitEventContext*)funcctx->user_fctx)->class_cnt=1;

MemoryContextSwitchTo(oldcontext);

}