Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > EXPLAIN detail
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 3975 of 4424
Post > Topic >>

EXPLAIN detail

by npuleio@[EMAIL PROTECTED] ("Luigi N. Puleio") Apr 9, 2008 at 02:51 AM

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
 




 6 Posts in Topic:
EXPLAIN detail
npuleio@[EMAIL PROTECTED]  2008-04-09 02:51:50 
Re: EXPLAIN detail
pavan.deolasee@[EMAIL PRO  2008-04-09 15:34:06 
Re: EXPLAIN detail
craig@[EMAIL PROTECTED]   2008-04-09 18:28:36 
Re: EXPLAIN detail
npuleio@[EMAIL PROTECTED]  2008-04-09 04:05:54 
Re: EXPLAIN detail
craig@[EMAIL PROTECTED]   2008-04-09 19:16:29 
Re: EXPLAIN detail
matthew@[EMAIL PROTECTED]  2008-04-09 11:33:43 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 7:58:57 CST 2008.