From: Łukasz Filut <l.filut@wsb.pl>
To: Mario Weilguni <mweilguni@sime.com>
Cc: Andreas Hartmann <andreas@apache.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Less rows -> better performance?
Date: Tue, 22 Jul 2008 09:48:34 +0200
Message-ID: <488590D2.4080800@wsb.pl> (raw)
In-Reply-To: <4884AB4A.2020709@sime.com>
References: <48846A02.7090702@apache.org>
<48846DA3.2090308@archonet.com>
<4884722A.1000405@apache.org>
<1d4e0c10807210432v45c6272awb1ea13974747de54@mail.gmail.com>
<4884A0F6.2000501@apache.org>
<4884A4A7.7050503@sime.com>
<4884A7D3.7050501@apache.org>
<4884AB4A.2020709@sime.com>
[...]
> You can check this too:
> select relname, relpages, reltuples, relkind
> from pg_class
> where relkind in ('r', 'i')
> order by relpages desc limit 20;
>
> Will give you the top-20 tables and their sizes, 1 page is typically
> 8KB, so you can cross-check if relpages/reltuples is completly off,
> this is a good indicator for table/index bloat.
use this query :
select pg_size_pretty(pg_relation_size(oid)) as relation_size,relname,
relpages, reltuples, relkind
from pg_class
where relkind in ('r', 'i')
order by relpages desc limit 20;
output will be much more readeable
>
> Regards,
> Mario
Lukasz
--
Lukasz Filut
DBA - IT Group, WSB-TEB Corporation
Poznan - Poland
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: l.filut@wsb.pl, mweilguni@sime.com, andreas@apache.org
Subject: Re: Less rows -> better performance?
In-Reply-To: <488590D2.4080800@wsb.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox