process_open_sockets

Processes which have open network sockets on the system.

Table schema

Name Type Description
pid INTEGER Process (or thread) ID
fd BIGINT Socket file descriptor number
socket BIGINT Socket handle or inode number
family INTEGER Network protocol (IPv4, IPv6)
protocol INTEGER Transport protocol (TCP/UDP)
local_address TEXT Socket local address
remote_address TEXT Socket remote address
local_port INTEGER Socket local port
remote_port INTEGER Socket remote port
path TEXT For UNIX sockets (family=AF_UNIX), the domain path
net_namespace TEXT The inode number of the network namespace

Query examples

select * from process_open_sockets where pid = 1