Ferramentas de PostgreSQL
Administração, consultas e tuning PostgreSQL
PostgreSQL Backup Command Gerador
Gerar full and incremental PostgreSQL backup shell commands
PostgreSQL Restore Command Gerador
Gerar PostgreSQL restore workflows from backup files
pg_dump Command Gerador
Build pg_dump commands with format, compression, and scope options
pg_restore Command Gerador
Build pg_restore commands for custom-format dumps
Construtor de cadeia de conexão PostgreSQL
Crie strings de conexão PostgreSQL e URIs libpq
PostgreSQL User Creation Command
Gerar CREATE ROLE and GRANT commands for new PostgreSQL users
PostgreSQL Role Permission Gerador
Gerar GRANT and REVOKE statements for schemas, tables, and sequences
PostgreSQL Table Size Query Gerador
Gerar queries to list table and index sizes
PostgreSQL Database Size Query
Gerar queries for database and tablespace size monitoring
PostgreSQL Index Bloat Verificador Query
Gerar queries to detect bloated and unused indexes
PostgreSQL Vacuum Command Helper
Gerar VACUUM, VACUUM FULL, and autovacuum tuning commands
PostgreSQL Analyze Command Helper
Gerar ANALYZE commands and statistics maintenance queries
PostgreSQL Replication Slot Verificador
Gerar queries to monitor replication slots and lag
PostgreSQL WAL Size Calculadora
Estimate WAL generation and disk requirements
Analisador de log PostgreSQL
Analise as linhas de log do PostgreSQL e resuma erros e consultas lentas
PostgreSQL Config Verificador
Review postgresql.conf settings and tuning recommendations
PostgreSQL Port Verificador
Gerar commands to verify PostgreSQL port and connectivity
PostgreSQL SSL Connection Helper
Gerar SSL connection strings and verify TLS configuration
Formatador de consulta PostgreSQL
Formate e embeleze consultas SQL do PostgreSQL
PostgreSQL JSON Query Helper
Gerar JSONB operators and path queries for PostgreSQL
PostgreSQL Date Query Helper
Gerar date, interval, and timezone queries for PostgreSQL
PostgreSQL Lock Query Gerador
Gerar queries to find blocking locks and deadlocks
Analisador de consulta lenta PostgreSQL
Analise pg_stat_statements e saída de consulta lenta baseada em log
Lista de verificação de atualização do PostgreSQL
Lista de verificação passo a passo para as principais atualizações de versão do PostgreSQL
PostgreSQL DBA Report Gerador
Gerar a PostgreSQL health and configuration audit report