Re: Querying dead rows

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Rakesh Kumar <rakeshkumar464(at)outlook(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Querying dead rows
Date: 2016-12-23 20:45:19
Message-ID: 20161223204519.GD18360@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Rakesh Kumar (rakeshkumar464(at)outlook(dot)com) 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.

CREATE EXTENSION pageinspect;

https://www.postgresql.org/docs/9.6/static/pageinspect.html

Thanks!

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2016-12-24 15:00:54 Re: Is there a reason the "-v/verbose" switch is not printed with pg_dumpall --help
Previous Message rob stone 2016-12-23 19:21:51 Re: [OT] Postgresql and PHP