Re: Explain Analyze mode

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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83