On Wed, Jul 19, 2017 at 8:33 PM, Craig Ringer <craig@2ndquadrant.com> wrote:
> That's silly, so here's a patch to teach pageinspect how to decode infomasks
> to a human readable array of flag names.
>
> Example:
>
> SELECT t_infomask, t_infomask2, flags
> FROM heap_page_items(get_raw_page('test1', 0)),
> LATERAL heap_infomask_flags(t_infomask, t_infomask2, true) m(flags);
> t_infomask | t_infomask2 | flags
> ------------+-------------+----------------------------------------------------------------------------
> 2816 | 2 |
> {HEAP_XMIN_COMMITTED,HEAP_XMIN_INVALID,HEAP_XMAX_INVALID,HEAP_XMIN_FROZEN}
> (1 row)
Seems like a good idea to me.
--
Peter Geoghegan