pg_replication_slots

A system view listing all replication slots

pg_replication_slots is a system catalogue view listing all replication slots.

pg_replication_slots was added in PostgreSQL 9.4.

Definition by PostgreSQL version

pg_replication_slots (PostgreSQL 15)

             View "pg_catalog.pg_replication_slots"
       Column        |  Type   | Collation | Nullable | Default 
---------------------+---------+-----------+----------+---------
 slot_name           | name    |           |          | 
 plugin              | name    |           |          | 
 slot_type           | text    |           |          | 
 datoid              | oid     |           |          | 
 database            | name    |           |          | 
 temporary           | boolean |           |          | 
 active              | boolean |           |          | 
 active_pid          | integer |           |          | 
 xmin                | xid     |           |          | 
 catalog_xmin        | xid     |           |          | 
 restart_lsn         | pg_lsn  |           |          | 
 confirmed_flush_lsn | pg_lsn  |           |          | 
 wal_status          | text    |           |          | 
 safe_wal_size       | bigint  |           |          | 
 two_phase           | boolean |           |          |

Documentation: pg_replication_slots

pg_replication_slots (PostgreSQL 14)

             View "pg_catalog.pg_replication_slots"
       Column        |  Type   | Collation | Nullable | Default 
---------------------+---------+-----------+----------+---------
 slot_name           | name    |           |          | 
 plugin              | name    |           |          | 
 slot_type           | text    |           |          | 
 datoid              | oid     |           |          | 
 database            | name    |           |          | 
 temporary           | boolean |           |          | 
 active              | boolean |           |          | 
 active_pid          | integer |           |          | 
 xmin                | xid     |           |          | 
 catalog_xmin        | xid     |           |          | 
 restart_lsn         | pg_lsn  |           |          | 
 confirmed_flush_lsn | pg_lsn  |           |          | 
 wal_status          | text    |           |          | 
 safe_wal_size       | bigint  |           |          | 
 two_phase           | boolean |           |          |

Documentation: pg_replication_slots

pg_replication_slots (PostgreSQL 13)

             View "pg_catalog.pg_replication_slots"
       Column        |  Type   | Collation | Nullable | Default 
---------------------+---------+-----------+----------+---------
 slot_name           | name    |           |          | 
 plugin              | name    |           |          | 
 slot_type           | text    |           |          | 
 datoid              | oid     |           |          | 
 database            | name    |           |          | 
 temporary           | boolean |           |          | 
 active              | boolean |           |          | 
 active_pid          | integer |           |          | 
 xmin                | xid     |           |          | 
 catalog_xmin        | xid     |           |          | 
 restart_lsn         | pg_lsn  |           |          | 
 confirmed_flush_lsn | pg_lsn  |           |          | 
 wal_status          | text    |           |          | 
 safe_wal_size       | bigint  |           |          |

Documentation: pg_replication_slots

pg_replication_slots (PostgreSQL 12)

             View "pg_catalog.pg_replication_slots"
       Column        |  Type   | Collation | Nullable | Default 
---------------------+---------+-----------+----------+---------
 slot_name           | name    |           |          | 
 plugin              | name    |           |          | 
 slot_type           | text    |           |          | 
 datoid              | oid     |           |          | 
 database            | name    |           |          | 
 temporary           | boolean |           |          | 
 active              | boolean |           |          | 
 active_pid          | integer |           |          | 
 xmin                | xid     |           |          | 
 catalog_xmin        | xid     |           |          | 
 restart_lsn         | pg_lsn  |           |          | 
 confirmed_flush_lsn | pg_lsn  |           |          |

Documentation: pg_replication_slots

pg_replication_slots (PostgreSQL 11)

             View "pg_catalog.pg_replication_slots"
       Column        |  Type   | Collation | Nullable | Default 
---------------------+---------+-----------+----------+---------
 slot_name           | name    |           |          | 
 plugin              | name    |           |          | 
 slot_type           | text    |           |          | 
 datoid              | oid     |           |          | 
 database            | name    |           |          | 
 temporary           | boolean |           |          | 
 active              | boolean |           |          | 
 active_pid          | integer |           |          | 
 xmin                | xid     |           |          | 
 catalog_xmin        | xid     |           |          | 
 restart_lsn         | pg_lsn  |           |          | 
 confirmed_flush_lsn | pg_lsn  |           |          |

Documentation: pg_replication_slots

pg_replication_slots (PostgreSQL 10)

             View "pg_catalog.pg_replication_slots"
       Column        |  Type   | Collation | Nullable | Default 
---------------------+---------+-----------+----------+---------
 slot_name           | name    |           |          | 
 plugin              | name    |           |          | 
 slot_type           | text    |           |          | 
 datoid              | oid     |           |          | 
 database            | name    |           |          | 
 temporary           | boolean |           |          | 
 active              | boolean |           |          | 
 active_pid          | integer |           |          | 
 xmin                | xid     |           |          | 
 catalog_xmin        | xid     |           |          | 
 restart_lsn         | pg_lsn  |           |          | 
 confirmed_flush_lsn | pg_lsn  |           |          |

Documentation: pg_replication_slots

pg_replication_slots (PostgreSQL 9.6)

  View "pg_catalog.pg_replication_slots"
       Column        |  Type   | Modifiers 
---------------------+---------+-----------
 slot_name           | name    | 
 plugin              | name    | 
 slot_type           | text    | 
 datoid              | oid     | 
 database            | name    | 
 active              | boolean | 
 active_pid          | integer | 
 xmin                | xid     | 
 catalog_xmin        | xid     | 
 restart_lsn         | pg_lsn  | 
 confirmed_flush_lsn | pg_lsn  |

Documentation: pg_replication_slots

pg_replication_slots (PostgreSQL 9.5)

View "pg_catalog.pg_replication_slots"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 slot_name    | name    | 
 plugin       | name    | 
 slot_type    | text    | 
 datoid       | oid     | 
 database     | name    | 
 active       | boolean | 
 active_pid   | integer | 
 xmin         | xid     | 
 catalog_xmin | xid     | 
 restart_lsn  | pg_lsn  |

Documentation: pg_replication_slots

pg_replication_slots (PostgreSQL 9.4)

View "pg_catalog.pg_replication_slots"
    Column    |  Type   | Modifiers 
--------------+---------+-----------
 slot_name    | name    | 
 plugin       | name    | 
 slot_type    | text    | 
 datoid       | oid     | 
 database     | name    | 
 active       | boolean | 
 xmin         | xid     | 
 catalog_xmin | xid     | 
 restart_lsn  | pg_lsn  |

Documentation: pg_replication_slots

Change history

PostgreSQL 14
- column two_phase added (commit 19890a06)
PostgreSQL 13
- column wal_status added (commit c6550776)
- column safe_wal_size added (originally as min_safe_lsn in commit c6550776, renamed in commit a8aaa0c7))
PostgreSQL 10
- column temporary added (commit a924c327)
PostgreSQL 9.6
- column confirmed_flush_lsn added (commit 3f811c2d)
PostgreSQL 9.5
- column active_pid added (commit d811c037)
PostgreSQL 9.4
- added (commit 858ec118)

Examples

Sample contents of pg_replication_slots (as of PostgreSQL 13) when a single physical replication slot is in use:

postgres=# SELECT * FROM pg_replication_slots\gx
-[ RECORD 1 ]-------+--------------
slot_name           | node2
plugin              |
slot_type           | physical
datoid              |
database            |
temporary           | f
active              | t
active_pid          | 1597000
xmin                |
catalog_xmin        |
restart_lsn         | 0/3002470
confirmed_flush_lsn |
wal_status          | reserved
safe_wal_size       |

References

PostgreSQL documentation: pg_replication_slots

Version charts

Useful overviews

Useful links

Contents

pg_replication_slots

Definition by PostgreSQL version

pg_replication_slots (PostgreSQL 15)

pg_replication_slots (PostgreSQL 14)

pg_replication_slots (PostgreSQL 13)

pg_replication_slots (PostgreSQL 12)

pg_replication_slots (PostgreSQL 11)

pg_replication_slots (PostgreSQL 10)

pg_replication_slots (PostgreSQL 9.6)

pg_replication_slots (PostgreSQL 9.5)

pg_replication_slots (PostgreSQL 9.4)

Change history

Examples

References

Categories

See also