Search Postgresql Archives

Re: EXPLAIN ANALYZE output

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



David Rysdam <drysdam@xxxxxxxxxx> writes:
> According to what I've been able to find:

> A = predicted time to first returned row in milliseconds
                                              ^^^^^^^^^^^^ arbitrary units
> B = total cost in arbitrary units
> C = actual time to first returned row in milliseconds
> D = actual total time in milliseconds

> 2) Does EXPLAIN ANALYZE add a lot of overhead that is being measured here? 

Yes, its per-row overhead can be significant.  Depends on what the query
plan actually is, and how many rows go through, which you didn't say...

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux