EXPLAIN ANALYZE on 8.2
От
Evgeny Gridasov
Тема
EXPLAIN ANALYZE on 8.2
Дата
Msg-id
20061214163230.d46f0138.eugrid@fpm.kubsu.ru
Список
Дерево обсуждения
EXPLAIN ANALYZE on 8.2 Evgeny Gridasov <eugrid@fpm.kubsu.ru>
Re: EXPLAIN ANALYZE on 8.2 Tom Lane <tgl@sss.pgh.pa.us>
Re: EXPLAIN ANALYZE on 8.2 Evgeny Gridasov <eugrid@fpm.kubsu.ru>
Re: EXPLAIN ANALYZE on 8.2 Tom Lane <tgl@sss.pgh.pa.us>
Re: EXPLAIN ANALYZE on 8.2 "Kelly Burkhart" <kelly.burkhart@gmail.com>
Re: EXPLAIN ANALYZE on 8.2 Tom Lane <tgl@sss.pgh.pa.us>
Re: EXPLAIN ANALYZE on 8.2 "Simon Riggs" <simon@2ndquadrant.com>
Re: [HACKERS] EXPLAIN ANALYZE on 8.2 Martijn van Oosterhout <kleptog@svana.org>
Re: [HACKERS] EXPLAIN ANALYZE on 8.2 "Simon Riggs" <simon@2ndquadrant.com>
Re: [HACKERS] EXPLAIN ANALYZE on 8.2 Martijn van Oosterhout <kleptog@svana.org>
Re: [HACKERS] EXPLAIN ANALYZE on 8.2 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] EXPLAIN ANALYZE on 8.2 Martijn van Oosterhout <kleptog@svana.org>
Re: [HACKERS] EXPLAIN ANALYZE on 8.2 Florian Weimer <fweimer@bfk.de>
Re: [HACKERS] EXPLAIN ANALYZE on 8.2 Dimitri Fontaine <dim@dalibo.com>
Re: EXPLAIN ANALYZE on 8.2 Mark Kirkwood <markir@paradise.net.nz>
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 по дате отправления
