top of page

SQL developer for PostgreSQL

Открытая·3 пользователя

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 просмотр

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 просмотров

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 просмотров

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 просмотр
bottom of page