Re: Digesting explain analyze

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Jesper Krogh <jesper(at)krogh(dot)cc>
Cc: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Digesting explain analyze
Date: 2010-01-07 06:39:31
Message-ID: 4B4581A3.1050401@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jesper Krogh wrote:
> Is it possible to get PG to tell me, how many rows that fits in a
> disk-page. All columns are sitting in "plain" storage according to \d+
> on the table.
>
select relname,round(reltuples / relpages) as "avg_rows_per_page" from
pg_class where relpages > 0;

--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Carlo Stonebanks 2010-01-07 07:17:22 Massive table (500M rows) update nightmare
Previous Message Jesper Krogh 2010-01-07 06:10:28 Re: Digesting explain analyze