Right now, the information on wait events is organized into one giant table inside https://www.postgresql.org/docs/devel/static/monitoring-stats.html#monitoring-stats-views -- the wait event type is inserted into the lefthand column of the table using moreRows="...", which is awkward to maintain and has already provoked several fixup commits after people (including me) messed it up. And indeed it seems to be slightly messed up at the moment, too; the LWLock section needs moreRows++.
Instead of continuing to repair this every time it gets broken, I propose that we break this into one table that lists all the wait_event_type values -- LWLock, Lock, BufferPin, Activity, Client, Extension, IPC, Timeout, and IO -- and then a second table for each type that has multiple wait events listing all of the wait events for that type. I also propose hoisting this out of section 28.2.3 - Viewing Statistics - and making it a new toplevel section of chapter 28. So between the current "28.3 Viewing Locks" and the current "28.4 Progress Reporting" we'd add a new section "Wait Events" and link to that from 28.2.3. That would also give us a place to include any general text that we want to have regarding wait events, apart from the tables. Thoughts? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
