For the record, I've recently observed such behaviour on non-cheap 64bit server harware. That was Pg 8.4.0. hardware specs available on request. EXPLAIN ANALYZE SELECT was over 2 times slower that SELECT. repeatedly. Answering an obligatory question: NO virtualization (vmware/xen/other) there. Question: Is there anything as normal, accepted level of performance degradation when using EXPLAIN ANALYZE compared to plain query? 2010/3/22 Tom Lane <tgl@xxxxxxxxxxxxx>: > Szymon Guz <mabewlun@xxxxxxxxx> writes: >> I've got a simple query. When I use explain analyze it lasts 7 times slower. >> Why? > > You've got a machine where gettimeofday() is really slow. This is > common on cheap PC hardware :-( > > regards, tom lane > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Filip Rembiałkowski JID,mailto:filip.rembialkowski@xxxxxxxxx http://filip.rembialkowski.net/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
