PostgreSQL 14对监控有所增强，包括内存上下文的使用监控和WAL活动监控 **内存上下文监控** 查询数据字典*pg_backend_memory_contexts*可查看数据库的内存上下文使用情况 ``` [local]:5014 pg14@testdb=#* select * from pg_backend_memory_contexts ORDER BY level asc,used_bytes desc limit 5; name | ident | parent | level | total_bytes | total_nblocks | free_bytes | free_chunks | used_bytes -------------------------+-------+------------------+-------+-------------+---------------+------------+-------------+------------ TopMemoryContext | | | 0 | 80800 | 6 | 13096 | 7 | 67704 CacheMemoryContext | | TopMemoryContext | 1 | 1048576 | 8 | 360880 | 1 | 687696 Timezones | | TopMemoryContext | 1 | 104128 | 2 | 2584 | 0 | 101544 MessageContext | | TopMemoryContext | 1 | 65536 | 4 | 17600 | 0 | 47936 WAL record construction | | TopMemoryContext | 1 | 49776 | 2 | 6344 | 0 | 43432 (5 rows) Time: 2.054 ms [local]:5014 pg14@testdb=#* select count(*) from t_node_ip; count -------- 178182 (1 row) Time: 100.878 ms [local]:5014 pg14@testdb=#* select * from pg_backend_memory_contexts ORDER BY level asc,used_bytes desc limit 5; name | ident | parent | level | total_bytes | total_nblocks | free_bytes | free_chunks | used_bytes -------------------------+-------+------------------+-------+-------------+---------------+------------+-------------+------------ TopMemoryContext | | | 0 | 80800 | 6 | 12944 | 6 | 67856 CacheMemoryContext | | TopMemoryContext | 1 | 1048576 | 8 | 358160 | 0 | 690416 Timezones | | TopMemoryContext | 1 | 104128 | 2 | 2584 | 0 | 101544 MessageContext | | TopMemoryContext | 1 | 65536 | 4 | 17600 | 0 | 47936 WAL record construction | | TopMemoryContext | 1 | 49776 | 2 | 6344 | 0 | 43432 (5 rows) Time: 0.504 ms [local]:5014 pg14@testdb=#* select pg_backend_pid(); pg_backend_pid ---------------- 3181 (1 row) Time: 2.558 ms ``` 使用*pg_log_backend_memory_contexts*可查询某个进程使用内存的全过程日志。 ``` [local]:5014 pg14@testdb=#* SELECT pg_log_backend_memory_contexts(3181); 2022-03-21 17:00:54.846 CST [3181] LOG: logging memory contexts of PID 3181 2022-03-21 17:00:54.846 CST [3181] LOG: level: 0; TopMemoryContext: 80800 total in 6 blocks; 13096 free (7 chunks); 67704 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; TableSpace cache: 8192 total in 1 blocks; 2048 free (0 chunks); 6144 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; pgstat TabStatusArray lookup hash table: 8192 total in 1 blocks; 360 free (0 chunks); 7832 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; TopTransactionContext: 8192 total in 1 blocks; 7720 free (2 chunks); 472 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; Record information cache: 8192 total in 1 blocks; 1536 free (0 chunks); 6656 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; Type information cache: 24384 total in 2 blocks; 2584 free (0 chunks); 21800 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; RowDescriptionContext: 8192 total in 1 blocks; 6880 free (0 chunks); 1312 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; MessageContext: 16384 total in 2 blocks; 5504 free (0 chunks); 10880 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; Operator class cache: 8192 total in 1 blocks; 512 free (0 chunks); 7680 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; smgr relation table: 32768 total in 3 blocks; 16768 free (8 chunks); 16000 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; TransactionAbortContext: 32768 total in 1 blocks; 32504 free (0 chunks); 264 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; Portal hash: 8192 total in 1 blocks; 512 free (0 chunks); 7680 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; TopPortalContext: 8192 total in 1 blocks; 7648 free (0 chunks); 544 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; PortalContext: 1024 total in 1 blocks; 576 free (0 chunks); 448 used: <unnamed> 2022-03-21 17:00:54.846 CST [3181] LOG: level: 3; ExecutorState: 8192 total in 1 blocks; 2784 free (0 chunks); 5408 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 4; printtup: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 4; ExprContext: 8192 total in 1 blocks; 7928 free (0 chunks); 264 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; Relcache by OID: 16384 total in 2 blocks; 3424 free (3 chunks); 12960 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 1; CacheMemoryContext: 1048576 total in 8 blocks; 355000 free (0 chunks); 693576 used 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 440 free (1 chunks); 1608 used: pg_toast_2619_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 736 free (0 chunks); 1312 used: pg_index_indrelid_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 824 free (0 chunks); 1224 used: pg_statistic_ext_relid_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 440 free (1 chunks); 1608 used: pg_attrdef_adrelid_adnum_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; relation rules: 8192 total in 4 blocks; 464 free (0 chunks); 7728 used: pg_backend_memory_contexts 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 408 free (1 chunks); 1640 used: pg_db_role_setting_databaseid_rol_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 584 free (2 chunks); 1464 used: pg_user_mapping_user_server_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_user_mapping_oid_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 736 free (0 chunks); 1312 used: pg_type_oid_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_type_typname_nsp_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_ts_template_oid_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_ts_template_tmplname_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_ts_parser_oid_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_ts_parser_prsname_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_ts_dict_oid_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_ts_dict_dictname_index 2022-03-21 17:00:54.846 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_ts_config_oid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_ts_config_cfgname_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 1088 free (2 chunks); 1984 used: pg_ts_config_map_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_transform_type_lang_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_transform_oid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 736 free (0 chunks); 1312 used: pg_tablespace_oid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 584 free (2 chunks); 1464 used: pg_subscription_rel_srrelid_srsubid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_subscription_oid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_subscription_subname_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 704 free (1 chunks); 2368 used: pg_statistic_relid_att_inh_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_statistic_ext_oid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_statistic_ext_name_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 880 free (2 chunks); 1168 used: pg_statistic_ext_data_stxoid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_sequence_seqrelid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 880 free (2 chunks); 1168 used: pg_replication_origin_roname_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 880 free (2 chunks); 1168 used: pg_replication_origin_roiident_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 352 free (1 chunks); 1696 used: pg_class_relname_nsp_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_range_rngtypid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_range_rngmultitypid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 584 free (2 chunks); 1464 used: pg_publication_rel_prrelid_prpubid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_publication_rel_oid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_publication_oid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_publication_pubname_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 736 free (0 chunks); 1312 used: pg_proc_oid_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 912 free (1 chunks); 2160 used: pg_proc_proname_args_nsp_index 2022-03-21 17:00:54.847 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 880 free (2 chunks); 1168 used: pg_partitioned_table_partrelid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_opfamily_oid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 1088 free (2 chunks); 1984 used: pg_opfamily_am_name_nsp_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_operator_oid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 1024 free (1 chunks); 2048 used: pg_operator_oprname_l_r_n_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_namespace_oid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 736 free (0 chunks); 1312 used: pg_namespace_nspname_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_language_oid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_language_name_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_foreign_table_relid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_foreign_server_oid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_foreign_server_name_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 880 free (2 chunks); 1168 used: pg_foreign_data_wrapper_oid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 880 free (2 chunks); 1168 used: pg_foreign_data_wrapper_name_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_event_trigger_oid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_event_trigger_evtname_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_enum_typid_label_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_enum_oid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 1056 free (1 chunks); 2016 used: pg_default_acl_role_nsp_obj_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_conversion_oid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_constraint_oid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_conversion_name_nsp_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 1024 free (1 chunks); 2048 used: pg_conversion_default_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_collation_oid_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 1088 free (2 chunks); 1984 used: pg_collation_name_enc_nsp_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 912 free (1 chunks); 2160 used: pg_opclass_am_name_nsp_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 352 free (1 chunks); 1696 used: pg_cast_source_target_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 584 free (2 chunks); 1464 used: pg_auth_members_role_member_index 2022-03-21 17:00:54.850 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_attribute_relid_attnam_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 584 free (1 chunks); 2488 used: pg_amop_fam_strat_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 912 free (1 chunks); 2160 used: pg_amop_opr_fam_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 736 free (0 chunks); 1312 used: pg_aggregate_fnoid_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 1088 free (2 chunks); 1984 used: pg_shseclabel_object_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 584 free (2 chunks); 1464 used: pg_auth_members_member_role_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_authid_oid_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_authid_rolname_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 736 free (0 chunks); 1312 used: pg_database_oid_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 912 free (0 chunks); 1136 used: pg_database_datname_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 616 free (2 chunks); 1432 used: pg_trigger_tgrelid_tgname_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 440 free (1 chunks); 1608 used: pg_rewrite_rel_rulename_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 3072 total in 2 blocks; 584 free (1 chunks); 2488 used: pg_amproc_fam_proc_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 736 free (0 chunks); 1312 used: pg_opclass_oid_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 736 free (0 chunks); 1312 used: pg_index_indexrelid_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 352 free (1 chunks); 1696 used: pg_attribute_relid_attnum_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 2; index info: 2048 total in 2 blocks; 736 free (0 chunks); 1312 used: pg_class_oid_index 2022-03-21 17:00:54.851 CST [3181] LOG: level: 1; WAL record construction: 49776 total in 2 blocks; 6344 free (0 chunks); 43432 used 2022-03-21 17:00:54.851 CST [3181] LOG: level: 1; PrivateRefCount: 8192 total in 1 blocks; 2584 free (0 chunks); 5608 used 2022-03-21 17:00:54.851 CST [3181] LOG: level: 1; MdSmgr: 8192 total in 1 blocks; 6744 free (0 chunks); 1448 used 2022-03-21 17:00:54.851 CST [3181] LOG: level: 1; LOCALLOCK hash: 8192 total in 1 blocks; 512 free (0 chunks); 7680 used 2022-03-21 17:00:54.851 CST [3181] LOG: level: 1; Timezones: 104128 total in 2 blocks; 2584 free (0 chunks); 101544 used 2022-03-21 17:00:54.851 CST [3181] LOG: level: 1; ErrorContext: 8192 total in 1 blocks; 7928 free (3 chunks); 264 used 2022-03-21 17:00:54.851 CST [3181] LOG: Grand total: 1725456 bytes in 218 blocks; 569368 free (93 chunks); 1156088 used pg_log_backend_memory_contexts -------------------------------- t (1 row) Time: 6.360 ms [local]:5014 pg14@testdb=#* ``` **WAL活动监控** 使用视图pg_stat_wal可跟踪WAL的相关活动 ``` [local]:5014 pg14@testdb=#* create table a as select * from t_node_ip; SELECT 178182 Time: 541.900 ms [local]:5014 pg14@testdb=#* SELECT * FROM pg_stat_wal; wal_records | wal_fpi | wal_bytes | wal_buffers_full | wal_write | wal_sync | wal_write_time | wal_sync_time | stats_reset -------------+---------+-----------+------------------+-----------+----------+----------------+---------------+------------------------------- 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 2022-03-21 16:53:58.488321+08 (1 row) Time: 1.022 ms [local]:5014 pg14@testdb=# create table b as select * from t_node_ip; SELECT 178182 Time: 595.625 ms [local]:5014 pg14@testdb=#* create table c as select * from t_node_ip; SELECT 178182 Time: 577.467 ms [local]:5014 pg14@testdb=#* SELECT * FROM pg_stat_wal; wal_records | wal_fpi | wal_bytes | wal_buffers_full | wal_write | wal_sync | wal_write_time | wal_sync_time | stats_reset -------------+---------+-----------+------------------+-----------+----------+----------------+---------------+------------------------------- 178226 | 18 | 22005810 | 0 | 14 | 14 | 0 | 0 | 2022-03-21 16:53:58.488321+08 (1 row) Time: 16.371 ms [local]:5014 pg14@testdb=#* checkpoint; CHECKPOINT Time: 814.862 ms [local]:5014 pg14@testdb=#* create table d as select * from t_node_ip; SELECT 178182 Time: 535.339 ms [local]:5014 pg14@testdb=#* checkpoint; CHECKPOINT Time: 227.352 ms [local]:5014 pg14@testdb=#* SELECT * FROM pg_stat_wal; wal_records | wal_fpi | wal_bytes | wal_buffers_full | wal_write | wal_sync | wal_write_time | wal_sync_time | stats_reset -------------+---------+-----------+------------------+-----------+----------+----------------+---------------+------------------------------- 178226 | 18 | 22005810 | 0 | 14 | 14 | 0 | 0 | 2022-03-21 16:53:58.488321+08 (1 row) Time: 0.533 ms [local]:5014 pg14@testdb=#* ``` **参考资料** [An early look at Postgres 14: Performance and Monitoring Improvements](https://pganalyze.com/blog/postgres-14-performance-monitoring#improved-active-and-idle-connection-scaling-in-postgres-14)