Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Querying dead rows - Mailing list pgsql-general

From Stephen Frost
Subject Re: [GENERAL] Querying dead rows
Date
Msg-id 20161223204519.GD18360@tamriel.snowman.net
Whole thread Raw
In response to [GENERAL] Querying dead rows  (Rakesh Kumar <rakeshkumar464@outlook.com>)
List pgsql-general
Tree view 
* Rakesh Kumar (rakeshkumar464@outlook.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
askingthis just as an academical question. 

CREATE EXTENSION pageinspect;

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

Thanks!

Stephen
Attachment

pgsql-general by date:

Previous
From: rob stone
Date:
Subject: Re: [GENERAL] [OT] Postgresql and PHP
Next
From: Stephen Frost
Date:
Subject: Re: [GENERAL] Is there a reason the "-v/verbose" switch is notprinted with pg_dumpall --help