Нужна поддержка IBM, Red Hat, SAS, PostgreSQL или HCL?
Проведем первичную диагностику, определим риски и предложим модель сопровождения под ваш стек, требования к SLA и бюджет.
Нужна поддержка IBM, Red Hat, SAS, PostgreSQL или HCL?
Проведем первичную диагностику, определим риски и предложим модель сопровождения под ваш стек, требования к SLA и бюджет.
Нужна поддержка IBM, Red Hat, SAS, PostgreSQL или HCL?
Проведем первичную диагностику, определим риски и предложим модель сопровождения под ваш стек, требования к SLA и бюджет.
PGLens
An enterprise solution for PostgreSQL management: cluster monitoring, bottleneck detection, and analysis of slow queries, blocking, indexes, and configuration.
LabSoft helps organize a pilot, PostgreSQL audit, PGLens implementation, and ongoing support in enterprise environments — on-premises or PaaS — with a focus on security, operations, and actionable results for the DBA team.
Product / Official Distributor: LabSoft
WHAT PGLENS CAN DO
- Аудит PostgreSQL AuditChecks SQL queries, indexes, blocking, configuration, CPU/RAM/disk load, logs, and replication.
- Cluster Monitoring
Continuous metric collection, session and blocking history, workload trends, reports, and a unified view of PostgreSQL health. - Deep Analysis
Metric correlation, root-cause analysis of degradation, and analysis of user activity, deadlocks, wait queues, and database settings. - Optimization
Ranks resource-intensive queries, checks index coverage, and safely simulates new indexes through EXPLAIN.
HOW PGLENS HELPS DBAs AND THE BUSINESS
Less Manual Log Analysis
Top queries, sessions, blocking, and workload data are consolidated in one interface instead of being scattered across logs and system views.
Secure On-Premises Deployment
The solution can run entirely within the customer perimeter, keeping technical data and metrics inside the customer infrastructure.
History Instead of a Point-in-Time Snapshot
Review what happened an hour, a day, or any period ago — essential when the blocking event is gone but its effects remain.
Risk-Free Hypothesis Testing
Index simulation uses EXPLAIN to evaluate potential plan changes without modifying the actual database structure.
Expert Support
PostgreSQL specialists assist with implementation, interpretation of results, migrations, and emergency situations.
Before/After Comparison
The team can see the impact of parameter changes, upgrades, migrations, and query optimization.
HOW THE POSTGRESQL AUDIT WORKS
PGLens Installation
We deploy the system in your environment or agree on a PaaS model that meets your security requirements.
We deploy the system in your environment or agree on a PaaS model that meets your security requirements.
Results Review
We meet with the team to explain findings, risks, priorities, and possible remediation scenarios.
We meet with the team to explain findings, risks, priorities, and possible remediation scenarios.
Recommendations
Формируем понятный план оптимизации: что исправить первым, какой эффект ожидать и как внедрять безопасно.
Формируем понятный план оптимизации: что исправить первым, какой эффект ожидать и как внедрять безопасно.
Data Collection
We collect metrics, SQL activity, blocking data, indexes, configuration, logs, and database health information.
We collect metrics, SQL activity, blocking data, indexes, configuration, logs, and database health information.
Analysis
We identify slow queries, conflicting transactions, configuration issues, and performance degradation.
We identify slow queries, conflicting transactions, configuration issues, and performance degradation.
5
4
3
2
1
EXAMPLES OF WHERE PGLENS HELPS
- ERP System Slows Down at NightProblem: batch jobs regularly caused the system to hang, while the logs contained thousands of lines with no clear prioritization.
Solution: PGLens identified the most resource-intensive queries and inefficient JOINs.
Result: problem queries were optimized, reducing execution time from 12 seconds to 0.8 seconds. - Write Performance Drop After a PatchProblem: after an update in a telecom environment, write performance dropped by approximately 40%.
Solution: the system identified newly unused indexes and the need to refresh statistics.
Result: unnecessary indexes were removed, disk space was freed, and write performance was restored. - Morning Slowdown from 9:00 to 11:00Problem: users reported slow performance at the start of the workday.
Solution: PGLens revealed resource contention between reporting workloads, cache cleanup, and production activity.
Result: background jobs were rescheduled, reporting query parameters were tuned, and response times were reduced to seconds.
DEPLOYMENT OPTIONS
- On‑premiseDeployment in the customer’s infrastructure when isolation, data control, and internal information-security requirements are critical.
- Data and technical metrics remain inside the customer perimeter
- Suitable for financial services, the public sector, and restricted environments
- Docker-based deployment with a fast setup using only a few commands
- PaaSReady-to-use monitoring infrastructure without the need to provision a separate server or maintain the product platform yourself.
- Fast launch without significant DevOps resources
- Infrastructure operated by the product team
- Scales with cluster growth and increasing workloads
FREQUENTLY ASKED QUESTIONS
The distribution is provided as a Docker container, and the instructions consist of just a few commands. You can connect a specialist to run it for the first time, so you don't have to figure out the setup yourself.
PostgreSQL technical metrics and system views are used for monitoring. The on-premise solution is deployed within the customer's premises.
The PGLens FAQ states that the pglens system role requires SUPERUSER + LOGIN because the statistics collector accesses internal PostgreSQL structures for low-level statistics.
Yes. The product documentation specifically states compatibility with PostgreSQL, PostgreSQL Pro, and Tantor; Tantor is responsible for DBMS performance, while PGLens provides in-depth performance diagnostics.
PGLens creates a "pseudo-index" in the current session's memory for EXPLAIN: you can see possible plan changes without creating a real index and without affecting SELECT operations.
Zabbix and Grafana are good at showing infrastructure symptoms, and PGLens adds PostgreSQL analysis: problematic SQL queries, plans, locks, and root-cause analysis.
Technical support and maintenance of enterprise solutions: DBMS, middleware, and infrastructure for critical IT systems
DETAILS
CONTACTS
Almaty, Nur Alatau microdistrict, st. Nurly Baykenova 64
BIN: 240140012491
Products:
Services:
© LABSOFT — support and maintenance of enterprise solutions
SITE MAP