How Can I Analyze a Explain? - Mailing list pgsql-general

From jose antonio leo
Subject How Can I Analyze a Explain?
Date
Msg-id KAEFLIDKHEJNPPKOLGHMIEKDCOAA.jaleo8@storelandia.com
Whole thread Raw
In response to Suggestion for the postgresql.org survey  (greg@turnstep.com)
Responses Re: How Can I Analyze a Explain?  (Neil Conway <neilc@samurai.com>)
List 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


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: index usage (and foreign keys/triggers)
Next
From: Darko Prenosil
Date:
Subject: Re: Function example