EXPLAIN ANALYZE on 8.2 - Mailing list pgsql-performance

From Evgeny Gridasov
Subject EXPLAIN ANALYZE on 8.2
Date
Msg-id 20061214163230.d46f0138.eugrid@fpm.kubsu.ru
Whole thread Raw
Responses Re: EXPLAIN ANALYZE on 8.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Hi, everybody!

Running the same query on pg 8.2 through EXPLAIN ANALYZE takes 4x-10x time as running it without it.
Is it ok?


Example:

testing=> select count(*) from auth_user;
  count
---------
 2575675
(1 row)

Time: 1450,829 ms
testing=> explain analyze select count(*) from auth_user;
                                                         QUERY PLAN
    

----------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=89814.87..89814.88 rows=1 width=0) (actual time=18460.436..18460.439 rows=1 loops=1)
   ->  Seq Scan on auth_user  (cost=0.00..83373.89 rows=2576389 width=0) (actual time=0.424..9871.520 rows=2575675
loops=1)
 Total runtime: 18460.535 ms
(3 rows)

Time: 18461,194 ms

pgsql-performance by date:

Previous
From: "Tim Jones"
Date:
Subject: Re: strange query behavior
Next
From: Greg Smith
Date:
Subject: Re: New to PostgreSQL, performance considerations