Search This Blog

Groovy DBA

Documentation of my work relating to DB2, MySQL, Oracle, Unix Navigation, Universe

Postgres: To View what is running on the database

Get link
Facebook
X
Pinterest
Email
Other Apps

Thursday, July 17, 2025

SELECT * FROM pg_stat_activity where state <> 'idle';

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Postgres: To list table owners

Thursday, May 22, 2025

SELECT schemaname, tablename, tableowner FROM pg_tables WHERE schemaname NOT IN ('pg_catalog', 'information_schema') ORDER BY tableowner, schemaname, tablename;

Postgres: Clean up stopped replication slot

Friday, January 10, 2025

When a slot is inactive, that means that Murty and his team have stopped the replication on their side. The SQL below will identify inactive slots. We should schedule this script in a job , running every hour. (1) SELECT slot_name, pg_size_pretty(pg_wal_lsn_diff(pg_current_wal_lsn(),restart_lsn)) AS size, active, slot_type FROM pg_replication_slots; (2) Once you identify the replication slot, the job should drop it with the following command: SELECT pg_drop_replication_slot ('pg_replication_slot_name_from_above'); (3) Restart the database instance to clean up unwanted disk space. Notes from Google:- Thank you for contacting Google Cloud Support. My name is Jagadeesh and I will be assisting you with this issue. I understand that WAL logs are expanding to over 1.5TB and you want to know what is causing WAL logs to grow and you want to reduce it. Please confirm if ...

DB2: To check table status in the event of SQLCODE=-668, SQLSTATE=57007

Tuesday, December 07, 2021

To check table's status ('C' means that the table is in set integrity pending) db2 "select status from syscat.tables where tabname = 'COLLDESC'" To set integrity db2 "set integrity for wcs.colldesc immediate checked"

Contact

Name

Email *

Message *