Problem You'd like to know how big is your PostgreSQL database. Solution Just run this query: SELECT pg_size_pretty(pg_database_size('database')) where: * database - your database name Read also PostgreSQL Disk Usage… »
Problem You'd like to know how big is the replication lag between master and slave on PostgreSQL. Solution You may run this query on your slave host: SELECT EXTRACT(EPOCH FROM (now() - pg_last_… »
Problem You want to view all tables related to specific table by foreign keys. Or you'd like to see all tables related to specific column. Solution You can use this simple query: For specific table… »
Problem You forget or don't know administrator password for mysql or mariaDB. You should have access to server (terminal or ssh) Solution To reset mysql administrator (root) password you should: 1. Stop database: sudo systemctl… »