Re: Really really slow select count(*)

felix <crucialfelix@xxxxxxxxx> · Fri, 4 Feb 2011 21:14:22 +0100

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@xxxxxxxxx> 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@xxxxxxxxx

______________________________________________

See Âhttp://www.peak6.com/email_disclaimer.php

for terms and conditions related to this email