Re: Really really slow select count(*)

it probably has good reason to hate me.

ns=> SELECT n.nspname AS schema_name, c.relname AS table_name,
ns-> c.reltuples AS row_count,
ns-> c.relpages*8/1024 AS mb_used,
ns-> pg_total_relation_size(c.oid)/1024/1024 AS total_mb_used
ns-> FROM pg_class c
ns-> JOIN pg_namespace n ON (n.oid=c.relnamespace)
ns-> WHERE c.relkind = 'r'
ns-> ORDER BY total_mb_used DESC
ns-> LIMIT 20;
schema_name | table_name | row_count | mb_used |
total_mb_used
-------------+----------------------------------+-------------+---------+---------------
public | django_session | 1.47843e+07 | 4122 |
18832
public | traffic_tracking2010 | 9.81985e+06 | 811 |
1653
public | mailer_mailingmessagelog | 7.20214e+06 | 441 |
1082
public | auth_user | 3.20077e+06 | 572 |
791
public | fastadder_fastadderstatus | 302479 | 458 |
693
public | registration_registrationprofile | 3.01345e+06 | 248 |
404
public | reporting_dp_6c93734c | 1.1741e+06 | 82 |
224
public | peoplez_contact | 79759 | 18 |
221
public | traffic_tracking201101 | 1.49972e+06 | 163 |
204
public | reporting_dp_a3439e2a | 1.32739e+06 | 82 |
187
public | nsproperties_apthistory | 44906 | 69 |
126
public | nsproperties_apt | 30780 | 71 |
125
public | clients_showingrequest | 85175 | 77 |
103
public | reporting_dp_4ffe04ad | 330252 | 26 |
63
public | fastadder_fastadderstatuslog | 377402 | 28 |
60
public | nsmailings_officememotoagent | 268345 | 15 |
52
public | celery_taskmeta | 5041 | 12 |
32
public | mailer_messagelog | 168298 | 24 |
32
public | datapoints_job | 9167 | 12 |
23
public | fastadder_fastadderstatus_errors | 146314 | 7 |
21

oh and there in the footnotes to django they say "dont' forget to run the
delete expired sessions management every once in a while". thanks guys.

it won't run now because its too big, I can delete them from psql though

well just think how sprightly my website will run tomorrow once I fix these.

On Fri, Feb 4, 2011 at 9:00 PM, Shaun Thomas <sthomas(at)peak6(dot)com> wrote:

> On 02/04/2011 01:59 PM, felix wrote:
>
>
> still no advice on the pages
>>
>
> I think it just hates you.
>
>
> --
> Shaun Thomas
> OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
> 312-676-8870
> sthomas(at)peak6(dot)com
>
> ______________________________________________
>
> See http://www.peak6.com/email_disclaimer.php
> for terms and conditions related to this email
>