It provides top like viewer with a few admin functions, tool for recording stats into files and building reports.Ĭheck_pgactivity is designed to monitor PostgreSQL clusters from any Nagios like software. Pgcenter is an admin tool for working with PostgreSQL stats, written in Golang. It also provides a tool to generate CSV files to graph the pgstats metrics. Pgstats is a command line tool written in C which can sample various PostgreSQL informations. Pgmetrics collects a lot of information and statistics from a running PostgreSQL server and displays it in easy-to-read text format or export it as JSON for scripting. Pg_activity is a htop like application for PostgreSQL server activity monitoring, written in Python. Pg_view is a Python-based tool to quickly get information about running databases and resources used by them as well as correlate running queries and why they might be slow. Pg_buffercache gives you introspection into Postgres' shared buffers, showing how many pages of which relations are currently held in the cache. Pgstattuple can generate statistics for tables and indexes, showing how much space in each table & index is consumed by live tuples, deleted tuples as well as how much unused space is available in each relation. This is very helpful when you're experiencing performance regressions due to inefficient query plans due to changed parameters or table sizes. Pg_stat_plans extends on pg_stat_statements and records query plans for all executed quries. Pg_stat_statements tracks all queries that are executed on the server and records average runtime per query "class" among other parameters. Most of them are shipped with Postgres (the -contrib packages may need to be installed) and can be activated via the extension interface. The following extensions offer access to Postgres internals which may be of interest or collect additional information. Official documentation on the Statistics Collector.PostgreSQL collects lots of data on its own and offers it via the pg_stat(io)_ system views PostgreSQL builtin & contrib Statistics collector 2.5.9 PASH-Viewer: PostgreSQL Active Session History Viewer.2.5.1 EnterpriseDB Postgres Enterprise Manager.2.5 Postgres-centric monitoring solutions.2.4 Generic monitoring solutions with plugins.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |