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)?
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 |