Re: View deleted records in a table

On 03/26/2016 09:08 AM, Boyan Botev wrote:
> I want to view deleted records in table from a week ago in order to
> troubleshoot a data issue. The table has not been vacuumed yet. I was

Are you sure?
In other words do you have autovacuum turned off?

> trying to use the pageinspect v1.4 extension but can't seem to convert
> the t_data to a readable record. Is there an easy way for me to get a

What is t_data?

What version of Postgres?

> SQL to produce all system columns like xmin, xmax along with the visible
> and invisible records of the table in a readable form.
>
> I was hoping to find a setting similar to what Netezza has "set
> show_deleted_records=1;" to easily turn this visibility on or off, but
> it seems that feature was shot down several years ago. As a DBA I want
> to say that a feature like this is indispensible when troubleshooting
> data problems in large tables and environments where restores may not
> always be an option.

That means keeping deleted records around for some indefinite period of
time, which means table bloat.

>
> Thanks in advance for any help,
> Boyan
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com