Equivalent of SQL Server's SYSPROCESS in POSTGRESQL

Asked Dec 22 '20 at 18:13

Active Dec 22 '20 at 20:27

Viewed 166 times

I have a query in SQL Server:

 SELECT kpid,hostprocess
 FROM master..sysprocesses

I want to know the equivalent code of this in POSTGRESQL.

Thanks!

edited Dec 22 '20 at 20:27

marc_s

asked Dec 22 '20 at 18:13

dn2301

[pg_stat_activity](https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ACTIVITY-VIEW)? – Dec 22 '20 at 18:36
thanks @a_horse_with_no_name – dn2301 Dec 23 '20 at 17:45

0 Answers0