[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] Less rows -> better performance?
From:       Łukasz Filut <l.filut () wsb ! pl>
Date:       2008-07-22 7:48:34
Message-ID: 488590D2.4080800 () wsb ! pl
[Download RAW message or body]

[...]
> 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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]