Re: EXPLAIN ANALYZE output - Mailing list pgsql-general

From Tom Lane
Subject Re: EXPLAIN ANALYZE output
Date
Msg-id 4507.1135722988@sss.pgh.pa.us
Whole thread Raw
In response to EXPLAIN ANALYZE output  (David Rysdam <drysdam@ll.mit.edu>)
List pgsql-general
David Rysdam <drysdam@ll.mit.edu> 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

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [ADMIN] Running with fsync=off
Next
From: Tom Lane
Date:
Subject: Re: [ADMIN] Running with fsync=off