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

EXPLAIN output explanation requested

From: Ron Arts <ron(dot)arts(at)neonova(dot)nl>
To: pgsql-novice(at)postgresql(dot)org
Subject: EXPLAIN output explanation requested
Date: 2008-06-03 09:56:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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


NeoNova BV, The Netherlands
Professional internet and VoIP solutions   Kruislaan 419              1098 VA Amsterdam
info: 020-5628292       servicedesk: 020-5628292   fax: 020-5628291
KvK Amsterdam 34151241

The following disclaimer applies to this email:


pgsql-novice by date

Next:From: A. KretschmerDate: 2008-06-03 10:35:34
Subject: Re: EXPLAIN output explanation requested
Previous:From: Derrick BettsDate: 2008-06-01 14:49:15
Subject: Re: Running .psqlrc from a custom location

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