频道导航

PostgreSQL的监控一(pgsnap & pgstatspack)

2020-06-23 Postgre SQL 前端之家

前端之家收集整理的这篇文章主要介绍了PostgreSQL的监控一(pgsnap & pgstatspack)，前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。

转载：http://blog.chinaunix.net/uid-20726500-id-4504167.html

监控postgresql的方法很多，本文做个简单的比较。

大的方面，监控方法可以分为以下几种 @H_403_10@

1 直接利用PG提供的性能 统计数据

PG的很多性能数据可以通过查询pg_stat_或pg_statio_开头的系统表获取。 @H_403_10@ 比如： @H_403_10@ @H_403_10@

 
  postgres=#\x
 
 Expanded display is on.
 
 postgres#select*from pg_stat_database where datname='postgres';
 
 -[RECORD1]+-
 
 datid|12896
 
 datname|postgres
 
 numbackends|1
 
 xact_commit|5692
 
 xact_rollback|3
 
 blks_read|155
 
 blks_hit|157853
 
 tup_returned|2566687
 
 tup_fetched|32370
 
 tup_inserted|0
 
 tup_updated|7
 
 tup_deleted|0
 
 conflicts|0
 
 temp_files|0
 
 temp_bytes|0
 
 deadlocks|0
 
 blk_read_time|0
 
 blk_write_time|0
 
 stats_reset|2014-09-23 01:23:12.123612+08

http://www.postgresql.org/docs/current/static/monitoring-stats.html
2 PG专用的监控工具 pgsnap,pgstatspack,pgwatch,pg_statsinfo等。这些工具主要做PG的性能分析，状态查看的。不能做故障通知。 @H_403_10@

2.1pgsnap

http://pgsnap.projects.pgfoundry.org/

pgsnap是个Postgresql报告工具，不需要在数据库上安装任何东西，可以远程连接到数据库，然后通过PG已有的系统表查询统计数据并生成HTML报告。 @H_403_10@ 使用例：
[root@zabbix ~#tar xfz pgsnap-0.8.0.tar.gz

#cd pgsnap.0

[root@zabbix pgsnap#./pgsnap.PHP-h localhost-p 5432-U postgres postgres

Connecting to postgres database.

Adding some HTML files.

Getting Misc informations.

Getting General informations.

sh:pg_config:commandnotfound

sh:pg_controldatanotfound

Getting Global Informations.

pg_buffercache

Getting Database Informations.

pg_buffercache

pgstattuple

pgstattuple on indexes

Getting Current Activities Informations.

Getting Statistical Informations.

Getting Tools Informations.

pgPool

@H_403_10@生成的结果，可参考下面的demo @H_403_10@http://pgsnap.projects.pgfoundry.org/pgbench_snap_20120930/
2.2 pgstatspack http://pgfoundry.org/projects/pgstatspack/ @H_403_10@前面介绍的pgsnap真的只是个某一时间点的snap采集工具，不能对一段时间内的变化做分析。 @H_403_10@pgstatspack稍微进了一步，它把每次采集的snap信息存在数据库里，然后可以对2个snap信息进行比较生成文本的性能报告。 @H_403_10@下面是使用的例子： @H_403_10@1）安装pgstatspack
#tar xfz /root/pgstatspack_version_2.3.1#cd pgstatspack

[root@zabbix pgstatspack#su postgres/install_pgstats.sh

Resultsfordatabase template1

Installing Statistics Packagefordatabase template1

Resultsfordatabase zabbix

Installing Statistics Packagefordatabase zabbix

@H_403_10@2）创建snapshot

/bin/snapshot.sh

Resultsfordatabase zabbix

pgstatspack_snap

-

1

(1 row)

-

2

)

@H_403_10@3）生成报告

[root@zabbix pgstatspack]# su postgres ./bin/pgstatspack_report.sh /root/pgstatspack/bin /root/pgstatspack Please specify a username: postgres List of available databases: 1 . zabbix Please select a number from the above list [ 1 - 1 ] 1 snapid | ts | description --------+----------------------------+--------------------- 2 | 2014-09-25 01:13:02.292668 | cron based snapshot 1 | 2014-09-25 01:09:20.71257 | cron based snapshot (2 rows) Enter start snapshot id : 1 Enter stop snapshot id : 2 Using file name: /tmp/pgstatreport_zabbix_1_2.txt ########################################################################################################### PGStatspack version 2.3 by uwe.bartels@gmail.com ########################################################################################################### Snapshot information Begin snapshot : snapid | ts | description --------+---------------------------+--------------------- 1 | 2014-09-25 01:09:20.71257 | cron based snapshot (1 row) End snapshot : snapid | ts | description --------+----------------------------+--------------------- 2 | 2014-09-25 01:13:02.292668 | cron based snapshot (1 row) Seconds in snapshot: 221.580098 Database version version -------------------------------------------------------------------------------------------------------------- Postgresql 9.3.4 on x86_64-unknown-linux-gnu,compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4),64-bit (1 row) Database information current_database | dbsize ------------------+-------- zabbix | 140 MB (1 row) Database statistics database | tps | hitrate | lio_ps | pio_ps | rollbk_ps -----------+------+---------+--------+--------+----------- zabbix | 1.73 | 99.00 | 164.87 | 0.58 | 0.00 postgres | 0.05 | 99.00 | 1.73 | 0.00 | 0.00 template1 | 0.04 | 99.00 | 0.99 | 0.00 | 0.00 template0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 (4 rows) Top 20 tables ordered by table size changes table | table_growth | index_growth ------------------------------+--------------+-------------- pg_toast.pg_toast_16818 | | 0 pg_catalog.pg_ts_config | | 0 pg_toast.pg_toast_17807 | | 0 pg_toast.pg_toast_16792 | | 0 public.services_times | | 0 pg_catalog.pg_authid | | 0 public.opcommand_hst | | 0 public.icon_mapping | | 0 pg_catalog.pg_cast | | 0 pg_toast.pg_toast_12481 | | 0 pg_catalog.pg_foreign_server | | 0 pg_catalog.pg_event_trigger | | 0 pg_catalog.pg_namespace | | 0 public.nodes | | 0 pg_toast.pg_toast_12491 | | 0 public.pgstatspack_indexes | | 32768 public.history_sync | | 0 pg_catalog.pg_depend | | 0 public.profiles | | 0 pg_toast.pg_toast_2396 | | 0 (20 rows) Top 20 tables ordered by high table to index read ratio table | system_read_pct | table_read_pct | index_read_pct ----------------------------+-----------------+----------------+---------------- pg_catalog.pg_class | 23 | 88 | 11 public.pgstatspack_names | 21 | 98 | 1 public.items | 17 | 98 | 1 public.hosts | 6 | 99 | 0 pg_catalog.pg_proc | 5 | 93 | 6 pg_catalog.pg_index | 4 | 83 | 16 public.pgstatspack_tables | 3 | 100 | 0 public.triggers | 3 | 99 | 0 public.functions | 3 | 98 | 1 pg_catalog.pg_attribute | 3 | 0 | 100 pg_catalog.pg_opclass | 1 | 0 | 100 public.globalmacro | 0 | 100 | 0 public.interface | 0 | 100 | 0 public.config | 0 | 100 | 0 public.pgstatspack_indexes | 0 | 100 | 0 pg_catalog.pg_am | 0 | 100 | 0 public.expressions | 0 | 100 | 0 public.host_inventory | 0 | 100 | 0 public.regexps | 0 | 100 | 0 public.media_type | 0 | 100 | 0 (20 rows) Top 20 tables ordered by inserts table | table_inserts -------------------------------+--------------- public.history_uint | 797 public.pgstatspack_names | 728 public.pgstatspack_indexes | 425 public.pgstatspack_tables | 228 public.history | 196 public.pgstatspack_settings | 34 pg_catalog.pg_statistic | 29 public.pgstatspack_sequences | 8 public.pgstatspack_database | 4 public.history_str | 4 public.pgstatspack_snap | 1 public.pgstatspack_bgwriter | 1 public.nodes | 0 pg_catalog.pg_namespace | 0 pg_catalog.pg_db_role_setting | 0 pg_catalog.pg_foreign_server | 0 public.dchecks | 0 pg_catalog.pg_event_trigger | 0 pg_toast.pg_toast_12481 | 0 pg_catalog.pg_cast | 0 (20 rows) Top 20 tables ordered by updates table | table_updates -------------------------------+--------------- public.hosts | 12 pg_catalog.pg_event_trigger | 0 pg_catalog.pg_description | 0 pg_toast.pg_toast_16792 | 0 public.dchecks | 0 public.pgstatspack_names | 0 pg_toast.pg_toast_12491 | 0 public.icon_mapping | 0 pg_catalog.pg_cast | 0 pg_toast.pg_toast_12481 | 0 pg_catalog.pg_foreign_server | 0 pg_catalog.pg_db_role_setting | 0 pg_catalog.pg_namespace | 0 public.nodes | 0 public.config | 0 public.pgstatspack_indexes | 0 public.history_sync | 0 pg_catalog.pg_depend | 0 public.opcommand_hst | 0 public.profiles | 0 (20 rows) Top 20 tables ordered by deletes table | table_deletes -------------------------------+--------------- public.opcommand_hst | 0 pg_catalog.pg_event_trigger | 0 public.config | 0 pg_toast.pg_toast_16792 | 0 public.dchecks | 0 public.pgstatspack_names | 0 pg_toast.pg_toast_12491 | 0 public.icon_mapping | 0 pg_catalog.pg_cast | 0 pg_toast.pg_toast_12481 | 0 pg_catalog.pg_foreign_server | 0 pg_catalog.pg_db_role_setting | 0 pg_catalog.pg_namespace | 0 public.nodes | 0 pg_catalog.pg_description | 0 public.pgstatspack_indexes | 0 public.history_sync | 0 pg_catalog.pg_depend | 0 public.profiles | 0 pg_toast.pg_toast_17807 | 0 (20 rows) Tables ordered by percentage of tuples scanned table | rows_read_pct | tab_hitrate | idx_hitrate | tab_read | tab_hit | idx_read | idx_hit ------------------------------+---------------+-------------+-------------+----------+---------+----------+--------- pg_catalog.pg_class | 23 | 99 | 99 | 1 | 3101 | 0 | 5212 public.pgstatspack_names | 21 | 99 | 99 | 8 | 1235 | 11 | 2994 public.items | 17 | 99 | 99 | 0 | 908 | 0 | 118 public.hosts | 6 | 99 | 97 | 0 | 312 | 0 | 40 pg_catalog.pg_proc | 5 | 93 | 99 | 27 | 383 | 4 | 572 pg_catalog.pg_index | 4 | 99 | 99 | 0 | 682 | 0 | 1258 public.functions | 3 | 98 | 98 | 0 | 80 | 0 | 96 public.triggers | 3 | 98 | 94 | 0 | 96 | 0 | 16 public.pgstatspack_tables | 3 | 97 | 98 | 7 | 308 | 2 | 235 pg_catalog.pg_attribute | 3 | 99 | 99 | 11 | 1503 | 1 | 2901 pg_catalog.pg_opclass | 1 | 99 | 99 | 0 | 631 | 0 | 230 pg_toast.pg_toast_2619 | 0 | 50 | 66 | 0 | 1 | 0 | 2 public.regexps | 0 | 80 | 0 | 0 | 4 | 0 | 0 public.host_inventory | 0 | 80 | 0 | 0 | 4 | 0 | 0 pg_catalog.pg_type | 0 | 99 | 99 | 0 | 310 | 0 | 674 pg_catalog.pg_amop | 0 | 99 | 99 | 0 | 479 | 0 | 740 pg_catalog.pg_attrdef | 0 | 99 | 99 | 0 | 198 | 0 | 258 pg_toast.pg_toast_1255 | 0 | 66 | 75 | 0 | 2 | 0 | 3 pg_catalog.pg_aggregate | 0 | 83 | 90 | 0 | 5 | 0 | 9 public.pgstatspack_bgwriter | 0 | 66 | 66 | 1 | 4 | 2 | 6 public.trigger_depends | 0 | 80 | 80 | 0 | 4 | 0 | 4 pg_toast.pg_toast_2618 | 0 | 68 | 96 | 5 | 13 | 0 | 24 pg_catalog.pg_tablespace | 0 | 90 | 95 | 0 | 10 | 0 | 20 public.media_type | 0 | 80 | 80 | 0 | 4 | 0 | 4 pg_catalog.pg_trigger | 0 | 99 | 99 | 0 | 179 | 0 | 218 pg_catalog.pg_am | 0 | 96 | 0 | 0 | 31 | 0 | 0 public.expressions | 0 | 80 | 0 | 0 | 4 | 0 | 0 public.drules | 0 | 88 | 88 | 0 | 8 | 0 | 8 public.interface | 0 | 80 | 0 | 0 | 4 | 0 | 0 pg_catalog.pg_language | 0 | 50 | 66 | 0 | 1 | 0 | 2 public.pgstatspack_sequences | 0 | 88 | 85 | 1 | 16 | 2 | 18 public.pgstatspack_database | 0 | 71 | 70 | 1 | 5 | 2 | 7 public.httptest | 0 | 98 | 98 | 0 | 90 | 0 | 90 public.pgstatspack_settings | 0 | 97 | 95 | 1 | 68 | 2 | 70 public.config | 0 | 80 | 92 | 0 | 4 | 0 | 12 pg_catalog.pg_database | 0 | 98 | 99 | 0 | 83 | 0 | 108 pg_catalog.pg_cast | 0 | 99 | 99 | 0 | 159 | 0 | 615 pg_catalog.pg_namespace | 0 | 97 | 98 | 0 | 44 | 0 | 93 public.pgstatspack_indexes | 0 | 98 | 98 | 7 | 445 | 5 | 564 pg_catalog.pg_rewrite | 0 | 76 | 97 | 5 | 20 | 0 | 40 pg_catalog.pg_authid | 0 | 95 | 97 | 0 | 19 | 0 | 38 public.hosts_templates | 0 | 80 | 80 | 0 | 4 | 0 | 4 pg_catalog.pg_statistic | 0 | 99 | 99 | 0 | 141 | 0 | 1104 pg_catalog.pg_operator | 0 | 99 | 99 | 1 | 482 | 0 | 651 pg_catalog.pg_amproc | 0 | 99 | 99 | 0 | 168 | 0 | 375 public.globalmacro | 0 | 80 | 0 | 0 | 4 | 0 | 0 (46 rows) Indexes ordered by scans index | table | scans | tup_read | tup_fetch | idx_blks_read | idx_blks_hit ----------------------------------------------------+-------------------------------+-------+----------+-----------+---------------+-------------- pg_catalog.pg_class_oid_index | pg_catalog.pg_class | 2456 | 2456 | 2456 | 0 | 4951 pg_catalog.pg_attribute_relid_attnum_index | pg_catalog.pg_attribute | 1433 | 3737 | 3737 | 1 | 2901 pg_catalog.pg_cast_source_target_index | pg_catalog.pg_cast | 598 | 159 | 159 | 0 | 615 pg_catalog.pg_index_indexrelid_index | pg_catalog.pg_index | 534 | 534 | 534 | 0 | 1100 pg_catalog.pg_statistic_relid_att_inh_index | pg_catalog.pg_statistic | 510 | 86 | 86 | 0 | 1104 pg_catalog.pg_type_oid_index | pg_catalog.pg_type | 297 | 296 | 296 | 0 | 622 pg_catalog.pg_proc_oid_index | pg_catalog.pg_proc | 247 | 247 | 247 | 0 | 527 pg_catalog.pg_amop_fam_strat_index | pg_catalog.pg_amop | 214 | 214 | 214 | 0 | 452 pg_catalog.pg_operator_oid_index | pg_catalog.pg_operator | 179 | 179 | 179 | 0 | 383 pg_catalog.pg_amproc_fam_proc_index | pg_catalog.pg_amproc | 172 | 258 | 258 | 0 | 375 public.idx_pgstatspack_names_name | public.pgstatspack_names | 171 | 159 | 159 | 7 | 1591 public.pgstatspack_names_pkey | public.pgstatspack_names | 168 | 168 | 168 | 4 | 1403 pg_catalog.pg_opclass_oid_index | pg_catalog.pg_opclass | 145 | 145 | 145 | 0 | 176 pg_catalog.pg_amop_opr_fam_index | pg_catalog.pg_amop | 131 | 265 | 265 | 0 | 288 pg_catalog.pg_operator_oprname_l_r_n_index | pg_catalog.pg_operator | 122 | 406 | 406 | 0 | 268 pg_catalog.pg_attrdef_adrelid_adnum_index | pg_catalog.pg_attrdef | 119 | 949 | 949 | 0 | 258 pg_catalog.pg_class_relname_nsp_index | pg_catalog.pg_class | 118 | 68 | 68 | 0 | 261 pg_catalog.pg_trigger_tgrelid_tgname_index | pg_catalog.pg_trigger | 104 | 612 | 612 | 0 | 218 public.httptest_3 | public.httptest | 90 | 90 | 90 | 0 | 90 pg_catalog.pg_db_role_setting_databaseid_rol_index | pg_catalog.pg_db_role_setting | 80 | 0 | 0 | 0 | 80 public.escalations_1 | public.escalations | 74 | 0 | 0 | 0 | 74 pg_catalog.pg_index_indrelid_index | pg_catalog.pg_index | 68 | 119 | 119 | 0 | 158 pg_catalog.pg_namespace_nspname_index | pg_catalog.pg_namespace | 62 | 35 | 35 | 0 | 89 public.items_1 | public.items | 42 | 216 | 40 | 0 | 86 pg_catalog.pg_opclass_am_name_nsp_index | pg_catalog.pg_opclass | 40 | 1568 | 1568 | 0 | 54 public.hosts_pkey | public.hosts | 40 | 40 | 40 | 0 | 40 pg_catalog.pg_database_oid_index | pg_catalog.pg_database | 39 | 39 | 39 | 0 | 59 public.pgstatspack_settings_pk | public.pgstatspack_settings | 35 | 68 | 34 | 2 | 70 public.functions_2 | public.functions | 32 | 32 | 32 | 0 | 64 pg_catalog.pg_database_datname_index | pg_catalog.pg_database | 29 | 29 | 29 | 0 | 49 pg_catalog.pg_rewrite_rel_rulename_index | pg_catalog.pg_rewrite | 25 | 27 | 27 | 0 | 40 pg_catalog.pg_type_typname_nsp_index | pg_catalog.pg_type | 21 | 14 | 14 | 0 | 52 pg_catalog.pg_proc_proname_args_nsp_index | pg_catalog.pg_proc | 19 | 79 | 79 | 4 | 45 public.items_pkey | public.items | 16 | 16 | 16 | 0 | 32 public.functions_1 | public.functions | 16 | 16 | 16 | 0 | 32 pg_toast.pg_toast_2618_index | pg_toast.pg_toast_2618 | 15 | 28 | 28 | 0 | 24 public.media_2 | public.media | 12 | 0 | 0 | 0 | 16 pg_catalog.pg_tablespace_oid_index | pg_catalog.pg_tablespace | 10 | 10 | 10 | 0 | 19 pg_catalog.pg_authid_oid_index | pg_catalog.pg_authid | 10 | 10 | 10 | 0 | 20 pg_catalog.pg_authid_rolname_index | pg_catalog.pg_authid | 9 | 9 | 9 | 0 | 18 public.pgstatspack_sequences_pk | public.pgstatspack_sequences | 9 | 16 | 8 | 2 | 18 public.drules_1 | public.drules | 8 | 8 | 8 | 0 | 8 public.triggers_pkey | public.triggers | 8 | 8 | 8 | 0 | 16 public.alerts_4 | public.alerts | 8 | 0 | 0 | 0 | 16 pg_catalog.pg_aggregate_fnoid_index | pg_catalog.pg_aggregate | 5 | 5 | 5 | 0 | 9 public.trigger_depends_1 | public.trigger_depends | 4 | 164 | 164 | 0 | 4 public.hosts_templates_1 | public.hosts_templates | 4 | 108 | 108 | 0 | 4 public.pgstatspack_bgwriter_pk | public.pgstatspack_bgwriter | 4 | 4 | 4 | 2 | 6 public.pgstatspack_database_pk | public.pgstatspack_database | 2 | 8 | 0 | 2 | 7 pg_toast.pg_toast_1255_index | pg_toast.pg_toast_1255 | 2 | 4 | 4 | 0 | 3 public.pgstatspack_functions_pk | public.pgstatspack_functions | 1 | 0 | 0 | 1 | 2 pg_catalog.pg_language_oid_index | pg_catalog.pg_language | 1 | 1 | 1 | 0 | 2 pg_toast.pg_toast_2619_index | pg_toast.pg_toast_2619 | 1 | 1 | 1 | 0 | 2 pg_catalog.pg_namespace_oid_index | pg_catalog.pg_namespace | 1 | 1 | 1 | 0 | 4 public.pgstatspack_statements_pk | public.pgstatspack_statements | 1 | 0 | 0 | 1 | 4 public.hostmacro_pkey | public.hostmacro | 0 | 0 | 0 | 0 | 4 public.history_uint_1 | public.history_uint | 0 | 0 | 0 | 11 | 2424 public.users_groups_pkey | public.users_groups | 0 | 0 | 0 | 0 | 4 public.maintenances_windows_pkey | public.maintenances_windows | 0 | 0 | 0 | 0 | 4 public.alerts_1 | public.alerts | 0 | 0 | 0 | 0 | 8 public.pgstatspack_indexes_pk | public.pgstatspack_indexes | 0 | 0 | 0 | 5 | 564 public.alerts_6 | public.alerts | 0 | 0 | 0 | 0 | 8 public.hostmacro_1 | public.hostmacro | 0 | 0 | 0 | 0 | 4 public.maintenances_windows_2 | public.maintenances_windows | 0 | 0 | 0 | 0 | 4 public.media_type_pkey | public.media_type | 0 | 0 | 0 | 0 | 4 public.alerts_5 | public.alerts | 0 | 0 | 0 | 0 | 8 pg_catalog.pg_tablespace_spcname_index | pg_catalog.pg_tablespace | 0 | 0 | 0 | 0 | 1 public.history_str_1 | public.history_str | 0 | 0 | 0 | 0 | 8 public.alerts_2 | public.alerts | 0 | 0 | 0 | 0 | 8 public.config_1 | public.config | 0 | 0 | 0 | 0 | 4 public.maintenances_1 | public.maintenances | 0 | 0 | 0 | 0 | 4 public.media_pkey | public.media | 0 | 0 | 0 | 0 | 4 public.alerts_pkey | public.alerts | 0 | 0 | 0 | 0 | 8 public.users_groups_1 | public.users_groups | 0 | 0 | 0 | 0 | 4 public.config_2 | public.config | 0 | 0 | 0 | 0 | 4 public.maintenances_windows_1 | public.maintenances_windows | 0 | 0 | 0 | 0 | 4 public.maintenances_pkey | public.maintenances | 0 | 0 | 0 | 0 | 4 public.timeperiods_pkey | public.timeperiods | 0 | 0 | 0 | 0 | 4 public.history_1 | public.history | 0 | 0 | 0 | 2 | 600 public.pgstatspack_tables_pk | public.pgstatspack_tables | 0 | 0 | 0 | 2 | 235 public.config_pkey | public.config | 0 | 0 | 0 | 0 | 4 public.media_1 | public.media | 0 | 0 | 0 | 0 | 4 public.alerts_3 | public.alerts | 0 | 0 | 0 | 0 | 8 public.users_groups_2 | public.users_groups | 0 | 0 | 0 | 0 | 4 (84 rows) Sequences ordered by blks_read sequence | blks_read | blks_hit --------------------------+-----------+---------- public.pgstatspackid | 0 | 1 public.pgstatspacknameid | 0 | 728 (2 rows) Top 20 sql statements ordered by total_time calls | total_time | total_time_percent | rows | user | query -------+------------+--------------------+------+------+------- (0 rows) Top 20 user functions ordered by total_time funcid | function_name | calls | total_time | self_time --------+---------------+-------+------------+----------- (0 rows) background writer stats checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean | maxwritten_clean | buffers_backend | buffers_alloc -------------------+-----------------+--------------------+---------------+------------------+-----------------+--------------- 0 | 0 | 0 | 0 | 0 | 0 | 128 (1 row) background writer relative stats checkpoints_timed | minutes_between_checkpoint | buffers_checkpoint | buffers_clean | buffers_backend | total_writes | avg_checkpoint_write -------------------+----------------------------+--------------------+---------------+-----------------+--------------+---------------------- | | | | | 0.000 MB/s | (1 row) Parameters name | start_setting | stop_setting | source ----------------------------+-----------------------------------------+-----------------------------------------+---------------------- max_stack_depth | 2048 | 2048 | environment variable hba_file | /var/lib/pgsql/9.3/data/pg_hba.conf | /var/lib/pgsql/9.3/data/pg_hba.conf | override lc_time | en_US.UTF-8 | en_US.UTF-8 | configuration file log_destination | stderr | stderr | configuration file ident_file | /var/lib/pgsql/9.3/data/pg_ident.conf | /var/lib/pgsql/9.3/data/pg_ident.conf | override log_rotation_age | 1440 | 1440 | configuration file max_connections | 100 | 100 | configuration file log_truncate_on_rotation | on | on | configuration file TimeZone | PRC | PRC | configuration file port | 5432 | 5432 | command line application_name | psql | psql | client lc_numeric | en_US.UTF-8 | en_US.UTF-8 | configuration file wal_buffers | 512 | 512 | override lc_ctype | en_US.UTF-8 | en_US.UTF-8 | override data_checksums | off | off | override client_encoding | UTF8 | UTF8 | client config_file | /var/lib/pgsql/9.3/data/postgresql.conf | /var/lib/pgsql/9.3/data/postgresql.conf | override transaction_deferrable | off | off | override lc_collate | en_US.UTF-8 | en_US.UTF-8 | override log_rotation_size | 0 | 0 | configuration file log_filename | postgresql-%a.log | postgresql-%a.log | configuration file lc_messages | en_US.UTF-8 | en_US.UTF-8 | configuration file transaction_isolation | read committed | read committed | override default_text_search_config | pg_catalog.english | pg_catalog.english | configuration file server_encoding | UTF8 | UTF8 | override log_directory | pg_log | pg_log | configuration file transaction_read_only | off | off | override lc_monetary | en_US.UTF-8 | en_US.UTF-8 | configuration file logging_collector | on | on | configuration file log_line_prefix | < %m > | < %m > | configuration file DateStyle | ISO,MDY | ISO,MDY | configuration file shared_buffers | 16384 | 16384 | configuration file data_directory | /var/lib/pgsql/9.3/data | /var/lib/pgsql/9.3/data | override log_timezone | PRC | PRC | configuration file (34 rows) This report is saved as /tmp/pgstatreport_zabbix_1_2.txt /root/pgstatspack

原文链接：https://www.f2er.com/postgresql/194863.html

上一篇：postgresql远程不能访问 - Postgre 下一篇：PostgreSQL的监控二(pgwatch &

猜你在找的Postgre SQL相关文章

PosegreSQL基础回顾(第 4 章 SQL语法)

来源：http://www.postgres.cn/docs/11/ 4.1.1. 标识符和关键词 SQL标识符和关键...

作者：前端之家时间：2020-11-21

PosegreSQL基础回顾(第 8 章数据类型)

来源：http://www.postgres.cn/docs/11/ 8.1. 数字类型数字类型由2、4或8字节的...

作者：前端之家时间：2020-11-21

PosegreSQL基础回顾(第 5 章数据定义)

来源：http://www.postgres.cn/docs/11/ 5.1. 表基础 SQL并不保证表中行的顺序。...

作者：前端之家时间：2020-11-21

PosegreSQL基础回顾(第 6 章数据操纵、第 7 章查询)

来源：http://www.postgres.cn/docs/11/ 6.4. 从修改的行中返回数据有时在修改行...

作者：前端之家时间：2020-11-21

PosegreSQL基础回顾(第 13 章并发控制)

来源：http://www.postgres.cn/docs/11/ 13.2.1. 读已提交隔离级别读已提交是Po...

作者：前端之家时间：2020-11-21

PostgreSQL安装和使用

青岛OJ系统用的关系型数据库是PostgreSQL,为此对PostgreSQL大致了解下。今天的主要话题围...

作者：前端之家时间：2020-11-01

PostgreSQL整体架构

作者：前端之家时间：2020-08-07

为什么选择PostgreSQL而不是MySQL

David Bolton是一名独立开发者，他使用PostgreSQL和MySQL都已有超过十年的时间。近日，他撰...

作者：前端之家时间：2020-08-07

为什么选择PostgreSQL而不是MySQL

David Bolton是一名独立开发者，他使用PostgreSQL和MySQL都已有超过十年的时间。近日，他撰...

作者：前端之家时间：2020-08-07

专访唐成：从小工到专家，PostgreSQL的修炼之道

唐成，拥有十几年数据库、操作系统、存储领域的工作经验。目前任沃趣科技首席数据库架构师...

作者：前端之家时间：2020-08-07

编程分类

MySQL MsSQL Oracle Sqlite Postgre SQL Mariadb MongoDB NoSQL HBase JDBC

最新文章