top of page

SQL editor for PostgreSQL

Public·2 members

Admin
8 days ago · joined the group.
1 View

PostgreSQL monitor: unused indexes



[EN]

List of PostgreSQL cluster indexes that have not been accessed or their number is less than specified in the "show indices with hit less" field


select * from pg_catalog.pg_stat_all_indexes

 where idx_scan < $$NUMBER


14 Views

PostgreSQL monitor: parameter editor



[EN]

The PostgreSQL cluster parameters editor allows you to quickly and conveniently edit current parameters

The "Filter" field is used to filter the list of parameters by the entered text. Text is searched in all columns and in any part of the line

The "Category" field is used for block filtering of the list


8 Views

PostgreSQL monitor: database statistics




[EN]

The window displays various statistics on the operation of PostgreSQL cluster databases


Database stats

Provides system view information pg_stat_database


23 Views

About

Welcome to the group! Connect with other members, get updates and share media.

bottom of page