| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: That EXPLAIN ANALYZE patch still needs work |
| Date: | 2006-06-08 21:07:56 |
| Message-ID: | 20060608210756.GF20220@surnet.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Simon Riggs wrote:
> postgres=# explain analyze select count(*) from accounts;
> QUERY PLAN
> ------------------------------------------------------------------------------------------------------------------------
> Aggregate (cost=2890.00..2890.01 rows=1 width=0) (actual
> time=0.000..690.780 rows=1 loops=1)
> -> Seq Scan on accounts (cost=0.00..2640.00 rows=100000 width=0)
> (actual time=0.000..2672.562 rows=100000 loops=1)
> Total runtime: 734.474 ms
> (3 rows)
>
> Time: 891.822 ms
Wow, that is slow. Maybe a problem in the kernel? Perhaps something
similar to this:
http://www.ussg.iu.edu/hypermail/linux/kernel/0603.2/index.html#1282
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Larry Rosenman | 2006-06-08 21:08:48 | Re: That EXPLAIN ANALYZE patch still needs work |
| Previous Message | Jim C. Nasby | 2006-06-08 21:06:55 | Re: ADD/DROP constraints |