planner's cost functions

From: dafNi zaf <dzaf88(at)gmail(dot)com>
To: pgsql-students(at)postgresql(dot)org
Subject: planner's cost functions
Date: 2013-04-05 16:07:36
Message-ID: CAAega+6zVDCYsu5r3Ab8EnqftAb0uwnGTzCNeum+ULKXXSZmXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-students

Hello everybody!

I'm trying to understand the the query planner's cost estimator.
I was not able to find anywhere the functions that estimate the cost
of each operation that the optimizer produces (via EXPLAIN ANALYZE).

I only found this from for the sequencial scan:
SEQ SCAN = ( cpu_tuple_cost * rows ) + ( number of pages * seq_page_cost )

and I am wondering where could I find the rest formulas for the rest
operations
(e.g. HashAggregate, Nested Loop, Hash Join, Index Scan, Sort, etc)

I have spent more than three days looking for these but I couldn't find
anything.
At least not from the official documentation or other relavant publications

Thank you in advance!
dafNi

Browse pgsql-students by date

  From Date Subject
Next Message Govind kumar sah 2013-04-07 09:09:32 downloading of project source code
Previous Message german andres arzayus millan 2013-03-26 16:51:42 Fwd: 3/26/2013 5:51:40 PM