postgreSQL troubleshooting 故障分析
1: 產品介紹
來自於
完全開源,兩板斧就可以安裝入庫
幫助DBA提供分析問題的手段,然後定位問題解決問題
Postgres provides various activity statistics that include detailed information about its behaviour:
connections, statements, database operations, replication, resources usage and more.
General purpose of the statistics is to help DBAs to monitor and troubleshoot Postgres.
However, these statistics provided in textual form retrieved from SQL functions and views,
and Postgres doesn't provide any tools for working with them.
pgCenter's main goal is to help Postgres DBA manage statistics that theу have in their databases
and see all the necessary data in convenient format based on builtin stats views and functions.
2:特色
Top-like interface that allows you to monitor stats changes as you go.
When troubleshooting Postgres it's always important to keep an eye not only on Postgres metrics,
but also system metrics,
since Postgres utilizes system resources, such as cpu, memory, storage and network when working.
pgCenter allows you to see both kinds of statistics related to Postgres and your system.
3:統計了哪些內容
pgCenter supports majority of statistics views available in Postgres,
and at the same time, uses additional SQL functions applied to statistics to show these in a more convenient way.
The following stats are available:
current summary activity - a compilation/selection of metrics from different sources - postgres uptime, version, recovery status, number of clients grouped by their states, number of (auto)vacuums, statements per second, age of the longest transaction and the longest vacuum;
pg_stat_activity - information related to the current activity of connected clients and Postgres background processes.
pg_stat_database - database-wide statistics, such as number of commits/rollbacks, handled tuples, deadlocks, temporary files, etc.
pg_stat_replication - statistics on replication, connected standby hosts and their activity.
pg_stat_user_tables, pg_statio_user_tables - statistics on accesses (including IO) to tables.
pg_stat_user_indexes, pg_statio_user_indexes - statistics on accesses (including IO) to indexes.
pg_stat_user_functions - statistics on execution of functions.
pg_stat_statements - statistics on SQL statements executed including time and resources usage.
statistics on tables sizes based on pg_relation_size() and pg_total_relation_size() functions;
pg_stat_progress_vacuum - information about (auto)vacuums status.
System statistics
pgcenter top also provides system usage information based on statistics from procfs filesystem:
load average and CPU usage time (user, system, nice, idle, iowait, software and hardware interrupts, steal);
memory and swap usage, amount of cached and dirty memory, writeback activity;
storage devices statistics: iops, throughput, latencies, average queue and requests size, devices utilization;
network interfaces statistics: throughput in bytes and packets, different kind of errors, saturation and utilization.
In case of connecting to remote Postgres there is possibility to use additional SQL functions used for
retrieving /proc statistics from remote host.
4:其他類似產品,沒有用過,大家可以驗證一下,歡迎分享經驗
pg_top
99:多練習,多實踐,就可以找到各種問題,尤其效能故障,總可以找到蛛絲馬跡,只要你夠仔細認真。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29497382/viewspace-2287035/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【Spark篇】---Spark故障解決(troubleshooting)Spark
- websphere中介軟體故障診斷troubleshootingWeb
- create index , rebuild index troubleshooting 索引故障解決IndexRebuild索引
- 故障分析 | Greenplum Segment 故障處理
- 故障分析 | Kubernetes 故障診斷流程
- 故障分析 | MySQL死鎖案例分析MySql
- postgreSQL 恢復至故障點 精準恢復SQL
- MongoDB單點故障分析MongoDB
- cpu故障現象分析 CPU常見故障案例
- PostgreSQL中利用驅動程式實現故障轉移SQL
- Troubleshooting ServeRAIDServerAI
- Troubleshooting tips
- 故障分析 | MySQL 從機故障重啟後主從同步報錯案例分析MySql主從同步
- 故障分析 | Redis AOF 重寫原始碼分析Redis原始碼
- PostgreSQL+PostGIS時態分析SQL
- 電腦黑屏怎麼辦 顯示卡故障導致黑屏故障分析
- 【故障】“ORACLE使用者被鎖定”故障處理和分析Oracle
- ORA-00265故障分析
- <Win7硬體故障分析>Win7
- Web 網站 故障常用分析命令Web網站
- PostgreSQL pg_rewind 報錯分析SQL
- PostgreSQL的事務隔離分析SQL
- Troubleshooting POST error codesError
- zt_oracle troubleshooting案例Oracle
- 故障分析 | MySQL鎖等待超時一例分析MySql
- 【故障處理】ORA- 2730*,status 12故障分析與處理
- 工業交換機軟體故障分析
- remote_listener引發的故障分析REM
- 資料庫監聽夯故障分析資料庫
- 使用ttTraceMon進行TimesTen故障分析
- 生產庫故障分析(主外來鍵和DML效能分析)
- PostgreSQL pg_ctl start超時分析SQL
- Systematic Latch Contention Troubleshooting in OracleOracle
- Java Monitoring, Management and Troubleshooting ToolsJava
- Checkpoint Tuning and Troubleshooting GuideGUIIDE
- Troubleshooting Database Creation (121)Database
- 故障分析 | 是誰偷走了我的 IO
- 基於TRIZ的引風機故障分析