# 主题索引

LLMS 索引： [llms.txt](/llms.txt)

---

<span id="mon-chapter-star-168" class="pdf-anchor"></span><span id="pdf-page-240" class="pdf-anchor"></span>

## A {#index-a}

- address [42](/02-activity-statistics/#pdf-page-43)

- ANALYZE [198](/08-vacuum/#pdf-page-199), [200](/08-vacuum/#pdf-page-201), [222](/09-operation-progress/#pdf-page-223)–[224](/09-operation-progress/#pdf-page-225)

- *application\_name* [33](/02-activity-statistics/#pdf-page-34), [44](/02-activity-statistics/#pdf-page-45)

- *archive\_command* [167](/06-write-ahead-log/#pdf-page-168), [171](/06-write-ahead-log/#pdf-page-172)

- archiver [21](/01-statistics-overview/#pdf-page-22), [167](/06-write-ahead-log/#pdf-page-168)–[168](/06-write-ahead-log/#pdf-page-169)

- *archive\_timeout* [168](/06-write-ahead-log/#pdf-page-169)

- atop [29](/02-activity-statistics/#pdf-page-30)

- *autovacuum* [203](/08-vacuum/#pdf-page-204)–[204](/08-vacuum/#pdf-page-205)

- autovacuum launcher [22](/01-statistics-overview/#pdf-page-23), [196](/08-vacuum/#pdf-page-197), [200](/08-vacuum/#pdf-page-201)

- autovacuum worker [22](/01-statistics-overview/#pdf-page-23), [197](/08-vacuum/#pdf-page-198)

- *autovacuum\_freeze\_max\_age* [204](/08-vacuum/#pdf-page-205)–[205](/08-vacuum/#pdf-page-206), [208](/08-vacuum/#pdf-page-209)

- *autovacuum\_max\_workers* [214](/08-vacuum/#pdf-page-215)

- *autovacuum\_naptime* [22](/01-statistics-overview/#pdf-page-23), [199](/08-vacuum/#pdf-page-200)–[200](/08-vacuum/#pdf-page-201), [215](/08-vacuum/#pdf-page-216)

- *autovacuum\_vacuum\_scale\_factor* [198](/08-vacuum/#pdf-page-199)

- *autovacuum\_vacuum\_threshold* [198](/08-vacuum/#pdf-page-199)

- *autovacuum\_work\_mem* [18](/01-statistics-overview/#pdf-page-19), [217](/08-vacuum/#pdf-page-218)–[218](/08-vacuum/#pdf-page-219)

## B {#index-b}

- background writer [20](/01-statistics-overview/#pdf-page-21), [22](/01-statistics-overview/#pdf-page-23), [149](/05-shared-memory-and-io/#pdf-page-150)

- BEGIN [30](/02-activity-statistics/#pdf-page-31), [44](/02-activity-statistics/#pdf-page-45)

- *bgwriter\_lru\_maxpages* [150](/05-shared-memory-and-io/#pdf-page-151), [154](/05-shared-memory-and-io/#pdf-page-155)

- *bgwriter\_lru\_multiplier* [150](/05-shared-memory-and-io/#pdf-page-151)

- buffers\_backend [154](/05-shared-memory-and-io/#pdf-page-155)

- bytea [125](/04-databases/#pdf-page-126)

## C {#index-c}

- CHECKPOINT [151](/05-shared-memory-and-io/#pdf-page-152)–[152](/05-shared-memory-and-io/#pdf-page-153)

- checkpointer [20](/01-statistics-overview/#pdf-page-21), [22](/01-statistics-overview/#pdf-page-23), [149](/05-shared-memory-and-io/#pdf-page-150)

- *checkpoint\_timeout* [151](/05-shared-memory-and-io/#pdf-page-152), [163](/06-write-ahead-log/#pdf-page-164)

- clock\_timestamp [58](/02-activity-statistics/#pdf-page-59)

- CLUSTER [221](/09-operation-progress/#pdf-page-222), [226](/09-operation-progress/#pdf-page-227)–[227](/09-operation-progress/#pdf-page-228)

- COMMIT [30](/02-activity-statistics/#pdf-page-31), [38](/02-activity-statistics/#pdf-page-39), [67](/02-activity-statistics/#pdf-page-68), [161](/06-write-ahead-log/#pdf-page-162)

- *compute\_query\_id* [91](/03-queries-and-functions/#pdf-page-92)

- convert\_from [125](/04-databases/#pdf-page-126)

- COPY [203](/08-vacuum/#pdf-page-204), [221](/09-operation-progress/#pdf-page-222)–[222](/09-operation-progress/#pdf-page-223), [231](/09-operation-progress/#pdf-page-232)–[233](/09-operation-progress/#pdf-page-234)

- count [215](/08-vacuum/#pdf-page-216)

- CREATE INDEX [18](/01-statistics-overview/#pdf-page-19), [198](/08-vacuum/#pdf-page-199), [221](/09-operation-progress/#pdf-page-222), [229](/09-operation-progress/#pdf-page-230)

- CREATE INDEX CONCURRENTLY [229](/09-operation-progress/#pdf-page-230)–[230](/09-operation-progress/#pdf-page-231)

- cron [58](/02-activity-statistics/#pdf-page-59), [196](/08-vacuum/#pdf-page-197)

- current\_setting [134](/05-shared-memory-and-io/#pdf-page-135)

## D {#index-d}

- database [42](/02-activity-statistics/#pdf-page-43), [60](/02-activity-statistics/#pdf-page-61), [77](/03-queries-and-functions/#pdf-page-78)

- DataGrip [17](/01-statistics-overview/#pdf-page-18), [23](/01-statistics-overview/#pdf-page-24)

- DBeaver [23](/01-statistics-overview/#pdf-page-24)

- dblink [103](/04-databases/#pdf-page-104)

- *deadlock\_timeout* [55](/02-activity-statistics/#pdf-page-56), [68](/02-activity-statistics/#pdf-page-69)

- *default\_statistics\_target* [222](/09-operation-progress/#pdf-page-223)

- DELETE [107](/04-databases/#pdf-page-108), [109](/04-databases/#pdf-page-110), [196](/08-vacuum/#pdf-page-197)

- delta [122](/04-databases/#pdf-page-123)

- docker [236](/test-environment/#pdf-page-237)

- docker-compose [236](/test-environment/#pdf-page-237)

- dstat [30](/02-activity-statistics/#pdf-page-31)

## E {#index-e}

- END [30](/02-activity-statistics/#pdf-page-31), [44](/02-activity-statistics/#pdf-page-45), [67](/02-activity-statistics/#pdf-page-68)

- EXPLAIN [91](/03-queries-and-functions/#pdf-page-92), [161](/06-write-ahead-log/#pdf-page-162), [222](/09-operation-progress/#pdf-page-223)

## F {#index-f}

- false [170](/06-write-ahead-log/#pdf-page-171)

- FPI [151](/05-shared-memory-and-io/#pdf-page-152), [162](/06-write-ahead-log/#pdf-page-163)

- *fsync* [152](/05-shared-memory-and-io/#pdf-page-153)

- *full\_page\_writes* [94](/03-queries-and-functions/#pdf-page-95), [151](/05-shared-memory-and-io/#pdf-page-152)

## G {#index-g}

- getrusage [72](/03-queries-and-functions/#pdf-page-73), [89](/03-queries-and-functions/#pdf-page-90)

- Grafana [235](/test-environment/#pdf-page-236), [238](/test-environment/#pdf-page-239)

## H {#index-h}

- *hot\_standby\_feedback* [178](/07-replication/#pdf-page-179), [192](/07-replication/#pdf-page-193), [206](/08-vacuum/#pdf-page-207)

- HTAP [214](/08-vacuum/#pdf-page-215)

- htop [29](/02-activity-statistics/#pdf-page-30)

## I {#index-i}

- *idle\_in\_transaction\_session\_timeout* [38](/02-activity-statistics/#pdf-page-39), [58](/02-activity-statistics/#pdf-page-59)

- increase [47](/02-activity-statistics/#pdf-page-48), [97](/03-queries-and-functions/#pdf-page-98)

- initdb [100](/04-databases/#pdf-page-101)–[101](/04-databases/#pdf-page-102)

- INSERT [107](/04-databases/#pdf-page-108), [109](/04-databases/#pdf-page-110), [196](/08-vacuum/#pdf-page-197)

- iostat [30](/02-activity-statistics/#pdf-page-31)

## K {#index-k}

- Kubernetes [46](/02-activity-statistics/#pdf-page-47), [56](/02-activity-statistics/#pdf-page-57)

<span id="pdf-page-241" class="pdf-anchor"></span>

## L {#index-l}

- LIMIT [82](/03-queries-and-functions/#pdf-page-83), [84](/03-queries-and-functions/#pdf-page-85)

- LISTEN [138](/05-shared-memory-and-io/#pdf-page-139)

- *log\_autovacuum\_min\_duration* [216](/08-vacuum/#pdf-page-217)–[217](/08-vacuum/#pdf-page-218)

- *log\_directory* [126](/04-databases/#pdf-page-127)

- *logging\_collector* [126](/04-databases/#pdf-page-127)

- logical replication worker [187](/07-replication/#pdf-page-188)

- *logical\_decoding\_work\_mem* [188](/07-replication/#pdf-page-189)–[189](/07-replication/#pdf-page-190)

- *log\_line\_prefix* [56](/02-activity-statistics/#pdf-page-57), [91](/03-queries-and-functions/#pdf-page-92)

- *log\_lock\_waits* [68](/02-activity-statistics/#pdf-page-69)

- *log\_min\_duration\_statement* [56](/02-activity-statistics/#pdf-page-57)

- *log\_statement* [56](/02-activity-statistics/#pdf-page-57)

- *log\_temp\_files* [145](/05-shared-memory-and-io/#pdf-page-146), [147](/05-shared-memory-and-io/#pdf-page-148)

- LSN [159](/06-write-ahead-log/#pdf-page-160), [178](/07-replication/#pdf-page-179)

## M {#index-m}

- *maintenance\_work\_mem* [18](/01-statistics-overview/#pdf-page-19), [217](/08-vacuum/#pdf-page-218)–[218](/08-vacuum/#pdf-page-219)

- make [236](/test-environment/#pdf-page-237)

- *max\_connections* [42](/02-activity-statistics/#pdf-page-43), [46](/02-activity-statistics/#pdf-page-47)

- *max\_slot\_wal\_keep\_size* [183](/07-replication/#pdf-page-184)–[185](/07-replication/#pdf-page-186)

- *max\_standby\_archive\_delay* [191](/07-replication/#pdf-page-192)

- *max\_standby\_streaming\_delay* [190](/07-replication/#pdf-page-191)–[192](/07-replication/#pdf-page-193)

- *max\_wal\_senders* [188](/07-replication/#pdf-page-189)

- *max\_wal\_size* [151](/05-shared-memory-and-io/#pdf-page-152)–[152](/05-shared-memory-and-io/#pdf-page-153), [185](/07-replication/#pdf-page-186)–[186](/07-replication/#pdf-page-187)

- maxwritten\_clean [154](/05-shared-memory-and-io/#pdf-page-155)

- mode [78](/03-queries-and-functions/#pdf-page-79), [85](/03-queries-and-functions/#pdf-page-86), [88](/03-queries-and-functions/#pdf-page-89)

## N {#index-n}

- nicstat [30](/02-activity-statistics/#pdf-page-31)

- NOTIFY [138](/05-shared-memory-and-io/#pdf-page-139)

- now [58](/02-activity-statistics/#pdf-page-59)

## O {#index-o}

- OLAP [65](/02-activity-statistics/#pdf-page-66), [111](/04-databases/#pdf-page-112)

- OLTP [74](/03-queries-and-functions/#pdf-page-75), [76](/03-queries-and-functions/#pdf-page-77), [82](/03-queries-and-functions/#pdf-page-83), [111](/04-databases/#pdf-page-112)

- other [78](/03-queries-and-functions/#pdf-page-79), [82](/03-queries-and-functions/#pdf-page-83)

## P {#index-p}

- pg\_activity [24](/01-statistics-overview/#pdf-page-25)

- pgAdmin [17](/01-statistics-overview/#pdf-page-18), [23](/01-statistics-overview/#pdf-page-24)–[24](/01-statistics-overview/#pdf-page-25)

- pg\_authid [117](/04-databases/#pdf-page-118)

- pg\_backend\_memory\_contexts [136](/05-shared-memory-and-io/#pdf-page-137)

- pg\_backend\_pid [64](/02-activity-statistics/#pdf-page-65)

- pg\_basebackup [224](/09-operation-progress/#pdf-page-225)–[225](/09-operation-progress/#pdf-page-226)

- pgbench [44](/02-activity-statistics/#pdf-page-45)–[45](/02-activity-statistics/#pdf-page-46), [48](/02-activity-statistics/#pdf-page-49), [96](/03-queries-and-functions/#pdf-page-97), [111](/04-databases/#pdf-page-112), [113](/04-databases/#pdf-page-114), [205](/08-vacuum/#pdf-page-206), [235](/test-environment/#pdf-page-236)

- pgbench\_accounts [135](/05-shared-memory-and-io/#pdf-page-136), [143](/05-shared-memory-and-io/#pdf-page-144), [166](/06-write-ahead-log/#pdf-page-167), [200](/08-vacuum/#pdf-page-201), [204](/08-vacuum/#pdf-page-205), [208](/08-vacuum/#pdf-page-209), [211](/08-vacuum/#pdf-page-212)–[212](/08-vacuum/#pdf-page-213), [215](/08-vacuum/#pdf-page-216), [219](/08-vacuum/#pdf-page-220)–[220](/08-vacuum/#pdf-page-221), [233](/09-operation-progress/#pdf-page-234)

- pgbench\_branches [199](/08-vacuum/#pdf-page-200), [211](/08-vacuum/#pdf-page-212)–[212](/08-vacuum/#pdf-page-213), [216](/08-vacuum/#pdf-page-217)

- pgbench\_history [143](/05-shared-memory-and-io/#pdf-page-144)

- pgbench\_tellers [199](/08-vacuum/#pdf-page-200), [216](/08-vacuum/#pdf-page-217)

- pg\_blocking\_pids [66](/02-activity-statistics/#pdf-page-67)

- pg\_buffercache [96](/03-queries-and-functions/#pdf-page-97), [130](/05-shared-memory-and-io/#pdf-page-131)–[131](/05-shared-memory-and-io/#pdf-page-132), [133](/05-shared-memory-and-io/#pdf-page-134), [135](/05-shared-memory-and-io/#pdf-page-136)–[136](/05-shared-memory-and-io/#pdf-page-137), [138](/05-shared-memory-and-io/#pdf-page-139)

- pg\_buffercache\_pages [96](/03-queries-and-functions/#pdf-page-97)–[97](/03-queries-and-functions/#pdf-page-98)

- pgcenter [24](/01-statistics-overview/#pdf-page-25), [93](/03-queries-and-functions/#pdf-page-94)–[94](/03-queries-and-functions/#pdf-page-95)

- pg\_class [104](/04-databases/#pdf-page-105)–[105](/04-databases/#pdf-page-106), [120](/04-databases/#pdf-page-121)–[121](/04-databases/#pdf-page-122), [131](/05-shared-memory-and-io/#pdf-page-132), [203](/08-vacuum/#pdf-page-204), [218](/08-vacuum/#pdf-page-219)

  - relfilenode [123](/04-databases/#pdf-page-124), [131](/05-shared-memory-and-io/#pdf-page-132)

  - relfrozenxid [203](/08-vacuum/#pdf-page-204)–[205](/08-vacuum/#pdf-page-206), [209](/08-vacuum/#pdf-page-210)

  - relminmxid [204](/08-vacuum/#pdf-page-205)

  - reltuples [198](/08-vacuum/#pdf-page-199), [233](/09-operation-progress/#pdf-page-234)

- pgcompacttable [213](/08-vacuum/#pdf-page-214)

- pg\_current\_wal\_flush\_lsn [160](/06-write-ahead-log/#pdf-page-161)

- pg\_current\_wal\_insert\_lsn [160](/06-write-ahead-log/#pdf-page-161)

- pg\_current\_wal\_lsn [160](/06-write-ahead-log/#pdf-page-161), [178](/07-replication/#pdf-page-179), [185](/07-replication/#pdf-page-186)

- pg\_database [75](/03-queries-and-functions/#pdf-page-76), [103](/04-databases/#pdf-page-104)

  - datfrozenxid [35](/02-activity-statistics/#pdf-page-36), [205](/08-vacuum/#pdf-page-206)–[206](/08-vacuum/#pdf-page-207), [208](/08-vacuum/#pdf-page-209)

  - datminmxid [206](/08-vacuum/#pdf-page-207)

  - oid [103](/04-databases/#pdf-page-104), [131](/05-shared-memory-and-io/#pdf-page-132)

- pg\_database\_size [117](/04-databases/#pdf-page-118), [119](/04-databases/#pdf-page-120)

- pg\_default [101](/04-databases/#pdf-page-102)–[102](/04-databases/#pdf-page-103), [127](/04-databases/#pdf-page-128), [149](/05-shared-memory-and-io/#pdf-page-150)

- pg\_dump [203](/08-vacuum/#pdf-page-204), [222](/09-operation-progress/#pdf-page-223), [231](/09-operation-progress/#pdf-page-232), [233](/09-operation-progress/#pdf-page-234)

- pg\_filenode\_relation [123](/04-databases/#pdf-page-124)

- pg\_get\_userbyid [75](/03-queries-and-functions/#pdf-page-76)

- pg\_global [102](/04-databases/#pdf-page-103)

- pg\_index [104](/04-databases/#pdf-page-105), [120](/04-databases/#pdf-page-121)–[121](/04-databases/#pdf-page-122)

- pg\_indexes [104](/04-databases/#pdf-page-105), [121](/04-databases/#pdf-page-122)

- pg\_indexes\_size [117](/04-databases/#pdf-page-118), [119](/04-databases/#pdf-page-120)

- pg\_is\_in\_recovery [182](/07-replication/#pdf-page-183)

- pg\_last\_wal\_receive\_lsn [182](/07-replication/#pdf-page-183)

- pg\_last\_wal\_replay\_lsn [182](/07-replication/#pdf-page-183)

- pg\_locks [31](/02-activity-statistics/#pdf-page-32), [35](/02-activity-statistics/#pdf-page-36)–[37](/02-activity-statistics/#pdf-page-38), [39](/02-activity-statistics/#pdf-page-40), [53](/02-activity-statistics/#pdf-page-54), [63](/02-activity-statistics/#pdf-page-64)–[66](/02-activity-statistics/#pdf-page-67), [121](/04-databases/#pdf-page-122), [133](/05-shared-memory-and-io/#pdf-page-134), [221](/09-operation-progress/#pdf-page-222)

  - granted [36](/02-activity-statistics/#pdf-page-37), [53](/02-activity-statistics/#pdf-page-54), [61](/02-activity-statistics/#pdf-page-62), [64](/02-activity-statistics/#pdf-page-65)–[65](/02-activity-statistics/#pdf-page-66)

  - waitstart [36](/02-activity-statistics/#pdf-page-37), [61](/02-activity-statistics/#pdf-page-62), [63](/02-activity-statistics/#pdf-page-64), [65](/02-activity-statistics/#pdf-page-66)–[66](/02-activity-statistics/#pdf-page-67)

- pg\_lock\_status [36](/02-activity-statistics/#pdf-page-37)

- pg\_log\_backend\_memory\_contexts [136](/05-shared-memory-and-io/#pdf-page-137)–[137](/05-shared-memory-and-io/#pdf-page-138)

- pg\_ls\_archive\_statusdir [124](/04-databases/#pdf-page-125), [127](/04-databases/#pdf-page-128), [170](/06-write-ahead-log/#pdf-page-171)

- pg\_ls\_dir [124](/04-databases/#pdf-page-125), [170](/06-write-ahead-log/#pdf-page-171)

<span id="pdf-page-242" class="pdf-anchor"></span>

- pg\_ls\_logdir [124](/04-databases/#pdf-page-125)–[126](/04-databases/#pdf-page-127)

- pg\_ls\_logicalmapdir [124](/04-databases/#pdf-page-125), [127](/04-databases/#pdf-page-128)

- pg\_ls\_logicalsnapdir [124](/04-databases/#pdf-page-125), [127](/04-databases/#pdf-page-128)

- pg\_lsn [178](/07-replication/#pdf-page-179)

- pg\_ls\_replslotdir [124](/04-databases/#pdf-page-125), [128](/04-databases/#pdf-page-129)

- pg\_ls\_tmpdir [124](/04-databases/#pdf-page-125), [127](/04-databases/#pdf-page-128)

- pg\_ls\_waldir [124](/04-databases/#pdf-page-125), [126](/04-databases/#pdf-page-127)–[127](/04-databases/#pdf-page-128)

- pg\_monitor [126](/04-databases/#pdf-page-127)–[128](/04-databases/#pdf-page-129)

- pg\_namespace [104](/04-databases/#pdf-page-105)

- pg\_prepared\_xacts [206](/08-vacuum/#pdf-page-207)

- pg\_read\_binary\_file [125](/04-databases/#pdf-page-126)

- pg\_read\_file [117](/04-databases/#pdf-page-118), [125](/04-databases/#pdf-page-126)

- pg\_read\_server\_files [117](/04-databases/#pdf-page-118)

- pg\_relation [105](/04-databases/#pdf-page-106)

- pg\_relation\_filenode [123](/04-databases/#pdf-page-124)

- pg\_relation\_filepath [123](/04-databases/#pdf-page-124), [132](/05-shared-memory-and-io/#pdf-page-133)

- pg\_relation\_size [117](/04-databases/#pdf-page-118), [119](/04-databases/#pdf-page-120)–[120](/04-databases/#pdf-page-121), [232](/09-operation-progress/#pdf-page-233)

- pg\_repack [213](/08-vacuum/#pdf-page-214)

- pg\_replication\_slots [176](/07-replication/#pdf-page-177), [183](/07-replication/#pdf-page-184)–[186](/07-replication/#pdf-page-187)

  - xmin [184](/07-replication/#pdf-page-185)–[185](/07-replication/#pdf-page-186), [192](/07-replication/#pdf-page-193), [206](/08-vacuum/#pdf-page-207)

- pg\_restore [231](/09-operation-progress/#pdf-page-232)

- pgSCV [235](/test-environment/#pdf-page-236)

- pg\_shmem\_allocations [130](/05-shared-memory-and-io/#pdf-page-131), [135](/05-shared-memory-and-io/#pdf-page-136)–[136](/05-shared-memory-and-io/#pdf-page-137)

- pg\_size\_bytes [118](/04-databases/#pdf-page-119)

- pg\_size\_pretty [118](/04-databases/#pdf-page-119)

- pg\_squeeze [213](/08-vacuum/#pdf-page-214)

- pg\_stat\_activity [31](/02-activity-statistics/#pdf-page-32)–[32](/02-activity-statistics/#pdf-page-33), [34](/02-activity-statistics/#pdf-page-35)–[40](/02-activity-statistics/#pdf-page-41), [50](/02-activity-statistics/#pdf-page-51)–[51](/02-activity-statistics/#pdf-page-52), [58](/02-activity-statistics/#pdf-page-59)–[60](/02-activity-statistics/#pdf-page-61), [64](/02-activity-statistics/#pdf-page-65)–[66](/02-activity-statistics/#pdf-page-67), [91](/03-queries-and-functions/#pdf-page-92), [133](/05-shared-memory-and-io/#pdf-page-134), [177](/07-replication/#pdf-page-178), [213](/08-vacuum/#pdf-page-214), [215](/08-vacuum/#pdf-page-216)–[217](/08-vacuum/#pdf-page-218), [219](/08-vacuum/#pdf-page-220), [221](/09-operation-progress/#pdf-page-222), [223](/09-operation-progress/#pdf-page-224), [226](/09-operation-progress/#pdf-page-227)–[227](/09-operation-progress/#pdf-page-228), [232](/09-operation-progress/#pdf-page-233)

  - application\_name [33](/02-activity-statistics/#pdf-page-34)

  - backend\_start [33](/02-activity-statistics/#pdf-page-34), [214](/08-vacuum/#pdf-page-215)

  - backend\_type [33](/02-activity-statistics/#pdf-page-34), [41](/02-activity-statistics/#pdf-page-42), [214](/08-vacuum/#pdf-page-215)–[215](/08-vacuum/#pdf-page-216)

  - backend\_xid [35](/02-activity-statistics/#pdf-page-36), [206](/08-vacuum/#pdf-page-207)

  - backend\_xmin [35](/02-activity-statistics/#pdf-page-36)

  - client\_addr [33](/02-activity-statistics/#pdf-page-34), [40](/02-activity-statistics/#pdf-page-41)

  - client\_port [33](/02-activity-statistics/#pdf-page-34)

  - datid [34](/02-activity-statistics/#pdf-page-35)

  - datname [33](/02-activity-statistics/#pdf-page-34), [40](/02-activity-statistics/#pdf-page-41), [214](/08-vacuum/#pdf-page-215)

  - leader\_pid [34](/02-activity-statistics/#pdf-page-35)

  - pid [34](/02-activity-statistics/#pdf-page-35), [213](/08-vacuum/#pdf-page-214)

  - query [34](/02-activity-statistics/#pdf-page-35), [214](/08-vacuum/#pdf-page-215)

  - queryid [34](/02-activity-statistics/#pdf-page-35), [91](/03-queries-and-functions/#pdf-page-92)

  - query\_start [34](/02-activity-statistics/#pdf-page-35), [59](/02-activity-statistics/#pdf-page-60)–[60](/02-activity-statistics/#pdf-page-61)

  - state [34](/02-activity-statistics/#pdf-page-35), [49](/02-activity-statistics/#pdf-page-50), [51](/02-activity-statistics/#pdf-page-52), [53](/02-activity-statistics/#pdf-page-54)–[55](/02-activity-statistics/#pdf-page-56), [60](/02-activity-statistics/#pdf-page-61), [65](/02-activity-statistics/#pdf-page-66), [214](/08-vacuum/#pdf-page-215), [226](/09-operation-progress/#pdf-page-227)

  - state\_change [34](/02-activity-statistics/#pdf-page-35), [63](/02-activity-statistics/#pdf-page-64), [65](/02-activity-statistics/#pdf-page-66)

  - usename [33](/02-activity-statistics/#pdf-page-34), [40](/02-activity-statistics/#pdf-page-41)

  - usesysid [34](/02-activity-statistics/#pdf-page-35)

  - wait\_event [34](/02-activity-statistics/#pdf-page-35), [51](/02-activity-statistics/#pdf-page-52), [66](/02-activity-statistics/#pdf-page-67), [214](/08-vacuum/#pdf-page-215)

  - wait\_event\_type [34](/02-activity-statistics/#pdf-page-35), [51](/02-activity-statistics/#pdf-page-52), [53](/02-activity-statistics/#pdf-page-54), [55](/02-activity-statistics/#pdf-page-56), [60](/02-activity-statistics/#pdf-page-61), [66](/02-activity-statistics/#pdf-page-67), [214](/08-vacuum/#pdf-page-215)

  - waiting [51](/02-activity-statistics/#pdf-page-52)

  - xact\_start [34](/02-activity-statistics/#pdf-page-35), [59](/02-activity-statistics/#pdf-page-60)–[60](/02-activity-statistics/#pdf-page-61), [214](/08-vacuum/#pdf-page-215)

- pg\_stat\_all\_indexes [110](/04-databases/#pdf-page-111)

- pg\_stat\_all\_tables [110](/04-databases/#pdf-page-111), [198](/08-vacuum/#pdf-page-199), [200](/08-vacuum/#pdf-page-201)

- `pg_stat_archiver` [167](/06-write-ahead-log/#pdf-page-168), [170](/06-write-ahead-log/#pdf-page-171)

- pg\_stat\_bgwriter [150](/05-shared-memory-and-io/#pdf-page-151)

- pg\_stat\_database [31](/02-activity-statistics/#pdf-page-32), [37](/02-activity-statistics/#pdf-page-38), [39](/02-activity-statistics/#pdf-page-40)–[40](/02-activity-statistics/#pdf-page-41), [44](/02-activity-statistics/#pdf-page-45)–[47](/02-activity-statistics/#pdf-page-48), [107](/04-databases/#pdf-page-108), [110](/04-databases/#pdf-page-111), [112](/04-databases/#pdf-page-113), [114](/04-databases/#pdf-page-115), [139](/05-shared-memory-and-io/#pdf-page-140), [143](/05-shared-memory-and-io/#pdf-page-144)–[149](/05-shared-memory-and-io/#pdf-page-150)

  - active\_time [39](/02-activity-statistics/#pdf-page-40)

  - blk\_read\_time [139](/05-shared-memory-and-io/#pdf-page-140)–[140](/05-shared-memory-and-io/#pdf-page-141)

  - blks\_hit [139](/05-shared-memory-and-io/#pdf-page-140)

  - blks\_read [139](/05-shared-memory-and-io/#pdf-page-140)

  - blk\_write\_time [139](/05-shared-memory-and-io/#pdf-page-140)–[140](/05-shared-memory-and-io/#pdf-page-141)

  - checksum\_failures [115](/04-databases/#pdf-page-116)

  - checksum\_last\_failure [115](/04-databases/#pdf-page-116)

  - conflicts [115](/04-databases/#pdf-page-116), [191](/07-replication/#pdf-page-192)–[192](/07-replication/#pdf-page-193)

  - deadlocks [55](/02-activity-statistics/#pdf-page-56), [115](/04-databases/#pdf-page-116)

  - idle\_in\_transaction\_time [39](/02-activity-statistics/#pdf-page-40)

  - numbackends [37](/02-activity-statistics/#pdf-page-38)

  - sessions [38](/02-activity-statistics/#pdf-page-39), [48](/02-activity-statistics/#pdf-page-49)

  - sessions\_abandoned [38](/02-activity-statistics/#pdf-page-39), [48](/02-activity-statistics/#pdf-page-49), [115](/04-databases/#pdf-page-116)

  - sessions\_fatal [38](/02-activity-statistics/#pdf-page-39), [115](/04-databases/#pdf-page-116)

  - sessions\_killed [38](/02-activity-statistics/#pdf-page-39), [115](/04-databases/#pdf-page-116)

  - session\_time [38](/02-activity-statistics/#pdf-page-39)

  - state [50](/02-activity-statistics/#pdf-page-51)

  - stats\_reset [39](/02-activity-statistics/#pdf-page-40), [145](/05-shared-memory-and-io/#pdf-page-146)

  - temp\_bytes [145](/05-shared-memory-and-io/#pdf-page-146)–[146](/05-shared-memory-and-io/#pdf-page-147)

  - temp\_files [145](/05-shared-memory-and-io/#pdf-page-146)

  - tup\_deleted [107](/04-databases/#pdf-page-108)

  - tup\_fetched [107](/04-databases/#pdf-page-108)

  - tup\_inserted [107](/04-databases/#pdf-page-108)

  - tup\_returned [107](/04-databases/#pdf-page-108)

  - tup\_updated [107](/04-databases/#pdf-page-108)

  - xact\_commit [38](/02-activity-statistics/#pdf-page-39), [44](/02-activity-statistics/#pdf-page-45)

  - xact\_rollback [38](/02-activity-statistics/#pdf-page-39), [44](/02-activity-statistics/#pdf-page-45), [114](/04-databases/#pdf-page-115)–[115](/04-databases/#pdf-page-116)

- pg\_stat\_database\_conflicts [173](/07-replication/#pdf-page-174), [176](/07-replication/#pdf-page-177), [191](/07-replication/#pdf-page-192)

<span id="pdf-page-243" class="pdf-anchor"></span>

- pg\_stat\_file [125](/04-databases/#pdf-page-126)

- pg\_stat\_get\_activity [32](/02-activity-statistics/#pdf-page-33)

- pg\_stat\_get\_autovacuum\_count [200](/08-vacuum/#pdf-page-201)

- pg\_statio\_all\_indexes [139](/05-shared-memory-and-io/#pdf-page-140), [141](/05-shared-memory-and-io/#pdf-page-142)

- pg\_statio\_all\_sequences [139](/05-shared-memory-and-io/#pdf-page-140)

- pg\_statio\_all\_tables [139](/05-shared-memory-and-io/#pdf-page-140)–[140](/05-shared-memory-and-io/#pdf-page-141)

- pg\_statistic [222](/09-operation-progress/#pdf-page-223)

- pg\_statistics [222](/09-operation-progress/#pdf-page-223)

- pg\_stat\_kcache [72](/03-queries-and-functions/#pdf-page-73), [89](/03-queries-and-functions/#pdf-page-90)

- pg\_stat\_monitor [72](/03-queries-and-functions/#pdf-page-73)

- pg\_stat\_progress\_analyze [221](/09-operation-progress/#pdf-page-222), [223](/09-operation-progress/#pdf-page-224)

- pg\_stat\_progress\_basebackup [221](/09-operation-progress/#pdf-page-222), [225](/09-operation-progress/#pdf-page-226)

- pg\_stat\_progress\_cluster [221](/09-operation-progress/#pdf-page-222), [226](/09-operation-progress/#pdf-page-227)–[227](/09-operation-progress/#pdf-page-228)

- pg\_stat\_progress\_copy [221](/09-operation-progress/#pdf-page-222), [231](/09-operation-progress/#pdf-page-232), [233](/09-operation-progress/#pdf-page-234)

- pg\_stat\_progress\_create\_index [221](/09-operation-progress/#pdf-page-222), [229](/09-operation-progress/#pdf-page-230)–[230](/09-operation-progress/#pdf-page-231)

- pg\_stat\_progress\_vacuum [213](/08-vacuum/#pdf-page-214), [217](/08-vacuum/#pdf-page-218), [219](/08-vacuum/#pdf-page-220), [221](/09-operation-progress/#pdf-page-222)

- pg\_stat\_replication [176](/07-replication/#pdf-page-177)–[177](/07-replication/#pdf-page-178), [182](/07-replication/#pdf-page-183)

  - backend\_xmin [178](/07-replication/#pdf-page-179), [192](/07-replication/#pdf-page-193)

- pg\_stat\_replication\_slots [155](/05-shared-memory-and-io/#pdf-page-156), [176](/07-replication/#pdf-page-177), [188](/07-replication/#pdf-page-189)

- pgstats [24](/01-statistics-overview/#pdf-page-25), [222](/09-operation-progress/#pdf-page-223)

- pg\_stat\_slru [138](/05-shared-memory-and-io/#pdf-page-139)

- pg\_stat\_statements [34](/02-activity-statistics/#pdf-page-35), [46](/02-activity-statistics/#pdf-page-47), [72](/03-queries-and-functions/#pdf-page-73)–[76](/03-queries-and-functions/#pdf-page-77), [79](/03-queries-and-functions/#pdf-page-80)–[80](/03-queries-and-functions/#pdf-page-81), [86](/03-queries-and-functions/#pdf-page-87), [91](/03-queries-and-functions/#pdf-page-92)–[97](/03-queries-and-functions/#pdf-page-98), [141](/05-shared-memory-and-io/#pdf-page-142), [143](/05-shared-memory-and-io/#pdf-page-144)–[149](/05-shared-memory-and-io/#pdf-page-150), [161](/06-write-ahead-log/#pdf-page-162)–[162](/06-write-ahead-log/#pdf-page-163), [165](/06-write-ahead-log/#pdf-page-166)–[166](/06-write-ahead-log/#pdf-page-167)

  - blk\_read\_time [79](/03-queries-and-functions/#pdf-page-80)–[80](/03-queries-and-functions/#pdf-page-81), [86](/03-queries-and-functions/#pdf-page-87), [144](/05-shared-memory-and-io/#pdf-page-145)

  - blks\_dirtied [141](/05-shared-memory-and-io/#pdf-page-142)

  - blks\_written [141](/05-shared-memory-and-io/#pdf-page-142)

  - blk\_write\_time [79](/03-queries-and-functions/#pdf-page-80)–[80](/03-queries-and-functions/#pdf-page-81), [86](/03-queries-and-functions/#pdf-page-87), [144](/05-shared-memory-and-io/#pdf-page-145)

  - calls [79](/03-queries-and-functions/#pdf-page-80)–[80](/03-queries-and-functions/#pdf-page-81)

  - dbid [75](/03-queries-and-functions/#pdf-page-76), [147](/05-shared-memory-and-io/#pdf-page-148)

  - local\_blks\_dirtied [144](/05-shared-memory-and-io/#pdf-page-145)

  - local\_blks\_hit [144](/05-shared-memory-and-io/#pdf-page-145)

  - local\_blks\_read [144](/05-shared-memory-and-io/#pdf-page-145)

  - local\_blks\_written [144](/05-shared-memory-and-io/#pdf-page-145)

  - max\_exec\_time [79](/03-queries-and-functions/#pdf-page-80)

  - max\_plan\_time [77](/03-queries-and-functions/#pdf-page-78)

  - mean\_exec\_time [79](/03-queries-and-functions/#pdf-page-80)

  - mean\_plan\_time [77](/03-queries-and-functions/#pdf-page-78)

  - min\_exec\_time [79](/03-queries-and-functions/#pdf-page-80)

  - min\_plan\_time [77](/03-queries-and-functions/#pdf-page-78)

  - plans [76](/03-queries-and-functions/#pdf-page-77), [78](/03-queries-and-functions/#pdf-page-79)–[79](/03-queries-and-functions/#pdf-page-80)

  - query [46](/02-activity-statistics/#pdf-page-47), [75](/03-queries-and-functions/#pdf-page-76)

  - queryid [75](/03-queries-and-functions/#pdf-page-76), [91](/03-queries-and-functions/#pdf-page-92)

  - rows [79](/03-queries-and-functions/#pdf-page-80)

  - shared\_blks\_dirtied [144](/05-shared-memory-and-io/#pdf-page-145)

  - shared\_blks\_hit [143](/05-shared-memory-and-io/#pdf-page-144)

  - shared\_blks\_read [144](/05-shared-memory-and-io/#pdf-page-145)

  - shared\_blks\_written [144](/05-shared-memory-and-io/#pdf-page-145)

  - stddev\_exec\_time [79](/03-queries-and-functions/#pdf-page-80)

  - stddev\_plan\_time [77](/03-queries-and-functions/#pdf-page-78)

  - temp\_blk\_read\_time [86](/03-queries-and-functions/#pdf-page-87), [147](/05-shared-memory-and-io/#pdf-page-148)

  - temp\_blks\_read [147](/05-shared-memory-and-io/#pdf-page-148)

  - temp\_blks\_written [147](/05-shared-memory-and-io/#pdf-page-148)

  - temp\_blk\_write\_time [86](/03-queries-and-functions/#pdf-page-87), [147](/05-shared-memory-and-io/#pdf-page-148)

  - toplevel [76](/03-queries-and-functions/#pdf-page-77), [94](/03-queries-and-functions/#pdf-page-95)

  - total\_exec\_time [79](/03-queries-and-functions/#pdf-page-80), [85](/03-queries-and-functions/#pdf-page-86), [89](/03-queries-and-functions/#pdf-page-90)

  - total\_plan\_time [76](/03-queries-and-functions/#pdf-page-77), [85](/03-queries-and-functions/#pdf-page-86)

  - total\_rows [83](/03-queries-and-functions/#pdf-page-84)

  - total\_time [79](/03-queries-and-functions/#pdf-page-80)

  - userid [75](/03-queries-and-functions/#pdf-page-76)

  - wal\_bytes [165](/06-write-ahead-log/#pdf-page-166)

  - wal\_fpi [165](/06-write-ahead-log/#pdf-page-166)

  - wal\_records [165](/06-write-ahead-log/#pdf-page-166)

- pg\_stat\_statements\_info [74](/03-queries-and-functions/#pdf-page-75), [85](/03-queries-and-functions/#pdf-page-86), [94](/03-queries-and-functions/#pdf-page-95)

- *pg\_stat\_statements.max* [74](/03-queries-and-functions/#pdf-page-75)–[75](/03-queries-and-functions/#pdf-page-76), [94](/03-queries-and-functions/#pdf-page-95)–[95](/03-queries-and-functions/#pdf-page-96)

- pg\_stat\_statements\_reset [74](/03-queries-and-functions/#pdf-page-75)

- *pg\_stat\_statements.save* [74](/03-queries-and-functions/#pdf-page-75)

- *pg\_stat\_statements.track* [74](/03-queries-and-functions/#pdf-page-75), [76](/03-queries-and-functions/#pdf-page-77), [94](/03-queries-and-functions/#pdf-page-95)

- *pg\_stat\_statements.track\_planning* [74](/03-queries-and-functions/#pdf-page-75)

- *pg\_stat\_statements.track\_utility* [74](/03-queries-and-functions/#pdf-page-75)

- pg\_stat\_subscription [176](/07-replication/#pdf-page-177), [189](/07-replication/#pdf-page-190)

- pg\_stat\_subscription\_stats [176](/07-replication/#pdf-page-177), [190](/07-replication/#pdf-page-191)

- pg\_stat\_sys\_indexes [110](/04-databases/#pdf-page-111)

- pg\_stat\_sys\_tables [110](/04-databases/#pdf-page-111), [200](/08-vacuum/#pdf-page-201)

- pgstattuple [210](/08-vacuum/#pdf-page-211)–[212](/08-vacuum/#pdf-page-213)

- pg\_stat\_user\_functions [72](/03-queries-and-functions/#pdf-page-73), [95](/03-queries-and-functions/#pdf-page-96)–[97](/03-queries-and-functions/#pdf-page-98)

- pg\_stat\_user\_indexes [109](/04-databases/#pdf-page-110)–[110](/04-databases/#pdf-page-111)

- `pg_stat_user_tables` [109](/04-databases/#pdf-page-110)–[110](/04-databases/#pdf-page-111), [112](/04-databases/#pdf-page-113)–[113](/04-databases/#pdf-page-114), [120](/04-databases/#pdf-page-121), [200](/08-vacuum/#pdf-page-201)

- pg\_stat\_wal [155](/05-shared-memory-and-io/#pdf-page-156), [161](/06-write-ahead-log/#pdf-page-162)–[162](/06-write-ahead-log/#pdf-page-163), [165](/06-write-ahead-log/#pdf-page-166)

- pg\_stat\_wal\_receiver [176](/07-replication/#pdf-page-177), [181](/07-replication/#pdf-page-182)–[182](/07-replication/#pdf-page-183)

- pg\_tables [104](/04-databases/#pdf-page-105)

- pg\_table\_size [117](/04-databases/#pdf-page-118), [119](/04-databases/#pdf-page-120)

- pg\_tablespace [102](/04-databases/#pdf-page-103), [120](/04-databases/#pdf-page-121), [131](/05-shared-memory-and-io/#pdf-page-132)

- pg\_tablespace\_location [118](/04-databases/#pdf-page-119)

- pg\_tablespace\_size [117](/04-databases/#pdf-page-118)–[118](/04-databases/#pdf-page-119)

<span id="pdf-page-244" class="pdf-anchor"></span>

- pg\_terminate\_backend [38](/02-activity-statistics/#pdf-page-39), [58](/02-activity-statistics/#pdf-page-59), [145](/05-shared-memory-and-io/#pdf-page-146)

- pg\_total\_relation\_size [117](/04-databases/#pdf-page-118), [119](/04-databases/#pdf-page-120)–[120](/04-databases/#pdf-page-121)

- pg\_upgrade [222](/09-operation-progress/#pdf-page-223)

- pg\_user [75](/03-queries-and-functions/#pdf-page-76)

- pg\_waldump [159](/06-write-ahead-log/#pdf-page-160), [161](/06-write-ahead-log/#pdf-page-162)

- pg\_walfile\_name [160](/06-write-ahead-log/#pdf-page-161)

- pg\_walinspect [159](/06-write-ahead-log/#pdf-page-160), [161](/06-write-ahead-log/#pdf-page-162)

- pidstat [30](/02-activity-statistics/#pdf-page-31)

- postgres [45](/02-activity-statistics/#pdf-page-46), [47](/02-activity-statistics/#pdf-page-48), [73](/03-queries-and-functions/#pdf-page-74), [103](/04-databases/#pdf-page-104), [146](/05-shared-memory-and-io/#pdf-page-147)

- postgres\_activity\_connections\_in\_flight [54](/02-activity-statistics/#pdf-page-55)

- postgres\_activity\_max\_seconds [60](/02-activity-statistics/#pdf-page-61)

- postgres\_checkpoints\_seconds\_total [153](/05-shared-memory-and-io/#pdf-page-154)

- postgres\_connected\_clients\_total [42](/02-activity-statistics/#pdf-page-43)

- postgres\_database\_checksum\_failures\_total [115](/04-databases/#pdf-page-116)

- postgres\_database\_conflicts\_total [115](/04-databases/#pdf-page-116)

- postgres\_database\_deadlocks\_total [115](/04-databases/#pdf-page-116)

- postgres\_database\_sessions\_total [115](/04-databases/#pdf-page-116)

- postgres\_database\_size\_bytes [121](/04-databases/#pdf-page-122)

- postgres\_database\_temp\_bytes\_total [146](/05-shared-memory-and-io/#pdf-page-147)

- postgres\_database\_tuples\_deleted\_total [108](/04-databases/#pdf-page-109)

- postgres\_database\_tuples\_fetched\_total [108](/04-databases/#pdf-page-109)

- postgres\_database\_tuples\_inserted\_total [108](/04-databases/#pdf-page-109)

- postgres\_database\_tuples\_returned\_total [108](/04-databases/#pdf-page-109)

- postgres\_database\_tuples\_updated\_total [108](/04-databases/#pdf-page-109)

- postgres\_database\_xact\_rollbacks\_total [115](/04-databases/#pdf-page-116)

- postgres\_fdw [103](/04-databases/#pdf-page-104)

- postgres\_index\_size\_bytes [121](/04-databases/#pdf-page-122)

- postgres\_service\_settings\_info [42](/02-activity-statistics/#pdf-page-43)

- postgres\_shared\_buffers\_all\_usage\_bytes [135](/05-shared-memory-and-io/#pdf-page-136)

- postgres\_statements\_calls\_total [80](/03-queries-and-functions/#pdf-page-81)

- postgres\_statements\_query\_info [77](/03-queries-and-functions/#pdf-page-78)

- postgres\_statements\_time\_seconds\_total [77](/03-queries-and-functions/#pdf-page-78)

- postgres\_table\_idx\_tup\_fetch\_total [113](/04-databases/#pdf-page-114)

- postgres\_table\_seq\_tup\_read\_total [113](/04-databases/#pdf-page-114)

- postgres\_table\_size\_bytes [121](/04-databases/#pdf-page-122)

- postgres\_table\_tuples\_deleted\_total [113](/04-databases/#pdf-page-114)

- postgres\_table\_tuples\_hot\_updated\_total [113](/04-databases/#pdf-page-114)

- postgres\_table\_tuples\_inserted\_total [113](/04-databases/#pdf-page-114)

- postgres\_table\_tuples\_updated\_total [113](/04-databases/#pdf-page-114)

- postmaster [28](/02-activity-statistics/#pdf-page-29)–[29](/02-activity-statistics/#pdf-page-30), [196](/08-vacuum/#pdf-page-197)

- Prometheus [235](/test-environment/#pdf-page-236)

- ps [29](/02-activity-statistics/#pdf-page-30)

- psql [17](/01-statistics-overview/#pdf-page-18), [23](/01-statistics-overview/#pdf-page-24)–[24](/01-statistics-overview/#pdf-page-25), [32](/02-activity-statistics/#pdf-page-33), [40](/02-activity-statistics/#pdf-page-41), [58](/02-activity-statistics/#pdf-page-59), [80](/03-queries-and-functions/#pdf-page-81), [84](/03-queries-and-functions/#pdf-page-85), [118](/04-databases/#pdf-page-119)

- public [103](/04-databases/#pdf-page-104)

## Q {#index-q}

- query [77](/03-queries-and-functions/#pdf-page-78)

- queryid [77](/03-queries-and-functions/#pdf-page-78)

## R {#index-r}

- rate [80](/03-queries-and-functions/#pdf-page-81), [97](/03-queries-and-functions/#pdf-page-98)

- REINDEX [18](/01-statistics-overview/#pdf-page-19), [221](/09-operation-progress/#pdf-page-222), [229](/09-operation-progress/#pdf-page-230)

- REINDEX CONCURRENTLY [212](/08-vacuum/#pdf-page-213), [229](/09-operation-progress/#pdf-page-230)–[230](/09-operation-progress/#pdf-page-231)

- ROLLBACK [30](/02-activity-statistics/#pdf-page-31), [38](/02-activity-statistics/#pdf-page-39), [115](/04-databases/#pdf-page-116)

## S {#index-s}

- *shared\_buffers* [134](/05-shared-memory-and-io/#pdf-page-135)

- *shared\_preload\_libraries* [73](/03-queries-and-functions/#pdf-page-74)–[74](/03-queries-and-functions/#pdf-page-75)

- startup [21](/01-statistics-overview/#pdf-page-22), [175](/07-replication/#pdf-page-176), [178](/07-replication/#pdf-page-179)–[179](/07-replication/#pdf-page-180), [182](/07-replication/#pdf-page-183)

- state [54](/02-activity-statistics/#pdf-page-55), [60](/02-activity-statistics/#pdf-page-61)

- *statement\_timeout* [145](/05-shared-memory-and-io/#pdf-page-146)

- stats [43](/02-activity-statistics/#pdf-page-44)

- stats collector [23](/01-statistics-overview/#pdf-page-24)

- *synchronous\_commit* [67](/02-activity-statistics/#pdf-page-68), [161](/06-write-ahead-log/#pdf-page-162), [164](/06-write-ahead-log/#pdf-page-165), [174](/07-replication/#pdf-page-175), [179](/07-replication/#pdf-page-180)

## T {#index-t}

- *temp\_buffers* [18](/01-statistics-overview/#pdf-page-19), [144](/05-shared-memory-and-io/#pdf-page-145)

- template0 [101](/04-databases/#pdf-page-102), [103](/04-databases/#pdf-page-104)

- template1 [102](/04-databases/#pdf-page-103)–[103](/04-databases/#pdf-page-104)

- *temp\_tablespaces* [148](/05-shared-memory-and-io/#pdf-page-149)–[149](/05-shared-memory-and-io/#pdf-page-150)

- text [125](/04-databases/#pdf-page-126)

- TOAST [106](/04-databases/#pdf-page-107)

- top [29](/02-activity-statistics/#pdf-page-30)

- Top-K [78](/03-queries-and-functions/#pdf-page-79), [112](/04-databases/#pdf-page-113)

- topk\_avg [78](/03-queries-and-functions/#pdf-page-79)

- *track\_activity\_query\_size* [34](/02-activity-statistics/#pdf-page-35)

- *track\_commit\_timestamp* [137](/05-shared-memory-and-io/#pdf-page-138)

- *track\_functions* [95](/03-queries-and-functions/#pdf-page-96)

- *track\_io\_timing* [80](/03-queries-and-functions/#pdf-page-81), [86](/03-queries-and-functions/#pdf-page-87), [139](/05-shared-memory-and-io/#pdf-page-140)

- *track\_utility* [46](/02-activity-statistics/#pdf-page-47)

- *track\_wal\_io\_timing* [162](/06-write-ahead-log/#pdf-page-163)

<span id="pdf-page-245" class="pdf-anchor"></span>

- true [167](/06-write-ahead-log/#pdf-page-168), [170](/06-write-ahead-log/#pdf-page-171)

- TRUNCATE [68](/02-activity-statistics/#pdf-page-69)

- type [60](/02-activity-statistics/#pdf-page-61)

## U {#index-u}

- UPDATE [107](/04-databases/#pdf-page-108), [109](/04-databases/#pdf-page-110), [196](/08-vacuum/#pdf-page-197)

- user [42](/02-activity-statistics/#pdf-page-43), [60](/02-activity-statistics/#pdf-page-61), [77](/03-queries-and-functions/#pdf-page-78)

## V {#index-v}

- VACUUM [18](/01-statistics-overview/#pdf-page-19), [196](/08-vacuum/#pdf-page-197), [198](/08-vacuum/#pdf-page-199), [200](/08-vacuum/#pdf-page-201)–[201](/08-vacuum/#pdf-page-202), [214](/08-vacuum/#pdf-page-215), [222](/09-operation-progress/#pdf-page-223)

- VACUUM FREEZE [203](/08-vacuum/#pdf-page-204)–[204](/08-vacuum/#pdf-page-205)

- VACUUM FULL [212](/08-vacuum/#pdf-page-213)–[213](/08-vacuum/#pdf-page-214), [221](/09-operation-progress/#pdf-page-222), [226](/09-operation-progress/#pdf-page-227)–[228](/09-operation-progress/#pdf-page-229)

- *vacuum\_failsafe\_age* [209](/08-vacuum/#pdf-page-210)

- *vacuum\_freeze\_min\_age* [204](/08-vacuum/#pdf-page-205)

- *vacuum\_freeze\_table\_age* [204](/08-vacuum/#pdf-page-205)

- Victoriametrics [235](/test-environment/#pdf-page-236)

- Vmagent [235](/test-environment/#pdf-page-236)

- vmstat [30](/02-activity-statistics/#pdf-page-31)

## W {#index-w}

- *wal\_block\_size* [159](/06-write-ahead-log/#pdf-page-160)

- *wal\_buffers* [161](/06-write-ahead-log/#pdf-page-162)–[162](/06-write-ahead-log/#pdf-page-163)

- *wal\_keep\_segments* [183](/07-replication/#pdf-page-184)

- *wal\_keep\_size* [183](/07-replication/#pdf-page-184), [185](/07-replication/#pdf-page-186)

- walreceiver [21](/01-statistics-overview/#pdf-page-22), [174](/07-replication/#pdf-page-175)–[176](/07-replication/#pdf-page-177), [178](/07-replication/#pdf-page-179)–[179](/07-replication/#pdf-page-180), [181](/07-replication/#pdf-page-182)–[182](/07-replication/#pdf-page-183)

- *wal\_segment\_size* [159](/06-write-ahead-log/#pdf-page-160)

- walsender [21](/01-statistics-overview/#pdf-page-22), [175](/07-replication/#pdf-page-176)–[179](/07-replication/#pdf-page-180), [187](/07-replication/#pdf-page-188)–[188](/07-replication/#pdf-page-189), [192](/07-replication/#pdf-page-193), [206](/08-vacuum/#pdf-page-207), [224](/09-operation-progress/#pdf-page-225)–[225](/09-operation-progress/#pdf-page-226)

- *wal\_sync\_method* [68](/02-activity-statistics/#pdf-page-69), [162](/06-write-ahead-log/#pdf-page-163)

- walwriter [161](/06-write-ahead-log/#pdf-page-162), [164](/06-write-ahead-log/#pdf-page-165)–[165](/06-write-ahead-log/#pdf-page-166)

- *work\_mem* [18](/01-statistics-overview/#pdf-page-19), [20](/01-statistics-overview/#pdf-page-21), [144](/05-shared-memory-and-io/#pdf-page-145)–[145](/05-shared-memory-and-io/#pdf-page-146)

## А {#index-а}

- 自动清理 [22](/01-statistics-overview/#pdf-page-23), [196](/08-vacuum/#pdf-page-197)–[220](/08-vacuum/#pdf-page-221), [222](/09-operation-progress/#pdf-page-223)

  - 持续时间 [214](/08-vacuum/#pdf-page-215)

  - 延迟 [203](/08-vacuum/#pdf-page-204), [206](/08-vacuum/#pdf-page-207)

  - 触发 [197](/08-vacuum/#pdf-page-198)

  - 阶段 [217](/08-vacuum/#pdf-page-218)

- 活动 [27](/02-activity-statistics/#pdf-page-28)

- 日志归档 [21](/01-statistics-overview/#pdf-page-22), [166](/06-write-ahead-log/#pdf-page-167)–[172](/06-write-ahead-log/#pdf-page-173)

## Б {#index-б}

- 数据库 [37](/02-activity-statistics/#pdf-page-38), [44](/02-activity-statistics/#pdf-page-45), [103](/04-databases/#pdf-page-104), [107](/04-databases/#pdf-page-108), [119](/04-databases/#pdf-page-120)

  - 输入/输出 [139](/05-shared-memory-and-io/#pdf-page-140)

- 块，*参见* 页面

- 锁 [30](/02-activity-statistics/#pdf-page-31), [34](/02-activity-statistics/#pdf-page-35)–[35](/02-activity-statistics/#pdf-page-36), [51](/02-activity-statistics/#pdf-page-52), [68](/02-activity-statistics/#pdf-page-69), [213](/08-vacuum/#pdf-page-214), [226](/09-operation-progress/#pdf-page-227)

  - 树 [65](/02-activity-statistics/#pdf-page-66)

  - 避免 [120](/04-databases/#pdf-page-121)

- 缓冲区缓存 [19](/01-statistics-overview/#pdf-page-20), [130](/05-shared-memory-and-io/#pdf-page-131)

  - 淘汰 [132](/05-shared-memory-and-io/#pdf-page-133), [150](/05-shared-memory-and-io/#pdf-page-151)

  - 脏缓冲区 [132](/05-shared-memory-and-io/#pdf-page-133), [150](/05-shared-memory-and-io/#pdf-page-151), [154](/05-shared-memory-and-io/#pdf-page-155)

  - 固定 [132](/05-shared-memory-and-io/#pdf-page-133)

  - 效率 [139](/05-shared-memory-and-io/#pdf-page-140)

- 后端进程 [17](/01-statistics-overview/#pdf-page-18), [29](/02-activity-statistics/#pdf-page-30), [33](/02-activity-statistics/#pdf-page-34), [41](/02-activity-statistics/#pdf-page-42)

## В {#index-в}

- 输入/输出 [86](/03-queries-and-functions/#pdf-page-87), [129](/05-shared-memory-and-io/#pdf-page-130), [139](/05-shared-memory-and-io/#pdf-page-140)

  - 同步 [152](/05-shared-memory-and-io/#pdf-page-153), [164](/06-write-ahead-log/#pdf-page-165)

- 行版本 [105](/04-databases/#pdf-page-106), [196](/08-vacuum/#pdf-page-197)

- 死锁 [55](/02-activity-statistics/#pdf-page-56)

## Г {#index-г}

- 界限

  - 可见性界限 [35](/02-activity-statistics/#pdf-page-36), [178](/07-replication/#pdf-page-179), [185](/07-replication/#pdf-page-186), [207](/08-vacuum/#pdf-page-208)

  - 冻结界限 [203](/08-vacuum/#pdf-page-204), [205](/08-vacuum/#pdf-page-206)–[206](/08-vacuum/#pdf-page-207)

## Ж {#index-ж}

- 服务器日志 [21](/01-statistics-overview/#pdf-page-22), [56](/02-activity-statistics/#pdf-page-57), [125](/04-databases/#pdf-page-126), [147](/05-shared-memory-and-io/#pdf-page-148), [187](/07-replication/#pdf-page-188), [216](/08-vacuum/#pdf-page-217)

- 事务日志 [18](/01-statistics-overview/#pdf-page-19), [20](/01-statistics-overview/#pdf-page-21), [126](/04-databases/#pdf-page-127), [150](/05-shared-memory-and-io/#pdf-page-151), [157](/06-write-ahead-log/#pdf-page-158), [174](/07-replication/#pdf-page-175)

  - 归档 [21](/01-statistics-overview/#pdf-page-22), [166](/06-write-ahead-log/#pdf-page-167)–[172](/06-write-ahead-log/#pdf-page-173)

  - 重放 [175](/07-replication/#pdf-page-176)

## З {#index-з}

- 缓冲区固定 [132](/05-shared-memory-and-io/#pdf-page-133)

- 冻结 [202](/08-vacuum/#pdf-page-203)

- 查询 [17](/01-statistics-overview/#pdf-page-18), [30](/02-activity-statistics/#pdf-page-31), [33](/02-activity-statistics/#pdf-page-34)–[34](/02-activity-statistics/#pdf-page-35), [71](/03-queries-and-functions/#pdf-page-72)

  - PromQL [77](/03-queries-and-functions/#pdf-page-78)

  - 输入/输出 [86](/03-queries-and-functions/#pdf-page-87), [143](/05-shared-memory-and-io/#pdf-page-144)

  - 持续时间 [59](/02-activity-statistics/#pdf-page-60), [79](/03-queries-and-functions/#pdf-page-80), [84](/03-queries-and-functions/#pdf-page-85)

  - 日志记录 [165](/06-write-ahead-log/#pdf-page-166)

  - 执行 [79](/03-queries-and-functions/#pdf-page-80)

  - 元数据 [75](/03-queries-and-functions/#pdf-page-76)

  - 规范化 [74](/03-queries-and-functions/#pdf-page-75)

  - 规划 [17](/01-statistics-overview/#pdf-page-18), [76](/03-queries-and-functions/#pdf-page-77), [78](/03-queries-and-functions/#pdf-page-79)

## И {#index-и}

- 多余访问 [110](/04-databases/#pdf-page-111)

<span id="pdf-page-246" class="pdf-anchor"></span>

- 索引 [104](/04-databases/#pdf-page-105), [107](/04-databases/#pdf-page-108), [110](/04-databases/#pdf-page-111), [120](/04-databases/#pdf-page-121)

  - 输入/输出 [140](/05-shared-memory-and-io/#pdf-page-141)

  - 创建 [229](/09-operation-progress/#pdf-page-230)

## К {#index-к}

- 映射

  - 可见性映射 [105](/04-databases/#pdf-page-106)

  - 空闲空间映射 [105](/04-databases/#pdf-page-106)

- 数据目录 [100](/04-databases/#pdf-page-101), [123](/04-databases/#pdf-page-124)

- SLRU 缓存 [137](/05-shared-memory-and-io/#pdf-page-138)

- 集群

  - 数据库集簇 [100](/04-databases/#pdf-page-101)

  - 复制集群 [173](/07-replication/#pdf-page-174)

- 客户端进程，*参见* 后端进程

- 命令 [17](/01-statistics-overview/#pdf-page-18), [30](/02-activity-statistics/#pdf-page-31), [71](/03-queries-and-functions/#pdf-page-72)

- 内存上下文 [137](/05-shared-memory-and-io/#pdf-page-138)

- 校验和 [115](/04-databases/#pdf-page-116)

- 检查点 [22](/01-statistics-overview/#pdf-page-23), [150](/05-shared-memory-and-io/#pdf-page-151), [158](/06-write-ahead-log/#pdf-page-159)

  - 配置 [151](/05-shared-memory-and-io/#pdf-page-152)

- 冲突

  - 恢复 [190](/07-replication/#pdf-page-191)

  - 逻辑复制 [190](/07-replication/#pdf-page-191)

- 元组 [105](/04-databases/#pdf-page-106)

## Л {#index-л}

- 时间线 [159](/06-write-ahead-log/#pdf-page-160)

## М {#index-м}

- 等待标记 [52](/02-activity-statistics/#pdf-page-53)

- 多事务 [204](/08-vacuum/#pdf-page-205)

## Н {#index-н}

- 工作负载 [17](/01-statistics-overview/#pdf-page-18), [28](/02-activity-statistics/#pdf-page-29), [72](/03-queries-and-functions/#pdf-page-73), [80](/03-queries-and-functions/#pdf-page-81), [107](/04-databases/#pdf-page-108)

## О {#index-о}

- 反馈 [178](/07-replication/#pdf-page-179), [192](/07-replication/#pdf-page-193), [206](/08-vacuum/#pdf-page-207)

- 等待 [34](/02-activity-statistics/#pdf-page-35), [50](/02-activity-statistics/#pdf-page-51)–[51](/02-activity-statistics/#pdf-page-52)

  - 锁 [53](/02-activity-statistics/#pdf-page-54)

  - 树 [65](/02-activity-statistics/#pdf-page-66)

  - 持续时间 [61](/02-activity-statistics/#pdf-page-62)

  - 标记 [52](/02-activity-statistics/#pdf-page-53)

- 关系 [105](/04-databases/#pdf-page-106)

- 清理 [22](/01-statistics-overview/#pdf-page-23), [195](/08-vacuum/#pdf-page-196)

  - 持续时间 [214](/08-vacuum/#pdf-page-215)

  - 延迟 [203](/08-vacuum/#pdf-page-204), [206](/08-vacuum/#pdf-page-207)

  - 阶段 [217](/08-vacuum/#pdf-page-218)

- 错误 [114](/04-databases/#pdf-page-115), [190](/07-replication/#pdf-page-191), [210](/08-vacuum/#pdf-page-211)

## П {#index-п}

- 内存

  - 本地 [18](/01-statistics-overview/#pdf-page-19), [137](/05-shared-memory-and-io/#pdf-page-138)

  - 共享 [19](/01-statistics-overview/#pdf-page-20), [130](/05-shared-memory-and-io/#pdf-page-131), [135](/05-shared-memory-and-io/#pdf-page-136), [158](/06-write-ahead-log/#pdf-page-159)

- 规划 [17](/01-statistics-overview/#pdf-page-18), [76](/03-queries-and-functions/#pdf-page-77), [78](/03-queries-and-functions/#pdf-page-79)

- 连接，*参见* 会话

- 订阅 [175](/07-replication/#pdf-page-176), [187](/07-replication/#pdf-page-188), [189](/07-replication/#pdf-page-190)

- 发布 [175](/07-replication/#pdf-page-176), [187](/07-replication/#pdf-page-188)

## Р {#index-р}

- 膨胀 [57](/02-activity-statistics/#pdf-page-58), [192](/07-replication/#pdf-page-193), [197](/08-vacuum/#pdf-page-198), [210](/08-vacuum/#pdf-page-211)

- 扩展 [23](/01-statistics-overview/#pdf-page-24), [72](/03-queries-and-functions/#pdf-page-73)

- 备份 [224](/09-operation-progress/#pdf-page-225)

- 复制标识符 [189](/07-replication/#pdf-page-190)

- 复制 [21](/01-statistics-overview/#pdf-page-22), [173](/07-replication/#pdf-page-174)

  - 延迟 [174](/07-replication/#pdf-page-175)

  - 冲突 [190](/07-replication/#pdf-page-191)

  - 滞后 [178](/07-replication/#pdf-page-179), [185](/07-replication/#pdf-page-186)–[186](/07-replication/#pdf-page-187)

  - 槽 [175](/07-replication/#pdf-page-176), [183](/07-replication/#pdf-page-184), [185](/07-replication/#pdf-page-186), [188](/07-replication/#pdf-page-189)

## С {#index-с}

- 会话 [17](/01-statistics-overview/#pdf-page-18), [28](/02-activity-statistics/#pdf-page-29), [33](/02-activity-statistics/#pdf-page-34), [37](/02-activity-statistics/#pdf-page-38), [39](/02-activity-statistics/#pdf-page-40), [41](/02-activity-statistics/#pdf-page-42)

  - 异常终止 [46](/02-activity-statistics/#pdf-page-47), [115](/04-databases/#pdf-page-116)

  - 状态 [49](/02-activity-statistics/#pdf-page-50)

- 段 [105](/04-databases/#pdf-page-106), [149](/05-shared-memory-and-io/#pdf-page-150), [158](/06-write-ahead-log/#pdf-page-159)

- 同步 [174](/07-replication/#pdf-page-175)

- 系统目录 [40](/02-activity-statistics/#pdf-page-41), [102](/04-databases/#pdf-page-103), [211](/08-vacuum/#pdf-page-212)

- 存储分支 [105](/04-databases/#pdf-page-106), [119](/04-databases/#pdf-page-120)

- 复制槽 [175](/07-replication/#pdf-page-176), [183](/07-replication/#pdf-page-184), [185](/07-replication/#pdf-page-186), [188](/07-replication/#pdf-page-189)

- 快照 [196](/08-vacuum/#pdf-page-197)

- 连接，*参见* 会话

- 规划器统计信息 [200](/08-vacuum/#pdf-page-201), [222](/09-operation-progress/#pdf-page-223)

  - 阶段 [223](/09-operation-progress/#pdf-page-224)

- 代价 [76](/03-queries-and-functions/#pdf-page-77)

- 页面 [19](/01-statistics-overview/#pdf-page-20), [106](/04-databases/#pdf-page-107), [134](/05-shared-memory-and-io/#pdf-page-135), [159](/06-write-ahead-log/#pdf-page-160), [175](/07-replication/#pdf-page-176)

  - 整页镜像 [151](/05-shared-memory-and-io/#pdf-page-152), [162](/06-write-ahead-log/#pdf-page-163)

- 模式 [103](/04-databases/#pdf-page-104)

## Т {#index-т}

- 表 [104](/04-databases/#pdf-page-105), [107](/04-databases/#pdf-page-108), [109](/04-databases/#pdf-page-110), [112](/04-databases/#pdf-page-113), [119](/04-databases/#pdf-page-120)

  - 输入/输出 [140](/05-shared-memory-and-io/#pdf-page-141)

- 表空间 [101](/04-databases/#pdf-page-102), [118](/04-databases/#pdf-page-119)

<span id="pdf-page-247" class="pdf-anchor"></span>

- 事务 [30](/02-activity-statistics/#pdf-page-31), [33](/02-activity-statistics/#pdf-page-34), [38](/02-activity-statistics/#pdf-page-39), [44](/02-activity-statistics/#pdf-page-45)

  - 空闲 [56](/02-activity-statistics/#pdf-page-57)

  - 持续时间 [59](/02-activity-statistics/#pdf-page-60)

  - 标识符 [202](/08-vacuum/#pdf-page-203), [206](/08-vacuum/#pdf-page-207)

  - 回滚 [114](/04-databases/#pdf-page-115)

## Ф {#index-ф}

- 文件

  - 临时 [20](/01-statistics-overview/#pdf-page-21), [127](/04-databases/#pdf-page-128), [144](/05-shared-memory-and-io/#pdf-page-145)–[149](/05-shared-memory-and-io/#pdf-page-150)

  - 关系 [105](/04-databases/#pdf-page-106)

- 后台写入 [22](/01-statistics-overview/#pdf-page-23)

- 后台进程 [33](/02-activity-statistics/#pdf-page-34), [41](/02-activity-statistics/#pdf-page-42)

  - 输入/输出 [149](/05-shared-memory-and-io/#pdf-page-150)

- 函数

  - 用户函数 [95](/03-queries-and-functions/#pdf-page-96)

  - 系统管理函数 [117](/04-databases/#pdf-page-118)

## Э {#index-э}

- 实例 [100](/04-databases/#pdf-page-101)