pg_stats_recovery view - Mailing list pgsql-hackers

From Jaime Casanova
Subject pg_stats_recovery view
Date
Msg-id CAJKUy5jkCT_xUOVF0Tqd_ofYSuiWjC7dFMxVB+D_wbw5HxKYJw@mail.gmail.com
Whole thread Raw
Responses Re: pg_stats_recovery view  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
Hi,

Attached is a patch thats implements a pg_stat_recovery view that
keeps counters about processed wal records. I just notice that it
still lacks documentation but i will add it during the week.

Because it tracks redo time this introduces to GetCurrentTimestamp()
calls to the redo main loop, so i add a track_recovery GUC so only the
people that wants the view has to spent time in those calls.

Probably the most controversial part of the patch will be the addition
of a new column in RmgrData that is a pointer to a new function for
*_short_desc() these functions are similar to the *_desc functions
that already exists and that is called via rm_desc but instead of
giving full details about the record being processed it just inform of
the type of the record, for example the 2 first columns will look
something like:

rmgr: XLOG
wal_record_type: xlog switch

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación

Attachment

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Our poll() based WaitLatch implementation is broken
Next
From: Magnus Hagander
Date:
Subject: Re: automating CF submissions (was xlog location arithmetic)