Pgbadger

pgBadger هو محلل سجلات PostgreSQL ومحلل أداء قاعدة البيانات يقوم بتحليل سجلات قاعدة البيانات لإنشاء تقارير مفصلة عن الاستعلامات البطيئة وأخطاء النظام. يعمل كمصور للإحصائيات، حيث يحول السجلات الخام إلى مخططات ورسوم بيانية تفاعلية لمراقبة اتجاهات النظام.

تستخدم الأداة معالج سجلات متعدد النواة لتوزيع التحليل عبر أنوية CPU، مما يسرع تحليل أحجام كبيرة من سجلات نشاط قاعدة البيانات. وتوفر آلية لتحليل السجلات عن بعد عن طريق استرجاع وتحليل الملفات من خوادم بعيدة عبر اتصالات shell آمنة.

يغطي النظام مراقبة موارد قاعدة البيانات، وتحليل سجلات مجمع الاتصالات، وتصور اتجاهات الأداء. ويدعم إنشاء تقارير تزايدية لإنشاء ملخصات تراكمية ويصدر المقاييس المحللة بتنسيق JSON للتكامل مع أدوات المراقبة الخارجية.

يتم تحويل البيانات المحللة إلى تقارير HTML ثابتة وصور للعرض دون اتصال.

Features

PostgreSQL Performance Monitoring - Analyzes PostgreSQL database log files to identify slow queries and system errors to improve database speed.
Parallel Log Parsing - Utilizes a multi-core log processor to distribute parsing across CPU cores, significantly accelerating the analysis of large log volumes.
Database Performance Profiling - Identifies bottlenecks, temporary file usage, and error distributions within database log files.
Database Performance Monitoring - Tracks query duration, request throughput, and active session counts to monitor database resource utilization.
Log Statistics Visualizers - Transforms raw database logs into interactive charts and graphs to monitor system trends.
Log File Parsing - Parses database log files in multiple formats to generate detailed performance reports.
Log Management Systems - Processes large volumes of PostgreSQL database logs into readable reports and summaries.
Performance Trend Analysis - Transforms raw database logs into interactive charts and graphs to visualize system activity and performance trends.
Portable HTML Reports - Transforms analyzed metrics into self-contained, interlinked static HTML pages and images for offline viewing.
Incremental Log Processing - Processes logs in successive runs to create cumulative daily and weekly summaries of system performance.
Parallel Log Parsing - Utilizes multi-core parallel processing to accelerate the analysis of large database log files.
Remote Database Log Retrieval - Fetches logs from distant servers over secure shell tunnels for centralized analysis without local file copies.
Parallel Log Processing - Uses parallel processing across multiple CPU cores to analyze large volumes of database activity logs.
Connection Pooler Statistics - Processes connection pooler logs to report on request throughput, query duration, and active session counts.
Remote Log Parsing - Retrieves and analyzes log files from remote servers via secure shell connections to identify system issues.
Cumulative Summaries - Generates cumulative daily and weekly performance summaries by processing logs in successive runs.
Remote Logging Utilities - Retrieves and parses log files from remote servers via secure shell to diagnose issues without manual transfers.
Performance and Optimization - Fast log analyzer for PostgreSQL.

سجل النجوم

daroldpgbadger

Name: darold/pgbadger
Author: darold

View on GitHub

4,030 نجوم376 تفرعاتPerlPostgreSQL6 مشاهداتpgbadger.darold.net

Pgbadger

يتم تحويل البيانات المحللة إلى تقارير HTML ثابتة وصور للعرض دون اتصال.

Features

PostgreSQL Performance Monitoring - Analyzes PostgreSQL database log files to identify slow queries and system errors to improve database speed.
Parallel Log Parsing - Utilizes a multi-core log processor to distribute parsing across CPU cores, significantly accelerating the analysis of large log volumes.
Database Performance Profiling - Identifies bottlenecks, temporary file usage, and error distributions within database log files.
Database Performance Monitoring - Tracks query duration, request throughput, and active session counts to monitor database resource utilization.
Log Statistics Visualizers - Transforms raw database logs into interactive charts and graphs to monitor system trends.
Log File Parsing - Parses database log files in multiple formats to generate detailed performance reports.
Log Management Systems - Processes large volumes of PostgreSQL database logs into readable reports and summaries.
Performance Trend Analysis - Transforms raw database logs into interactive charts and graphs to visualize system activity and performance trends.
Portable HTML Reports - Transforms analyzed metrics into self-contained, interlinked static HTML pages and images for offline viewing.
Incremental Log Processing - Processes logs in successive runs to create cumulative daily and weekly summaries of system performance.
Parallel Log Parsing - Utilizes multi-core parallel processing to accelerate the analysis of large database log files.
Remote Database Log Retrieval - Fetches logs from distant servers over secure shell tunnels for centralized analysis without local file copies.
Parallel Log Processing - Uses parallel processing across multiple CPU cores to analyze large volumes of database activity logs.
Connection Pooler Statistics - Processes connection pooler logs to report on request throughput, query duration, and active session counts.
Remote Log Parsing - Retrieves and analyzes log files from remote servers via secure shell connections to identify system issues.
Cumulative Summaries - Generates cumulative daily and weekly performance summaries by processing logs in successive runs.
Remote Logging Utilities - Retrieves and parses log files from remote servers via secure shell to diagnose issues without manual transfers.
Performance and Optimization - Fast log analyzer for PostgreSQL.

بدائل مفتوحة المصدر لـ Pgbadger

مشاريع مفتوحة المصدر مشابهة، مرتبة حسب عدد الميزات المشتركة مع Pgbadger.

ankane/pghero
ankane/pghero
8,880عرض على GitHub
PgHero is a performance dashboard and diagnostic tool for PostgreSQL. It provides a web interface for monitoring database metrics, analyzing query performance, and managing active connections across multiple database instances. The project distinguishes itself by recording query and storage statistics over time, enabling historical trend analysis through a time-range slider. It also identifies missing indexes by analyzing query patterns and integrates with cloud provider APIs to retrieve system-level hardware statistics such as CPU and IOPS. The tool's broader capabilities cover process admi
Ruby
عرض على GitHub8,880
uptrace/uptrace
uptrace/uptrace
4,098عرض على GitHub
Uptrace is an OpenTelemetry-based observability platform designed to collect, store, and analyze distributed traces, metrics, and logs. It functions as a centralized logging backend, a distributed tracing system, and a metrics engine to monitor application performance and system health. The platform is distinguished by AI-powered operational capabilities, allowing users to query telemetry data and manage monitoring dashboards using natural language. It specifically includes specialized monitoring for generative AI pipelines, tracking token usage and response quality for LLM interactions and r
Goapmapplication-monitoringclickhouse
عرض على GitHub4,098
pgsty/pigsty
pgsty/pigsty
4,703عرض على GitHub
Pigsty is a full-stack orchestration suite for deploying, monitoring, and managing high-availability PostgreSQL clusters and their supporting infrastructure. It functions as a cluster management platform and high-availability suite that automates failover, manages virtual IPs, and ensures data consistency through distributed consensus. The project distinguishes itself by providing a comprehensive database infrastructure-as-code framework and a dedicated observability stack. It incorporates a backup and recovery manager supporting point-in-time recovery via S3-compatible object storage, alongs
Shellgraphicsinfrapostgres
عرض على GitHub4,703
ghostpack/seatbelt
GhostPack/Seatbelt
4,619عرض على GitHub
Seatbelt is a C# offensive security framework and host security auditor designed to perform endpoint surveys on Windows systems. It functions as a modular tool for identifying vulnerabilities, misconfigurations, and security-relevant artifacts on both local and remote hosts. The project distinguishes itself through a module-based check system that allows for the integration of custom security command units. It features a security event log parser to track logon and process activity, alongside a credential extraction utility for gathering browser history, saved passwords, and cloud credentials
C#
عرض على GitHub4,619

عرض جميع البدائل الـ 30 لـ Pgbadger

الأسئلة الشائعة

ما هي وظيفة darold/pgbadger؟

ما هي الميزات الرئيسية لـ darold/pgbadger؟

الميزات الرئيسية لـ darold/pgbadger هي: PostgreSQL Performance Monitoring, Parallel Log Parsing, Database Performance Profiling, Database Performance Monitoring, Log Statistics Visualizers, Log File Parsing, Log Management Systems, Performance Trend Analysis.

ما هي البدائل مفتوحة المصدر لـ darold/pgbadger؟

تشمل البدائل مفتوحة المصدر لـ darold/pgbadger: ankane/pghero — PgHero is a performance dashboard and diagnostic tool for PostgreSQL. It provides a web interface for monitoring… uptrace/uptrace — Uptrace is an OpenTelemetry-based observability platform designed to collect, store, and analyze distributed traces,… pgsty/pigsty — Pigsty is a full-stack orchestration suite for deploying, monitoring, and managing high-availability PostgreSQL… ghostpack/seatbelt — Seatbelt is a C# offensive security framework and host security auditor designed to perform endpoint surveys on… analogj/scrutiny — Scrutiny is a distributed hardware monitoring system and predictive drive failure analyzer. It provides a centralized… google/battery-historian — Battery Historian is a visualization and profiling tool for analyzing power consumption and battery drain on Android…

Pgbadger

Features

سجل النجوم

Pgbadger

Features

بدائل مفتوحة المصدر لـ Pgbadger

ankane/pghero

uptrace/uptrace

pgsty/pigsty

GhostPack/Seatbelt

الأسئلة الشائعة

سجل النجوم

الأسئلة الشائعة

بدائل مفتوحة المصدر لـ Pgbadger

ankane/pghero

uptrace/uptrace

pgsty/pigsty

GhostPack/Seatbelt