Skip site navigation (1) Skip section navigation (2)

EXPLAIN detail

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 (view raw or flat)
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 

Responses

pgsql-performance by date

Next:From: Pavan DeolaseeDate: 2008-04-09 10:04:06
Subject: Re: EXPLAIN detail
Previous:From: PFCDate: 2008-04-08 22:48:35
Subject: Re: bulk insert performance problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group