Thread: Suggestion for the postgresql.org survey

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


In another thread ("7.4?") <20030226110156.4FD8E4180F@mailer.elma.fr>,
someone wrote:

> ... looking the survey of Postgres.org web site :
> http://www.postgresql.org/survey.php?View=1&SurveyID=9

I would receommend taking the results of these polls with a large grain
of salt. I just reloaded my browser three times and watched the totals
change. Could we add a way to limit the ballot stuffing? I realize that
no method is perfect, but a simple cookie plus an IP restriction (with
timeout) should help immensely and not be too hard to implement.

Thanks,
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200302260934

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+XNGovJuQZxSWSsgRAj0cAJ4quXTKrH2ly1QDQ8WnRhQEGducCACfQw0D
jKJkdilJ07Hvp017ARPLUs0=
=CEfq
-----END PGP SIGNATURE-----

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

On Wed, 2003-02-26 at 11:13, jose antonio leo wrote:
> How Can I analyze a Explain?

EXPLAIN output is documented here:

http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/performance-tips.html#USING-EXPLAIN

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC