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
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 *