| From: | "Luigi N(dot) Puleio" <npuleio(at)rocketmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | EXPLAIN detail |
| Date: | 2008-04-09 09:51:50 |
| Message-ID: | 862313.90586.qm@web33505.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hello everyone!!
I have a table with 17 columns and it has almost
530000 records and doing just a
SELECT * FROM table
with the EXPLAIN ANALYZE I get:
Seq Scan on table (cost=0.00...19452.95 rows=529395
width=170) (actual time=0.155...2194.294 rows=529395
loops=1)
total runtime=3679.039 ms
and this table has a PK...
Do you think is too much time for a simple select?...
I guess it's a bit slow to get all those records...but
since I'm a newbie with PostgreSQL, what I can check
to optimize?
Thanks to all!
Ciao,
Luigi
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Deolasee | 2008-04-09 10:04:06 | Re: EXPLAIN detail |
| Previous Message | PFC | 2008-04-08 22:48:35 | Re: bulk insert performance problem |