QUERY PLAN: - Mailing list pgsql-general

From Tim Joyce
Subject QUERY PLAN:
Date
Msg-id 00b501bf2062$910e71b0$0501a8c0@noonoo
Whole thread Raw
In response to Re: [GENERAL] Windows Server?  (mfb@radical-solutions.co.uk (Mike Brickman))
Responses Re: [GENERAL] QUERY PLAN:
List pgsql-general
can someone point me at documentation so that i can unserstand the results
of an EXPLAIN, eg:

Index Scan using words_id_idx on books_idx  (cost=441.19 rows=7644 width=8)

explain select * from books_idx where wrd_id=1;

I am paticularly interested in what the rows= figure means.

TIA

timj



pgsql-general by date:

Previous
From: "Vince DiCiero"
Date:
Subject: Creating case insensative Index
Next
From: Andrzej Mazurkiewicz
Date:
Subject: FW: inheritance of functions