Предметный указатель

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