PostgreSQL 9.6.0 锟街诧拷
锟斤拷一页	锟斤拷一锟斤拷	锟斤拷录 F. 锟斤拷锟斤拷锟结供锟斤拷模锟斤拷	锟斤拷一页

F.29. pg_stat_statements

pg_stat_statements模锟斤拷锟结供一锟街凤拷锟斤拷追锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷执锟叫碉拷锟斤拷锟斤拷 SQL 锟斤拷锟斤拷执锟斤拷统锟斤拷锟斤拷息锟斤拷

锟斤拷模锟斤拷锟斤拷锟酵拷锟斤拷锟�postgresql.conf锟斤拷shared_preload_libraries锟斤拷锟斤拷锟斤拷pg_stat_statements锟斤拷锟斤拷锟诫，锟斤拷为锟斤拷锟斤拷要锟斤拷锟斤拷墓锟斤拷锟斤拷诖妗ｏ拷锟斤拷锟轿讹拷锟斤拷锟斤拷踊锟斤拷瞥锟斤拷锟侥ｏ拷锟斤拷锟揭伙拷畏锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�

锟斤拷pg_stat_statements锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟斤拷俑梅锟斤拷锟斤拷锟� 锟斤拷锟斤拷锟斤拷锟斤拷锟捷匡拷锟酵筹拷锟斤拷锟较拷锟斤拷锟侥ｏ拷锟斤拷峁╋拷锟揭伙拷锟斤拷锟酵� pg_stat_statements锟皆硷拷锟斤拷锟斤拷pg_stat_statements_reset 锟斤拷pg_stat_statements锟斤拷锟节凤拷锟绞和诧拷锟斤拷锟斤拷些统锟斤拷锟斤拷息锟斤拷锟斤拷些锟斤拷图锟酵猴拷锟斤拷锟斤拷锟斤拷全锟街匡拷锟矫的ｏ拷锟斤拷锟角匡拷锟斤拷锟斤拷CREATE EXTENSION pg_stat_statements 为锟截讹拷锟斤拷锟捷匡拷锟斤拷锟斤拷锟斤拷锟角★拷

F.29.1. `pg_stat_statements`锟斤拷图

锟缴革拷模锟斤拷锟秸硷拷锟斤拷统锟斤拷锟斤拷息锟斤拷锟斤拷通锟斤拷一锟斤拷锟斤拷为 pg_stat_statements锟斤拷锟斤拷图使锟矫★拷锟斤拷锟斤拷锟酵嘉� 一锟斤拷锟斤拷锟斤拷锟街碉拷锟斤拷锟捷匡拷 ID锟斤拷锟矫伙拷 ID 锟酵诧拷询 ID锟斤拷锟斤拷嗟斤拷锟侥ｏ拷锟斤拷锟斤拷追锟劫的匡拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷隙锟斤拷锟斤拷锟揭伙拷小锟斤拷锟斤拷锟酵硷拷锟斤拷锟斤拷锟� 锟斤拷 F-22锟斤拷锟斤拷示锟斤拷

锟斤拷 F-22. pg_stat_statements锟斤拷

锟斤拷锟斤拷	锟斤拷锟斤拷	锟斤拷锟斤拷	锟斤拷锟斤拷
`userid`	`oid`	`pg_authid.oid`	执锟叫革拷锟斤拷锟斤拷锟矫伙拷锟斤拷 OID
`dbid`	`oid`	`pg_database.oid`	锟斤拷锟斤拷锟斤拷执锟叫革拷锟斤拷锟斤拷锟斤拷锟捷匡拷锟� OID
`queryid`	`bigint`		锟节诧拷锟斤拷希锟诫，锟斤拷锟斤拷锟侥斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
`query`	`text`		锟斤拷锟斤拷锟侥憋拷锟斤拷式
`calls`	`bigint`		锟斤拷执锟叫的达拷锟斤拷
`total_time`	`double precision`		锟节革拷锟斤拷锟斤拷谢锟斤拷训锟斤拷锟绞憋拷洌拷院锟斤拷锟斤拷
`min_time`	`double precision`		锟节革拷锟斤拷锟斤拷谢锟斤拷训锟斤拷锟叫∈憋拷洌拷院锟斤拷锟斤拷
`max_time`	`double precision`		锟节革拷锟斤拷锟斤拷谢锟斤拷训锟斤拷锟斤拷时锟戒，锟皆猴拷锟斤拷锟�
`mean_time`	`double precision`		锟节革拷锟斤拷锟斤拷谢锟斤拷训锟狡斤拷锟绞憋拷洌拷院锟斤拷锟斤拷
`stddev_time`	`double precision`		锟节革拷锟斤拷锟斤拷谢锟斤拷锟绞憋拷锟斤拷锟斤拷锟斤拷锟阶计拷睿拷院锟斤拷锟斤拷
`rows`	`bigint`		锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷影锟斤拷锟斤拷锟斤拷锟斤拷锟�
`shared_blks_hit`	`bigint`		锟斤拷锟斤拷锟斤拷锟缴的癸拷锟斤拷锟介缓锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
`shared_blks_read`	`bigint`		锟斤拷锟斤拷锟斤拷取锟侥癸拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
`shared_blks_dirtied`	`bigint`		锟斤拷锟斤拷锟脚拷锟侥癸拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
`shared_blks_written`	`bigint`		锟斤拷锟斤拷锟叫达拷锟侥癸拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
`local_blks_hit`	`bigint`		锟斤拷锟斤拷锟斤拷锟缴的憋拷锟截块缓锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
`local_blks_read`	`bigint`		锟斤拷锟斤拷锟斤拷取锟侥憋拷锟截匡拷锟斤拷锟斤拷锟�
`local_blks_dirtied`	`bigint`		锟斤拷锟斤拷锟脚拷锟侥憋拷锟截匡拷锟斤拷锟斤拷锟�
`local_blks_written`	`bigint`		锟斤拷锟斤拷锟叫达拷锟侥憋拷锟截匡拷锟斤拷锟斤拷锟�
`temp_blks_read`	`bigint`		锟斤拷锟斤拷锟斤拷取锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟�
`temp_blks_written`	`bigint`		锟斤拷锟斤拷锟叫达拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟�
`blk_read_time`	`double precision`		锟斤拷锟斤拷浠拷诙锟饺★拷锟斤拷系锟斤拷锟绞憋拷洌拷院锟斤拷锟狡ｏ拷锟斤拷锟�track_io_timing锟斤拷锟斤拷锟矫ｏ拷锟斤拷锟斤拷为锟姐）
`blk_write_time`	`double precision`		锟斤拷锟斤拷浠拷锟叫达拷锟斤拷锟较碉拷锟斤拷时锟戒，锟皆猴拷锟斤拷疲锟斤拷锟斤拷track_io_timing锟斤拷锟斤拷锟矫ｏ拷锟斤拷锟斤拷为锟姐）

锟斤拷锟节帮拷全锟斤拷原锟津，非筹拷锟斤拷锟矫伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫伙拷执锟叫的诧拷询锟斤拷 SQL 锟侥憋拷锟斤拷锟斤拷queryid锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵硷拷锟斤拷锟阶帮拷锟斤拷锟斤拷堑锟斤拷锟斤拷菘锟斤拷校锟斤拷锟斤拷蔷锟斤拷芄锟斤拷锟斤拷锟酵� 锟斤拷锟斤拷息锟斤拷

只要锟缴规划锟侥诧拷询锟斤拷锟斤拷SELECT锟斤拷INSERT锟斤拷UPDATE锟皆硷拷DELETE锟斤拷锟斤拷锟斤拷一锟斤拷锟节诧拷锟斤拷希锟斤拷锟斤拷锟斤拷锟斤拷锟酵拷牟锟窖拷峁癸拷锟斤拷锟斤拷蔷突岜伙拷锟较碉拷一锟斤拷锟斤拷一锟斤拷pg_stat_statements锟筋。通锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟侥匡拷模锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷询锟斤拷锟剿诧拷询锟叫碉拷锟侥憋拷锟斤拷锟斤拷值之锟斤拷锟斤拷锟斤拷锟斤拷锟较碉拷效锟斤拷锟斤拷锟角斤拷锟结被锟斤拷为锟斤拷锟斤拷同锟侥★拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟筋（锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟筋）锟斤拷锟较革拷锟斤拷锟斤拷锟斤拷堑锟斤拷谋锟斤拷锟窖拷址锟斤拷锟轿拷锟斤拷锟斤拷锟斤拷斜冉稀锟�

锟斤拷为锟剿帮拷一锟斤拷锟斤拷询锟斤拷锟斤拷锟斤拷锟斤拷询匹锟戒，锟斤拷锟斤拷值锟结被锟斤拷锟皆ｏ拷锟斤拷pg_stat_statements锟斤拷示锟斤拷锟斤拷锟结被一锟斤拷?锟斤拷锟芥换锟斤拷锟斤拷询锟侥憋拷锟斤拷剩锟洁部锟街撅拷锟角撅拷锟斤拷锟斤拷锟�pg_stat_statements锟斤拷锟斤拷氐锟斤拷囟锟�queryid锟斤拷希值锟侥碉拷一锟斤拷锟斤拷询锟斤拷锟侥憋拷锟斤拷

锟斤拷某些锟斤拷锟斤拷校锟斤拷锟斤拷锟斤拷锟斤拷圆锟酵拷谋锟斤拷牟锟窖拷锟斤拷芑岜伙拷诤系锟揭伙拷锟斤拷锟揭伙拷锟�pg_stat_statements锟筋。通锟斤拷锟斤拷只锟结发锟斤拷锟斤拷锟斤拷锟斤拷燃鄣牟锟窖拷锟斤拷希锟斤拷锟斤拷锟揭诧拷泻锟叫★拷幕锟斤拷锟斤拷锟轿拷锟较ｏ拷锟阶诧拷锟皆拷锟斤拷锟斤拷薰氐牟锟窖拷锟斤拷诤系锟揭伙拷锟斤拷锟斤拷校锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷诓锟酵拷没锟斤拷锟斤拷锟斤拷菘锟侥诧拷询锟斤拷说锟斤拷锟结发锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�

锟斤拷锟斤拷queryid锟斤拷希值锟角革拷锟捷诧拷询锟斤拷锟斤拷锟斤拷锟酵凤拷锟斤拷锟斤拷谋锟斤拷锟斤拷锟斤拷模锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷也锟斤拷锟杰达拷锟节ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵拷谋锟斤拷牟锟窖拷锟斤拷诓锟斤拷锟斤拷锟斤拷绮煌拷锟�search_path锟斤拷锟矫ｏ拷锟斤拷原锟斤拷锟斤拷锟斤拷胁锟酵拷暮锟斤拷澹拷锟斤拷蔷涂锟斤拷锟斤拷锟轿拷锟酵拷锟斤拷锟斤拷锟节★拷

pg_stat_statements锟斤拷使锟斤拷锟竭匡拷锟斤拷希锟斤拷使锟斤拷 queryid锟斤拷也锟斤拷锟斤拷锟斤拷dbid锟斤拷userid锟斤拷希锟斤拷锟轿伙拷锟斤拷锟饺诧拷询锟侥憋拷锟斤拷锟饺讹拷锟酵可匡拷锟侥憋拷识锟斤拷锟斤拷锟斤拷锟角ｏ拷锟斤拷一锟斤拷锟斤拷锟揭拷锟斤拷牵锟斤拷锟斤拷锟�queryid锟斤拷希值锟饺讹拷锟斤拷只锟斤拷锟斤拷锟睫的憋拷锟较★拷锟斤拷为锟矫憋拷识锟斤拷锟角从斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷模锟斤拷锟斤拷锟街碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞斤拷锟斤拷值锟斤拷诓锟斤拷锟斤拷锟斤拷识锟斤拷锟侥猴拷锟斤拷锟斤拷锟斤拷锟斤拷一些违锟斤拷直锟斤拷锟侥猴拷锟藉。锟斤拷锟界，锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟窖拷锟斤拷锟斤拷锟酵伙拷锟斤拷锟斤拷锟斤拷锟斤拷歉帽锟斤拷锟斤拷锟斤拷尾锟窖拷浔簧撅拷锟斤拷锟斤拷锟斤拷亟锟斤拷锟斤拷锟饺伙拷锟斤拷锟斤拷锟斤拷锟窖拷锟斤拷锟饺伙拷碌模锟斤拷锟斤拷锟�pg_stat_statements锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟角诧拷同锟侥★拷锟斤拷希锟斤拷锟斤拷也锟皆伙拷锟斤拷锟杰癸拷锟皆硷拷平台锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷牟锟斤拷锟斤拷锟斤拷小锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟轿�PostgreSQL锟侥诧拷同锟斤拷锟芥本之锟斤拷queryid锟斤拷锟结保锟斤拷锟饺讹拷锟角诧拷锟斤拷全锟侥★拷

锟斤拷锟捷撅拷锟介，只锟斤拷锟节底诧拷锟斤拷锟斤拷锟斤拷姹撅拷约锟侥柯荚拷锟斤拷锟较革拷诒锟斤拷锟斤拷锟饺拷锟酵憋拷锟�queryid值锟斤拷锟杰憋拷锟劫讹拷为锟饺讹拷锟斤拷锟揭可比★拷锟斤拷台锟斤拷锟诫到锟斤拷锟斤拷锟斤拷锟斤拷 WAL 锟截放的革拷锟斤拷锟叫的凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵拷牟锟窖拷锟斤拷锟揭伙拷锟斤拷锟�queryid值锟斤拷锟斤拷锟角ｏ拷锟竭硷拷锟斤拷锟斤拷模式锟斤拷锟斤拷锟斤拷证锟斤拷锟斤拷锟斤拷锟斤拷锟较革拷锟斤拷隙锟斤拷锟斤拷锟斤拷锟饺伙拷锟斤拷母锟斤拷疲锟斤拷锟斤拷锟斤拷锟竭硷拷锟斤拷锟狡伙拷之锟斤拷锟斤拷锟斤拷锟斤拷时锟斤拷queryid锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟矫的憋拷识锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷剩锟斤拷萍锟街憋拷咏锟斤拷胁锟斤拷浴锟�

锟叫达拷锟斤拷锟皆的诧拷询锟侥憋拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟解部锟斤拷锟斤拷锟侥硷拷锟叫ｏ拷锟斤拷锟揭诧拷锟斤拷锟斤拷锟侥癸拷锟斤拷锟节存。锟斤拷耍锟斤拷锟斤拷锟斤拷呛艹锟斤拷牟锟窖拷谋锟揭诧拷鼙锟斤拷晒锟斤拷拇娲拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟桔伙拷锟剿很讹拷锟斤拷锟侥诧拷询锟侥憋拷锟斤拷锟斤拷锟解部锟侥硷拷也锟斤拷锟斤拷锟斤拷锟斤拷锟杰达拷锟斤拷为一锟街恢革拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟� 锟斤拷锟斤拷锟斤拷锟斤拷锟�pg_stat_statements锟斤拷锟杰伙拷选锟斤拷锟斤拷锟斤拷些锟斤拷询锟侥憋拷锟斤拷锟斤拷锟斤拷pg_stat_statements锟斤拷图锟叫碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟筋将锟斤拷锟斤拷示锟秸碉拷 query锟津，诧拷锟斤拷锟斤拷每锟斤拷queryid锟斤拷锟斤拷锟斤拷锟� 统锟斤拷锟斤拷息锟结被锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟皆匡拷锟角硷拷小 pg_stat_statements.max锟斤拷锟斤拷止锟斤拷锟斤拷锟斤拷

F.29.2. 锟斤拷锟斤拷

pg_stat_statements_reset() 锟斤拷锟斤拷 void: pg_stat_statements_reset锟斤拷锟斤拷目前锟斤拷pg_stat_statements锟秸硷拷锟斤拷锟斤拷锟斤拷统锟斤拷锟斤拷息锟斤拷默锟斤拷锟斤拷锟斤拷拢锟斤拷锟斤拷锟斤拷锟斤拷只锟杰憋拷锟斤拷锟斤拷锟矫伙拷执锟叫★拷
pg_stat_statements(showtext boolean) returns setof record: pg_stat_statements锟斤拷图锟斤拷锟斤拷一锟斤拷也锟斤拷 pg_stat_statements锟侥猴拷锟斤拷锟斤拷锟斤拷锟藉。锟酵伙拷锟剿匡拷锟斤拷直锟接碉拷锟斤拷 pg_stat_statements锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷通锟斤拷指锟斤拷 showtext := false锟斤拷锟斤拷锟皆诧拷询锟侥憋拷锟斤拷锟斤拷锟斤拷锟斤拷应锟斤拷锟斤拷图锟斤拷 query锟叫碉拷OUT锟斤拷锟斤拷锟斤拷锟斤拷锟截匡拷值锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿拷锟街э拷植锟斤拷锟斤拷馗锟斤拷锟斤拷粘锟斤拷炔锟斤拷锟斤拷牟锟窖拷谋锟斤拷锟斤拷獠匡拷锟斤拷叨锟斤拷锟狡的★拷锟斤拷锟洁工锟竭匡拷锟斤拷转锟斤拷锟斤拷锟叫伙拷锟斤拷锟揭伙拷锟斤拷鄄斓斤拷牟锟窖拷谋锟斤拷锟斤拷锟轿拷锟斤拷锟斤拷 pg_stat_statements锟皆硷拷锟斤拷锟斤拷锟斤拷全锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷只锟斤拷锟斤拷要锟斤拷时锟斤拷锟斤拷锟斤拷锟窖拷谋锟斤拷锟斤拷锟轿拷锟斤拷锟斤拷锟斤拷锟窖诧拷询锟侥憋拷锟芥储锟斤拷一锟斤拷锟侥硷拷锟叫ｏ拷锟斤拷锟街凤拷锟斤拷锟斤拷锟皆斤拷锟斤拷锟截革拷锟斤拷锟�pg_stat_statements锟斤拷锟捷碉拷锟斤拷锟斤拷 I/O锟斤拷

F.29.3. 锟斤拷锟矫诧拷锟斤拷

pg_stat_statements.max (integer): pg_stat_statements.max锟斤拷锟缴革拷模锟斤拷锟斤拷俚锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷目锟斤拷锟斤拷pg_stat_statements锟斤拷图锟斤拷锟叫碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟桔测到锟侥匡拷锟斤拷锟街碉拷锟斤拷涑拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟劫憋拷执锟叫碉拷锟斤拷锟斤拷锟斤拷息锟斤拷锟结被锟斤拷锟斤拷锟斤拷默锟斤拷值为 5000锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷诜锟斤拷锟斤拷锟斤拷锟斤拷锟绞憋拷锟斤拷谩锟�
pg_stat_statements.track (enum): pg_stat_statements.track锟斤拷锟斤拷锟斤拷些锟斤拷锟结被锟斤拷模锟斤拷锟斤拷锟斤拷锟街革拷锟�top锟斤拷锟皆革拷锟劫讹拷锟斤拷锟斤拷洌拷锟叫┲憋拷锟斤拷煽突锟斤拷朔锟斤拷锟斤拷锟斤拷锟戒）锟斤拷指锟斤拷all锟斤拷锟斤拷锟皆革拷锟斤拷嵌锟阶碉拷锟斤拷洌拷锟斤拷锟斤拷诤锟斤拷锟斤拷械锟斤拷玫锟斤拷锟戒）锟斤拷指锟斤拷none锟斤拷锟皆斤拷锟斤拷锟斤拷锟酵筹拷锟斤拷锟较拷占锟斤拷锟侥拷锟街碉拷锟�top锟斤拷只锟叫筹拷锟斤拷锟矫伙拷锟杰癸拷锟侥憋拷锟斤拷锟斤拷锟斤拷谩锟�
pg_stat_statements.track_utility (boolean): pg_stat_statements.track_utility锟斤拷锟狡革拷模锟斤拷锟角凤拷锟斤拷锟劫癸拷锟斤拷锟斤拷锟筋。锟斤拷锟斤拷锟斤拷锟斤拷锟角筹拷锟斤拷SELECT锟斤拷INSERT锟斤拷 UPDATE锟斤拷DELETE之锟斤拷锟斤拷锟叫碉拷锟斤拷锟斤拷锟斤拷锟筋。默锟斤拷值锟斤拷on锟斤拷只锟叫筹拷锟斤拷锟矫伙拷锟杰癸拷锟侥憋拷锟斤拷锟斤拷锟斤拷谩锟�
pg_stat_statements.save (boolean): pg_stat_statements.save指锟斤拷锟角凤拷锟节凤拷锟斤拷锟斤拷锟截憋拷之锟襟还憋拷锟斤拷锟斤拷锟酵筹拷锟斤拷锟较拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为off锟斤拷锟斤拷么锟截闭后不憋拷锟斤拷统锟斤拷锟斤拷息锟斤拷锟斤拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷时也锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷统锟斤拷锟斤拷息锟斤拷默锟斤拷值为on锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟斤拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷

锟斤拷模锟斤拷要锟斤拷锟斤拷pg_stat_statements.max锟缴憋拷锟斤拷锟侥讹拷锟解共锟斤拷锟节存。注锟斤拷只要锟斤拷模锟介被锟斤拷锟斤拷突锟斤拷锟斤拷锟斤拷锟矫达拷锟斤拷锟节存，锟斤拷锟斤拷pg_stat_statements.track锟斤拷锟斤拷锟斤拷为none锟斤拷

锟斤拷些锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷postgresql.conf锟斤拷锟斤拷锟矫★拷锟斤拷锟酵碉拷锟矫凤拷锟斤拷锟斤拷锟角ｏ拷

# postgresql.conf
shared_preload_libraries = 'pg_stat_statements'

pg_stat_statements.max = 10000
pg_stat_statements.track = all

F.29.4. 示锟斤拷锟斤拷锟�

bench=# SELECT pg_stat_statements_reset();

$ pgbench -i bench
$ pgbench -c10 -t300 bench

bench=# \x
bench=# SELECT query, calls, total_time, rows, 100.0 * shared_blks_hit /
               nullif(shared_blks_hit + shared_blks_read, 0) AS hit_percent
          FROM pg_stat_statements ORDER BY total_time DESC LIMIT 5;
-[ RECORD 1 ]---------------------------------------------------------------------
query       | UPDATE pgbench_branches SET bbalance = bbalance + ? WHERE bid = ?;
calls       | 3000
total_time  | 9609.00100000002
rows        | 2836
hit_percent | 99.9778970000200936
-[ RECORD 2 ]---------------------------------------------------------------------
query       | UPDATE pgbench_tellers SET tbalance = tbalance + ? WHERE tid = ?;
calls       | 3000
total_time  | 8015.156
rows        | 2990
hit_percent | 99.9731126579631345
-[ RECORD 3 ]---------------------------------------------------------------------
query       | copy pgbench_accounts from stdin
calls       | 1
total_time  | 310.624
rows        | 100000
hit_percent | 0.30395136778115501520
-[ RECORD 4 ]---------------------------------------------------------------------
query       | UPDATE pgbench_accounts SET abalance = abalance + ? WHERE aid = ?;
calls       | 3000
total_time  | 271.741999999997
rows        | 3000
hit_percent | 93.7968855088209426
-[ RECORD 5 ]---------------------------------------------------------------------
query       | alter table pgbench_accounts add primary key (aid)
calls       | 1
total_time  | 81.42
rows        | 0
hit_percent | 34.4947735191637631

F.29.5. 锟斤拷锟斤拷

Takahiro Itagaki <[email protected]>锟斤拷Peter Geoghegan <[email protected]>为锟斤拷锟斤拷锟斤拷锟剿诧拷询锟斤拷锟芥化锟侥癸拷锟杰★拷

锟斤拷一页	锟斤拷始页	锟斤拷一页
pgrowlocks	锟斤拷一锟斤拷	pgstattuple