Explain Analyze mode

From: Ioannis Theoharis <theohari(at)ics(dot)forth(dot)gr>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Explain Analyze mode
Date: 2005-03-11 14:16:58
Message-ID: Pine.GSO.4.58.0503111614490.18547@ourania.ics.forth.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi, i found this form of output of explain analyze, watching some old
mails in lists.

test4=# explain analyze select * from patients;
LOG: query: explain analyze select * from patients;
LOG: duration: 0.603887 sec
LOG: QUERY STATISTICS
! system usage stats:
! 0.624269 elapsed 0.458985 user 0.123047 system sec
! [0.468750 user 0.125000 sys total]
! 0/0 [0/0] filesystem blocks in/out
! 7/4 [310/158] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [0/0] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 2742 read, 0 written, buffer hit
rate = 3.59%
! Local blocks: 0 read, 0 written, buffer hit
rate = 0.00%
! Direct blocks: 0 read, 0 written
QUERY PLAN
-----------------------------------------------------------------
Seq Scan on patients (cost=0.00..4048.60 rows=131960 width=172)
(actual time=0.04..562.97 rows=133886 loops=1)
Total runtime: 602.42 msec
(2 rows)

How can i turn my configuration to achieve this output for explain
analyze (and only the QUERY PLAN, as like tomorrow)?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruno Wolff III 2005-03-11 14:55:54 Re: Grant ALL on schema
Previous Message Terry Yapt 2005-03-11 13:37:37 Re: We are not following the spec for HAVING without GROUP