From: | Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | EXPLAIN ANALYZE on 8.2 |
Date: | 2006-12-14 13:32:30 |
Message-ID: | 20061214163230.d46f0138.eugrid@fpm.kubsu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
Hi, everybody!
Running the same query on pg 8.2 through EXPLAIN ANALYZE takes 4x-10x time as running it without it.
Is it ok?
Example:
testing=> select count(*) from auth_user;
count
---------
2575675
(1 row)
Time: 1450,829 ms
testing=> explain analyze select count(*) from auth_user;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=89814.87..89814.88 rows=1 width=0) (actual time=18460.436..18460.439 rows=1 loops=1)
-> Seq Scan on auth_user (cost=0.00..83373.89 rows=2576389 width=0) (actual time=0.424..9871.520 rows=2575675 loops=1)
Total runtime: 18460.535 ms
(3 rows)
Time: 18461,194 ms
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2006-12-14 14:41:59 | Re: recovery.conf parsing problems |
Previous Message | Martijn van Oosterhout | 2006-12-14 13:09:49 | Re: Operator class group proposal |
From | Date | Subject | |
---|---|---|---|
Next Message | Arnaud Lesauvage | 2006-12-14 14:01:34 | Re: Slow update with simple query |
Previous Message | Gregory S. Williamson | 2006-12-14 06:49:05 | Re: New to PostgreSQL, performance considerations |