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 Novice > EXPLAIN output ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 3132 of 3215
Post > Topic >>

EXPLAIN output explanation requested

by ron.arts@[EMAIL PROTECTED] (Ron Arts) Jun 3, 2008 at 11:56 AM

Hello all,

I have an EXPLAIN statement that gives me output I understand,
but on the other hand I don't...

tium=# explain select codec1, phonetype from phone;
                          QUERY PLAN
------------------------------------------------------------
  Seq Scan on phone  (cost=0.00..85882.58 rows=658 width=11)
(1 row)


This is a table with 658 rows. Queries are indeed very
slow. How is the query plan computed? What does the 85882 value
mean?

Thanks,
Ron


-- 
NeoNova BV, The Netherlands
Professional internet and VoIP solutions

http://www.neonova.nl
  Kruislaan 419              1098 VA Amsterdam
info: 020-5628292       servicedesk: 020-5628292   fax: 020-5628291
KvK Amsterdam 34151241

The following disclaimer applies to this email:
http://www.neonova.nl/maildisclaimer

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




 8 Posts in Topic:
EXPLAIN output explanation requested
ron.arts@[EMAIL PROTECTED  2008-06-03 11:56:39 
Re: EXPLAIN output explanation requested
andreas.kretschmer@[EMAIL  2008-06-03 12:35:34 
Re: EXPLAIN output explanation requested
andreas.kretschmer@[EMAIL  2008-06-03 12:52:28 
Re: EXPLAIN output explanation requested
ron.arts@[EMAIL PROTECTED  2008-06-03 13:10:10 
Re: EXPLAIN output explanation requested
ron.arts@[EMAIL PROTECTED  2008-06-03 19:51:05 
Re: EXPLAIN output explanation requested
andreas.kretschmer@[EMAIL  2008-06-03 20:24:58 
Re: EXPLAIN output explanation requested
andreas.kretschmer@[EMAIL  2008-06-03 20:28:39 
Re: EXPLAIN output explanation requested
andreas.kretschmer@[EMAIL  2008-06-04 09:42:05 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Sat Sep 6 15:22:19 CDT 2008.