主题索引

A

• address 42

• ANALYZE 198, 200, 222–224

• application_name 33, 44

• archive_command 167, 171

• archiver 21, 167–168

• archive_timeout 168

• atop 29

• autovacuum 203–204

• autovacuum launcher 22, 196, 200

• autovacuum worker 22, 197

• autovacuum_freeze_max_age 204–205, 208

• autovacuum_max_workers 214

• autovacuum_naptime 22, 199–200, 215

• autovacuum_vacuum_scale_factor 198

• autovacuum_vacuum_threshold 198

• autovacuum_work_mem 18, 217–218

B

• background writer 20, 22, 149

• BEGIN 30, 44

• bgwriter_lru_maxpages 150, 154

• bgwriter_lru_multiplier 150

• buffers_backend 154

• bytea 125

C

• CHECKPOINT 151–152

• checkpointer 20, 22, 149

• checkpoint_timeout 151, 163

• clock_timestamp 58

• CLUSTER 221, 226–227

• COMMIT 30, 38, 67, 161

• compute_query_id 91

• convert_from 125

• COPY 203, 221–222, 231–233

• count 215

• CREATE INDEX 18, 198, 221, 229

• CREATE INDEX CONCURRENTLY 229–230

• cron 58, 196

• current_setting 134

D

• database 42, 60, 77

• DataGrip 17, 23

• DBeaver 23

• dblink 103

• deadlock_timeout 55, 68

• default_statistics_target 222

• DELETE 107, 109, 196

• delta 122

• docker 236

• docker-compose 236

• dstat 30

E

• END 30, 44, 67

• EXPLAIN 91, 161, 222

F

• false 170

• FPI 151, 162

• fsync 152

• full_page_writes 94, 151

G

• getrusage 72, 89

• Grafana 235, 238

H

• hot_standby_feedback 178, 192, 206

• HTAP 214

• htop 29

I

• idle_in_transaction_session_timeout 38, 58

• increase 47, 97

• initdb 100–101

• INSERT 107, 109, 196

• iostat 30

K

• Kubernetes 46, 56

L

• LIMIT 82, 84

• LISTEN 138

• log_autovacuum_min_duration 216–217

• log_directory 126

• logging_collector 126

• logical replication worker 187

• logical_decoding_work_mem 188–189

• log_line_prefix 56, 91

• log_lock_waits 68

• log_min_duration_statement 56

• log_statement 56

• log_temp_files 145, 147

• LSN 159, 178

M

• maintenance_work_mem 18, 217–218

• make 236

• max_connections 42, 46

• max_slot_wal_keep_size 183–185

• max_standby_archive_delay 191

• max_standby_streaming_delay 190–192

• max_wal_senders 188

• max_wal_size 151–152, 185–186

• maxwritten_clean 154

• mode 78, 85, 88

N

• nicstat 30

• NOTIFY 138

• now 58

O

• OLAP 65, 111

• OLTP 74, 76, 82, 111

• other 78, 82

P

• pg_activity 24

• pgAdmin 17, 23–24

• pg_authid 117

• pg_backend_memory_contexts 136

• pg_backend_pid 64

• pg_basebackup 224–225

• pgbench 44–45, 48, 96, 111, 113, 205, 235

• pgbench_accounts 135, 143, 166, 200, 204, 208, 211–212, 215, 219–220, 233

• pgbench_branches 199, 211–212, 216

• pgbench_history 143

• pgbench_tellers 199, 216

• pg_blocking_pids 66

• pg_buffercache 96, 130–131, 133, 135–136, 138

• pg_buffercache_pages 96–97

• pgcenter 24, 93–94

• pg_class 104–105, 120–121, 131, 203, 218

  • relfilenode 123, 131

  • relfrozenxid 203–205, 209

  • relminmxid 204

  • reltuples 198, 233

• pgcompacttable 213

• pg_current_wal_flush_lsn 160

• pg_current_wal_insert_lsn 160

• pg_current_wal_lsn 160, 178, 185

• pg_database 75, 103

  • datfrozenxid 35, 205–206, 208

  • datminmxid 206

  • oid 103, 131

• pg_database_size 117, 119

• pg_default 101–102, 127, 149

• pg_dump 203, 222, 231, 233

• pg_filenode_relation 123

• pg_get_userbyid 75

• pg_global 102

• pg_index 104, 120–121

• pg_indexes 104, 121

• pg_indexes_size 117, 119

• pg_is_in_recovery 182

• pg_last_wal_receive_lsn 182

• pg_last_wal_replay_lsn 182

• pg_locks 31, 35–37, 39, 53, 63–66, 121, 133, 221

  • granted 36, 53, 61, 64–65

  • waitstart 36, 61, 63, 65–66

• pg_lock_status 36

• pg_log_backend_memory_contexts 136–137

• pg_ls_archive_statusdir 124, 127, 170

• pg_ls_dir 124, 170

• pg_ls_logdir 124–126

• pg_ls_logicalmapdir 124, 127

• pg_ls_logicalsnapdir 124, 127

• pg_lsn 178

• pg_ls_replslotdir 124, 128

• pg_ls_tmpdir 124, 127

• pg_ls_waldir 124, 126–127

• pg_monitor 126–128

• pg_namespace 104

• pg_prepared_xacts 206

• pg_read_binary_file 125

• pg_read_file 117, 125

• pg_read_server_files 117

• pg_relation 105

• pg_relation_filenode 123

• pg_relation_filepath 123, 132

• pg_relation_size 117, 119–120, 232

• pg_repack 213

• pg_replication_slots 176, 183–186

  • xmin 184–185, 192, 206

• pg_restore 231

• pgSCV 235

• pg_shmem_allocations 130, 135–136

• pg_size_bytes 118

• pg_size_pretty 118

• pg_squeeze 213

• pg_stat_activity 31–32, 34–40, 50–51, 58–60, 64–66, 91, 133, 177, 213, 215–217, 219, 221, 223, 226–227, 232

  • application_name 33

  • backend_start 33, 214

  • backend_type 33, 41, 214–215

  • backend_xid 35, 206

  • backend_xmin 35

  • client_addr 33, 40

  • client_port 33

  • datid 34

  • datname 33, 40, 214

  • leader_pid 34

  • pid 34, 213

  • query 34, 214

  • queryid 34, 91

  • query_start 34, 59–60

  • state 34, 49, 51, 53–55, 60, 65, 214, 226

  • state_change 34, 63, 65

  • usename 33, 40

  • usesysid 34

  • wait_event 34, 51, 66, 214

  • wait_event_type 34, 51, 53, 55, 60, 66, 214

  • waiting 51

  • xact_start 34, 59–60, 214

• pg_stat_all_indexes 110

• pg_stat_all_tables 110, 198, 200

• pg_stat_archiver 167, 170

• pg_stat_bgwriter 150

• pg_stat_database 31, 37, 39–40, 44–47, 107, 110, 112, 114, 139, 143–149

  • active_time 39

  • blk_read_time 139–140

  • blks_hit 139

  • blks_read 139

  • blk_write_time 139–140

  • checksum_failures 115

  • checksum_last_failure 115

  • conflicts 115, 191–192

  • deadlocks 55, 115

  • idle_in_transaction_time 39

  • numbackends 37

  • sessions 38, 48

  • sessions_abandoned 38, 48, 115

  • sessions_fatal 38, 115

  • sessions_killed 38, 115

  • session_time 38

  • state 50

  • stats_reset 39, 145

  • temp_bytes 145–146

  • temp_files 145

  • tup_deleted 107

  • tup_fetched 107

  • tup_inserted 107

  • tup_returned 107

  • tup_updated 107

  • xact_commit 38, 44

  • xact_rollback 38, 44, 114–115

• pg_stat_database_conflicts 173, 176, 191

• pg_stat_file 125

• pg_stat_get_activity 32

• pg_stat_get_autovacuum_count 200

• pg_statio_all_indexes 139, 141

• pg_statio_all_sequences 139

• pg_statio_all_tables 139–140

• pg_statistic 222

• pg_statistics 222

• pg_stat_kcache 72, 89

• pg_stat_monitor 72

• pg_stat_progress_analyze 221, 223

• pg_stat_progress_basebackup 221, 225

• pg_stat_progress_cluster 221, 226–227

• pg_stat_progress_copy 221, 231, 233

• pg_stat_progress_create_index 221, 229–230

• pg_stat_progress_vacuum 213, 217, 219, 221

• pg_stat_replication 176–177, 182

  • backend_xmin 178, 192

• pg_stat_replication_slots 155, 176, 188

• pgstats 24, 222

• pg_stat_slru 138

• pg_stat_statements 34, 46, 72–76, 79–80, 86, 91–97, 141, 143–149, 161–162, 165–166

  • blk_read_time 79–80, 86, 144

  • blks_dirtied 141

  • blks_written 141

  • blk_write_time 79–80, 86, 144

  • calls 79–80

  • dbid 75, 147

  • local_blks_dirtied 144

  • local_blks_hit 144

  • local_blks_read 144

  • local_blks_written 144

  • max_exec_time 79

  • max_plan_time 77

  • mean_exec_time 79

  • mean_plan_time 77

  • min_exec_time 79

  • min_plan_time 77

  • plans 76, 78–79

  • query 46, 75

  • queryid 75, 91

  • rows 79

  • shared_blks_dirtied 144

  • shared_blks_hit 143

  • shared_blks_read 144

  • shared_blks_written 144

  • stddev_exec_time 79

  • stddev_plan_time 77

  • temp_blk_read_time 86, 147

  • temp_blks_read 147

  • temp_blks_written 147

  • temp_blk_write_time 86, 147

  • toplevel 76, 94

  • total_exec_time 79, 85, 89

  • total_plan_time 76, 85

  • total_rows 83

  • total_time 79

  • userid 75

  • wal_bytes 165

  • wal_fpi 165

  • wal_records 165

• pg_stat_statements_info 74, 85, 94

• pg_stat_statements.max 74–75, 94–95

• pg_stat_statements_reset 74

• pg_stat_statements.save 74

• pg_stat_statements.track 74, 76, 94

• pg_stat_statements.track_planning 74

• pg_stat_statements.track_utility 74

• pg_stat_subscription 176, 189

• pg_stat_subscription_stats 176, 190

• pg_stat_sys_indexes 110

• pg_stat_sys_tables 110, 200

• pgstattuple 210–212

• pg_stat_user_functions 72, 95–97

• pg_stat_user_indexes 109–110

• pg_stat_user_tables 109–110, 112–113, 120, 200

• pg_stat_wal 155, 161–162, 165

• pg_stat_wal_receiver 176, 181–182

• pg_tables 104

• pg_table_size 117, 119

• pg_tablespace 102, 120, 131

• pg_tablespace_location 118

• pg_tablespace_size 117–118

• pg_terminate_backend 38, 58, 145

• pg_total_relation_size 117, 119–120

• pg_upgrade 222

• pg_user 75

• pg_waldump 159, 161

• pg_walfile_name 160

• pg_walinspect 159, 161

• pidstat 30

• postgres 45, 47, 73, 103, 146

• postgres_activity_connections_in_flight 54

• postgres_activity_max_seconds 60

• postgres_checkpoints_seconds_total 153

• postgres_connected_clients_total 42

• postgres_database_checksum_failures_total 115

• postgres_database_conflicts_total 115

• postgres_database_deadlocks_total 115

• postgres_database_sessions_total 115

• postgres_database_size_bytes 121

• postgres_database_temp_bytes_total 146

• postgres_database_tuples_deleted_total 108

• postgres_database_tuples_fetched_total 108

• postgres_database_tuples_inserted_total 108

• postgres_database_tuples_returned_total 108

• postgres_database_tuples_updated_total 108

• postgres_database_xact_rollbacks_total 115

• postgres_fdw 103

• postgres_index_size_bytes 121

• postgres_service_settings_info 42

• postgres_shared_buffers_all_usage_bytes 135

• postgres_statements_calls_total 80

• postgres_statements_query_info 77

• postgres_statements_time_seconds_total 77

• postgres_table_idx_tup_fetch_total 113

• postgres_table_seq_tup_read_total 113

• postgres_table_size_bytes 121

• postgres_table_tuples_deleted_total 113

• postgres_table_tuples_hot_updated_total 113

• postgres_table_tuples_inserted_total 113

• postgres_table_tuples_updated_total 113

• postmaster 28–29, 196

• Prometheus 235

• ps 29

• psql 17, 23–24, 32, 40, 58, 80, 84, 118

• public 103

Q

• query 77

• queryid 77

R

• rate 80, 97

• REINDEX 18, 221, 229

• REINDEX CONCURRENTLY 212, 229–230

• ROLLBACK 30, 38, 115

S

• shared_buffers 134

• shared_preload_libraries 73–74

• startup 21, 175, 178–179, 182

• state 54, 60

• statement_timeout 145

• stats 43

• stats collector 23

• synchronous_commit 67, 161, 164, 174, 179

T

• temp_buffers 18, 144

• template0 101, 103

• template1 102–103

• temp_tablespaces 148–149

• text 125

• TOAST 106

• top 29

• Top-K 78, 112

• topk_avg 78

• track_activity_query_size 34

• track_commit_timestamp 137

• track_functions 95

• track_io_timing 80, 86, 139

• track_utility 46

• track_wal_io_timing 162

• true 167, 170

• TRUNCATE 68

• type 60

U

• UPDATE 107, 109, 196

• user 42, 60, 77

V

• VACUUM 18, 196, 198, 200–201, 214, 222

• VACUUM FREEZE 203–204

• VACUUM FULL 212–213, 221, 226–228

• vacuum_failsafe_age 209

• vacuum_freeze_min_age 204

• vacuum_freeze_table_age 204

• Victoriametrics 235

• Vmagent 235

• vmstat 30

W

• wal_block_size 159

• wal_buffers 161–162

• wal_keep_segments 183

• wal_keep_size 183, 185

• walreceiver 21, 174–176, 178–179, 181–182

• wal_segment_size 159

• walsender 21, 175–179, 187–188, 192, 206, 224–225

• wal_sync_method 68, 162

• walwriter 161, 164–165

• work_mem 18, 20, 144–145

А

• 自动清理 22, 196–220, 222

  • 持续时间 214

  • 延迟 203, 206

  • 触发 197

  • 阶段 217

• 活动 27

• 日志归档 21, 166–172

Б

• 数据库 37, 44, 103, 107, 119

  • 输入/输出 139

• 块，参见 页面

• 锁 30, 34–35, 51, 68, 213, 226

  • 树 65

  • 避免 120

• 缓冲区缓存 19, 130

  • 淘汰 132, 150

  • 脏缓冲区 132, 150, 154

  • 固定 132

  • 效率 139

• 后端进程 17, 29, 33, 41

В

• 输入/输出 86, 129, 139

  • 同步 152, 164

• 行版本 105, 196

• 死锁 55

Г

• 界限

  • 可见性界限 35, 178, 185, 207

  • 冻结界限 203, 205–206

Ж

• 服务器日志 21, 56, 125, 147, 187, 216

• 事务日志 18, 20, 126, 150, 157, 174

  • 归档 21, 166–172

  • 重放 175

З

• 缓冲区固定 132

• 冻结 202

• 查询 17, 30, 33–34, 71

  • PromQL 77

  • 输入/输出 86, 143

  • 持续时间 59, 79, 84

  • 日志记录 165

  • 执行 79

  • 元数据 75

  • 规范化 74

  • 规划 17, 76, 78

И

• 多余访问 110

• 索引 104, 107, 110, 120

  • 输入/输出 140

  • 创建 229

К

• 映射

  • 可见性映射 105

  • 空闲空间映射 105

• 数据目录 100, 123

• SLRU 缓存 137

• 集群

  • 数据库集簇 100

  • 复制集群 173

• 客户端进程，参见 后端进程

• 命令 17, 30, 71

• 内存上下文 137

• 校验和 115

• 检查点 22, 150, 158

  • 配置 151

• 冲突

  • 恢复 190

  • 逻辑复制 190

• 元组 105

Л

• 时间线 159

М

• 等待标记 52

• 多事务 204

Н

• 工作负载 17, 28, 72, 80, 107

О

• 反馈 178, 192, 206

• 等待 34, 50–51

  • 锁 53

  • 树 65

  • 持续时间 61

  • 标记 52

• 关系 105

• 清理 22, 195

  • 持续时间 214

  • 延迟 203, 206

  • 阶段 217

• 错误 114, 190, 210

П

• 内存

  • 本地 18, 137

  • 共享 19, 130, 135, 158

• 规划 17, 76, 78

• 连接，参见 会话

• 订阅 175, 187, 189

• 发布 175, 187

Р

• 膨胀 57, 192, 197, 210

• 扩展 23, 72

• 备份 224

• 复制标识符 189

• 复制 21, 173

  • 延迟 174

  • 冲突 190

  • 滞后 178, 185–186

  • 槽 175, 183, 185, 188

С

• 会话 17, 28, 33, 37, 39, 41

  • 异常终止 46, 115

  • 状态 49

• 段 105, 149, 158

• 同步 174

• 系统目录 40, 102, 211

• 存储分支 105, 119

• 复制槽 175, 183, 185, 188

• 快照 196

• 连接，参见 会话

• 规划器统计信息 200, 222

  • 阶段 223

• 代价 76

• 页面 19, 106, 134, 159, 175

  • 整页镜像 151, 162

• 模式 103

Т

• 表 104, 107, 109, 112, 119

  • 输入/输出 140

• 表空间 101, 118

• 事务 30, 33, 38, 44

  • 空闲 56

  • 持续时间 59

  • 标识符 202, 206

  • 回滚 114

Ф

• 文件

  • 临时 20, 127, 144–149

  • 关系 105

• 后台写入 22

• 后台进程 33, 41

  • 输入/输出 149

• 函数

  • 用户函数 95

  • 系统管理函数 117

Э

• 实例 100