Lists: | pgsql-students |
---|
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 |
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