How do you get the replication slots in PostgreSQL?

How do you get the replication slots in PostgreSQL? replication slot is active for pid In Postgres how do you fix it when logical replication slots become inactive? · Use the SELECT pg_drop_replication_slot statement to replication slot postgres A PostgreSQL replication slot may be stuck due to one of the following reasons: Check if the bgwriter process is healthy by inspecting its

replication slot already exists Query on the primary instance is always running After creating a replica, the query SELECT * from pg_stat_activity where state = 'active' and pid = XXXX and