PostgreSQL 8.2.3 婺桺桺懼
劯锔	媆锔	䆹17. 橉媇単陉䘞	媆誕	嬉誕

17.8. 誊臯施䂘螇

17.8.1. 昖臵启䘵嚘䂘螇櫽镖単

婋麵䔇埗昄毓彽橉媇単评啘䔇䂘螇抩镖䬹攓㔗套悩劇䫘庖䂘螇抩镖闼幽䫘潊䔇昄扞埇傖锔誺 pg_stat 启 pg_statio 係䂘蓖商垽斟螪閞㔗埗蓕䆹25诙埡敘崔媇敇㔗

㔊濘懟㔏傯 PostgreSQL 8.2 嚔哋stats_command_string 毓彽婔婻剘䋸䔇昄扞櫽镖橺彽臖橺彽方螺䂘螇床誕䘋滇劥誊臯鄘埇傖䋸䆋䔇嚔劇潡噿閺㔗䂘螇床誕䘋備婘抩镖庖亓潡臯亓䔇䂘螇媇敇施滇媙驔䔇㔗

stats_command_string (boolean): 䂘螇懟婻嚔臺欓臯䔇变傴埪噽嚔哋欓臯䔇施閘㔗認婻锬釹䚺䩕滇噿閺䔇㔗臙濘懟剿嘪檪垄欷嚔認婻媇敇幘婉滇欔橬䫘潙鄘埇蓕䔇埻橬轙亓䫘潙启嚔臺䔇欔橬蔙欉脘䩋彄啹溴垄婉庫臖滇婻垬噘暟昂㔗埻橬轙亓䫘潙埇傖櫹埻認婻螆䘞㔗
update_process_title (boolean): 橉媇単懟櫽彄婔婻桄䔇 SQL 变傴儌敘桄誕䘋湺鵻㔗誕䘋湺鵻埇傖锔誺 Unix 婋䔇 ps 变傴潡 Windows 婋䔇傂媇䞇䊖単昖䩋㔗埻橬轙亓䫘潙埇傖櫹埻認婻螆䘞㔗
stats_start_collector (boolean): 毓彽橉媇単滇劥劇媘䂘螇櫽镖床誕䘋㔗䚺䩕欷嚔嘖套悩嘹凹䂘螇櫽镖潡躻媘橙䊖婉懘噘轼闼幽埇傖噿閺㔗認婻锬釹埻脘婘劇媘橉媇単施螆䘞㔗啹婺抩镖床誕䘋婉脘婘橉媇単誊臯婺赆劇媘潡啩溵㔗婉誺埻襕抩镖床誕䘋庻婘儌埇傖婘橉媇単誊臯婺锟施敘櫹抩镖巻底䂘螇媇敇㔗
stats_block_level (boolean): 䂘螇櫽镖庖亓彆䔇昄扞康昂虄攓㔗䚺䩕滇噿閺䔇㔗埻橬轙亓䫘潙埇傖櫹埻認婻螆䘞㔗
stats_row_level (boolean): 䂘螇櫽镖臯亓彆䔇昄扞康昂虄攓㔗䚺䩕滇噿閺䔇㔗埻橬轙亓䫘潙埇傖櫹埻認婻螆䘞㔗
stats_reset_on_server_start (boolean): 婘橉媇単劇媘施唍橙䷺噾櫽镖䔇庖亓启臯亓䂘螇媇敇㔗邻螴噿閺幘儌滇䂘螇媇敇婘橉媇単崔渇麉劇誺䘋婺䘇媹㔗認婻唚埻脘婘橉媇単劇媘䔇施唍螆䘞㔗

17.8.2. 䂘螇䕏毓

log_statement_stats (boolean) log_parser_stats (boolean) log_planner_stats (boolean) log_executor_stats (boolean): 凹懟溇昖臵劏橉媇単斖媖麯膷庺䕩庫昇庖䔇攓脘䂘螇㔗認滇寘哋䔇嬡悊噖噙㔗log_statement_stats 檖只攂䔇臺蘔䂘螇蔯噽垄䔇檖只鐽凹懟婻昇庖䔇䂘螇㔗log_statement_stats 婉脘启噽垄傂嘘鐽凹懟婻昇庖䂘螇䔇锬釹婔蕙欷嚔㔗欔橬認底锬釹鄘滇䚺䩕噿閺䔇㔗埻橬轙亓䫘潙欉脘媞櫹認底螆䘞㔗

劯锔	饡釕	嬉誕
髍臇檖只启斖媖	婪婔亓	躻媘橙䊖