See your postgresql.conf for

log_planner_stats = true #false
log_executor_stats = true #false
#log_statement_stats = false




Oleg

On Fri, 11 Mar 2005, Ioannis Theoharis wrote:



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


---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match


Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to