| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "'Rakesh Kumar *EXTERN*'" <rakeshkumar464(at)outlook(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Querying dead rows |
| Date: | 2017-01-09 14:24:14 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B539C4EF7@ntex2010i.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Rakesh Kumar wrote:
> Is there a way to query dead rows (that is, rows which are dead and still not cleaned up by Vacuum)
> using SQL. I am asking this just as an academical question.
Sort of.
You can use heap_page_item_attrs() from the pageinspect contrib module to get at the
data, but you will only see the binary representation.
If your question is motivated by security concerns, you cannot do this unless you
are a superuser.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2017-01-09 14:26:29 | Re: checkpoint clarifications needed |
| Previous Message | Tom DalPozzo | 2017-01-09 14:14:32 | checkpoint clarifications needed |