How Can I Analyze a Explain?

From: "jose antonio leo" <jaleo8(at)storelandia(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How Can I Analyze a Explain?
Date: 2003-02-26 16:13:16
Message-ID: KAEFLIDKHEJNPPKOLGHMIEKDCOAA.jaleo8@storelandia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!!

How Can I analyze a Explain?
My simple select is the next
Select * from articul where des_art like "%arroz%"
Responds Explain is:
{ SEQSCAN :startup_cost 0.00 :total_cost 1.14 :rows 1 :width 265
:qptargetlist }
NOTICE: QUERY PLAN:
Seq Scan on art_emp (cost=0.00..1.14 rows=1 width=265) (actual
time=0.18..0.18)
Total runtime: 0.31 msec

What mean "rows:1" ?
and width?
qptargetlist?

Tks

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-02-26 16:18:28 Re: rserv replication error
Previous Message Kari Lempiainen 2003-02-26 15:52:49 timezone_hour missing