SELECT * FROM your_table_name LIMIT 5;
SELECT 1;
SELECT COUNT(*) FROM your_table_name;
/var/log/postgresql/
or by checking the log_directory
setting:tail -f /var/log/postgresql/postgresql-XX-main.log
XX
with your PostgreSQL version.SELECT * FROM pg_locks pl
JOIN pg_class pc ON pl.relation = pc.oid
JOIN pg_database pd ON pl.database = pd.oid
WHERE pd.datname = 'your_database_name';
WHERE
clause conditions.SELECT * FROM pg_stat_replication;
SELECT inhrelid::regclass AS partition_name, n_live_tup
FROM pg_inherits
JOIN pg_stat_user_tables ON inhrelid = relid
WHERE inhparent = 'your_parent_table'::regclass;
SELECT * FROM pg_policies WHERE tablename = 'your_table_name';
SELECT * FROM pg_database WHERE datname = 'your_database_name';
SELECT * FROM pg_tables WHERE tablename = 'your_table_name';
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)