n_live_tup smaller than the number of rows in a table

From: Lisa Guo <lguo(at)fb(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: n_live_tup smaller than the number of rows in a table
Date: 2015-01-17 00:01:51
Message-ID: D0DEE66C.A5CC0%lguo@fb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

We are seeing a strange behavior where n_live_tup is way smaller than the number of rows in a table. The table has > 18m rows, but n_live_tup only has < 100K. We tried to do vacuum analyze to clear up any sticky errors, but it didn’t correct the problem. We are running Postgres 9.2. Any pointers on how we could debug this problem and how to correct the stats?

Thanks,
Lisa

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2015-01-17 00:10:27 Re: hung backends stuck in spinlock heavy endless loop
Previous Message Tom Lane 2015-01-16 23:45:07 Re: [PATCH] explain sortorder