top of page

SQL developer for PostgreSQL

Public·3 members

PostgreSQL monitor: unused indexes


ree

[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


21 Views

PostgreSQL monitor: parameter editor


ree

[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


10 Views

PostgreSQL monitor: database statistics


ree

ree

[EN]

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


Database stats

Provides system view information pg_stat_database


26 Views

PostgreSQL monitor: lock


ree

[EN]

Information on object locking (SQL type => PostgreSQL (relation))

The window displays information about object locks imposed on them when executing sql commands by PostgreSQL database users when executing queries/commands.


List of lock


21 Views
bottom of page