When I execute
ps aux | grep postgres
or top | grep postgres
I get all my postgres processes with some information, the last column (command) has the following structure:
postgres: username db ip_address(xxxxx) QUERY_TYPE
postgres: postgres test 192.168.0.100(33195) SELECT
What does this number means (33195)?
I'm having troubles with my database and I want to know if this information could help me. Some queries are taking too long.
It is some kind of process dependency?