For example, to check which columns belongs to the view "pg_stat_wal_receiver"
SELECT column_name
FROM information_schema.columns
WHERE table_name = 'pg_stat_wal_receiver';
Output
column_name
-----------------------
pid
last_msg_receipt_time
latest_end_lsn
latest_end_time
sender_port
receive_start_lsn
receive_start_tli
written_lsn
flushed_lsn
received_tli
last_msg_send_time
status
slot_name
sender_host
conninfo
(15 rows)
Or use the psql metacommand "\d+":
echo '\d+ pg_stat_wal_receiver' |psql
Output
View "pg_catalog.pg_stat_wal_receiver"
Column | Type | Collation | Nullable | Default | Storage | Description
-----------------------+--------------------------+-----------+----------+---------+----------+-------------
pid | integer | | | | plain |
status | text | | | | extended |
receive_start_lsn | pg_lsn | | | | plain |
receive_start_tli | integer | | | | plain |
written_lsn | pg_lsn | | | | plain |
flushed_lsn | pg_lsn | | | | plain |
received_tli | integer | | | | plain |
last_msg_send_time | timestamp with time zone | | | | plain |
last_msg_receipt_time | timestamp with time zone | | | | plain |
latest_end_lsn | pg_lsn | | | | plain |
latest_end_time | timestamp with time zone | | | | plain |
slot_name | text | | | | extended |
sender_host | text | | | | extended |
sender_port | integer | | | | plain |
conninfo | text | | | | extended |
View definition:
SELECT pid,
status,
receive_start_lsn,
receive_start_tli,
written_lsn,
flushed_lsn,
received_tli,
last_msg_send_time,
last_msg_receipt_time,
latest_end_lsn,
latest_end_time,
slot_name,
sender_host,
sender_port,
conninfo
FROM pg_stat_get_wal_receiver() s(pid, status, receive_start_lsn, receive_start_tli, written_lsn, flushed_lsn, received_tli, last_msg_send_time, last_msg_receipt_time, latest_end_lsn, latest_end_time, slot_name, sender_host, sender_port, conninfo)
WHERE pid IS NOT NULL;
No comments:
Post a Comment