{"repo":"vyruss/pg_statviz","free":true,"listed":false,"github":"https://github.com/vyruss/pg_statviz","clone":"git clone https://github.com/vyruss/pg_statviz.git","description":"A minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics.","language":"Python","stars":105,"topics":["dataviz","performance-analysis","postgresql","time-series","time-series-analysis","database","database-administration","database-management","open-source","postgres"],"license":null,"category":"databases-storage","readme_excerpt":"pg statviz pg statviz is a minimalist extension and utility pair for time series analysis and visualization of PostgreSQL internal statistics. Created for capturing PostgreSQL's cumulative and dynamic statistics, pg statviz enables deeper time series analysis than the standard PostgreSQL statistics views. The included utility generates visualizations for selected time ranges from the stored statistic snapshots, helping users track PostgreSQL performance over time and potentially aiding in performance tuning and troubleshooting. Optionally, an AI analysis mode can produce per-module HTML reports with chart commentary from a cloud LLM (Claude or Gemini) or a local model via Ollama. Design Philosophy Designed with the K.I.S.S. and UNIX philosophies in mind, pg statviz aims to be a modular, minimal and unobtrusive tool that does only what it's meant for: create snapshots of PostgreSQL statistics for visualization and analysis. To this end, a utility is provided for retrieving and creating simple visualizations with the stored snapshots, by using pandas and Matplotlib. Installing the extension Debian (12+) / Ubuntu (22.04+) 1. Configure the PostgreSQL Deb repository for your Linux distribution, as explained here for Debian and here for Ubuntu. 2. Use apt to install the extension for your PostgreSQL version: sudo apt install postgresql- -statviz Red Hat Enterprise Linux (v8.0+) / Fedora (37+) 1. Configure the PostgreSQL Yum repository for your Linux distribution, as explained here.","default_branch":null,"files":null,"tree":[],"storefront":"/r/vyruss","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/vyruss/pg_statviz/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}