state

gistfile1.txt

postgres=# \c l3simple_db1 
You are now connected to database "l3simple_db1" as user "postgres".
l3simple_db1=# select * from pgq_node.local_state;
 queue_name |  consumer_name   | provider_node | last_tick_id |                     cur_error                     | paused | uptodate 
------------+------------------+---------------+--------------+---------------------------------------------------+--------+----------
 replika    | st3_l3simple_db1 | node1         |            1 | Not subscriber to queue: replika/st3_l3simple_db1 | f      | t
(1 row)

l3simple_db1=# select * from pgq_node.node_location;
 queue_name | node_name |    node_location    | dead 
------------+-----------+---------------------+------
 replika    | node2     | dbname=l3simple_db1 | f
 replika    | node1     | dbname=l3simple_db1 | f
(2 rows)