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