Horton

Re: WIP: new system catalog pg_wait_event

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-08-04T15:08:21Z
Lists: pgsql-hackers 
"Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com> writes:
> Now that fa88928470 generates automatically code and documentation
> related to wait events, why not exposing the wait events description
> through a system catalog relation?

I think you'd be better off making this a view over a set-returning
function.  The nearby work to allow run-time extensibility of the
set of wait events is not going to be happy with a static catalog.

			regards, tom lane

Commits

  1. doc: Improve example query related to pg_wait_events

  2. Add system view pg_wait_events